SELECT

DATE(t.block_timestamp) AS date,

COUNT(*) AS total_transactions,

SUM(t.gas_used * t.gas_unit_price) / 1e18 AS total_fees_native,

AVG(t.gas_used) AS avg_gas_used

FROM

aptos.core.fact_transactions t

WHERE

t.block_timestamp >= DATEADD(MONTH, -2, CURRENT_DATE)

GROUP BY

DATE(t.block_timestamp)

SELECT

dt.date,

dt.total_transactions,

dt.total_fees_native,

dt.avg_gas_used

FROM

daily_transactions dt

ORDER BY

dt.date;