PREVIEW / stock_1hour / 2004-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-16.parquet
  size:    503 KB
  rows:    23,770
  symbols: 1,796

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
2004-07-16 08:00:00	AAPL	Stock	0.5893	0.5893	0.5857	0.5857	582400.0
2004-07-16 09:00:00	AAPL	Stock	0.5857	0.5879	0.5798	0.583	73026128.0
2004-07-16 10:00:00	AAPL	Stock	0.5827	0.5864	0.5784	0.5804	94601808.0
2004-07-16 11:00:00	AAPL	Stock	0.5805	0.5857	0.5804	0.582	43219064.0
2004-07-16 12:00:00	AAPL	Stock	0.582	0.5839	0.5814	0.5823	31709160.0
2004-07-16 13:00:00	AAPL	Stock	0.5823	0.5829	0.5805	0.582	19351416.0
2004-07-16 14:00:00	AAPL	Stock	0.582	0.582	0.5804	0.5811	37571184.0
2004-07-16 15:00:00	AAPL	Stock	0.5811	0.5818	0.5743	0.5745	118380696.0
2004-07-16 16:00:00	AAPL	Stock	0.5743	0.5763	0.5729	0.5738	9554720.0
2004-07-16 17:00:00	AAPL	Stock	0.5748	0.575	0.5748	0.575	280000.0
2004-07-16 08:00:00	MSFT	Stock	27.97	28.19	27.97	28.15	134995.0
2004-07-16 09:00:00	MSFT	Stock	28.11	28.19	27.92	28.02	11352104.0
2004-07-16 10:00:00	MSFT	Stock	28.02	28.04	27.81	27.92	11364258.0
2004-07-16 11:00:00	MSFT	Stock	27.92	27.97	27.85	27.88	5866629.0
2004-07-16 12:00:00	MSFT	Stock	27.88	27.94	27.84	27.92	4055227.0
2004-07-16 13:00:00	MSFT	Stock	27.92	27.93	27.78	27.85	4520362.0
2004-07-16 14:00:00	MSFT	Stock	27.85	27.87	27.52	27.54	9794132.0
2004-07-16 15:00:00	MSFT	Stock	27.54	27.69	27.47	27.49	12860123.0
2004-07-16 16:00:00	MSFT	Stock	27.49	27.707	27.45	27.5	2146893.0
2004-07-16 17:00:00	MSFT	Stock	27.52	27.52	27.5	27.52	55700.0
2004-07-16 08:00:00	NVDA	Stock	0.1317	0.1333	0.1303	0.1333	11357160.0
2004-07-16 09:00:00	NVDA	Stock	0.1333	0.1344	0.1304	0.1312	70023840.0
2004-07-16 10:00:00	NVDA	Stock	0.1312	0.1314	0.1293	0.1302	85209000.0
2004-07-16 11:00:00	NVDA	Stock	0.1302	0.1303	0.128	0.1283	62531160.0
2004-07-16 12:00:00	NVDA	Stock	0.1282	0.1291	0.1279	0.1288	49676640.0
2004-07-16 13:00:00	NVDA	Stock	0.1288	0.1289	0.1284	0.1284	23814960.0
2004-07-16 14:00:00	NVDA	Stock	0.1285	0.1285	0.1272	0.1276	44773080.0
2004-07-16 15:00:00	NVDA	Stock	0.1275	0.1285	0.1265	0.1266	95101680.0
2004-07-16 16:00:00	NVDA	Stock	0.1266	0.127	0.1265	0.1265	4753080.0
2004-07-16 17:00:00	NVDA	Stock	0.1265	0.1265	0.1262	0.1262	144000.0
2004-07-16 18:00:00	NVDA	Stock	0.1262	0.1262	0.1262	0.1262	180000.0
2004-07-16 08:00:00	AMZN	Stock	2.4365	2.4365	2.428	2.435	92000.0
2004-07-16 09:00:00	AMZN	Stock	2.4445	2.4535	2.428	2.444	18646000.0
2004-07-16 10:00:00	AMZN	Stock	2.444	2.4475	2.3795	2.391	35200360.0
2004-07-16 11:00:00	AMZN	Stock	2.3915	2.423	2.388	2.413	23142360.0
2004-07-16 12:00:00	AMZN	Stock	2.413	2.4175	2.4025	2.409	8296820.0
2004-07-16 13:00:00	AMZN	Stock	2.409	2.4095	2.3875	2.3895	14472760.0
2004-07-16 14:00:00	AMZN	Stock	2.3895	2.3905	2.3485	2.3575	36521940.0
2004-07-16 15:00:00	AMZN	Stock	2.3576	2.3615	2.339	2.355	40516580.0
2004-07-16 16:00:00	AMZN	Stock	2.355	2.3565	2.3485	2.3535	2803680.0
2004-07-16 17:00:00	AMZN	Stock	2.354	2.355	2.353	2.3545	102120.0
2004-07-16 09:00:00	CL	Stock	28.45	28.45	28.305	28.355	505600.0
2004-07-16 10:00:00	CL	Stock	28.34	28.345	28.015	28.015	631800.0
2004-07-16 11:00:00	CL	Stock	28.015	28.125	27.95	28.105	644400.0
2004-07-16 12:00:00	CL	Stock	28.105	28.195	28.09	28.17	239800.0
2004-07-16 13:00:00	CL	Stock	28.17	28.225	28.135	28.215	292000.0
2004-07-16 14:00:00	CL	Stock	28.215	28.23	28.05	28.07	275600.0
2004-07-16 15:00:00	CL	Stock	28.065	28.225	28.065	28.175	534800.0
2004-07-16 16:00:00	CL	Stock	28.1605	28.1605	28.1605	28.1605	1600.0

> showing 49 of 23,770 rows — these rows as CSV

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