piper143. Astroport TVL before launch date (2021-12-28)
Updated 2022-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH provide_liquidity AS (
SELECT
*
FROM
terra.msg_events
WHERE
event_attributes:"1_action" = 'increase_lockup_position'
AND
event_attributes:"1_contract_address" IS NOT NULL
AND
event_attributes:"1_contract_address" = 'terra1627ldjvxatt54ydd3ns6xaxtd68a2vtyu7kakj'
AND
event_type = 'wasm'
--GROUP BY day
),
remove_liquidity AS (
SELECT
DATE(block_timestamp) AS day,
SUM(event_attributes:refund_assets[0]:amount / POW(10,6)) AS bLuna_amount,
SUM( event_attributes:refund_assets[1]:amount / POW(10,6)) AS Luna_amount
FROM
terra.msg_events
WHERE
event_attributes:"0_action" = 'withdraw_from_lockup'
AND
event_attributes:"0_contract_address" IS NOT NULL
AND
event_attributes:"0_contract_address" = 'terra1627ldjvxatt54ydd3ns6xaxtd68a2vtyu7kakj'
AND
event_type = 'wasm'
GROUP BY day
),
daily_tvl_in_bluna_luna AS (
SELECT
Run a query to Download Data