with t1 as (select row_number() over (order by quote_date) n

,quote_date

,close_price

from #google_stock)

select a.n

,a.quote_date

,a.close_price

...