(SELECT *,

row_number() over (partition by day order by cum_fees desc ) as rn

from

(SELECT date(block_timestamp) as day, tx_receiver, count(*) as total_txs, sum(transaction_fee)/pow(10,24) as fee, sum(fee) over (partition by tx_receiver order by day) as cum_fees

from near.core.fact_transactions

where day >= CURRENT_DATE - 30

GROUP by 1 , 2 ))

where rn < 11

-- ORDER by 3 desc