kasadeghAlgo_New_Address
    Updated 2022-06-28
    with new_wallets as (
    select date(b.BLOCK_TIMESTAMP) as date, count(distinct a.ADDRESS) as total_number_of_new_wallets from flipside_prod_db.algorand.account as a
    join flipside_prod_db.algorand.block as b
    on b.BLOCK_ID=a.CREATED_AT
    where a.ACCOUNT_CLOSED=0
    group by date
    )

    select * from new_wallets
    order by date
    Run a query to Download Data