PREVIEW / stock_1hour / 2003-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-10-10.parquet
  size:    469 KB
  rows:    22,253
  symbols: 1,643

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-10 08:00:00	AAPL	Stock	0.42	0.42	0.4196	0.4196	112000.0
2003-10-10 09:00:00	AAPL	Stock	0.4179	0.4252	0.4179	0.4205	30823576.0
2003-10-10 10:00:00	AAPL	Stock	0.4205	0.4233	0.4191	0.4198	28203168.0
2003-10-10 11:00:00	AAPL	Stock	0.4198	0.4213	0.4173	0.4202	24606064.0
2003-10-10 12:00:00	AAPL	Stock	0.42	0.422	0.4196	0.4216	17819144.0
2003-10-10 13:00:00	AAPL	Stock	0.4216	0.4223	0.421	0.4218	14476056.0
2003-10-10 14:00:00	AAPL	Stock	0.4221	0.4223	0.4182	0.4196	8967000.0
2003-10-10 15:00:00	AAPL	Stock	0.4196	0.4238	0.4188	0.4223	30744392.0
2003-10-10 16:00:00	AAPL	Stock	0.4236	0.425	0.4225	0.4241	1522472.0
2003-10-10 08:00:00	MSFT	Stock	28.5	29.19	28.5	29.05	63000.0
2003-10-10 09:00:00	MSFT	Stock	29.02	29.07	28.86	28.929	7201415.0
2003-10-10 10:00:00	MSFT	Stock	28.921	28.99	28.77	28.8	6362620.0
2003-10-10 11:00:00	MSFT	Stock	28.799	28.9	28.73	28.87	4280948.0
2003-10-10 12:00:00	MSFT	Stock	28.87	28.94	28.82	28.92	3347782.0
2003-10-10 13:00:00	MSFT	Stock	28.91	28.97	28.82	28.86	2726818.0
2003-10-10 14:00:00	MSFT	Stock	28.87	28.87	28.73	28.77	2801331.0
2003-10-10 15:00:00	MSFT	Stock	28.78	28.93	28.67	28.92	6430040.0
2003-10-10 16:00:00	MSFT	Stock	28.901	28.96	28.82	28.949	743917.0
2003-10-10 17:00:00	MSFT	Stock	28.949	29.02	28.83	28.95	79939.0
2003-10-10 18:00:00	MSFT	Stock	28.95	28.95	28.93	28.93	3800.0
2003-10-10 08:00:00	NVDA	Stock	0.1378	0.1382	0.1378	0.138	348000.0
2003-10-10 09:00:00	NVDA	Stock	0.138	0.1399	0.1375	0.1383	45265920.0
2003-10-10 10:00:00	NVDA	Stock	0.1382	0.1398	0.1378	0.1382	60133080.0
2003-10-10 11:00:00	NVDA	Stock	0.1382	0.1393	0.1376	0.1383	72255120.0
2003-10-10 12:00:00	NVDA	Stock	0.1382	0.1387	0.1375	0.1382	25035120.0
2003-10-10 13:00:00	NVDA	Stock	0.138	0.1404	0.138	0.1391	98052240.0
2003-10-10 14:00:00	NVDA	Stock	0.1391	0.1393	0.1385	0.1391	26631600.0
2003-10-10 15:00:00	NVDA	Stock	0.139	0.1396	0.1387	0.1392	46979040.0
2003-10-10 16:00:00	NVDA	Stock	0.1392	0.1398	0.1389	0.1393	8809200.0
2003-10-10 17:00:00	NVDA	Stock	0.1393	0.1405	0.1392	0.1405	1959600.0
2003-10-10 18:00:00	NVDA	Stock	0.1394	0.1394	0.1394	0.1394	36000.0
2003-10-10 08:00:00	AMZN	Stock	2.902	2.915	2.893	2.893	583800.0
2003-10-10 09:00:00	AMZN	Stock	2.895	2.9025	2.8755	2.891	34279340.0
2003-10-10 10:00:00	AMZN	Stock	2.8915	2.9165	2.872	2.8755	48373160.0
2003-10-10 11:00:00	AMZN	Stock	2.8755	2.9045	2.872	2.8955	32930240.0
2003-10-10 12:00:00	AMZN	Stock	2.8955	2.896	2.8855	2.8875	18995360.0
2003-10-10 13:00:00	AMZN	Stock	2.8895	2.911	2.887	2.899	21817400.0
2003-10-10 14:00:00	AMZN	Stock	2.899	2.909	2.8895	2.892	11418600.0
2003-10-10 15:00:00	AMZN	Stock	2.891	2.9055	2.8835	2.905	25881020.0
2003-10-10 16:00:00	AMZN	Stock	2.9025	2.911	2.9005	2.91	740220.0
2003-10-10 17:00:00	AMZN	Stock	2.9095	2.9165	2.898	2.91	324000.0
2003-10-10 18:00:00	AMZN	Stock	2.9115	2.9165	2.9115	2.9165	50000.0
2003-10-10 09:00:00	CL	Stock	28.865	28.875	28.785	28.8	114800.0
2003-10-10 10:00:00	CL	Stock	28.805	28.935	28.805	28.89	322200.0
2003-10-10 11:00:00	CL	Stock	28.9	29.03	28.88	29.025	243200.0
2003-10-10 12:00:00	CL	Stock	29.015	29.045	28.92	28.96	269000.0
2003-10-10 13:00:00	CL	Stock	28.955	29.01	28.935	28.945	133600.0
2003-10-10 14:00:00	CL	Stock	28.965	29.035	28.92	28.92	212000.0
2003-10-10 15:00:00	CL	Stock	28.925	29.015	28.905	28.975	351200.0
2003-10-10 16:00:00	CL	Stock	28.98	28.98	28.875	28.875	113800.0

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

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