PREVIEW / stock_1hour / 2003-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-14.parquet
  size:    419 KB
  rows:    20,272
  symbols: 1,607

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-08-14 09:00:00	AAPL	Stock	0.3602	0.363	0.3568	0.3595	13733888.0
2003-08-14 10:00:00	AAPL	Stock	0.3595	0.3614	0.3573	0.3575	24250520.0
2003-08-14 11:00:00	AAPL	Stock	0.3575	0.3593	0.3571	0.3589	15937152.0
2003-08-14 12:00:00	AAPL	Stock	0.3589	0.3614	0.3582	0.3591	18532864.0
2003-08-14 13:00:00	AAPL	Stock	0.3588	0.3595	0.358	0.3589	4768288.0
2003-08-14 14:00:00	AAPL	Stock	0.3588	0.3618	0.3586	0.3618	8191176.0
2003-08-14 15:00:00	AAPL	Stock	0.3614	0.3618	0.3561	0.3563	75508888.0
2003-08-14 16:00:00	AAPL	Stock	0.3561	0.3598	0.3464	0.3464	11650800.0
2003-08-14 18:00:00	AAPL	Stock	0.3482	0.3482	0.3482	0.3482	44800.0
2003-08-14 08:00:00	MSFT	Stock	25.59	25.72	25.54	25.6	15290.0
2003-08-14 09:00:00	MSFT	Stock	25.6	25.7	25.52	25.58	4357704.0
2003-08-14 10:00:00	MSFT	Stock	25.57	25.71	25.52	25.61	8421382.0
2003-08-14 11:00:00	MSFT	Stock	25.61	25.66	25.56	25.6	3456443.0
2003-08-14 12:00:00	MSFT	Stock	25.6	25.689	25.57	25.6	4310495.0
2003-08-14 13:00:00	MSFT	Stock	25.6	25.64	25.59	25.63	2338903.0
2003-08-14 14:00:00	MSFT	Stock	25.64	25.64	25.52	25.6	3981999.0
2003-08-14 15:00:00	MSFT	Stock	25.6	25.67	25.55	25.63	5840755.0
2003-08-14 16:00:00	MSFT	Stock	25.66	25.67	25.45	25.46	716149.0
2003-08-14 18:00:00	MSFT	Stock	25.41	25.45	25.4	25.4	9700.0
2003-08-14 08:00:00	NVDA	Stock	0.1375	0.1401	0.1317	0.1356	97725840.0
2003-08-14 09:00:00	NVDA	Stock	0.1356	0.1372	0.1332	0.1352	384016080.0
2003-08-14 10:00:00	NVDA	Stock	0.1352	0.1354	0.134	0.1349	250438800.0
2003-08-14 11:00:00	NVDA	Stock	0.1349	0.1353	0.1342	0.1352	124073640.0
2003-08-14 12:00:00	NVDA	Stock	0.1352	0.1369	0.1349	0.1351	100887600.0
2003-08-14 13:00:00	NVDA	Stock	0.1351	0.1352	0.1338	0.134	111661920.0
2003-08-14 14:00:00	NVDA	Stock	0.1339	0.1347	0.1339	0.1346	104073480.0
2003-08-14 15:00:00	NVDA	Stock	0.1346	0.1352	0.1344	0.1347	201902640.0
2003-08-14 16:00:00	NVDA	Stock	0.1347	0.1354	0.1343	0.135	9047760.0
2003-08-14 08:00:00	AMZN	Stock	2.012	2.0125	2.012	2.0125	40000.0
2003-08-14 09:00:00	AMZN	Stock	2.0095	2.01	1.9825	1.9905	14620520.0
2003-08-14 10:00:00	AMZN	Stock	1.9905	2.0	1.9875	1.995	18832940.0
2003-08-14 11:00:00	AMZN	Stock	1.995	1.9973	1.988	1.9895	9944840.0
2003-08-14 12:00:00	AMZN	Stock	1.99	2.0005	1.989	1.9975	12015840.0
2003-08-14 13:00:00	AMZN	Stock	1.997	2.0095	1.9965	2.0065	8653300.0
2003-08-14 14:00:00	AMZN	Stock	2.0065	2.014	2.001	2.0135	9140300.0
2003-08-14 15:00:00	AMZN	Stock	2.013	2.0185	2.0075	2.0155	15145540.0
2003-08-14 16:00:00	AMZN	Stock	2.0155	2.02	2.013	2.013	551980.0
2003-08-14 09:00:00	CL	Stock	27.925	27.96	27.69	27.725	180000.0
2003-08-14 10:00:00	CL	Stock	27.705	27.95	27.625	27.945	432000.0
2003-08-14 11:00:00	CL	Stock	27.95	28.02	27.925	27.98	210400.0
2003-08-14 12:00:00	CL	Stock	27.985	28.02	27.87	27.89	233200.0
2003-08-14 13:00:00	CL	Stock	27.895	27.95	27.865	27.885	154800.0
2003-08-14 14:00:00	CL	Stock	27.89	27.9	27.845	27.885	237000.0
2003-08-14 15:00:00	CL	Stock	27.895	27.92	27.84	27.89	491000.0
2003-08-14 16:00:00	CL	Stock	27.885	27.885	27.875	27.875	43400.0

> showing 45 of 20,272 rows — these rows as CSV

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