SELECT
CAST(BLOCK_TIMESTAMP AS DATE) AS date,
COUNT(DISTINCT PROGRAM_ID) AS unique_programs,
COUNT(PROGRAM_ID) AS total_interactions
FROM solana.core.fact_events
WHERE date >= '2022-01-01'
-- AND EVENT_TYPE IS NOT NULL
GROUP BY date
ORDER BY date DESC