cypherTerra2 dash - supply - circulating supply
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with t1 as
(select
date_trunc('day',BLOCK_TIMESTAMP) as date,
sum(case when FROM_CURRENCY='uluna' then FROM_AMOUNT/1e6 else null end) as from_amountt,
sum(case when to_CURRENCY='uluna' then FROM_AMOUNT/1e6 else null end) as to_amountt,
from_amountt-to_amountt as circulating_volume,
sum(circulating_volume) over (order by date) as circulating_supply
from
terra.core.ez_swaps
group by date
)
-- t3 as
-- (select
-- sum(circulating_volume) over (order by date) as circulating_supply , DATE from t1)
-- select circulating_supply, circulating_supply*100/1043378214 as ratio from t3
-- where
-- date='2022-12-11'
select * from t1
Run a query to Download Data