LTirrell2022-03-04_terra_feet-wet_most-protocols
    Updated 2022-03-10
    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'
    ),
    new_wallets as (
    select
    wallet,
    min(block_timestamp) :: date as join_date
    from
    flattened_transactions
    group by
    wallet
    having
    join_date >= current_date - 90
    ),
    transactions as (
    select
    ft.block_timestamp,
    ft.tx_id,
    ft.wallet,
    nw.join_date
    from
    new_wallets nw
    inner join flattened_transactions ft on nw.wallet = ft.wallet
    ),
    contracts as (
    select
    distinct m.msg_value :contract :: string as contract,
    m.tx_id as tx_id
    Run a query to Download Data