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

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 date('2022-12-24') - 21 and date('2022-12-24') + 21

group by 1