superflyTotal & Circulating Supply
    Updated 2022-12-14
    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