PREVIEW / stock_1hour / 2003-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-12.parquet
  size:    451 KB
  rows:    21,605
  symbols: 1,604

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-12 09:00:00	AAPL	Stock	0.352	0.3536	0.3475	0.3479	13819120.0
2003-08-12 10:00:00	AAPL	Stock	0.3479	0.3514	0.3477	0.3484	24497816.0
2003-08-12 11:00:00	AAPL	Stock	0.3484	0.3495	0.3475	0.3489	14233520.0
2003-08-12 12:00:00	AAPL	Stock	0.3489	0.3502	0.3488	0.3496	10868648.0
2003-08-12 13:00:00	AAPL	Stock	0.3498	0.3507	0.3493	0.3502	11332160.0
2003-08-12 14:00:00	AAPL	Stock	0.3502	0.353	0.3488	0.3511	28558432.0
2003-08-12 15:00:00	AAPL	Stock	0.3511	0.353	0.3502	0.352	34439272.0
2003-08-12 16:00:00	AAPL	Stock	0.3518	0.3536	0.3511	0.3518	1276800.0
2003-08-12 08:00:00	MSFT	Stock	25.69	25.69	25.62	25.66	34092.0
2003-08-12 09:00:00	MSFT	Stock	25.67	25.77	25.51	25.61	3431268.0
2003-08-12 10:00:00	MSFT	Stock	25.6	25.72	25.56	25.6	4222901.0
2003-08-12 11:00:00	MSFT	Stock	25.6	25.62	25.5	25.53	3773571.0
2003-08-12 12:00:00	MSFT	Stock	25.54	25.6	25.51	25.55	2444175.0
2003-08-12 13:00:00	MSFT	Stock	25.55	25.56	25.47	25.54	3883528.0
2003-08-12 14:00:00	MSFT	Stock	25.53	25.71	25.45	25.61	8539095.0
2003-08-12 15:00:00	MSFT	Stock	25.61	25.77	25.51	25.74	8127123.0
2003-08-12 16:00:00	MSFT	Stock	25.74	25.761	25.45	25.72	389148.0
2003-08-12 17:00:00	MSFT	Stock	25.729	25.729	25.69	25.7	19200.0
2003-08-12 18:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	2500.0
2003-08-12 08:00:00	NVDA	Stock	0.1371	0.1379	0.1371	0.1375	1418160.0
2003-08-12 09:00:00	NVDA	Stock	0.1375	0.1391	0.1367	0.1372	112704480.0
2003-08-12 10:00:00	NVDA	Stock	0.1372	0.1374	0.1357	0.136	121379160.0
2003-08-12 11:00:00	NVDA	Stock	0.1359	0.1368	0.1357	0.1363	81566520.0
2003-08-12 12:00:00	NVDA	Stock	0.1363	0.1377	0.1363	0.1374	53485800.0
2003-08-12 13:00:00	NVDA	Stock	0.1374	0.1377	0.1372	0.1374	33322680.0
2003-08-12 14:00:00	NVDA	Stock	0.1374	0.139	0.1372	0.1382	160801080.0
2003-08-12 15:00:00	NVDA	Stock	0.1383	0.1392	0.1373	0.1386	122535840.0
2003-08-12 16:00:00	NVDA	Stock	0.1385	0.139	0.1372	0.138	26417280.0
2003-08-12 17:00:00	NVDA	Stock	0.1379	0.138	0.1375	0.1379	2247360.0
2003-08-12 18:00:00	NVDA	Stock	0.1379	0.1381	0.1379	0.1381	156000.0
2003-08-12 08:00:00	AMZN	Stock	1.9465	1.9465	1.9425	1.9425	138000.0
2003-08-12 09:00:00	AMZN	Stock	1.945	1.9475	1.9255	1.9325	10016960.0
2003-08-12 10:00:00	AMZN	Stock	1.9325	1.9425	1.928	1.93	8618220.0
2003-08-12 11:00:00	AMZN	Stock	1.93	1.9305	1.9155	1.924	14233260.0
2003-08-12 12:00:00	AMZN	Stock	1.9235	1.9475	1.923	1.944	14235020.0
2003-08-12 13:00:00	AMZN	Stock	1.9436	1.955	1.9435	1.952	14083200.0
2003-08-12 14:00:00	AMZN	Stock	1.9516	1.9795	1.95	1.9755	24017540.0
2003-08-12 15:00:00	AMZN	Stock	1.9748	1.998	1.9675	1.9925	22999340.0
2003-08-12 16:00:00	AMZN	Stock	1.991	2.002	1.9905	2.0	2896040.0
2003-08-12 17:00:00	AMZN	Stock	2.0	2.0	1.9533	2.0	1341000.0
2003-08-12 18:00:00	AMZN	Stock	1.9955	1.9955	1.9955	1.9955	9000.0
2003-08-12 09:00:00	CL	Stock	27.725	27.78	27.56	27.78	224400.0
2003-08-12 10:00:00	CL	Stock	27.785	27.98	27.785	27.925	486600.0
2003-08-12 11:00:00	CL	Stock	27.93	28.035	27.9	27.955	530000.0
2003-08-12 12:00:00	CL	Stock	27.96	27.96	27.88	27.88	207200.0
2003-08-12 13:00:00	CL	Stock	27.89	27.89	27.79	27.835	212400.0
2003-08-12 14:00:00	CL	Stock	27.835	28.02	27.78	27.95	530400.0
2003-08-12 15:00:00	CL	Stock	27.945	28.07	27.85	28.05	675000.0
2003-08-12 16:00:00	CL	Stock	28.025	28.025	28.025	28.025	33600.0
2003-08-12 17:00:00	CL	Stock	28.05	28.05	28.045	28.045	800.0

> showing 50 of 21,605 rows — these rows as CSV

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