LTirrellSolana Signers and Fee Payers -- succeeded-only
    Updated 2023-12-07
    -- forked from Solana Signers and Fee Payers @ https://flipsidecrypto.xyz/edit/queries/7d69821b-2a72-4a0d-afca-920a20d48a4d

    select
    'Signers' as type,
    date(block_timestamp) as date,
    count(distinct s.value) as wallets
    from
    solana.core.fact_transactions,
    lateral flatten(signers) as s
    where
    date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
    and succeeded = TRUE
    group by
    date
    UNION
    select
    'Fee Payers' as type,
    date(block_timestamp) as date,
    count(distinct signers[0]) as wallets
    from
    solana.core.fact_transactions
    where
    date_trunc('day', block_timestamp) between current_date() -61 and current_date() -1
    and succeeded = TRUE
    group by
    date