kasadeghTotal_number_of_wallets_per_day
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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