headitmanagerNEAR Gas Guzzlers : last month's 10 contracts that users spending the most gas on
    Updated 2022-07-23
    with total_to10_contracts as (select sum(gas_used/1e12),tx_receiver from mdao_near.transactions
    group by tx_receiver
    order by sum(gas_used/1e12) desc
    limit 10)
    ,lastweek_to10_contracts as (select sum(gas_used/1e12),tx_receiver from mdao_near.transactions
    where block_timestamp::date > current_date - interval '7 days'
    group by tx_receiver
    order by sum(gas_used/1e12) desc
    limit 10)
    ,last_month_to10_contracts as (select sum(gas_used/1e12),tx_receiver from mdao_near.transactions
    where block_timestamp::date > current_date - interval '30 days'
    group by tx_receiver
    order by sum(gas_used/1e12) desc
    limit 10)
    ,to10_contracts_lastweek as (select sum(gas_used/1e12),mdao_near.transactions.tx_receiver, block_timestamp::date from mdao_near.transactions
    inner join total_to10_contracts on total_to10_contracts.tx_receiver=mdao_near.transactions.tx_receiver
    where block_timestamp::date > current_date + 1 - interval '7 days'
    group by mdao_near.transactions.tx_receiver,block_timestamp::date)
    ,to10_contracts_lastmonth as (select sum(gas_used/1e12),mdao_near.transactions.tx_receiver, block_timestamp::date from mdao_near.transactions
    inner join total_to10_contracts on total_to10_contracts.tx_receiver=mdao_near.transactions.tx_receiver
    where block_timestamp::date > current_date + 1 - interval '30 days'
    group by mdao_near.transactions.tx_receiver,block_timestamp::date)

    select * from last_month_to10_contracts
    Run a query to Download Data