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 >= '2022-04-01'

AND BLOCK_TIMESTAMP < '2022-07-01'

GROUP BY 1

ORDER BY 1;