SELECT

DATE(BLOCK_TIMESTAMP) AS day, -- Extract the day

SUM(VALUE) AS total_transaction_volume,

SUM(TX_FEE) AS total_transaction_fees,

AVG(GAS_PRICE) AS avg_gas_price,

SUM(GAS_USED) AS total_gas_used,

COUNT(*) AS total_transactions,

AVG(VALUE) AS avg_transaction_value,

AVG(TX_FEE) AS avg_transaction_fee,

SUM(CASE WHEN TX_SUCCEEDED THEN 1 ELSE 0 END) * 1.0 / COUNT(*) AS success_rate

FROM kaia.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2025-02-01' AND BLOCK_TIMESTAMP < '2025-03-01'

GROUP BY DATE(BLOCK_TIMESTAMP) -- Grouping by day

'Kaia' AS blockchain,

day,

total_transaction_volume,

total_transaction_fees,

avg_gas_price,

total_gas_used,

total_transactions,

avg_transaction_value,

avg_transaction_fee,

success_rate

FROM kaia_feb_2025

ORDER BY day;