SELECT distinct(ts.pool_name) as pool, sum((ts.liq_fee_asset * tp.asset_usd) + (ts.liq_fee_rune * tp.rune_usd)) AS fee
FROM thorchain.swaps ts
INNER JOIN thorchain.prices tp ON tp.block_timestamp = ts.block_timestamp
WHERE tp.block_timestamp = ts.block_timestamp
GROUP by pool