/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
WITH all_blocks AS (
SELECT
block_timestamp::date AS date,
count(block_number) AS number_of_blocks
FROM
gnosis.core.fact_transactions
GROUP BY date
)
SELECT
AVG(number_of_blocks) AS avg_number_of_blocks
FROM
all_blocks
/* The End! */