from thorchain.liquidity_actions

where lp_action = 'add_liquidity' and block_timestamp >= CURRENT_DATE - 1

group by 2

order by 1 desc