nethermindnarutSol 2022Q4 - Tx Count and Active Addresses
    Updated 2023-02-15
    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 >= '2022-10-01'
    AND BLOCK_TIMESTAMP < '2023-01-01'
    GROUP BY 1
    ORDER BY 1;
    Run a query to Download Data