LTirrellacme_all_users
    Updated 2022-07-07
    with flattened_transactions as (
    select
    t.block_timestamp,
    t.tx_id,
    w.value as wallet
    from
    terra.transactions t,
    lateral flatten(input => t.tx_from) w
    where
    tx_status = 'SUCCEEDED'
    ),
    wallets as (
    select
    wallet,
    min(block_timestamp) :: date as join_date
    from
    flattened_transactions
    group by
    wallet
    )
    SELECT
    join_date,
    count(wallet) as new_users
    from
    wallets
    group by
    join_date
    Run a query to Download Data