LTirrell2022-02-04_solana_wallets_hourly
    Updated 2022-02-08
    with unique_wallets as (
    select
    date_trunc('hour', block_timestamp) as datetime,
    tx_from_address as address
    from
    solana.transactions
    union
    select
    date_trunc('hour', block_timestamp) as datetime,
    tx_to_address as address
    from
    solana.transactions
    )
    select
    unique_wallets.datetime,
    count(distinct unique_wallets.address) as active_addresses
    -- sum(1)
    from
    unique_wallets
    where
    datetime >= '2022-01-01'
    group by
    datetime
    order by datetime

    Run a query to Download Data