isabelhendricknaer4
Updated 2022-07-27
9
1
2
3
4
5
6
›
⌄
SELECT * from (SELECT *,row_number() over (partition by day order by cum_fees desc ) as ran from
(SELECT date(block_timestamp) as day, tx_receiver,
count(*) as total_txs, sum(transaction_fee)/1e24 as fee,
sum(fee) over (partition by tx_receiver order by day) as cum_fees
from near.core.fact_transactions where day >= CURRENT_DATE -60
GROUP by 1 , 2 )) where ran < 15
Run a query to Download Data