date_trunc('day', block_timestamp),

pool_name,

SUM(LIQ_FEE_RUNE_USD) as rune_fee,

SUM(LIQ_FEE_ASSET_USD) as asset_fee,

SUM(LIQ_FEE_RUNE_USD + LIQ_FEE_ASSET_USD) as total_fee

FROM flipside_prod_db.thorchain.swaps

GROUP BY 1,2