/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
WITH all_tps AS (
SELECT
block_timestamp::date AS date,
COUNT(tx_hash)/86400 AS tps
FROM
gnosis.core.fact_transactions
GROUP BY date
)
SELECT
AVG(tps) AS avg_tps
FROM
all_tps
/* The End! */