strawbettyburned LUNA and burned UST
Updated 2022-04-23
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
›
⌄
with burntluna as (
SELECT
date_trunc ('day', block_timestamp) as date,
sum(token_0_amount) as LUNA_BURNT
from terra.swaps
where to_date(block_timestamp) > '2022-03-01'
and ask_currency = 'UST'
and offer_currency = 'LUNA'
and tx_status = 'SUCCEEDED'
group by 1
), burntUST as (
SELECT
date_trunc ('day', block_timestamp) as date,
sum(token_0_amount) as UST_BURNT
from terra.swaps
where to_date(block_timestamp) > '2022-03-01'
and ask_currency = 'LUNA'
and offer_currency = 'UST'
and tx_status = 'SUCCEEDED'
group by 1
)
select l.date, LUNA_BURNT, UST_BURNT
from burntluna l left join burntUST u on l.date = u.date
Run a query to Download Data