flipside

    Contracts with the Highest Amount of Gas Consumption in 2022
    kitlunaContracts with the Highest Amount of Gas Consumption in 2022
    Updated 2022-07-25
    SELECT
    SUM (gas_used/1e12) AS Tgas,
    TX_RECEIVER AS contracts,
    COUNT (TXN_HASH) AS transactions
    FROM flipside_prod_db.mdao_near.transactions
    WHERE BLOCK_TIMESTAMP >= '2022-01-01'
    GROUP BY contracts
    ORDER BY Tgas DESC
    LIMIT 100

    Run a query to Download Data