SELECT * from
(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
-- limit 10