block_timestamp::date as day,

iff(year(day) = 2022, 'Before Christmas', 'After Christmas') as timespan,

count(distinct tx_id) as txn_count,

count(distinct instruction:accounts[0]) as users_count,

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

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

from solana.core.fact_events

join solana.core.dim_labels

on program_id = address

where label_type = 'defi'

and succeeded = 1

and day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'

group by day, timespan

order by day