farid-c9j0VMUntitled Query
Updated 2022-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with base as (select date(BLOCK_TIMESTAMP) as date,
tx_receiver,
sum(GAS_USED/1e12) as gasd,
1 as numbering,
sum(numbering) over (partition by date order by gasd desc) as filtering
from flipside_prod_db.mdao_near.transactions
where date>= CURRENT_DATE-7
group by 1,2)
select *
from base
where filtering <10
order by 3 desc
Run a query to Download Data