shengyi-chiuUntitled Query
Updated 2022-07-26
9
1
2
3
4
5
6
7
›
⌄
with Guzz as (select TX_RECEIVER c, sum(GAS_USED)/1e12 as Gass
from flipside_prod_db.mdao_near.transactions group by TX_RECEIVER order by Gass desc limit 10)
select date_trunc(week,BLOCK_TIMESTAMP) as weeks, TX_RECEIVER ,
sum(GAS_USED)/1e12 as Gass ,
from flipside_prod_db.mdao_near.transactions where TX_RECEIVER in
(select c from Guzz ) group by 1 ,2 order by 1
Run a query to Download Data