SELECT
DATE_TRUNC('day', block_timestamp) as "Day",
COUNT(*) as "Transaction Count",
AVG(gas_price) as "Average Gas Price",
AVG(GAS_USED) as "Average Gas Used",
COUNT(DISTINCT from_address) as "Unique Active Addresses",
AVG(TX_FEE) as "Average Transaction Fee",
FROM
ethereum.core.fact_transactions
WHERE
extract('year', block_timestamp)='2024'
GROUP BY
DATE_TRUNC('day', block_timestamp)
ORDER BY
"Day" DESC;