PREVIEW / stock_1hour / 2006-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-29.parquet
  size:    631 KB
  rows:    30,380
  symbols: 2,285

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
2006-06-29 08:00:00	AAPL	Stock	2.0082	2.0129	2.0036	2.0129	1046304.0
2006-06-29 09:00:00	AAPL	Stock	2.0129	2.0371	2.0111	2.02	80174304.0
2006-06-29 10:00:00	AAPL	Stock	2.0204	2.0343	2.0186	2.03	86975532.0
2006-06-29 11:00:00	AAPL	Stock	2.03	2.0432	2.0296	2.0386	85410584.0
2006-06-29 12:00:00	AAPL	Stock	2.0386	2.0389	2.0257	2.0279	45757880.0
2006-06-29 13:00:00	AAPL	Stock	2.0279	2.0329	2.0239	2.0293	34799100.0
2006-06-29 14:00:00	AAPL	Stock	2.0293	2.0693	2.0293	2.0639	209993476.0
2006-06-29 15:00:00	AAPL	Stock	2.0636	2.1104	2.0636	2.1071	266179368.0
2006-06-29 16:00:00	AAPL	Stock	2.1082	2.1132	2.0318	2.0443	35233548.0
2006-06-29 17:00:00	AAPL	Stock	2.0443	2.1061	2.0339	2.0536	16433900.0
2006-06-29 18:00:00	AAPL	Stock	2.0536	2.11	2.045	2.0464	1235696.0
2006-06-29 08:00:00	MSFT	Stock	23.22	23.28	23.2	23.28	22040.0
2006-06-29 09:00:00	MSFT	Stock	23.28	23.49	23.23	23.47	10561781.0
2006-06-29 10:00:00	MSFT	Stock	23.46	23.55	23.45	23.48	12966032.0
2006-06-29 11:00:00	MSFT	Stock	23.49	23.56	23.418	23.46	11316368.0
2006-06-29 12:00:00	MSFT	Stock	23.45	23.5	23.35	23.35	6043465.0
2006-06-29 13:00:00	MSFT	Stock	23.36	23.49	23.22	23.24	6264910.0
2006-06-29 14:00:00	MSFT	Stock	23.24	23.63	23.23	23.57	23898741.0
2006-06-29 15:00:00	MSFT	Stock	23.55	23.6	23.34	23.54	35978849.0
2006-06-29 16:00:00	MSFT	Stock	23.54	23.56	23.429	23.46	388793.0
2006-06-29 17:00:00	MSFT	Stock	23.47	23.48	23.41	23.42	224714.0
2006-06-29 18:00:00	MSFT	Stock	23.42	23.54	23.42	23.42	9660.0
2006-06-29 05:00:00	NVDA	Stock	0.354	0.354	0.354	0.354	30000.0
2006-06-29 06:00:00	NVDA	Stock	0.3427	0.3427	0.3427	0.3427	30000.0
2006-06-29 07:00:00	NVDA	Stock	0.3368	0.3368	0.3367	0.3367	66000.0
2006-06-29 08:00:00	NVDA	Stock	0.3407	0.3407	0.33	0.333	4676400.0
2006-06-29 09:00:00	NVDA	Stock	0.333	0.339	0.3317	0.3373	103510440.0
2006-06-29 10:00:00	NVDA	Stock	0.3373	0.34	0.3348	0.3387	95216160.0
2006-06-29 11:00:00	NVDA	Stock	0.3387	0.3428	0.3383	0.341	67964460.0
2006-06-29 12:00:00	NVDA	Stock	0.341	0.3412	0.3387	0.3388	37407960.0
2006-06-29 13:00:00	NVDA	Stock	0.3388	0.34	0.338	0.3393	31290720.0
2006-06-29 14:00:00	NVDA	Stock	0.3393	0.3522	0.3387	0.3513	133662780.0
2006-06-29 15:00:00	NVDA	Stock	0.3512	0.3582	0.35	0.358	183087720.0
2006-06-29 16:00:00	NVDA	Stock	0.3582	0.3582	0.3566	0.3573	6686940.0
2006-06-29 17:00:00	NVDA	Stock	0.3582	0.3582	0.357	0.3573	948300.0
2006-06-29 18:00:00	NVDA	Stock	0.3582	0.3582	0.3582	0.3582	6660.0
2006-06-29 09:00:00	AMZN	Stock	1.84	1.86	1.835	1.8585	7059760.0
2006-06-29 10:00:00	AMZN	Stock	1.859	1.8675	1.854	1.8635	10801980.0
2006-06-29 11:00:00	AMZN	Stock	1.863	1.8655	1.8445	1.8495	9527460.0
2006-06-29 12:00:00	AMZN	Stock	1.8495	1.8595	1.845	1.8465	5502300.0
2006-06-29 13:00:00	AMZN	Stock	1.847	1.8605	1.847	1.857	6526320.0
2006-06-29 14:00:00	AMZN	Stock	1.857	1.894	1.8555	1.8905	26330500.0
2006-06-29 15:00:00	AMZN	Stock	1.891	1.928	1.8905	1.928	52552540.0
2006-06-29 16:00:00	AMZN	Stock	1.9265	1.9315	1.9255	1.9285	235360.0
2006-06-29 17:00:00	AMZN	Stock	1.9265	1.9265	1.9255	1.9255	229300.0
2006-06-29 18:00:00	AMZN	Stock	1.926	1.926	1.926	1.926	2000.0
2006-06-29 09:00:00	CL	Stock	29.65	29.78	29.62	29.75	309400.0
2006-06-29 10:00:00	CL	Stock	29.75	29.875	29.75	29.82	399800.0
2006-06-29 11:00:00	CL	Stock	29.815	29.935	29.74	29.74	342600.0
2006-06-29 12:00:00	CL	Stock	29.74	29.905	29.72	29.815	337600.0

> showing 50 of 30,380 rows — these rows as CSV

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