ErsvanTotal FEE
    Updated 2022-07-07
    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