kasadeghAverage_number_of_TX_calls_per_block_day
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with first_6_month_2022 as (
select BLOCK_ID,date(BLOCK_TIMESTAMP), count(distinct TX_ID) as total_number_of_application_calls from flipside_prod_db.algorand.application_call_transaction
where date(BLOCK_TIMESTAMP)>='2022-01-01' and date(BLOCK_TIMESTAMP)<'2022-07-1'
group by BLOCK_ID,date(BLOCK_TIMESTAMP)
),
last_6_month_2021 as (
select BLOCK_ID,date(BLOCK_TIMESTAMP), count(distinct TX_ID) as total_number_of_application_calls from flipside_prod_db.algorand.application_call_transaction
where date(BLOCK_TIMESTAMP)>='2021-07-01' and date(BLOCK_TIMESTAMP)<'2022-01-1'
group by BLOCK_ID,date(BLOCK_TIMESTAMP)
)
select 'Last_6_month_of_2021' as "Date Range", avg (total_number_of_application_calls) as Average_number_of_TX_calls_per_block_day from last_6_month_2021
union
select 'First_6_month_of_2022' as "Date Range", avg (total_number_of_application_calls) Average_number_of_TX_calls_per_block_day from first_6_month_2022
Run a query to Download Data