onchainbrainDAUs by Chain
    Updated 2023-03-13
    -- forked from 912a1fe7-9a5d-4db0-a0e1-32d2ca802b8b

    WITH solana_waus AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS day
    ,'solana (fee payers)' AS chain
    ,COUNT(DISTINCT signers[0]) AS dayly_active_accounts
    FROM solana.core.fact_transactions
    WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
    AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
    AND succeeded
    GROUP BY 1, 2
    )
    ,solana_waus2 AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS day
    ,'solana (signers)' AS chain
    ,COUNT(DISTINCT s.value) AS dayly_active_accounts
    FROM solana.core.fact_transactions,
    LATERAL FLATTEN(signers) AS s
    WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
    AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
    AND succeeded
    GROUP BY 1, 2
    )
    ,ethereum_waus AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS day
    ,'ethereum' AS chain
    ,COUNT(DISTINCT from_address) AS dayly_active_accounts
    FROM ethereum.core.fact_transactions
    WHERE block_timestamp::DATE >= DATE_TRUNC('day', CURRENT_DATE - 180)
    AND block_timestamp::DATE < DATE_TRUNC('day', CURRENT_DATE)
    AND status = 'SUCCESS'
    GROUP BY 1, 2
    )
    ,polygon_waus AS (
    WITH polygon_transactions AS (
    SELECT DATE_TRUNC('day', block_timestamp) AS block_timestamp
    Run a query to Download Data