select date(block_timestamp) as date, sum(Rune_amount) as Total_amount, sum(Rune_amount_usd) as Total_amount_usd,
count(*) as Total_volume, lp_action, pool_name from thorchain.liquidity_actions
where block_timestamp >= CURRENT_DATE - 180
group by lp_Action, pool_name, block_timestamp order by block_timestamp desc;