princefarzamThe top ten Gas Guzzlers contract over the last month
    Updated 2022-07-27
    SELECT
    TX_RECEIVER AS Contracts,
    Sum(GAS_USED)/1e12 AS Total_Gas_Used
    FROM flipside_prod_db.mdao_near.transactions
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 30
    GROUP BY Contracts
    ORDER BY Total_Gas_Used DESC
    LIMIT 10
    Run a query to Download Data