WITH all_blocks AS (
SELECT
block_timestamp::date AS date,
count(block_number) AS number_of_blocks
FROM
arbitrum.core.fact_transactions
WHERE
block_timestamp::date <= '2022-07-25'
GROUP BY date
)
SELECT
avg(number_of_blocks) AS avg_number_of_blocks
FROM
all_blocks