princefarzamThe top ten Gas Guzzlers contract over the past week
    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 - 7
    GROUP BY Contracts
    ORDER BY Total_Gas_Used DESC
    LIMIT 10
    Run a query to Download Data