PREVIEW / stock_1hour / 2006-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-03.parquet
  size:    593 KB
  rows:    28,411
  symbols: 2,252

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2006-05-03 04:00:00	AAPL	Stock	2.5579	2.5579	2.5579	2.5579	2800.0
2006-05-03 08:00:00	AAPL	Stock	2.5571	2.5714	2.5571	2.5661	2732772.0
2006-05-03 09:00:00	AAPL	Stock	2.5646	2.5732	2.5064	2.5139	157232348.0
2006-05-03 10:00:00	AAPL	Stock	2.5139	2.535	2.5129	2.5186	122518844.0
2006-05-03 11:00:00	AAPL	Stock	2.5189	2.53	2.5079	2.5267	78522136.0
2006-05-03 12:00:00	AAPL	Stock	2.5264	2.5486	2.5254	2.5396	93902984.0
2006-05-03 13:00:00	AAPL	Stock	2.5396	2.5493	2.525	2.5336	62603520.0
2006-05-03 14:00:00	AAPL	Stock	2.5336	2.5357	2.52	2.5221	59723384.0
2006-05-03 15:00:00	AAPL	Stock	2.5218	2.5464	2.5211	2.5407	92572900.0
2006-05-03 16:00:00	AAPL	Stock	2.5414	2.5425	2.5393	2.5407	6266708.0
2006-05-03 17:00:00	AAPL	Stock	2.5404	2.5425	2.5393	2.5407	373660.0
2006-05-03 18:00:00	AAPL	Stock	2.5407	2.5421	2.54	2.54	241360.0
2006-05-03 06:00:00	MSFT	Stock	24.03	24.03	24.03	24.03	1000.0
2006-05-03 07:00:00	MSFT	Stock	24.03	24.03	24.03	24.03	100.0
2006-05-03 08:00:00	MSFT	Stock	24.03	24.06	23.5	23.93	403627.0
2006-05-03 09:00:00	MSFT	Stock	23.94	24.04	23.92	23.93	13666264.0
2006-05-03 10:00:00	MSFT	Stock	23.93	24.0	23.73	23.78	26319457.0
2006-05-03 11:00:00	MSFT	Stock	23.78	23.9	23.6	23.65	25521438.0
2006-05-03 12:00:00	MSFT	Stock	23.65	23.68	23.5	23.53	22788357.0
2006-05-03 13:00:00	MSFT	Stock	23.53	23.597	23.34	23.37	34001039.0
2006-05-03 14:00:00	MSFT	Stock	23.36	23.435	23.24	23.36	29311241.0
2006-05-03 15:00:00	MSFT	Stock	23.36	23.4	23.15	23.17	46890008.0
2006-05-03 16:00:00	MSFT	Stock	23.17	23.54	23.14	23.2	5850927.0
2006-05-03 17:00:00	MSFT	Stock	23.2	23.25	23.17	23.24	1044038.0
2006-05-03 18:00:00	MSFT	Stock	23.23	23.25	23.23	23.23	16227.0
2006-05-03 08:00:00	NVDA	Stock	0.5167	0.5167	0.5095	0.5097	240000.0
2006-05-03 09:00:00	NVDA	Stock	0.51	0.523	0.508	0.523	56136780.0
2006-05-03 10:00:00	NVDA	Stock	0.5232	0.5233	0.5098	0.512	71699400.0
2006-05-03 11:00:00	NVDA	Stock	0.512	0.5143	0.5108	0.5127	37573440.0
2006-05-03 12:00:00	NVDA	Stock	0.5125	0.5142	0.5107	0.5135	38264940.0
2006-05-03 13:00:00	NVDA	Stock	0.5135	0.5155	0.5113	0.5123	37795380.0
2006-05-03 14:00:00	NVDA	Stock	0.5123	0.5145	0.5122	0.5123	37338180.0
2006-05-03 15:00:00	NVDA	Stock	0.5125	0.5178	0.5123	0.5178	79068600.0
2006-05-03 16:00:00	NVDA	Stock	0.5177	0.5182	0.516	0.5175	1605540.0
2006-05-03 17:00:00	NVDA	Stock	0.5177	0.5183	0.515	0.515	6090660.0
2006-05-03 18:00:00	NVDA	Stock	0.515	0.515	0.515	0.515	6000.0
2006-05-03 09:00:00	AMZN	Stock	1.722	1.722	1.6935	1.694	14159080.0
2006-05-03 10:00:00	AMZN	Stock	1.6935	1.705	1.6805	1.6925	29026640.0
2006-05-03 11:00:00	AMZN	Stock	1.6925	1.697	1.677	1.6775	20470600.0
2006-05-03 12:00:00	AMZN	Stock	1.678	1.695	1.6755	1.6945	15440660.0
2006-05-03 13:00:00	AMZN	Stock	1.6945	1.7025	1.6885	1.6905	19459920.0
2006-05-03 14:00:00	AMZN	Stock	1.691	1.698	1.685	1.6926	18301960.0
2006-05-03 15:00:00	AMZN	Stock	1.693	1.7	1.676	1.699	16986320.0
2006-05-03 16:00:00	AMZN	Stock	1.699	1.699	1.6882	1.698	3285000.0
2006-05-03 18:00:00	AMZN	Stock	1.6965	1.6965	1.6965	1.6965	20000.0
2006-05-03 08:00:00	CL	Stock	29.6	29.6	29.5	29.5	400.0
2006-05-03 09:00:00	CL	Stock	29.47	29.475	29.28	29.28	462800.0
2006-05-03 10:00:00	CL	Stock	29.275	29.415	29.14	29.4	446400.0
2006-05-03 11:00:00	CL	Stock	29.405	29.5	29.37	29.495	568400.0
2006-05-03 12:00:00	CL	Stock	29.49	29.645	29.425	29.595	341800.0

> showing 50 of 28,411 rows — these rows as CSV

> unlock the full archive -- $79 one-time