drone-mostafaUntitled Query
Updated 2022-07-23
9
1
2
3
4
5
›
⌄
with Top_gas as ( select sum(gas_used) / Power(10, 12) as gas_used, TX_RECEIVER as Contract from flipside_prod_db.mdao_near.transactions group by Contract order by gas_used DESC limit 10 )
select date_trunc('day', block_timestamp) as daily, sum(gas_used) / Power(10, 12) as gas_used , TX_RECEIVER as Contract
from flipside_prod_db.mdao_near.transactions where tx_receiver in (select Contract from Top_gas) and block_timestamp > current_date - 7 group by daily , Contract
Run a query to Download Data