Tobi_12024-06-07 09:02 PM
    Updated 2024-06-07
    WITH recent_transactions AS (
    SELECT
    BLOCK_TIMESTAMP,
    SIGNERS
    FROM
    solana.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    ),
    unnested_signers AS (
    SELECT
    BLOCK_TIMESTAMP,
    s.value AS signer
    FROM
    recent_transactions,
    LATERAL FLATTEN(input => SIGNERS) s
    )
    SELECT
    COUNT(DISTINCT signer) AS active_signers
    FROM
    unnested_signers;

    QueryRunArchived: QueryRun has been archived