farid-c9j0VM2nd half of 2021 VS first half of 2022
Updated 2022-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with second_half_2021 as (
select Count(tx_id) /count(DISTINCT block_id) as avg_tx_per_block,Count(DISTINCT sender) as num_sender
from flipside_prod_db.algorand.application_call_transaction
where BLOCK_TIMESTAMP >= '2021-07-01' and BLOCK_TIMESTAMP <'2022-01-01'
),
first_half_2022 as(
select Count(tx_id)/count(DISTINCT block_id) as avg_tx_per_block,Count(DISTINCT sender) as num_sender
from flipside_prod_db.algorand.application_call_transaction
where BLOCK_TIMESTAMP >= '2022-01-01' and BLOCK_TIMESTAMP <='2022-06-29'
)
select 'second_half_2021'as type , * from second_half_2021
union all
select 'first_half_2022'as type , * from first_half_2022
Run a query to Download Data