anniecryptoLUNA Market Cap_over 90 days
Updated 2022-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with table1 as (select date_trunc('day',date) as daily1, sum(balance) as circulating_supply
from terra.daily_balances
where currency LIKE 'LUNA' and balance is not null
and daily1 >= '2022-02-09'
and daily1 <= '2022-05-09'
group by 1),
table2 as (select block_timestamp::date as daily2, avg(price_usd) as price_LUNA
from terra.oracle_prices
where currency = 'uluna'
and daily2 >= '2022-02-09'
and daily2 <= '2022-05-09'
group by 1)
select daily1, price_LUNA, circulating_supply * price_LUNA as market_capitalisation
from table1, table2 where daily1 = daily2
Run a query to Download Data