AVG(SIZE) AS mean_block_size

FROM

ethereum.core.fact_blocks

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAY';