block_timestamp_hour,

transaction_count,

total_fees_usd,

total_fees_usd/transaction_count AS fpt,

transaction_count/3600 AS tps

FROM solana.stats.ez_core_metrics_hourly

SUM(transaction_count) AS transactions,

SUM(total_fees_usd) AS fees_usd,

AVG(fpt) AS avg_fpt,

AVG(tps) AS avg_tps

FROM base

-- WHERE block_timestamp::date >= CURRENT_DATE - 186 AND block_timestamp::date != CURRENT_DATE

WHERE block_timestamp_hour::date >= '2020-10-10' AND block_timestamp_hour::date != CURRENT_DATE