flipside

    Solana new users and active users per day 1
    SocioCryptoSolana new users and active users per day 1
    Updated 2023-01-26
    SELECT a.date,
    a.new_address as "# New Addresses",
    b.address as "# Active Addresses"
    FROM
    (SELECT date_trunc('day', f_txn) as date,
    COUNT (DISTINCT signer) as new_address
    FROM
    (
    SELECT f.value as signer,
    min(block_timestamp) as f_txn
    FROM solana.fact_transactions p,
    table(flatten( p.signers)) f
    WHERE succeeded = 'TRUE'
    GROUP by signer
    )
    GROUP by date) a
    LEFT JOIN (
    SELECT date_Trunc('day', block_timestamp) as date,
    count(DISTINCT f.value) as address
    FROM solana.fact_transactions p,
    table(flatten( p.signers)) f
    WHERE succeeded = 'TRUE'
    GROUP by date
    )b
    ON a.date = b.date
    WHERE a.date between '2022-11-08' and '2023-01-31'
    ORDER by a.date DESC
    Run a query to Download Data