headitmanagerNEAR Gas Guzzlers : last month's 10 contracts that users spending the most gas on
Updated 2022-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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