/* Replace [yourstorageaccount] with the name of the Azure Blob Storage */
select Top 100 * from
 OPENROWSET(BULK 'https://[yourstorageaccount].dfs.core.windows.net/synapse/tickerdata/sp500.csv',
 
     FORMAT = 'CSV',
     PARSER_VERSION = '2.0',
     HEADER_ROW =TRUE --enable header row
     )
 AS [result]
 
 /* Queries used in blog post 
 select Min([date])as min_date,Max([date]) as max_date from SP500
 
select Year([date]) as stockyear, min([close]) as lowest, max([close]) as highest,
round((max([close])-min([close]))/min([close])*100,2) as pctdiff from sp500 
group by Year([date])
order by pctdiff desc

Select TOP 5 [date], [Close], Lag([Close],1) OVER(ORDER BY [Date]) as previousclose, 
(100*[Close]/Lag([Close],1) OVER(ORDER BY [Date]))-100 as pct_close_change
from SP500
ORDER BY pct_close_change ASC