date_trunc('day',block_timestamp) as date,

lp_action as action,

SUM(rune_amount_usd) as amount_in_usd

FROM thorchain.liquidity_actions

WHERE FROM_ADDRESS = ANY(SELECT

DISTINCT FROM_ADDRESS

FROM thorchain.liquidity_actions

WHERE lp_action = 'add_liquidity'

AND pool_name=ANY(SELECT DISTINCT POOL_NAME FROM thorchain.liquidity_actions WHERE POOL_NAME LIKE 'TERRA%')

AND block_timestamp < '2022-05-09' -- A day before the Terra crash

AND block_timestamp >= '2022-05-09'

GROUP BY date,lp_action