day as date,

pool_name as pool,

swap_count as swaps,

swap_volume_rune_usd as volume,

add_liquidity_count as liquidity,

total_swap_fees_usd as swap_fees,

(total_swap_fees_usd/(swap_volume_rune_usd/1000)) as fees_per_1000

FROM thorchain.daily_pool_stats

WHERE pool_name = 'BNB.BNB'

GROUP BY 1,2,3,4,5,6

ORDER BY 1 ASC