ChiefAverage number of TX Calls From July 2021- July 2022
    Updated 2022-07-01
    select date_trunc(day, block_timestamp) as date,
    count(distinct block_id) as num_of_blocks,
    count(tx_id) as num_of_tx,
    num_of_tx/num_of_blocks as avg_tx_per_block
    from flipside_prod_db.algorand.application_call_transaction
    where tx_type_name = 'application call'
    AND date BETWEEN '2021-07-02 00:00:00.000' AND '2022-07-02 00:00:00.000'
    group by date
    order by date asc
    Run a query to Download Data