Hey, I am currently working on total HBD in Savings for Hive Open Stats, and I'm getting a little less HBD. Up to the end of Dec 24th 2022, I'm getting that there is 4.56M HBD in Savings.

I'm simply getting the amount transferred to savings and subtracting from it the amount transferred from savings.

To double-check the result, I ran these queries in HiveSQL:

SELECT YEAR(timestamp) AS year, SUM(amount) AS total_amount
FROM TxTransfers
WHERE type = 'transfer_to_savings'
AND amount_symbol = 'HBD'
GROUP BY YEAR(timestamp);

SELECT YEAR(timestamp) AS year, SUM(amount) AS amount
FROM VOFillTransferFromSavings
WHERE amount_symbol = 'HBD'
GROUP BY YEAR(timestamp);

Adding up each year, and then subtracting the sums, seems to add to 4.5M.

Do you have a different way of doing the calculation to get the total HBD in Savings? Am I missing something? Would be good to see why we get different results.