shengyi-chiuUntitled Query
    Updated 2022-07-26
    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