mohammadh2)NEAR Gas Guzzlers
    Updated 2022-07-27
    with A as (select TX_RECEIVER as contract,
    sum(GAS_USED/POW(10,12)) as sum_gas
    from flipside_prod_db.mdao_near.transactions
    where block_timestamp >= '2022-01-01'
    group by contract
    order by sum_gas desc
    limit 50)

    select TX_RECEIVER as contract,
    date_trunc('week', BLOCK_TIMESTAMP) as block_week,
    sum(GAS_USED/POW(10,12)) as sum_gas,
    avg(GAS_USED/POW(10,12)) as avg_gas
    from flipside_prod_db.mdao_near.transactions
    where block_timestamp >= '2022-01-01'
    and contract in (select contract from A)
    group by block_week,contract
    Run a query to Download Data