c2ctraderDaily minted LUNA and burned UST
Updated 2022-04-15
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
›
⌄
with basic_data AS (
SELECT date_trunc('day',block_timestamp) day, tx_status status, ask_currency minted_coin, offer_currency burned_coin, offer_amount_usd burned_amount_usd from terra.swaps
WHERE
(status = 'SUCCEEDED') AND
(burned_amount_usd > 0) AND
(minted_coin = 'LUNA' AND burned_coin = 'UST') OR
(minted_coin = 'UST' AND burned_coin = 'LUNA')
--LIMIT 50
),
minted_ust as (
SELECT day, minted_coin, burned_coin, sum(burned_amount_usd) burned_luna_usd 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, burned_coin, sum(burned_amount_usd) burned_ust_usd from basic_data where (minted_coin = 'LUNA')
GROUP BY day, minted_coin, burned_coin
ORDER BY day, minted_coin
)
SELECT minted_ust.day, minted_ust.minted_coin coin_ust_minted, minted_ust.burned_luna_usd, minted_luna.minted_coin coin_luna_minted, minted_luna.burned_ust_usd
from minted_ust
INNER JOIN minted_luna ON minted_ust.day = minted_luna.day
Run a query to Download Data