cypherTerra2 dash - supply - circulating supply
    Updated 2023-01-03
    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