Query editor
-- 🩵 Average Gas Fee Used per Transaction in USD (from 2025)SELECTt.date AS "Date",AVG(t.gas_budget * t.gas_price * p.price_usd) AS "Average Gas Fee (USD)"FROM sui.transactions tJOIN sui.prices pON t.date = p.dateWHERE t.date >= DATE '2025-01-01'GROUP BY t.dateORDER BY t.date;