SELECT

l.tx_hash,

DATE_TRUNC('day', l.block_timestamp) AS tx_date,

t.tx_fee

FROM ronin.core.ez_decoded_event_logs l

JOIN ronin.core.fact_transactions t

ON l.tx_hash = t.tx_hash

WHERE l.event_name = 'Swap'

AND l.block_timestamp >= current_timestamp - INTERVAL '7 days'

SELECT

tx.tx_date,

SUM(tx.tx_fee) AS total_fee_wron,

AVG(tx.tx_fee) AS avg_fee_wron,

SUM(tx.tx_fee * p.price) AS total_fee_usd,

AVG(tx.tx_fee * p.price) AS avg_fee_usd

FROM tx_data tx

LEFT JOIN ronin.price.ez_prices_hourly p

ON tx.tx_date = DATE_TRUNC('day', p.hour)

WHERE p.symbol = 'WRON'

GROUP BY tx.tx_date

ORDER BY tx.tx_date DESC;