select date_trunc('day', BLOCK_TIMESTAMP) as dates,count(TX_HASH) as counts,count(distinct TX_SIGNER) as users, sum(TRANSACTION_FEE/pow(10,18)) as fees,
sum(counts) over (order by dates) as cumu_count,
sum(users) over (order by dates) as cumu_users,
sum(fees) over (order by dates) as cumu_fees
from near.core.fact_transactions
where
TX_RECEIVER LIKE '%v2.ref-%'
OR TX_RECEIVER LIKE '%-finance.near'
OR TX_RECEIVER IN
('boostfarm.ref-labs.near','berryclub.ek.near','v3.oin_finance.near',
'farm.berryclub.ek.near','contract.main.burrow.near','v1.jumbo_exchange.near',
'farm-draw.cheddar.near','farming-v1.jumbo_exchange.near','v1.pembrock.near',
'spot.spin-fi.near','contract.beta.burrow.near','p1-farm.cheddar.near',
'p2-cheddar.cheddar.near') and TX_STATUS='Success'
group by 1