kiacryptonew wallets
    Updated 2023-01-11
    with min_date as (
    select
    tx_signer,
    min(block_timestamp) as min_date
    from near.core.fact_transactions
    group by 1
    ),
    info as (
    select
    date_trunc('day', min_date) as "Day",
    count(distinct tx_signer) as "New wallet",
    sum("New wallet") over (order by "Day") as "Cum new wallet"
    from min_date
    where "Day" between '2022-07-01' and '2022-09-30'
    group by 1
    ),
    avg_info as (
    select avg("New wallet") as "AVG New wallet"
    from info
    )
    select *
    from info, avg_info
    Run a query to Download Data