ramishoowUntitled Query
Updated 2023-01-05
9
1
2
3
4
5
›
⌄
with ramishoow as (select 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,
--with ramishoow as (select 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, date_trunc('day',BLOCK_TIMESTAMP) as time from terra.core.ez_swaps group by time ), rami as (select
sum(circulating_volume) over (order by time) as circulating_supply , time from ramishoow) select circulating_supply, circulating_supply*100/1043378214 as ratio from rami where time='2022-12-11'
Run a query to Download Data