sarathust luna highway 2
Updated 2022-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH minted_luna as (
SELECT date(block_timestamp) as date2,sum(token_0_amount_usd) as minted_luna from terra.swaps where token_0_currency='LUNA'
GROUP by 1
),
burnt_ust as (
SELECT date(block_timestamp) as date1,sum(token_0_amount_usd) as burn_ust from terra.swaps where ask_currency='LUNA'
GROUP by 1
)
SELECT * from minted_luna JOIN burnt_ust on minted_luna.date2=burnt_ust.date1
LIMIT 1000
Run a query to Download Data