c2ctraderUST-LUNA Highway
Updated 2022-04-16
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
›
⌄
with basic_data AS (
SELECT date_trunc('day',block_timestamp) day,
tx_status status,
offer_currency burned_coin,
ask_currency minted_coin,
TOKEN_1_AMOUNT minted_amount,
offer_amount burned_amount
from terra.swaps
WHERE
(status = 'SUCCEEDED') AND
(minted_amount>0) AND
(burned_amount > 0) AND
(minted_coin = 'LUNA' AND burned_coin = 'UST') OR
(minted_coin = 'UST' AND burned_coin = 'LUNA')
),
minted_ust as (
SELECT day, minted_coin ust,sum(minted_amount) minted_ust, burned_coin, sum(burned_amount) burned_luna from basic_data where (minted_coin = 'UST')
GROUP BY day, minted_coin, burned_coin
ORDER BY day, minted_coin
),
minted_luna as (
SELECT day, minted_coin,sum(minted_amount) minted_luna, burned_coin, sum(burned_amount) burned_ust from basic_data where (minted_coin = 'LUNA')
GROUP BY day, minted_coin, burned_coin
ORDER BY day, minted_coin
)
SELECT s.day,
s.minted_ust,
s.burned_luna,
l.minted_luna,
l.burned_ust
from minted_ust s
INNER JOIN minted_luna l ON s.day = l.day
order by day
Run a query to Download Data