trunc (block_timestamp,'day') as date,

case when block_timestamp < CURRENT_DATE-INTERVAL '1 MONTH' then 'Past activity' else 'Present activity' end as period,

count(distinct tx_id) as txs,

count(distinct INSTRUCTION:accounts[1]) as users

from solana.core.fact_events

join solana.core.dim_labels on program_id = address

WHERE label_type IN ('dex', 'defi') AND block_timestamp >= CURRENT_DATE-INTERVAL '2 MONTHS'

GROUP BY 1, 2

order by 1 asc