, block_timestamp

, date_trunc('hour', block_timestamp) as timestamp_h

, tx_count

, difficulty

, gas_limit

, gas_used

, size

, TIMESTAMPDIFF(SECONDS, LAG(block_timestamp, 1) OVER (ORDER BY block_timestamp), block_timestamp) block_second

, (block_number - LAG(block_number, 1) over (order by block_number)) block_number_diff

from avalanche.core.fact_blocks

where block_number > 16462611

and block_number <= 16511800

and blockchain = 'avalanche'

order by block_number asc