PREVIEW / stock_1hour / 2003-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-31.parquet
  size:    476 KB
  rows:    22,015
  symbols: 1,657

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-31 08:00:00	AAPL	Stock	0.4125	0.4125	0.4125	0.4125	28000.0
2003-10-31 09:00:00	AAPL	Stock	0.4139	0.417	0.4125	0.415	14612024.0
2003-10-31 10:00:00	AAPL	Stock	0.415	0.415	0.4068	0.4107	31068744.0
2003-10-31 11:00:00	AAPL	Stock	0.4107	0.4113	0.4089	0.4107	13371960.0
2003-10-31 12:00:00	AAPL	Stock	0.4107	0.4118	0.4103	0.4107	21219856.0
2003-10-31 13:00:00	AAPL	Stock	0.4107	0.4116	0.4095	0.4098	12856592.0
2003-10-31 14:00:00	AAPL	Stock	0.4102	0.4116	0.4093	0.4109	37746184.0
2003-10-31 15:00:00	AAPL	Stock	0.4109	0.4116	0.4079	0.4088	25702432.0
2003-10-31 16:00:00	AAPL	Stock	0.4086	0.4091	0.4054	0.4088	3323488.0
2003-10-31 17:00:00	AAPL	Stock	0.4098	0.4098	0.4098	0.4098	67200.0
2003-10-31 18:00:00	AAPL	Stock	0.4075	0.4075	0.4054	0.4054	128800.0
2003-10-31 08:00:00	MSFT	Stock	26.33	26.43	26.11	26.4	218901.0
2003-10-31 09:00:00	MSFT	Stock	26.39	26.4	26.15	26.29	11552357.0
2003-10-31 10:00:00	MSFT	Stock	26.29	26.38	26.11	26.17	13454237.0
2003-10-31 11:00:00	MSFT	Stock	26.16	26.2	26.11	26.19	7671444.0
2003-10-31 12:00:00	MSFT	Stock	26.2	26.24	26.13	26.15	5292111.0
2003-10-31 13:00:00	MSFT	Stock	26.15	26.24	26.128	26.14	4998712.0
2003-10-31 14:00:00	MSFT	Stock	26.13	26.21	26.12	26.14	6002482.0
2003-10-31 15:00:00	MSFT	Stock	26.15	26.29	26.12	26.13	10428371.0
2003-10-31 16:00:00	MSFT	Stock	26.13	26.3	26.13	26.2	1713869.0
2003-10-31 17:00:00	MSFT	Stock	26.18	26.23	26.05	26.19	32600.0
2003-10-31 18:00:00	MSFT	Stock	26.18	26.18	26.15	26.17	23900.0
2003-10-31 08:00:00	NVDA	Stock	0.15	0.1501	0.15	0.1501	468000.0
2003-10-31 09:00:00	NVDA	Stock	0.1501	0.1521	0.1492	0.1502	67346760.0
2003-10-31 10:00:00	NVDA	Stock	0.1502	0.1502	0.1467	0.1475	116098080.0
2003-10-31 11:00:00	NVDA	Stock	0.1473	0.1474	0.145	0.146	102462840.0
2003-10-31 12:00:00	NVDA	Stock	0.146	0.1472	0.1456	0.1461	61543080.0
2003-10-31 13:00:00	NVDA	Stock	0.146	0.1462	0.1452	0.1452	57431280.0
2003-10-31 14:00:00	NVDA	Stock	0.1452	0.1465	0.1451	0.146	54160440.0
2003-10-31 15:00:00	NVDA	Stock	0.1461	0.1472	0.1459	0.147	96800160.0
2003-10-31 16:00:00	NVDA	Stock	0.1471	0.1475	0.1462	0.1473	4695240.0
2003-10-31 17:00:00	NVDA	Stock	0.1469	0.1477	0.1469	0.1477	780000.0
2003-10-31 18:00:00	NVDA	Stock	0.1477	0.1483	0.1477	0.1483	228600.0
2003-10-31 08:00:00	AMZN	Stock	2.8	2.805	2.7965	2.7965	68000.0
2003-10-31 09:00:00	AMZN	Stock	2.805	2.8065	2.768	2.777	14749900.0
2003-10-31 10:00:00	AMZN	Stock	2.7765	2.7805	2.732	2.749	40447240.0
2003-10-31 11:00:00	AMZN	Stock	2.7495	2.755	2.74	2.7545	12109180.0
2003-10-31 12:00:00	AMZN	Stock	2.7535	2.768	2.75	2.75	13649040.0
2003-10-31 13:00:00	AMZN	Stock	2.75	2.7556	2.7415	2.7425	12360700.0
2003-10-31 14:00:00	AMZN	Stock	2.7425	2.75	2.7395	2.7415	15143620.0
2003-10-31 15:00:00	AMZN	Stock	2.7425	2.745	2.719	2.7215	33899600.0
2003-10-31 16:00:00	AMZN	Stock	2.7215	2.7585	2.7175	2.721	1409120.0
2003-10-31 17:00:00	AMZN	Stock	2.7205	2.721	2.7205	2.721	172500.0
2003-10-31 18:00:00	AMZN	Stock	2.721	2.721	2.72	2.72	18000.0
2003-10-31 09:00:00	CL	Stock	26.35	26.38	26.215	26.335	984200.0
2003-10-31 10:00:00	CL	Stock	26.33	26.65	26.2905	26.585	1293600.0
2003-10-31 11:00:00	CL	Stock	26.615	26.73	26.51	26.685	1046600.0
2003-10-31 12:00:00	CL	Stock	26.685	26.73	26.455	26.465	1388200.0
2003-10-31 13:00:00	CL	Stock	26.465	26.55	26.425	26.525	557600.0
2003-10-31 14:00:00	CL	Stock	26.525	26.575	26.435	26.46	734000.0

> showing 50 of 22,015 rows — these rows as CSV

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