PREVIEW / stock_1hour / 2006-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-26.parquet
  size:    585 KB
  rows:    28,401
  symbols: 2,297

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-26 07:00:00	AAPL	Stock	2.1161	2.1161	2.1146	2.1146	70000.0
2006-06-26 08:00:00	AAPL	Stock	2.1111	2.1171	2.1057	2.1121	1760108.0
2006-06-26 09:00:00	AAPL	Stock	2.1107	2.1143	2.0893	2.0968	70568848.0
2006-06-26 10:00:00	AAPL	Stock	2.0968	2.1125	2.0929	2.1054	86841328.0
2006-06-26 11:00:00	AAPL	Stock	2.1055	2.1132	2.0971	2.1007	50886640.0
2006-06-26 12:00:00	AAPL	Stock	2.1011	2.1089	2.0918	2.095	47726420.0
2006-06-26 13:00:00	AAPL	Stock	2.095	2.0993	2.0846	2.0882	56410676.0
2006-06-26 14:00:00	AAPL	Stock	2.0882	2.1086	2.0846	2.0893	41037360.0
2006-06-26 15:00:00	AAPL	Stock	2.0896	2.1082	2.085	2.105	98669004.0
2006-06-26 16:00:00	AAPL	Stock	2.1029	2.1121	2.1029	2.1104	3190572.0
2006-06-26 17:00:00	AAPL	Stock	2.11	2.1107	2.1054	2.1071	221760.0
2006-06-26 18:00:00	AAPL	Stock	2.1096	2.1125	2.1057	2.1125	206220.0
2006-06-26 07:00:00	MSFT	Stock	22.67	22.69	22.67	22.68	2900.0
2006-06-26 08:00:00	MSFT	Stock	22.6	22.65	22.6	22.64	96020.0
2006-06-26 09:00:00	MSFT	Stock	22.66	22.82	22.63	22.77	6041152.0
2006-06-26 10:00:00	MSFT	Stock	22.77	22.89	22.74	22.81	10286497.0
2006-06-26 11:00:00	MSFT	Stock	22.8	22.84	22.75	22.78	5405106.0
2006-06-26 12:00:00	MSFT	Stock	22.78	22.84	22.75	22.84	5309015.0
2006-06-26 13:00:00	MSFT	Stock	22.83	22.87	22.81	22.86	3714564.0
2006-06-26 14:00:00	MSFT	Stock	22.86	22.88	22.79	22.79	5464151.0
2006-06-26 15:00:00	MSFT	Stock	22.79	22.85	22.79	22.83	8012298.0
2006-06-26 16:00:00	MSFT	Stock	22.84	22.86	22.82	22.83	139500.0
2006-06-26 17:00:00	MSFT	Stock	22.84	22.84	22.73	22.82	12583.0
2006-06-26 09:00:00	NVDA	Stock	0.3385	0.3417	0.3368	0.3392	36921120.0
2006-06-26 10:00:00	NVDA	Stock	0.3392	0.3405	0.3365	0.3383	43579320.0
2006-06-26 11:00:00	NVDA	Stock	0.3382	0.3397	0.3363	0.3363	33465780.0
2006-06-26 12:00:00	NVDA	Stock	0.3363	0.338	0.3348	0.3375	36282900.0
2006-06-26 13:00:00	NVDA	Stock	0.3377	0.3387	0.3353	0.3358	23823540.0
2006-06-26 14:00:00	NVDA	Stock	0.3358	0.3381	0.3337	0.3357	43471380.0
2006-06-26 15:00:00	NVDA	Stock	0.3355	0.336	0.3348	0.3353	41176740.0
2006-06-26 16:00:00	NVDA	Stock	0.3357	0.3357	0.3357	0.3357	71700.0
2006-06-26 17:00:00	NVDA	Stock	0.3353	0.3353	0.3352	0.3353	96000.0
2006-06-26 09:00:00	AMZN	Stock	1.8295	1.8555	1.8245	1.8435	11469120.0
2006-06-26 10:00:00	AMZN	Stock	1.8435	1.8585	1.8385	1.8425	14074740.0
2006-06-26 11:00:00	AMZN	Stock	1.8425	1.843	1.8215	1.8245	9255500.0
2006-06-26 12:00:00	AMZN	Stock	1.825	1.854	1.8225	1.847	8195040.0
2006-06-26 13:00:00	AMZN	Stock	1.848	1.8515	1.845	1.849	5418640.0
2006-06-26 14:00:00	AMZN	Stock	1.8495	1.8525	1.8435	1.845	5688100.0
2006-06-26 15:00:00	AMZN	Stock	1.8445	1.8465	1.8355	1.8395	15932660.0
2006-06-26 16:00:00	AMZN	Stock	1.8395	1.84	1.8395	1.84	94620.0
2006-06-26 17:00:00	AMZN	Stock	1.8375	1.839	1.8375	1.839	8000.0
2006-06-26 09:00:00	CL	Stock	30.03	30.09	29.965	30.065	245000.0
2006-06-26 10:00:00	CL	Stock	30.055	30.1	29.985	30.01	654600.0
2006-06-26 11:00:00	CL	Stock	30.01	30.195	30.01	30.13	421000.0
2006-06-26 12:00:00	CL	Stock	30.14	30.145	30.07	30.085	492200.0
2006-06-26 13:00:00	CL	Stock	30.085	30.175	30.055	30.115	661800.0
2006-06-26 14:00:00	CL	Stock	30.125	30.22	30.075	30.075	481800.0
2006-06-26 15:00:00	CL	Stock	30.075	30.14	30.035	30.125	793400.0

> showing 48 of 28,401 rows — these rows as CSV

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