-- Average Transaction Fee per txn per week
-- Total Transaction Fees per week
-- Total number of transactions per week
-- Average transactions per second (TPS) per week
-- Average block time per week
SELECT
date_trunc('week', block_timestamp) as "Week",
COUNT(tx_sender) as "Weekly # of Txns",
"Weekly # of Txns"/(7 * 24 * 60 * 60) as "Txn Per Second",
SUM(fee) as "Weekly Total Fees Collected",
AVG(fee) as "Average Fees Per Txn"
FROM terra.core.fact_transactions
GROUP BY 1 ORDER BY 1 DESC