PREVIEW / stock_1hour / 2003-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-21.parquet
  size:    485 KB
  rows:    22,859
  symbols: 1,648

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-21 08:00:00	AAPL	Stock	0.4196	0.4196	0.4161	0.4161	84000.0
2003-10-21 09:00:00	AAPL	Stock	0.4161	0.4179	0.4063	0.4091	35156968.0
2003-10-21 10:00:00	AAPL	Stock	0.4091	0.412	0.4089	0.4105	24353112.0
2003-10-21 11:00:00	AAPL	Stock	0.4104	0.4143	0.4102	0.4138	16326912.0
2003-10-21 12:00:00	AAPL	Stock	0.4138	0.4159	0.4132	0.4141	17520664.0
2003-10-21 13:00:00	AAPL	Stock	0.4139	0.4157	0.412	0.4157	10564064.0
2003-10-21 14:00:00	AAPL	Stock	0.4157	0.4168	0.4136	0.4164	17600744.0
2003-10-21 15:00:00	AAPL	Stock	0.4164	0.4166	0.4116	0.4141	30623096.0
2003-10-21 16:00:00	AAPL	Stock	0.4141	0.4154	0.4123	0.414	18549552.0
2003-10-21 17:00:00	AAPL	Stock	0.4139	0.4139	0.4139	0.4139	431200.0
2003-10-21 08:00:00	MSFT	Stock	29.5	29.53	29.17	29.17	148119.0
2003-10-21 09:00:00	MSFT	Stock	29.2	29.38	29.17	29.3	6384636.0
2003-10-21 10:00:00	MSFT	Stock	29.3	29.34	29.2	29.27	6478867.0
2003-10-21 11:00:00	MSFT	Stock	29.28	29.37	29.24	29.341	5079525.0
2003-10-21 12:00:00	MSFT	Stock	29.34	29.42	29.3	29.42	5575609.0
2003-10-21 13:00:00	MSFT	Stock	29.42	29.43	29.36	29.38	3516837.0
2003-10-21 14:00:00	MSFT	Stock	29.38	29.39	29.27	29.35	3983329.0
2003-10-21 15:00:00	MSFT	Stock	29.349	29.38	29.22	29.34	7729706.0
2003-10-21 16:00:00	MSFT	Stock	29.34	29.36	29.21	29.33	1360140.0
2003-10-21 17:00:00	MSFT	Stock	29.34	29.35	29.29	29.29	160000.0
2003-10-21 18:00:00	MSFT	Stock	29.27	29.3	29.27	29.3	4400.0
2003-10-21 08:00:00	NVDA	Stock	0.1432	0.1437	0.1427	0.1429	650400.0
2003-10-21 09:00:00	NVDA	Stock	0.1431	0.1454	0.1425	0.1437	84285240.0
2003-10-21 10:00:00	NVDA	Stock	0.1437	0.1451	0.1427	0.1451	102073920.0
2003-10-21 11:00:00	NVDA	Stock	0.1451	0.1458	0.1448	0.1454	92435400.0
2003-10-21 12:00:00	NVDA	Stock	0.1454	0.1458	0.1446	0.145	48388440.0
2003-10-21 13:00:00	NVDA	Stock	0.145	0.149	0.1444	0.1485	183881760.0
2003-10-21 14:00:00	NVDA	Stock	0.1485	0.1486	0.1462	0.1478	88900680.0
2003-10-21 15:00:00	NVDA	Stock	0.1476	0.1477	0.1451	0.1462	110534400.0
2003-10-21 16:00:00	NVDA	Stock	0.1459	0.1466	0.1442	0.1454	22885560.0
2003-10-21 17:00:00	NVDA	Stock	0.1462	0.1462	0.1454	0.1454	2508000.0
2003-10-21 08:00:00	AMZN	Stock	2.995	3.0175	2.995	2.995	589800.0
2003-10-21 09:00:00	AMZN	Stock	2.995	3.0095	2.9615	3.008	35630760.0
2003-10-21 10:00:00	AMZN	Stock	3.0065	3.017	2.9955	3.0095	48383420.0
2003-10-21 11:00:00	AMZN	Stock	3.0095	3.0475	3.005	3.044	34384820.0
2003-10-21 12:00:00	AMZN	Stock	3.0425	3.0575	3.0398	3.0398	27802140.0
2003-10-21 13:00:00	AMZN	Stock	3.0398	3.042	3.028	3.033	19138320.0
2003-10-21 14:00:00	AMZN	Stock	3.033	3.034	3.0085	3.0145	31301780.0
2003-10-21 15:00:00	AMZN	Stock	3.0145	3.0151	2.9545	2.9685	76855980.0
2003-10-21 16:00:00	AMZN	Stock	2.97	3.0086	2.843	2.9125	53729440.0
2003-10-21 17:00:00	AMZN	Stock	2.9125	2.968	2.8925	2.9	7095040.0
2003-10-21 18:00:00	AMZN	Stock	2.903	2.9065	2.9	2.904	1290000.0
2003-10-21 09:00:00	CL	Stock	28.685	28.9	28.68	28.9	235800.0
2003-10-21 10:00:00	CL	Stock	28.885	28.9	28.675	28.7	382600.0
2003-10-21 11:00:00	CL	Stock	28.7	28.8	28.64	28.785	275800.0
2003-10-21 12:00:00	CL	Stock	28.785	28.915	28.78	28.865	423200.0
2003-10-21 13:00:00	CL	Stock	28.865	28.925	28.85	28.86	295000.0
2003-10-21 14:00:00	CL	Stock	28.86	28.92	28.83	28.9	360200.0
2003-10-21 15:00:00	CL	Stock	28.905	28.905	28.8	28.815	475200.0
2003-10-21 16:00:00	CL	Stock	28.82	28.82	28.805	28.805	258400.0

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

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