nethermindnarutSol 2023Q1 - Tx Count and Active Addresses
    Updated 2023-02-16
    -- 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;


    Run a query to Download Data