date_trunc('{{interval}}', block_timestamp) as date,

sum((split(fee, 'usei')[0])/1e6) as tx_fee_sei,

avg((split(fee, 'usei')[0])/1e6) as avg_tx_fee_sei,

sum(((split(fee, 'usei')[0])/1e6) * b.sei_price) as tx_fee_usd,

avg(((split(fee, 'usei')[0])/1e6) * b.sei_price) as avg_tx_fee_usd

FROM sei.core.fact_transactions a

LEFT JOIN (

SELECT

date_trunc('{{interval}}',recorded_hour) as date,

median(price) as sei_price

FROM osmosis.core.ez_prices

WHERE symbol = 'SEI'

GROUP BY date) b ON date_trunc('day', a.block_timestamp) = b.date

WHERE date >= '2023-08-15'

GROUP BY 1

ORDER BY 1 DESC