ErsvanTotal FEE
Updated 2022-07-07
9
1
2
3
4
5
6
7
›
⌄
SELECT SUM(FEE) AS TOTAL_FEE FROM(
SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, SUM(FEE) AS FEE FROM(
SELECT BLOCK_TIMESTAMP, TX_ID, SENDER, FEE FROM flipside_prod_db.algorand.transactions WHERE BLOCK_TIMESTAMP > '2022-01-01' ORDER BY 1 DESC
)
GROUP BY DAY
ORDER BY 1 ASC
)
Run a query to Download Data