binhachon77. [Hard] Apollo Inflow: Total money zap into different vault on Apollo
    Updated 2021-10-05
    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

    Run a query to Download Data