mattkstewLAAF Wallets 3
    Updated 2023-01-25
    with tab1 as (
    select
    tx_sender,
    min(date_trunc('day', block_timestamp)) as date1

    from terra.core.fact_transactions
    group by 1
    )
    , tab2 as (
    select
    date1,
    count(*) as amount
    from tab1
    group by 1 )

    select
    date1,
    case when date1 >= '2023-01-14' then 'After Station Launch'
    else 'Before Station Launch'
    END as Station_launch,
    sum(amount) over (order by date1) as value
    from tab2
    where date1 > '2023-01-07'
    order by 1
    Run a query to Download Data