WITH UST_ZAP AS
(SELECT EVENT_ATTRIBUTES:"lp_token"::string as LP_ADDRESS,
EVENT_ATTRIBUTES:"0_amount"::float/1e6 as USD_AMOUNT, MSG_VALUE:"sender"::string AS ADDRESS
FROM terra.msg_events LEFT JOIN terra.msgs ON terra.msg_events.TX_ID = terra.msgs.TX_ID
WHERE EVENT_TYPE = 'from_contract'
AND EVENT_ATTRIBUTES:"0_action" = 'zap_into_strategy'
AND EVENT_ATTRIBUTES: "0_contract_address" = 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2') -- Zap into LP
SELECT LP_ADDRESS, SUM(USD_AMOUNT) AS USD_AMOUNT FROM UST_ZAP
GROUP BY LP_ADDRESS
ORDER BY USD_AMOUNT DESC