superflyTotal & Circulating Supply
Updated 2022-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with df1 as
(select
date_trunc('week',BLOCK_TIMESTAMP) as date,
sum(case when FROM_CURRENCY='uluna' then FROM_AMOUNT/pow(10,6) else null end) as "from",
sum(case when to_CURRENCY='uluna' then from_AMOUNT/pow(10,6) else null end) as "to",
"from"-"to" as volume
from terra.core.ez_swaps group by 1
)
select *,1047120273 as total_supply from(
select date,
sum(volume) over (order by date) as circulating_supply
from df1) where date>='2022-01-01' and circulating_supply > 1
Run a query to Download Data