princefarzamLiquidity Withdrawal from Terraswap LUNA/bLUNA Pool
Updated 2022-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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