PREVIEW / stock_1hour / 2006-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-21.parquet
  size:    603 KB
  rows:    28,645
  symbols: 2,354

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-09-21 07:00:00	AAPL	Stock	2.6911	2.6911	2.6893	2.6893	84000.0
2006-09-21 08:00:00	AAPL	Stock	2.6964	2.7018	2.6911	2.6986	1482404.0
2006-09-21 09:00:00	AAPL	Stock	2.6982	2.7075	2.6789	2.6879	94187576.0
2006-09-21 10:00:00	AAPL	Stock	2.6879	2.7075	2.6736	2.7004	135945376.0
2006-09-21 11:00:00	AAPL	Stock	2.7004	2.7164	2.6957	2.7025	113383648.0
2006-09-21 12:00:00	AAPL	Stock	2.7029	2.7046	2.6711	2.6796	104860308.0
2006-09-21 13:00:00	AAPL	Stock	2.6796	2.6879	2.6611	2.6626	88432764.0
2006-09-21 14:00:00	AAPL	Stock	2.6639	2.6714	2.6546	2.6554	103932836.0
2006-09-21 15:00:00	AAPL	Stock	2.6554	2.6693	2.6436	2.6639	145200804.0
2006-09-21 16:00:00	AAPL	Stock	2.6643	2.6693	2.6629	2.6675	2667112.0
2006-09-21 17:00:00	AAPL	Stock	2.6675	2.6686	2.6657	2.6657	369852.0
2006-09-21 18:00:00	AAPL	Stock	2.6657	2.6657	2.6646	2.6646	70840.0
2006-09-21 19:00:00	AAPL	Stock	2.665	2.665	2.6643	2.6643	36960.0
2006-09-21 08:00:00	MSFT	Stock	27.26	27.3	27.17	27.19	59694.0
2006-09-21 09:00:00	MSFT	Stock	27.19	27.25	27.11	27.11	4636812.0
2006-09-21 10:00:00	MSFT	Stock	27.11	27.22	27.0	27.13	9890712.0
2006-09-21 11:00:00	MSFT	Stock	27.13	27.18	26.96	27.01	6778012.0
2006-09-21 12:00:00	MSFT	Stock	27.01	27.12	26.95	27.07	5976972.0
2006-09-21 13:00:00	MSFT	Stock	27.07	27.08	26.91	26.98	7829968.0
2006-09-21 14:00:00	MSFT	Stock	26.98	27.04	26.89	26.9	6492515.0
2006-09-21 15:00:00	MSFT	Stock	26.9	26.97	26.85	26.89	13603935.0
2006-09-21 16:00:00	MSFT	Stock	26.89	26.95	26.88	26.94	122332.0
2006-09-21 17:00:00	MSFT	Stock	26.94	26.94	26.89	26.89	19625.0
2006-09-21 18:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	900.0
2006-09-21 08:00:00	NVDA	Stock	0.521	0.521	0.517	0.5183	610800.0
2006-09-21 09:00:00	NVDA	Stock	0.5192	0.52	0.5073	0.5107	62059920.0
2006-09-21 10:00:00	NVDA	Stock	0.5105	0.5177	0.5077	0.5137	102226440.0
2006-09-21 11:00:00	NVDA	Stock	0.5135	0.5208	0.5133	0.5151	76040400.0
2006-09-21 12:00:00	NVDA	Stock	0.5152	0.516	0.5075	0.5092	56591040.0
2006-09-21 13:00:00	NVDA	Stock	0.5092	0.5125	0.5072	0.51	56051640.0
2006-09-21 14:00:00	NVDA	Stock	0.5102	0.5125	0.5075	0.5109	76501080.0
2006-09-21 15:00:00	NVDA	Stock	0.511	0.5125	0.5085	0.5113	99579120.0
2006-09-21 16:00:00	NVDA	Stock	0.5113	0.5127	0.5102	0.512	2184000.0
2006-09-21 17:00:00	NVDA	Stock	0.512	0.5125	0.5118	0.5125	279000.0
2006-09-21 19:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	48000.0
2006-09-21 08:00:00	AMZN	Stock	1.6045	1.605	1.6045	1.605	4000.0
2006-09-21 09:00:00	AMZN	Stock	1.608	1.628	1.608	1.61	8680960.0
2006-09-21 10:00:00	AMZN	Stock	1.61	1.6175	1.597	1.6015	16608620.0
2006-09-21 11:00:00	AMZN	Stock	1.6015	1.615	1.6015	1.6105	12808300.0
2006-09-21 12:00:00	AMZN	Stock	1.61	1.612	1.5475	1.5525	41765200.0
2006-09-21 13:00:00	AMZN	Stock	1.5525	1.569	1.55	1.5545	50527940.0
2006-09-21 14:00:00	AMZN	Stock	1.555	1.555	1.5095	1.5315	83257300.0
2006-09-21 15:00:00	AMZN	Stock	1.5315	1.532	1.5035	1.512	92156860.0
2006-09-21 16:00:00	AMZN	Stock	1.5105	1.5125	1.507	1.5125	822480.0
2006-09-21 17:00:00	AMZN	Stock	1.5125	1.5135	1.5125	1.5135	90000.0
2006-09-21 18:00:00	AMZN	Stock	1.515	1.516	1.515	1.515	26000.0
2006-09-21 08:00:00	CL	Stock	30.925	30.925	30.925	30.925	4600.0
2006-09-21 09:00:00	CL	Stock	31.07	31.22	31.005	31.115	252000.0
2006-09-21 10:00:00	CL	Stock	31.105	31.115	30.95	30.95	425000.0
2006-09-21 11:00:00	CL	Stock	30.95	31.075	30.875	30.955	350600.0

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

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