, avg(tx_count) as avg_tx_count

, min(tx_count) as min_tx_count

, max(tx_count) as max_tx_count

, avg(gas_limit) as avg_gas_limit

, min(gas_limit) as min_gas_limit

, max(gas_limit) as max_gas_limit

, avg(gas_used) as avg_gas_used

, min(gas_used) as min_gas_used

, max(gas_used) as max_gas_used

from avalanche.core.fact_blocks

where block_timestamp >= '2022-06-20'

and blockchain = 'avalanche'

group by 1

order by timestamp_h asc