-- forked from fae933e2-109c-4000-bc8c-dced64820c00
SELECT
BLOCK_TIMESTAMP::DATE AS day,
COUNT(DISTINCT TX_ID) AS solana_txs_per_day,
COUNT(DISTINCT GET(GET(ACCOUNT_KEYS, 0), 'pubkey')) AS solana_activeaddrs_per_day
FROM solana.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2023-01-01'
AND BLOCK_TIMESTAMP < '2023-04-01'
GROUP BY 1
ORDER BY 1;