c2ctraderLUNA Market Cap - last year
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
›
⌄
--Evaluate average daily price of LUNA in USD
WITH luna_price as (
SELECT date_trunc('day',block_timestamp) day, avg(price_usd) luna_price_usd from terra.oracle_prices
WHERE (symbol = 'LUNA' and day >= DATEADD(day, -365, getdate()))
GROUP BY DAY
ORDER BY DAY
),
--Evaluate of daily LUNA market cap in LUNA and USD
market_cap as (
SELECT date_trunc('day',DATE) day, sum(balance_usd) market_cap_usd from terra.daily_balances
WHERE (currency = 'LUNA' and day >= DATEADD(day, -365, getdate()))
GROUP BY DAY
ORDER BY DAY
)
--Join tables
SELECT luna_price.day, luna_price.luna_price_usd, market_cap.market_cap_usd
FROM luna_price
JOIN market_cap on luna_price.day = market_cap.day
Run a query to Download Data