PapasotUST burnt/minted
Updated 2022-07-07
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
›
⌄
--https://app.flipsidecrypto.com/dashboard/pleasure-to-burn-1xFfCo
--credits to the original author David Enoch(potmo)
WITH BM AS(
WITH BURNED AS(
SELECT TO_DATE(block_timestamp) AS date,
CAST(SUM (offer_amount_usd) AS INTEGER) AS "UST burned"
--CAST(SUM (token_0_amount) AS INTEGER) AS "UST minted"
FROM terra.swaps
WHERE TO_DATE(block_timestamp) >= dateadd(day, -180, current_date())
AND offer_currency = 'UST'
AND tx_status = 'SUCCEEDED'
GROUP BY 1
ORDER BY 1 ),
MINTED AS (
SELECT TO_DATE(block_timestamp) AS date,
CAST(SUM (offer_amount_USD)/ 1000000 AS INTEGER) AS "UST minted"
--CAST(SUM (token_0_amount) AS INTEGER) AS "UST minted"
FROM terra.swaps
WHERE TO_DATE(block_timestamp) >= dateadd(day, -180, current_date())
AND offer_currency = 'LUNA'
AND tx_status = 'SUCCEEDED'
GROUP BY 1
ORDER BY 1 )
SELECT *
FROM BURNED
JOIN MINTED
USING(DATE))
--SELECT * FROM BM
Run a query to Download Data