roketAmount of fees based on gas in the network
    Updated 2022-07-27
    WITH contract AS (SELECT DISTINCT(TX_RECEIVER) , (sum(GAS_USED)/POWER(10,12)) as fees
    FROM flipside_prod_db.mdao_near.transactions
    WHERE BLOCK_TIMESTAMP::DATE between '2022-06-23' and '2022-07-23'
    GROUP BY TX_RECEIVER ORDER BY fees DESC
    LIMIT 5)

    SELECT BLOCK_TIMESTAMP::DATE AS day ,
    TX_RECEIVER ,
    (sum(GAS_USED)/POWER(10,12)) as fees
    FROM flipside_prod_db.mdao_near.transactions
    WHERE BLOCK_TIMESTAMP::DATE between '2022-06-23' and '2022-07-23' AND TX_RECEIVER IN
    (SELECT TX_RECEIVER FROM contract)
    GROUP BY day , TX_RECEIVER
    Run a query to Download Data