messarisolana_new_fee_payers
    Updated 2024-01-02
    select
    first_date as date,
    count(fee_payers) as new_fee_payers
    from (
    select
    min(date(block_timestamp)) as first_date,
    signers[0] as fee_payers
    from solana.core.fact_transactions
    group by fee_payers)
    group by date
    --having date is not null
    order by date desc

    QueryRunArchived: QueryRun has been archived