SPLIT(asset, '-')[0] AS asset,

POWER(10,-8) * MAX(asset_e8) OVER(PARTITION BY block_timestamp, asset) AS fee

FROM thorchain.core.fact_fee_events

WHERE DATE(block_timestamp) BETWEEN '2022-12-01' AND '2022-12-30'

AND asset LIKE '%.%' --Not synths.

ORDER BY block_timestamp DESC, asset ASC