NuveveCryptoArchivedTerra Total Number of New Wallets Per Week
    Updated 2023-03-15
    with new_wallets as (
    select
    min(block_timestamp) as timestamp,
    tx_sender
    from terra.core.fact_transactions
    group by tx_sender
    )

    select
    date_trunc('week', timestamp) as week,
    count(distinct tx_sender) as wallets
    from new_wallets
    group by week
    order by week asc
    Run a query to Download Data