LTirrell2022-02-25_solana_stepn
    Updated 2022-02-28
    with all_info as (
    select
    date_trunc('day', block_timestamp) as datetime,
    tx_from_address,
    tx_to_address,
    tx_id
    from
    solana.transactions
    where
    block_timestamp :: date >= '2022-01-01'
    and succeeded = 'TRUE'
    and (
    pre_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
    or post_mint = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'
    )
    ),
    unique_wallets as (
    select
    datetime,
    tx_from_address as address
    from
    all_info
    union
    select
    datetime,
    tx_to_address as address
    from
    all_info
    ),
    active_wallets as (
    select
    unique_wallets.datetime,
    count(distinct unique_wallets.address) as addresses
    from
    unique_wallets
    group by
    Run a query to Download Data