SELECT DISTINCT DATE(fact_fee_events.block_timestamp) AS date, block_id,
SPLIT(asset, '-')[0] AS asset,
POWER(10,-8) * asset_e8 AS max_asset_fee_amount
FROM thorchain.core.fact_fee_events INNER JOIN thorchain.core.dim_block
ON fact_fee_events.dim_block_id = dim_block.dim_block_id
WHERE (date IS NOT NULL)
AND (asset NOT LIKE '%/%')
AND (asset LIKE '%USD%')
QUALIFY max_asset_fee_amount = MAX(max_asset_fee_amount) OVER(PARTITION BY date, asset)
ORDER BY date DESC, block_id DESC