flipside

    Untitled Query
    nimasadjadiUntitled Query
    WITH TOP_40 AS (
    SELECT
    tx_receiver AS contract,
    sum (gas_used/pow(10,12)) AS used_gas
    FROM flipside_prod_db.mdao_near.transactions
    WHERE block_timestamp:: DATE >= CURRENT_DATE -7
    GROUP BY TX_RECEIVER
    ORDER BY used_gas DESC
    LIMIT 40 )
    SELECT
    DATE( block_timestamp) AS DAY_,
    tx_receiver, sum (gas_used/pow(10,12)) AS sum_gas
    FROM flipside_prod_db.mdao_near.transactions
    WHERE DAY_ >'2022-07-01' AND tx_receiver IN (SELECT contract FROM TOP_40)
    GROUP BY 1,2
    ORDER BY 3
    DESC

    Run a query to Download Data