kasadeghAverage_number_of_TX_calls_per_block_day
    Updated 2022-06-29
    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