princefarzamLiquidity Withdrawal from Terraswap LUNA/bLUNA Pool
    Updated 2022-02-03
    SELECT
    block_timestamp,
    EVENT_ATTRIBUTES:refund_assets[0]:amount::INT/POW(10,6) AS bLUNA_AMOUNT,
    EVENT_ATTRIBUTES:refund_assets[1].amount::INT/POW(10,6) AS UST_AMOUNT,
    (SELECT
    avg(price_usd)
    from terra.oracle_prices
    where symbol= 'LUNA'
    and block_timestamp >= '2021-12-14') * bLUNA_AMOUNT AS bLUNA_AMOUNT_IN_UST,
    bLUNA_AMOUNT_IN_UST + UST_AMOUNT AS Terraswap_bLUNA_UST_Pair_Burn_in_UST,
    SUM(Terraswap_bLUNA_UST_Pair_Burn_in_UST) OVER (ORDER BY block_timestamp ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative

    FROM TERRA.MSG_EVENTS
    WHERE event_attributes: "0_contract_address" = 'terra1qmr8j3m9x53dhws0yxhymzsvnkjq886yk8k93m'
    AND event_attributes: "1_action" = 'withdraw_liquidity'
    AND block_timestamp>= '2021-12-14'
    ORDER BY 1 ASC
    Run a query to Download Data