select

-- first argument is unit of time to add, second is amount to increment, third is starting date

dateadd(month, '-' || row_number() over (order by null), '2023-01-01') as cols

from table (generator(rowcount => 23)) --increment this

),

select date(date_trunc('month',cols) + INTERVAL '1 month' - INTERVAL '1 DAY' ) as _col from dt

)

select * from cte2

select date_trunc('month',a.date) as months,a.address,a.balance from

(select date, address, balance/pow(10,decimal) as balance

from osmosis.core.fact_daily_balances

where currency='uosmo'

and date in (select cte2.reqcol from cte2)) as a