PREVIEW / stock_1hour / 2004-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-07.parquet
  size:    495 KB
  rows:    23,850
  symbols: 1,826

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
2004-09-07 08:00:00	AAPL	Stock	0.6304	0.6339	0.6304	0.6339	36400.0
2004-09-07 09:00:00	AAPL	Stock	0.6339	0.6402	0.6291	0.6389	34145552.0
2004-09-07 10:00:00	AAPL	Stock	0.6393	0.6416	0.6339	0.6357	52193064.0
2004-09-07 11:00:00	AAPL	Stock	0.6357	0.6427	0.6346	0.6421	44237368.0
2004-09-07 12:00:00	AAPL	Stock	0.642	0.6463	0.6407	0.6421	44425640.0
2004-09-07 13:00:00	AAPL	Stock	0.6421	0.6432	0.6396	0.6404	24345888.0
2004-09-07 14:00:00	AAPL	Stock	0.6404	0.6421	0.6343	0.6379	46733792.0
2004-09-07 15:00:00	AAPL	Stock	0.6379	0.6398	0.6357	0.6396	38133592.0
2004-09-07 16:00:00	AAPL	Stock	0.6396	0.6396	0.6375	0.6386	3576608.0
2004-09-07 17:00:00	AAPL	Stock	0.6386	0.6386	0.6386	0.6386	22400.0
2004-09-07 18:00:00	AAPL	Stock	0.6386	0.6386	0.6386	0.6386	1431472.0
2004-09-07 08:00:00	MSFT	Stock	27.25	27.31	27.11	27.3	40513.0
2004-09-07 09:00:00	MSFT	Stock	27.3	27.35	27.2	27.28	5889196.0
2004-09-07 10:00:00	MSFT	Stock	27.27	27.34	27.19	27.25	7819517.0
2004-09-07 11:00:00	MSFT	Stock	27.24	27.34	27.24	27.29	3882451.0
2004-09-07 12:00:00	MSFT	Stock	27.3	27.37	27.29	27.34	4311365.0
2004-09-07 13:00:00	MSFT	Stock	27.34	27.38	27.27	27.3	4188533.0
2004-09-07 14:00:00	MSFT	Stock	27.3	27.32	27.18	27.21	6290363.0
2004-09-07 15:00:00	MSFT	Stock	27.2	27.37	27.16	27.35	9973640.0
2004-09-07 16:00:00	MSFT	Stock	27.35	27.3601	27.31	27.36	1321995.0
2004-09-07 17:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	5100.0
2004-09-07 18:00:00	MSFT	Stock	27.36	27.36	27.36	27.36	726049.0
2004-09-07 09:00:00	NVDA	Stock	0.1077	0.1097	0.1074	0.1083	73368600.0
2004-09-07 10:00:00	NVDA	Stock	0.1083	0.1085	0.1038	0.1044	178085760.0
2004-09-07 11:00:00	NVDA	Stock	0.1044	0.1053	0.1044	0.1049	85562640.0
2004-09-07 12:00:00	NVDA	Stock	0.1049	0.1062	0.1049	0.1061	70972320.0
2004-09-07 13:00:00	NVDA	Stock	0.1061	0.1064	0.1055	0.1055	48554040.0
2004-09-07 14:00:00	NVDA	Stock	0.1055	0.1059	0.1035	0.1036	94299120.0
2004-09-07 15:00:00	NVDA	Stock	0.1036	0.1052	0.1034	0.1047	148818000.0
2004-09-07 16:00:00	NVDA	Stock	0.1044	0.1048	0.1042	0.1047	5151840.0
2004-09-07 17:00:00	NVDA	Stock	0.1047	0.1047	0.1042	0.1042	252000.0
2004-09-07 18:00:00	NVDA	Stock	0.1048	0.1048	0.1048	0.1048	1339200.0
2004-09-07 08:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	20000.0
2004-09-07 09:00:00	AMZN	Stock	1.953	1.968	1.943	1.9455	19480960.0
2004-09-07 10:00:00	AMZN	Stock	1.944	1.9545	1.9055	1.9105	31269200.0
2004-09-07 11:00:00	AMZN	Stock	1.91	1.9325	1.9085	1.9295	16790360.0
2004-09-07 12:00:00	AMZN	Stock	1.9295	1.939	1.926	1.937	8632920.0
2004-09-07 13:00:00	AMZN	Stock	1.937	1.94	1.9255	1.926	7656000.0
2004-09-07 14:00:00	AMZN	Stock	1.9255	1.9335	1.9055	1.9145	15678480.0
2004-09-07 15:00:00	AMZN	Stock	1.914	1.929	1.9125	1.9285	12910480.0
2004-09-07 16:00:00	AMZN	Stock	1.929	1.9425	1.9175	1.926	1717160.0
2004-09-07 17:00:00	AMZN	Stock	1.926	1.926	1.919	1.919	65400.0
2004-09-07 18:00:00	AMZN	Stock	1.92	1.92	1.92	1.92	10000.0
2004-09-07 09:00:00	CL	Stock	27.5	27.57	27.48	27.535	269400.0
2004-09-07 10:00:00	CL	Stock	27.54	27.545	27.415	27.43	248600.0
2004-09-07 11:00:00	CL	Stock	27.435	27.485	27.425	27.43	263800.0
2004-09-07 12:00:00	CL	Stock	27.435	27.485	27.43	27.485	164000.0
2004-09-07 13:00:00	CL	Stock	27.485	27.525	27.415	27.415	241800.0
2004-09-07 14:00:00	CL	Stock	27.405	27.485	27.405	27.45	246000.0
2004-09-07 15:00:00	CL	Stock	27.445	27.5	27.4	27.5	271800.0

> showing 50 of 23,850 rows — these rows as CSV

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