(asset_liquidity*asset_price_usd) as asset_liq, (rune_liquidity*rune_price_usd) as rune_liq, (asset_liq + rune_liq) as total_liquidity_usd, swap_count,

swap_volume_rune_usd, swap_count, to_asset_swap_count, to_rune_swap_count, total_swap_fees_usd,

(total_swap_fees_usd/swap_volume_rune_usd)*1000 as "Fees per $1000"

from thorchain.daily_pool_stats

order by day desc