block_timestamp::date as day,

iff(block_timestamp >= '2022-12-24', 'After BONK', 'Before BONK') as timespan,

count(distinct tx_id) as txn_count,

count(distinct address_name) as pools_count,

count(distinct tx_from) as users_count,

sum(txn_count) over(partition by timespan order by day) as cumulative_txn_count,

sum(pools_count) over(partition by timespan order by day) as cumulative_pools_count,

sum(users_count) over(partition by timespan order by day) as cumulative_users_count

from solana.core.fact_transfers a

join solana.core.dim_labels b

on b.address = a.tx_to

where label ='orca'

and label_type = 'dex'

and label_subtype = 'pool'

and address_name not like '%aquafarm%'

and block_timestamp::date between '2022-12-10' and '2023-01-07'

group by 1, 2

order by 1