NuveveCryptoArchivedNew Wallets Weekly
    Updated 2023-01-15
    with first_deposit as (
    select
    min(block_timestamp) as timestamp,
    receiver
    from terra.core.ez_transfers
    where block_timestamp < '2023-01-01'
    group by receiver
    )

    select
    date_trunc('week', timestamp) as week,
    count(distinct receiver) as new_wallets
    from first_deposit
    group by week
    order by week asc

    Run a query to Download Data