transaction_fees AS (

SELECT

block_timestamp,

tx_fee

FROM

kaia.core.fact_transactions

SELECT

TRUNC(block_timestamp, 'day') AS "Date 📅",

AVG(tx_fee) AS "Average Fee (KLAY) 💸",

MAX(tx_fee) AS "Highest Fee (KLAY) 🚀",

MEDIAN(tx_fee) AS "Median Fee (KLAY) 🏷️",

SUM(tx_fee) AS "Total Fees (KLAY) 💰"

FROM

transaction_fees

WHERE

TRUNC(block_timestamp, 'day') < CURRENT_DATE

GROUP BY

1

ORDER BY

"Date 📅" DESC;