PREVIEW / stock_1hour / 2003-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-29.parquet
  size:    480 KB
  rows:    22,974
  symbols: 1,647

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-29 08:00:00	AAPL	Stock	0.4207	0.4214	0.4207	0.4214	39200.0
2003-10-29 09:00:00	AAPL	Stock	0.4207	0.4209	0.4184	0.4193	110000688.0
2003-10-29 10:00:00	AAPL	Stock	0.4193	0.4221	0.4168	0.422	27412896.0
2003-10-29 11:00:00	AAPL	Stock	0.4218	0.4218	0.4179	0.4202	18125968.0
2003-10-29 12:00:00	AAPL	Stock	0.4204	0.4216	0.4186	0.4209	13294568.0
2003-10-29 13:00:00	AAPL	Stock	0.4209	0.4268	0.4205	0.4232	26727120.0
2003-10-29 14:00:00	AAPL	Stock	0.4232	0.4263	0.4214	0.4243	25329752.0
2003-10-29 15:00:00	AAPL	Stock	0.4243	0.4252	0.4207	0.4227	22790096.0
2003-10-29 16:00:00	AAPL	Stock	0.4225	0.423	0.4216	0.423	3337600.0
2003-10-29 17:00:00	AAPL	Stock	0.423	0.423	0.423	0.423	593600.0
2003-10-29 08:00:00	MSFT	Stock	27.2	27.2	27.08	27.121	33988.0
2003-10-29 09:00:00	MSFT	Stock	27.12	27.25	27.04	27.07	7184930.0
2003-10-29 10:00:00	MSFT	Stock	27.08	27.13	26.96	27.02	11297120.0
2003-10-29 11:00:00	MSFT	Stock	27.02	27.0301	26.94	26.97	6222648.0
2003-10-29 12:00:00	MSFT	Stock	26.98	27.0	26.879	26.92	5645101.0
2003-10-29 13:00:00	MSFT	Stock	26.91	27.0	26.8599	26.91	7883342.0
2003-10-29 14:00:00	MSFT	Stock	26.9	26.92	26.685	26.75	14235958.0
2003-10-29 15:00:00	MSFT	Stock	26.75	26.8	26.66	26.76	13436463.0
2003-10-29 16:00:00	MSFT	Stock	26.73	26.9448	26.66	26.67	2482279.0
2003-10-29 17:00:00	MSFT	Stock	26.69	26.75	26.661	26.7	152770.0
2003-10-29 18:00:00	MSFT	Stock	26.7	26.71	26.66	26.67	22525.0
2003-10-29 08:00:00	NVDA	Stock	0.1523	0.1525	0.1506	0.1512	2379000.0
2003-10-29 09:00:00	NVDA	Stock	0.1521	0.1529	0.1477	0.1522	96005160.0
2003-10-29 10:00:00	NVDA	Stock	0.1522	0.1542	0.1505	0.1519	94366560.0
2003-10-29 11:00:00	NVDA	Stock	0.1519	0.1525	0.151	0.1522	45328200.0
2003-10-29 12:00:00	NVDA	Stock	0.1522	0.1527	0.1517	0.1519	64342200.0
2003-10-29 13:00:00	NVDA	Stock	0.152	0.1531	0.1515	0.1522	34083480.0
2003-10-29 14:00:00	NVDA	Stock	0.1521	0.1532	0.1517	0.153	45765720.0
2003-10-29 15:00:00	NVDA	Stock	0.1531	0.1534	0.1517	0.1518	60008160.0
2003-10-29 16:00:00	NVDA	Stock	0.1517	0.1545	0.1517	0.1536	16142760.0
2003-10-29 17:00:00	NVDA	Stock	0.1523	0.1532	0.1523	0.1532	444000.0
2003-10-29 18:00:00	NVDA	Stock	0.1527	0.1527	0.1527	0.1527	240000.0
2003-10-29 08:00:00	AMZN	Stock	2.8275	2.8365	2.81	2.8275	317400.0
2003-10-29 09:00:00	AMZN	Stock	2.833	2.8495	2.8115	2.82	20283320.0
2003-10-29 10:00:00	AMZN	Stock	2.8208	2.8565	2.8175	2.8177	30452980.0
2003-10-29 11:00:00	AMZN	Stock	2.818	2.826	2.8124	2.821	15290640.0
2003-10-29 12:00:00	AMZN	Stock	2.821	2.8292	2.8175	2.823	6827560.0
2003-10-29 13:00:00	AMZN	Stock	2.823	2.845	2.8	2.8395	39990000.0
2003-10-29 14:00:00	AMZN	Stock	2.8405	2.8575	2.83	2.845	25113120.0
2003-10-29 15:00:00	AMZN	Stock	2.8455	2.855	2.83	2.8375	20936340.0
2003-10-29 16:00:00	AMZN	Stock	2.836	2.839	2.829	2.83	2448320.0
2003-10-29 17:00:00	AMZN	Stock	2.8375	2.8375	2.82	2.8225	512000.0
2003-10-29 18:00:00	AMZN	Stock	2.8325	2.834	2.8324	2.8324	50000.0
2003-10-29 09:00:00	CL	Stock	25.5	25.745	25.475	25.615	942400.0
2003-10-29 10:00:00	CL	Stock	25.615	25.725	25.51	25.705	956800.0
2003-10-29 11:00:00	CL	Stock	25.7	25.91	25.7	25.875	985800.0
2003-10-29 12:00:00	CL	Stock	25.87	25.97	25.84	25.97	932600.0
2003-10-29 13:00:00	CL	Stock	25.97	26.045	25.925	26.03	753800.0
2003-10-29 14:00:00	CL	Stock	26.03	26.085	25.875	26.085	1036800.0
2003-10-29 15:00:00	CL	Stock	26.085	26.15	26.02	26.11	2401000.0

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

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