with receivet as ( select block_timestamp::date as date, tx_receiver as user1, sum (deposit/1e24) as volume from near.core.fact_transfers group by 1,2), sendt as ( select block_timestamp::date as date, tx_signer as user1, sum (deposit/1e24) as volume from near.core.fact_transfers group by 1,2), transfert as ( select t1.date, t1.user1, sum (t1.volume - t2.volume) as balance from receivet t1 full outer join sendt t2 on t1.user1 = t2.user1 --where t1.user1 = '8488978def70b076610974676205674ee7a7744b1aed29ddf40fbc11e3ca1ecb' group by 1,2), receivet1 as ( select block_timestamp::date as date, to_address as user1, sum (raw_amount/1e18) as volume from bsc.core.fact_token_transfers where contract_address = '0x1fa4a73a3f0133f0025378af00236f3abdee5d63' group by 1,2), sendt1 as ( select block_timestamp::date as date, from_address as user1, sum (raw_amount/1e18) as volume from bsc.core.fact_token_transfers where contract_address = '0x1fa4a73a3f0133f0025378af00236f3abdee5d63' group by 1,2), transfert1 as ( select t1.date,t1.user1, sum (t1.volume - t2.volume) as balance from receivet1 t1 full outer join sendt1 t2 on t1.user1 = t2.user1 --where t1.user1 = '8488978def70b076610974676205674ee7a7744b1aed29ddf40fbc11e3ca1ecb' group by 1,2), swaptot as ( select block_timestamp::date as date, trader as user1, sum (amount_out) as volume from near.core.ez_dex_swaps where token_out in ('NEAR','stNEAR') group by 1,2), swapfromt as ( select block_timestamp::date as date, trader as user1, sum (amount_in) as volume from near.core.ez_dex_swaps where token_in in ('NEAR','stNEAR') group by 1,2), swapt as ( select t1.date, t1.user1, sum (t1.volume - t2.volume) as balance from swaptot t1 full outer join swapfromt t2 on t1.user1 = t2.user1 group by 1,2), gasfeet as ( select block_timestamp::date, tx_signer as user1, sum (transaction_fee/1e24)*-1 as fee from near.core.fact_transactions group by 1,2), maintable as ( select * from transfert where balance > 0 union all select * from swapt where balance > 0 union ALL select * from transfert1 where balance > 0 union ALL select * from gasfeet where fee > 0) select date, case when balance < 10 then 'Less Than 10 NEAR' when balance >= 10 and balance < 25 then 'Between 10 and 25 NEAR' when balance >= 25 and balance < 50 then 'Between 25 and 50 NEAR' when balance >= 50 and balance < 100 then 'Between 50 and 100 NEAR' when balance >= 100 and balance < 250 then 'Between 100 and 250 NEAR' when balance >= 250 and balance < 500 then 'Between 250 and 500 NEAR' when balance >= 500 and balance < 1000 then 'Between 500 and 1000 NEAR' /*when balance >= 1000 and balance < 2500 then 'Between 1000 and 2500 NEAR' when balance >= 2500 and balance < 5000 then 'Between 2500 and 5000 NEAR' when balance >= 5000 and balance < 10000 then 'Between 5000 and 10000 NEAR'*/ else 'More Than 1000 NEAR' end as type, count (distinct user1) as user2, sum (user2) over (partition by type order by date) as Cumulative_Users from maintable group by 1,2 order by 1 desc --tx_hash = '4cxhoH4C4oNGPK6iRNuFmB6k1Z6JBz2dKDiHm6wWgRHw'

NEAR - 1. $NEAR Swap Outflows