LTirrellNew Solana Wallets copy
    Updated 2024-02-09
    WITH solana_wallets AS (
    SELECT
    signers[0] as wallets,
    min(date(block_timestamp)) as solana_first_tx
    FROM solana.core.fact_transactions
    GROUP BY 1
    ),

    solana_new_wallets AS (
    SELECT
    solana_first_tx,
    count(distinct wallets) as new_wallets
    FROM solana_wallets
    WHERE solana_first_tx between CURRENT_DATE()-30 and current_date()-1
    GROUP BY 1 )

    select * from solana_new_wallets
    order by solana_first_tx desc



    Last run: 12 months ago
    SOLANA_FIRST_TX
    NEW_WALLETS
    1
    2024-02-08 00:00:00.00080081
    2
    2024-02-07 00:00:00.00080293
    3
    2024-02-06 00:00:00.00048506
    4
    2024-02-05 00:00:00.00062439
    5
    2024-02-04 00:00:00.00064034
    6
    2024-02-03 00:00:00.00061402
    7
    2024-02-02 00:00:00.00088047
    8
    2024-02-01 00:00:00.00083549
    9
    2024-01-31 00:00:00.00092565
    10
    2024-01-30 00:00:00.00093079
    11
    2024-01-29 00:00:00.000126560
    12
    2024-01-28 00:00:00.00084419
    13
    2024-01-27 00:00:00.00084060
    14
    2024-01-26 00:00:00.00063056
    15
    2024-01-25 00:00:00.00067814
    16
    2024-01-24 00:00:00.00045595
    17
    2024-01-23 00:00:00.00047438
    18
    2024-01-22 00:00:00.00051854
    19
    2024-01-21 00:00:00.00052193
    20
    2024-01-20 00:00:00.00060827
    30
    1022B
    1088s