select

from_currency,

to_currency,

tx_id

from osmosis.core.fact_swaps

where tx_status = 'SUCCEEDED'

),

fees as (

select

swaps.from_currency as from_asset,

swaps.to_currency as to_asset,

avg(replace(transactions.fee, 'uosmo', '')) as avg_fee

from osmosis.core.fact_transactions as transactions

inner join swaps on transactions.tx_id = swaps.tx_id

where transactions.tx_status = 'SUCCEEDED'

and transactions.fee like '%uosmo%'

group by swaps.from_currency, swaps.to_currency

from_label.project_name as from_asset,

to_label.project_name as to_asset,

fees.avg_fee as fee_uosmo

from fees

inner join osmosis.core.dim_labels as from_label on from_label.address = fees.from_asset

inner join osmosis.core.dim_labels as to_label on to_label.address = fees.to_asset

order by fees.avg_fee desc

limit 10