PREVIEW / stock_1hour / 2003-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-25.parquet
  size:    492 KB
  rows:    22,543
  symbols: 1,618

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-09-25 09:00:00	AAPL	Stock	0.3809	0.3821	0.3705	0.3759	66323544.0
2003-09-25 10:00:00	AAPL	Stock	0.3757	0.3764	0.3709	0.3763	37014152.0
2003-09-25 11:00:00	AAPL	Stock	0.3761	0.3782	0.3713	0.3729	102421536.0
2003-09-25 12:00:00	AAPL	Stock	0.3729	0.3741	0.3644	0.3646	90825000.0
2003-09-25 13:00:00	AAPL	Stock	0.3648	0.3693	0.3616	0.3629	62368040.0
2003-09-25 14:00:00	AAPL	Stock	0.363	0.3675	0.3618	0.3663	39641168.0
2003-09-25 15:00:00	AAPL	Stock	0.3664	0.3705	0.3616	0.3634	83376104.0
2003-09-25 16:00:00	AAPL	Stock	0.3632	0.3648	0.3589	0.3631	5857600.0
2003-09-25 17:00:00	AAPL	Stock	0.3632	0.3648	0.3575	0.3634	1282344.0
2003-09-25 08:00:00	MSFT	Stock	28.55	28.61	28.49	28.58	99964.0
2003-09-25 09:00:00	MSFT	Stock	28.6	28.63	28.32	28.477	6507746.0
2003-09-25 10:00:00	MSFT	Stock	28.48	28.59	28.26	28.52	9143404.0
2003-09-25 11:00:00	MSFT	Stock	28.52	28.75	28.47	28.69	7286643.0
2003-09-25 12:00:00	MSFT	Stock	28.689	28.92	28.65	28.81	5882837.0
2003-09-25 13:00:00	MSFT	Stock	28.81	28.83	28.52	28.62	3979137.0
2003-09-25 14:00:00	MSFT	Stock	28.61	28.92	28.55	28.86	4946785.0
2003-09-25 15:00:00	MSFT	Stock	28.85	28.95	28.23	28.24	8619807.0
2003-09-25 16:00:00	MSFT	Stock	28.26	28.33	28.08	28.2571	1193726.0
2003-09-25 17:00:00	MSFT	Stock	28.14	28.2565	28.1	28.2	192990.0
2003-09-25 18:00:00	MSFT	Stock	28.2	28.5797	28.2	28.5797	8700.0
2003-09-25 08:00:00	NVDA	Stock	0.149	0.15	0.1489	0.1499	1391760.0
2003-09-25 09:00:00	NVDA	Stock	0.1498	0.151	0.1472	0.1507	118301400.0
2003-09-25 10:00:00	NVDA	Stock	0.1507	0.1517	0.147	0.1496	153433920.0
2003-09-25 11:00:00	NVDA	Stock	0.1496	0.1516	0.1495	0.1514	76143600.0
2003-09-25 12:00:00	NVDA	Stock	0.1514	0.152	0.15	0.1502	57871320.0
2003-09-25 13:00:00	NVDA	Stock	0.1502	0.1508	0.1483	0.1486	49029000.0
2003-09-25 14:00:00	NVDA	Stock	0.1486	0.1499	0.1478	0.1487	48692640.0
2003-09-25 15:00:00	NVDA	Stock	0.1487	0.1494	0.1454	0.1462	121072200.0
2003-09-25 16:00:00	NVDA	Stock	0.1461	0.1466	0.1442	0.146	7039440.0
2003-09-25 17:00:00	NVDA	Stock	0.146	0.146	0.145	0.145	909000.0
2003-09-25 18:00:00	NVDA	Stock	0.1452	0.1458	0.1452	0.1457	237480.0
2003-09-25 08:00:00	AMZN	Stock	2.48	2.5	2.4695	2.4865	224000.0
2003-09-25 09:00:00	AMZN	Stock	2.485	2.496	2.464	2.4845	20197420.0
2003-09-25 10:00:00	AMZN	Stock	2.4805	2.52	2.4665	2.5085	44216740.0
2003-09-25 11:00:00	AMZN	Stock	2.509	2.539	2.503	2.534	34717320.0
2003-09-25 12:00:00	AMZN	Stock	2.5345	2.537	2.5215	2.522	17057680.0
2003-09-25 13:00:00	AMZN	Stock	2.523	2.5285	2.513	2.5195	13417620.0
2003-09-25 14:00:00	AMZN	Stock	2.52	2.544	2.5175	2.5375	25227840.0
2003-09-25 15:00:00	AMZN	Stock	2.5375	2.5475	2.4985	2.4985	32915080.0
2003-09-25 16:00:00	AMZN	Stock	2.4985	2.5225	2.4685	2.4996	3112800.0
2003-09-25 17:00:00	AMZN	Stock	2.4993	2.5025	2.488	2.4925	349000.0
2003-09-25 18:00:00	AMZN	Stock	2.495	2.495	2.49	2.49	24000.0
2003-09-25 09:00:00	CL	Stock	27.725	27.9	27.7	27.855	466000.0
2003-09-25 10:00:00	CL	Stock	27.87	27.95	27.72	27.75	649200.0
2003-09-25 11:00:00	CL	Stock	27.75	27.88	27.735	27.81	782200.0
2003-09-25 12:00:00	CL	Stock	27.815	27.895	27.81	27.88	365200.0
2003-09-25 13:00:00	CL	Stock	27.88	27.88	27.755	27.8	295400.0
2003-09-25 14:00:00	CL	Stock	27.805	27.99	27.765	27.935	1168400.0
2003-09-25 15:00:00	CL	Stock	27.93	27.975	27.84	27.855	934000.0
2003-09-25 16:00:00	CL	Stock	27.86	27.865	27.84	27.855	73600.0

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

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