sum(osmo_issuance) over (partition BY NULL ORDER BY date_block ASC rows UNBOUNDED PRECEDING) "Circulating_Supply"

from (select date_block,

case

when date_block = '2021-06-18' then 100000000

else 300000000/365

end as osmo_issuance

from (select distinct date(block_timestamp) as date_block

from osmosis.core.fact_msgs

where block_timestamp::date >= '2021-06-18')

)