permarydaily stakers
    Updated 2025-05-07
    select
    date_trunc ('day', block_timestamp) as date,
    COUNT(distinct tx_from) as unique_stakers,
    sum(COUNT(distinct tx_from)) over (
    order by
    date_trunc ('day', block_timestamp) asc
    ) as total_stakers
    from
    solana.core.fact_transfers
    where
    mint = 'boopkpWqe68MSxLqBGogs8ZbUDN4GXaLhFwNP7mpP1i'
    and tx_to = 'AeeTg7PWuQDQiVkZYP2teJRQdLQjmETBaJG3QUgWiEKs'
    group by
    1
    order by
    date desc




    Last run: 25 days ago
    DATE
    UNIQUE_STAKERS
    TOTAL_STAKERS
    1
    2025-06-09 00:00:00.00089604
    2
    2025-06-08 00:00:00.000139596
    3
    2025-06-07 00:00:00.000169583
    4
    2025-06-06 00:00:00.000179567
    5
    2025-06-05 00:00:00.000219550
    6
    2025-06-04 00:00:00.000309529
    7
    2025-06-03 00:00:00.000279499
    8
    2025-06-02 00:00:00.000449472
    9
    2025-06-01 00:00:00.000649428
    10
    2025-05-31 00:00:00.000589364
    11
    2025-05-30 00:00:00.000529306
    12
    2025-05-29 00:00:00.000469254
    13
    2025-05-28 00:00:00.000609208
    14
    2025-05-27 00:00:00.000479148
    15
    2025-05-26 00:00:00.000349101
    16
    2025-05-25 00:00:00.000329067
    17
    2025-05-24 00:00:00.000309035
    18
    2025-05-23 00:00:00.000579005
    19
    2025-05-22 00:00:00.000868948
    20
    2025-05-21 00:00:00.0001068862
    41
    1KB
    20s