PREVIEW / stock_1hour / 2006-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-23.parquet
  size:    627 KB
  rows:    30,039
  symbols: 2,415

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-10-23 07:00:00	AAPL	Stock	2.8614	2.8614	2.8571	2.8571	5600.0
2006-10-23 08:00:00	AAPL	Stock	2.86	2.875	2.8571	2.8643	4273528.0
2006-10-23 09:00:00	AAPL	Stock	2.8646	2.8782	2.8482	2.8654	125626452.0
2006-10-23 10:00:00	AAPL	Stock	2.8654	2.9143	2.8636	2.9118	180704664.0
2006-10-23 11:00:00	AAPL	Stock	2.9121	2.9211	2.9054	2.9081	97642188.0
2006-10-23 12:00:00	AAPL	Stock	2.9082	2.925	2.9079	2.9168	81886196.0
2006-10-23 13:00:00	AAPL	Stock	2.9168	2.9232	2.9129	2.9146	57634556.0
2006-10-23 14:00:00	AAPL	Stock	2.9143	2.9211	2.8957	2.9175	95452280.0
2006-10-23 15:00:00	AAPL	Stock	2.9175	2.9246	2.9025	2.9096	109347728.0
2006-10-23 16:00:00	AAPL	Stock	2.9093	2.9104	2.9054	2.9079	9063096.0
2006-10-23 17:00:00	AAPL	Stock	2.9071	2.9093	2.9054	2.9057	155652.0
2006-10-23 18:00:00	AAPL	Stock	2.9057	2.9089	2.9054	2.9089	54908.0
2006-10-23 19:00:00	AAPL	Stock	2.9089	2.9089	2.9054	2.9054	29652.0
2006-10-23 08:00:00	MSFT	Stock	28.42	28.48	28.36	28.4	15418.0
2006-10-23 09:00:00	MSFT	Stock	28.36	28.41	28.18	28.4	4812363.0
2006-10-23 10:00:00	MSFT	Stock	28.4	28.6	28.39	28.56	8484069.0
2006-10-23 11:00:00	MSFT	Stock	28.56	28.69	28.45	28.5	9802236.0
2006-10-23 12:00:00	MSFT	Stock	28.5	28.61	28.48	28.52	4586147.0
2006-10-23 13:00:00	MSFT	Stock	28.52	28.59	28.47	28.55	2876438.0
2006-10-23 14:00:00	MSFT	Stock	28.54	28.55	28.42	28.43	5160231.0
2006-10-23 15:00:00	MSFT	Stock	28.44	28.5	28.42	28.44	9546344.0
2006-10-23 16:00:00	MSFT	Stock	28.49	28.605	28.42	28.48	1812947.0
2006-10-23 17:00:00	MSFT	Stock	28.44	28.47	28.44	28.47	72086.0
2006-10-23 18:00:00	MSFT	Stock	28.48	28.48	28.46	28.46	125300.0
2006-10-23 19:00:00	MSFT	Stock	28.4	28.4	28.4	28.4	100.0
2006-10-23 09:00:00	NVDA	Stock	0.5275	0.5323	0.525	0.5313	25124520.0
2006-10-23 10:00:00	NVDA	Stock	0.5315	0.5415	0.5315	0.5335	63844740.0
2006-10-23 11:00:00	NVDA	Stock	0.5335	0.5375	0.5333	0.5357	28414560.0
2006-10-23 12:00:00	NVDA	Stock	0.5358	0.5378	0.5317	0.5328	24026340.0
2006-10-23 13:00:00	NVDA	Stock	0.5327	0.5345	0.5317	0.5335	26166600.0
2006-10-23 14:00:00	NVDA	Stock	0.5335	0.5337	0.525	0.5272	54561420.0
2006-10-23 15:00:00	NVDA	Stock	0.5272	0.5297	0.525	0.5265	43942980.0
2006-10-23 16:00:00	NVDA	Stock	0.5265	0.5268	0.525	0.525	2235000.0
2006-10-23 18:00:00	NVDA	Stock	0.5263	0.5263	0.5263	0.5263	2520000.0
2006-10-23 19:00:00	NVDA	Stock	0.5258	0.5258	0.5247	0.5247	60000.0
2006-10-23 08:00:00	AMZN	Stock	1.626	1.629	1.626	1.627	48000.0
2006-10-23 09:00:00	AMZN	Stock	1.623	1.628	1.607	1.618	32235780.0
2006-10-23 10:00:00	AMZN	Stock	1.618	1.63	1.618	1.6275	27978000.0
2006-10-23 11:00:00	AMZN	Stock	1.628	1.6455	1.628	1.6335	31176460.0
2006-10-23 12:00:00	AMZN	Stock	1.634	1.6415	1.6285	1.6335	13758120.0
2006-10-23 13:00:00	AMZN	Stock	1.6335	1.6338	1.626	1.6285	7751140.0
2006-10-23 14:00:00	AMZN	Stock	1.6285	1.64	1.626	1.637	15200840.0
2006-10-23 15:00:00	AMZN	Stock	1.6365	1.6435	1.636	1.6415	28184040.0
2006-10-23 16:00:00	AMZN	Stock	1.6435	1.644	1.6365	1.644	792880.0
2006-10-23 17:00:00	AMZN	Stock	1.644	1.6445	1.644	1.6445	12000.0
2006-10-23 09:00:00	CL	Stock	30.34	30.36	30.075	30.255	331200.0
2006-10-23 10:00:00	CL	Stock	30.25	30.335	30.185	30.31	332200.0
2006-10-23 11:00:00	CL	Stock	30.315	30.34	30.22	30.315	718400.0
2006-10-23 12:00:00	CL	Stock	30.31	30.34	30.26	30.295	489000.0
2006-10-23 13:00:00	CL	Stock	30.3	30.35	30.26	30.3	489200.0

> showing 50 of 30,039 rows — these rows as CSV

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