hour(block_timestamp) as block_hour, pool_name, sum(rune_amount_usd) as rune, sum(asset_amount_usd) as asset, (rune + asset) as Total_Liquidity_USD

FROM thorchain.liquidity_actions

where block_timestamp >= CURRENT_DATE - 30 and lp_action = 'remove_liquidity'

group by 1,2