kasadeghTotal_number_of_wallets_per_day
    Updated 2022-06-29
    with first_6_month_2021 as (
    select 'First_6_month_of_2022' as "Date Range",date(BLOCK_TIMESTAMP), count(distinct SENDER) as total_number_of_wallets from flipside_prod_db.algorand.application_call_transaction
    where date(BLOCK_TIMESTAMP)>='2022-01-01' and date(BLOCK_TIMESTAMP)<'2022-07-1'
    group by date(BLOCK_TIMESTAMP)
    ),
    last_6_month_2021 as (
    select 'Last_6_month_of_2021' as "Date Range",date(BLOCK_TIMESTAMP), count(distinct SENDER) as total_number_of_wallets from flipside_prod_db.algorand.application_call_transaction
    where date(BLOCK_TIMESTAMP)>='2021-07-01' and date(BLOCK_TIMESTAMP)<'2022-01-1'
    group by date(BLOCK_TIMESTAMP)
    )



    Run a query to Download Data