block_size as (

select

block_id,

count(distinct tx_id) as txs

from algorand.transactions

group by 1

),

block_time as (

select

b.block_id,

txs,

block_timestamp

from block_size s join algorand.block b on s.block_id = b.block_id

select

date(block_timestamp) as date,

median(txs) as avg_txs_per_block,

min(txs) as min_txs_per_block,

max(txs) as max_txs_per_block

from block_time

group by 1

limit 1000