LTirrellSolana Signers and Fee Payers
    Updated 2024-02-09
    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
    Last run: about 1 year ago
    TYPE
    DATE
    WALLETS
    1
    Signers2024-01-18 00:00:00.000875488
    2
    Signers2024-01-16 00:00:00.0001138831
    3
    Fee Payers2024-01-07 00:00:00.000308520
    4
    Signers2024-01-29 00:00:00.0001128726
    5
    Fee Payers2024-01-26 00:00:00.000748485
    6
    Fee Payers2024-01-18 00:00:00.000389642
    7
    Fee Payers2023-12-29 00:00:00.000366142
    8
    Fee Payers2024-01-12 00:00:00.000319924
    9
    Signers2024-01-11 00:00:00.000917086
    10
    Fee Payers2024-01-31 00:00:00.000884691
    11
    Fee Payers2023-12-27 00:00:00.000440495
    12
    Fee Payers2024-01-03 00:00:00.000372168
    13
    Signers2023-12-24 00:00:00.000985911
    14
    Fee Payers2024-02-08 00:00:00.000466558
    15
    Signers2023-12-29 00:00:00.000820708
    16
    Fee Payers2024-02-04 00:00:00.000426454
    17
    Signers2023-12-19 00:00:00.0001071957
    18
    Signers2024-01-23 00:00:00.000932359
    19
    Signers2023-12-16 00:00:00.0001371881
    20
    Fee Payers2024-01-20 00:00:00.000382981
    ...
    122
    6KB
    339s