PREVIEW / stock_1hour / 2003-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-29.parquet
  size:    469 KB
  rows:    22,361
  symbols: 1,621

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-29 08:00:00	AAPL	Stock	0.3773	0.3832	0.3739	0.3821	1696800.0
2003-09-29 09:00:00	AAPL	Stock	0.3821	0.387	0.3755	0.3804	72601592.0
2003-09-29 10:00:00	AAPL	Stock	0.3804	0.3805	0.375	0.3755	57709120.0
2003-09-29 11:00:00	AAPL	Stock	0.3755	0.3791	0.3688	0.3788	58798712.0
2003-09-29 12:00:00	AAPL	Stock	0.3786	0.3813	0.3782	0.3811	17474128.0
2003-09-29 13:00:00	AAPL	Stock	0.3814	0.3848	0.3804	0.3814	25232928.0
2003-09-29 14:00:00	AAPL	Stock	0.3816	0.3816	0.3775	0.3804	32754680.0
2003-09-29 15:00:00	AAPL	Stock	0.3805	0.3818	0.3771	0.3816	37101064.0
2003-09-29 16:00:00	AAPL	Stock	0.3814	0.3818	0.3784	0.3814	2452520.0
2003-09-29 17:00:00	AAPL	Stock	0.3817	0.3817	0.3817	0.3817	156800.0
2003-09-29 08:00:00	MSFT	Stock	28.145	28.46	27.92	28.39	164260.0
2003-09-29 09:00:00	MSFT	Stock	28.39	28.49	28.297	28.39	4221132.0
2003-09-29 10:00:00	MSFT	Stock	28.38	28.44	28.1	28.28	5500416.0
2003-09-29 11:00:00	MSFT	Stock	28.28	28.39	28.12	28.36	6265568.0
2003-09-29 12:00:00	MSFT	Stock	28.36	28.73	28.36	28.58	5707481.0
2003-09-29 13:00:00	MSFT	Stock	28.57	28.69	28.5	28.55	3255439.0
2003-09-29 14:00:00	MSFT	Stock	28.55	28.703	28.44	28.7	4484700.0
2003-09-29 15:00:00	MSFT	Stock	28.7	28.88	28.42	28.84	8042109.0
2003-09-29 16:00:00	MSFT	Stock	28.83	28.91	28.78	28.801	1476552.0
2003-09-29 17:00:00	MSFT	Stock	28.82	28.88	28.4626	28.83	194159.0
2003-09-29 18:00:00	MSFT	Stock	28.83	28.88	28.829	28.84	3200.0
2003-09-29 08:00:00	NVDA	Stock	0.1344	0.1396	0.1325	0.1337	19134360.0
2003-09-29 09:00:00	NVDA	Stock	0.1336	0.1382	0.1333	0.1355	329397120.0
2003-09-29 10:00:00	NVDA	Stock	0.1355	0.1362	0.1339	0.1341	303154800.0
2003-09-29 11:00:00	NVDA	Stock	0.134	0.1342	0.1314	0.1321	322980600.0
2003-09-29 12:00:00	NVDA	Stock	0.1321	0.1337	0.1315	0.1334	163445040.0
2003-09-29 13:00:00	NVDA	Stock	0.1334	0.1347	0.1322	0.1337	169933200.0
2003-09-29 14:00:00	NVDA	Stock	0.1337	0.1338	0.1326	0.1335	124156680.0
2003-09-29 15:00:00	NVDA	Stock	0.1335	0.1335	0.1315	0.1332	288883560.0
2003-09-29 16:00:00	NVDA	Stock	0.133	0.135	0.1319	0.1321	10033560.0
2003-09-29 17:00:00	NVDA	Stock	0.1326	0.1329	0.1325	0.1329	1015800.0
2003-09-29 18:00:00	NVDA	Stock	0.1329	0.1329	0.1327	0.1327	420000.0
2003-09-29 08:00:00	AMZN	Stock	2.444	2.45	2.4285	2.4425	207000.0
2003-09-29 09:00:00	AMZN	Stock	2.441	2.46	2.435	2.45	24550080.0
2003-09-29 10:00:00	AMZN	Stock	2.4515	2.459	2.4315	2.4415	28770780.0
2003-09-29 11:00:00	AMZN	Stock	2.4415	2.4675	2.42	2.4665	29492400.0
2003-09-29 12:00:00	AMZN	Stock	2.467	2.48	2.4635	2.4785	18766940.0
2003-09-29 13:00:00	AMZN	Stock	2.4775	2.4815	2.471	2.481	12911460.0
2003-09-29 14:00:00	AMZN	Stock	2.481	2.494	2.4785	2.494	14001440.0
2003-09-29 15:00:00	AMZN	Stock	2.4938	2.4985	2.471	2.493	28112540.0
2003-09-29 16:00:00	AMZN	Stock	2.4925	2.5	2.485	2.4995	1543200.0
2003-09-29 17:00:00	AMZN	Stock	2.4928	2.5	2.492	2.4995	331120.0
2003-09-29 18:00:00	AMZN	Stock	2.499	2.4994	2.499	2.4994	8000.0
2003-09-29 09:00:00	CL	Stock	27.75	27.8195	27.675	27.785	218600.0
2003-09-29 10:00:00	CL	Stock	27.785	27.885	27.64	27.705	274600.0
2003-09-29 11:00:00	CL	Stock	27.715	27.81	27.67	27.775	290400.0
2003-09-29 12:00:00	CL	Stock	27.77	27.865	27.725	27.7595	267600.0
2003-09-29 13:00:00	CL	Stock	27.75	27.78	27.645	27.7	276000.0
2003-09-29 14:00:00	CL	Stock	27.7	27.875	27.66	27.815	423800.0
2003-09-29 15:00:00	CL	Stock	27.82	27.915	27.754	27.88	998600.0

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

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