PREVIEW / stock_1hour / 2002-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-27.parquet
  size:    423 KB
  rows:    19,840
  symbols: 1,517

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
2002-11-27 08:00:00	AAPL	Stock	0.2777	0.2804	0.2777	0.2804	190400.0
2002-11-27 09:00:00	AAPL	Stock	0.2795	0.2795	0.2754	0.2765	29048040.0
2002-11-27 10:00:00	AAPL	Stock	0.277	0.2793	0.2759	0.2793	38458000.0
2002-11-27 11:00:00	AAPL	Stock	0.2795	0.2804	0.277	0.2779	24232600.0
2002-11-27 12:00:00	AAPL	Stock	0.278	0.2821	0.2773	0.282	58997848.0
2002-11-27 13:00:00	AAPL	Stock	0.282	0.2832	0.2786	0.2804	30423064.0
2002-11-27 14:00:00	AAPL	Stock	0.2805	0.2821	0.2795	0.2811	19210632.0
2002-11-27 15:00:00	AAPL	Stock	0.2811	0.2816	0.2777	0.2804	40136376.0
2002-11-27 16:00:00	AAPL	Stock	0.2811	0.2827	0.2786	0.2786	6848800.0
2002-11-27 17:00:00	AAPL	Stock	0.2786	0.2789	0.2786	0.2789	67200.0
2002-11-27 08:00:00	MSFT	Stock	28.515	28.75	28.5	28.6905	69700.0
2002-11-27 09:00:00	MSFT	Stock	28.6905	28.865	28.665	28.83	7103376.0
2002-11-27 10:00:00	MSFT	Stock	28.835	29.148	28.8115	29.095	12891582.0
2002-11-27 11:00:00	MSFT	Stock	29.1	29.2	29.07	29.175	5905334.0
2002-11-27 12:00:00	MSFT	Stock	29.175	29.27	29.131	29.225	6402786.0
2002-11-27 13:00:00	MSFT	Stock	29.23	29.307	29.185	29.245	4925100.0
2002-11-27 14:00:00	MSFT	Stock	29.245	29.295	29.15	29.215	4823514.0
2002-11-27 15:00:00	MSFT	Stock	29.215	29.225	29.035	29.04	6751532.0
2002-11-27 16:00:00	MSFT	Stock	29.05	29.125	29.01	29.045	1317778.0
2002-11-27 17:00:00	MSFT	Stock	29.045	29.075	29.045	29.065	4800.0
2002-11-27 18:00:00	MSFT	Stock	29.075	29.09	29.075	29.09	1600.0
2002-11-27 08:00:00	NVDA	Stock	0.1358	0.1371	0.1358	0.1362	7092000.0
2002-11-27 09:00:00	NVDA	Stock	0.1367	0.1379	0.136	0.1372	105770760.0
2002-11-27 10:00:00	NVDA	Stock	0.1371	0.1391	0.1371	0.1377	161848800.0
2002-11-27 11:00:00	NVDA	Stock	0.1377	0.1387	0.1375	0.1382	86555400.0
2002-11-27 12:00:00	NVDA	Stock	0.1382	0.1414	0.1379	0.1412	181168200.0
2002-11-27 13:00:00	NVDA	Stock	0.1411	0.1447	0.1411	0.1439	182065200.0
2002-11-27 14:00:00	NVDA	Stock	0.1439	0.1442	0.1421	0.1432	121607280.0
2002-11-27 15:00:00	NVDA	Stock	0.1432	0.1432	0.1413	0.1423	161392680.0
2002-11-27 16:00:00	NVDA	Stock	0.1423	0.1425	0.1417	0.1423	13552440.0
2002-11-27 17:00:00	NVDA	Stock	0.1422	0.1424	0.1422	0.1423	696000.0
2002-11-27 18:00:00	NVDA	Stock	0.1423	0.1427	0.1423	0.1427	626400.0
2002-11-27 08:00:00	AMZN	Stock	1.1698	1.195	1.1698	1.194	643000.0
2002-11-27 09:00:00	AMZN	Stock	1.194	1.21	1.186	1.198	19706900.0
2002-11-27 10:00:00	AMZN	Stock	1.1981	1.212	1.1885	1.191	25629820.0
2002-11-27 11:00:00	AMZN	Stock	1.1915	1.1985	1.189	1.1935	13708360.0
2002-11-27 12:00:00	AMZN	Stock	1.193	1.2052	1.193	1.198	9054380.0
2002-11-27 13:00:00	AMZN	Stock	1.198	1.203	1.1956	1.1995	4902240.0
2002-11-27 14:00:00	AMZN	Stock	1.1995	1.2075	1.1995	1.2065	6704060.0
2002-11-27 15:00:00	AMZN	Stock	1.2065	1.21	1.195	1.204	19395600.0
2002-11-27 16:00:00	AMZN	Stock	1.202	1.2105	1.2	1.208	1398000.0
2002-11-27 17:00:00	AMZN	Stock	1.2095	1.2095	1.204	1.204	372000.0
2002-11-27 18:00:00	AMZN	Stock	1.204	1.204	1.2031	1.2031	6000.0
2002-11-27 09:00:00	CL	Stock	25.575	25.6	25.475	25.515	403200.0
2002-11-27 10:00:00	CL	Stock	25.515	25.95	25.515	25.855	626000.0
2002-11-27 11:00:00	CL	Stock	25.86	26.25	25.86	26.05	464600.0
2002-11-27 12:00:00	CL	Stock	26.05	26.06	25.91	25.96	270400.0
2002-11-27 13:00:00	CL	Stock	25.96	26.065	25.925	26.0	381600.0
2002-11-27 14:00:00	CL	Stock	26.015	26.075	25.895	25.925	190000.0
2002-11-27 15:00:00	CL	Stock	25.925	26.075	25.91	25.97	445000.0

> showing 50 of 19,840 rows — these rows as CSV

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