select

date_trunc('day', osmosis.core.fact_swaps.block_timestamp),

osmosis.core.dim_labels.project_name,

SUM(SUBSTRING (osmosis.core.fact_transactions.fee,0,CHARINDEX('uosmo',osmosis.core.fact_transactions.fee)-1)/pow(10,6)) as Fees

from osmosis.core.fact_swaps left outer join osmosis.core.dim_labels

on osmosis.core.fact_swaps.from_currency = osmosis.core.dim_labels.address

left outer join osmosis.core.fact_transactions on osmosis.core.fact_transactions.tx_id = osmosis.core.fact_swaps.tx_id

where fee like '%osmo%'

group by 1,2