PREVIEW / stock_1hour / 2003-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-27.parquet
  size:    460 KB
  rows:    21,494
  symbols: 1,654

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
2003-10-27 09:00:00	AAPL	Stock	0.4036	0.4088	0.4036	0.407	30655520.0
2003-10-27 10:00:00	AAPL	Stock	0.4071	0.4082	0.4025	0.4043	28634088.0
2003-10-27 11:00:00	AAPL	Stock	0.4038	0.4045	0.4016	0.4036	19733616.0
2003-10-27 12:00:00	AAPL	Stock	0.4036	0.4043	0.4018	0.4018	11865504.0
2003-10-27 13:00:00	AAPL	Stock	0.4018	0.4038	0.4016	0.4036	13687520.0
2003-10-27 14:00:00	AAPL	Stock	0.4034	0.4036	0.4016	0.4023	13350568.0
2003-10-27 15:00:00	AAPL	Stock	0.4025	0.4046	0.4016	0.4036	27037976.0
2003-10-27 16:00:00	AAPL	Stock	0.4034	0.4045	0.4025	0.4036	2228744.0
2003-10-27 17:00:00	AAPL	Stock	0.4036	0.4036	0.4036	0.4036	16800.0
2003-10-27 08:00:00	MSFT	Stock	26.8	27.0	26.61	26.86	308157.0
2003-10-27 09:00:00	MSFT	Stock	26.86	27.02	26.65	27.01	11103297.0
2003-10-27 10:00:00	MSFT	Stock	27.01	27.05	26.87	26.99	11990138.0
2003-10-27 11:00:00	MSFT	Stock	26.99	27.1	26.94	27.0	7772231.0
2003-10-27 12:00:00	MSFT	Stock	27.0	27.1	26.99	27.0	4841456.0
2003-10-27 13:00:00	MSFT	Stock	27.019	27.1	27.0	27.05	4118376.0
2003-10-27 14:00:00	MSFT	Stock	27.05	27.05	26.92	26.95	6051379.0
2003-10-27 15:00:00	MSFT	Stock	26.95	27.02	26.85	26.91	10239520.0
2003-10-27 16:00:00	MSFT	Stock	26.88	26.99	26.85	26.93	1674700.0
2003-10-27 17:00:00	MSFT	Stock	27.0	27.0	26.88	26.89	279940.0
2003-10-27 18:00:00	MSFT	Stock	26.92	26.92	26.85	26.85	12848.0
2003-10-27 08:00:00	NVDA	Stock	0.1428	0.1471	0.1428	0.145	541920.0
2003-10-27 09:00:00	NVDA	Stock	0.1429	0.145	0.1429	0.1447	41112960.0
2003-10-27 10:00:00	NVDA	Stock	0.1447	0.1447	0.1434	0.1436	46420560.0
2003-10-27 11:00:00	NVDA	Stock	0.1437	0.1441	0.1423	0.1429	34553280.0
2003-10-27 12:00:00	NVDA	Stock	0.1429	0.144	0.1428	0.1435	17336280.0
2003-10-27 13:00:00	NVDA	Stock	0.1435	0.144	0.1434	0.1436	17834880.0
2003-10-27 14:00:00	NVDA	Stock	0.1436	0.1436	0.1426	0.1432	29481240.0
2003-10-27 15:00:00	NVDA	Stock	0.1432	0.1438	0.1427	0.1437	32915280.0
2003-10-27 16:00:00	NVDA	Stock	0.1437	0.1437	0.1432	0.1436	2724000.0
2003-10-27 17:00:00	NVDA	Stock	0.1435	0.1435	0.1435	0.1435	108000.0
2003-10-27 08:00:00	AMZN	Stock	2.75	2.772	2.7455	2.754	414100.0
2003-10-27 09:00:00	AMZN	Stock	2.7525	2.7625	2.725	2.7555	22516700.0
2003-10-27 10:00:00	AMZN	Stock	2.7554	2.76	2.728	2.7465	23992760.0
2003-10-27 11:00:00	AMZN	Stock	2.7461	2.749	2.738	2.741	12006920.0
2003-10-27 12:00:00	AMZN	Stock	2.74	2.743	2.736	2.74	8105900.0
2003-10-27 13:00:00	AMZN	Stock	2.74	2.7495	2.7395	2.746	8530020.0
2003-10-27 14:00:00	AMZN	Stock	2.746	2.748	2.7365	2.7465	11583400.0
2003-10-27 15:00:00	AMZN	Stock	2.746	2.7556	2.7365	2.738	24643260.0
2003-10-27 16:00:00	AMZN	Stock	2.738	2.75	2.738	2.7425	988240.0
2003-10-27 17:00:00	AMZN	Stock	2.7415	2.7415	2.739	2.7396	618000.0
2003-10-27 18:00:00	AMZN	Stock	2.741	2.741	2.7396	2.74	70000.0
2003-10-27 09:00:00	CL	Stock	25.85	26.1	25.825	25.975	1117800.0
2003-10-27 10:00:00	CL	Stock	25.975	25.98	25.535	25.67	2268800.0
2003-10-27 11:00:00	CL	Stock	25.675	25.725	25.57	25.605	2046400.0
2003-10-27 12:00:00	CL	Stock	25.595	25.72	25.575	25.575	1458200.0
2003-10-27 13:00:00	CL	Stock	25.575	25.59	25.375	25.48	2086800.0
2003-10-27 14:00:00	CL	Stock	25.48	25.575	25.455	25.53	1660200.0
2003-10-27 15:00:00	CL	Stock	25.525	25.63	25.525	25.55	2133400.0
2003-10-27 16:00:00	CL	Stock	25.545	25.7	25.54	25.545	92000.0

> showing 49 of 21,494 rows — these rows as CSV

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