SELECT
DATE_TRUNC('hour', seconds) AS hours,
AVG(number_of_transactions) AS avg_number_of_transactions,
SUM(number_of_transactions) AS total_number_of_transactions
FROM (
SELECT
-- block_number,
DATE_TRUNC('second', block_timestamp) AS seconds,
COUNT(*) AS number_of_transactions
-- SUM (gas_used) AS total_gas_used,
-- SUM(tx_count) AS total_transactions_made
FROM avalanche.core.fact_transactions
WHERE block_timestamp >= '2022-06-20'
AND block_timestamp <= CURRENT_DATE
AND status = 'SUCCESS'
GROUP BY 1
)
GROUP BY 1
ORDER BY 2 DESC
-- SELECT tx_hash,
-- tx_fee
-- FROM avalanche.core.fact_transactions
-- WHERE status = 'SUCCESS'
-- LIMIT 10