COUNT(*) AS total_transactions,

SUM(value) AS total_volume_in_klay,

SUM(tx_fee) AS total_tx_fees_in_klay,

AVG(gas_price) AS avg_gas_price,

COUNT(DISTINCT from_address) AS unique_addresses,

AVG(value) AS avg_transaction_value

kaia.core.fact_transactions

block_timestamp >= '2024-08-01'

AND block_timestamp < '2024-09-01';