adambalaUntitled Query
    Updated 2022-12-07
    with
    txs_classic as (

    select

    date_trunc('week',block_timestamp) as date,
    tx_sender,
    count(distinct block_timestamp::date) as days_active

    from terra.core.fact_transactions txs
    where tx_succeeded
    and block_timestamp > current_date() - interval '90 days'
    group by 1,2
    having days_active > 3
    )

    select

    date,
    count(distinct tx_sender) as users

    from txs_classic
    group by 1
    Run a query to Download Data