BLOCK_TIMESTAMP::DATE as date,

case

when BLOCK_TIMESTAMP>='2022-12-25' then 'Holidays and new year'

else 'Before holidays' end as days,

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

where BLOCK_TIMESTAMP>='2022-12-01'

group by 1,2