PREVIEW / stock_1hour / 2010-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-17.parquet
  size:    917 KB
  rows:    43,585
  symbols: 3,475

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
2010-05-17 04:00:00	AAPL	Stock	9.0354	9.0354	9.0354	9.0354	7000.0
2010-05-17 05:00:00	AAPL	Stock	9.0668	9.0675	9.0396	9.0675	14000.0
2010-05-17 06:00:00	AAPL	Stock	9.0893	9.0893	9.0893	9.0893	5600.0
2010-05-17 07:00:00	AAPL	Stock	9.0818	9.1254	9.0768	9.1196	222880.0
2010-05-17 08:00:00	AAPL	Stock	9.1111	9.1236	9.0486	9.0629	3319008.0
2010-05-17 09:00:00	AAPL	Stock	9.0629	9.1493	9.0521	9.0796	108158652.0
2010-05-17 10:00:00	AAPL	Stock	9.0796	9.1379	9.0589	9.0739	92694224.0
2010-05-17 11:00:00	AAPL	Stock	9.0739	9.0879	8.9332	8.9371	113880004.0
2010-05-17 12:00:00	AAPL	Stock	8.9375	8.9593	8.8468	8.9007	135787064.0
2010-05-17 13:00:00	AAPL	Stock	8.9021	8.9682	8.8943	8.9489	64008224.0
2010-05-17 14:00:00	AAPL	Stock	8.9471	9.0175	8.9257	9.0132	85516648.0
2010-05-17 15:00:00	AAPL	Stock	9.0118	9.0821	8.9464	9.0768	144919600.0
2010-05-17 16:00:00	AAPL	Stock	9.0782	9.0814	8.9665	9.0807	8553244.0
2010-05-17 17:00:00	AAPL	Stock	8.9644	9.0875	8.9644	9.0875	574196.0
2010-05-17 18:00:00	AAPL	Stock	9.0871	9.0879	9.075	9.0782	421008.0
2010-05-17 19:00:00	AAPL	Stock	9.0818	9.0836	9.075	9.0818	371252.0
2010-05-17 07:00:00	MSFT	Stock	28.97	28.97	28.97	28.97	1245.0
2010-05-17 08:00:00	MSFT	Stock	28.87	29.15	28.82	28.97	33908.0
2010-05-17 09:00:00	MSFT	Stock	29.03	29.23	28.9	28.95	4849691.0
2010-05-17 10:00:00	MSFT	Stock	28.955	29.04	28.83	28.84	6614721.0
2010-05-17 11:00:00	MSFT	Stock	28.83	28.86	28.68	28.69	4793517.0
2010-05-17 12:00:00	MSFT	Stock	28.685	28.72	28.45	28.65	6574008.0
2010-05-17 13:00:00	MSFT	Stock	28.64	28.86	28.62	28.854	4730975.0
2010-05-17 14:00:00	MSFT	Stock	28.85	28.952	28.76	28.88	4828197.0
2010-05-17 15:00:00	MSFT	Stock	28.89	29.0	28.69	28.93	10760053.0
2010-05-17 16:00:00	MSFT	Stock	28.92	28.96	28.763	28.9	2704348.0
2010-05-17 17:00:00	MSFT	Stock	28.779	28.9	28.779	28.85	1750.0
2010-05-17 18:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	800.0
2010-05-17 19:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	1400.0
2010-05-17 05:00:00	NVDA	Stock	0.3238	0.3238	0.3238	0.3238	4000.0
2010-05-17 07:00:00	NVDA	Stock	0.3308	0.3308	0.3243	0.3243	8000.0
2010-05-17 08:00:00	NVDA	Stock	0.3258	0.3308	0.3225	0.3225	793600.0
2010-05-17 09:00:00	NVDA	Stock	0.324	0.326	0.3165	0.3217	107393760.0
2010-05-17 10:00:00	NVDA	Stock	0.3215	0.3288	0.3215	0.3251	157804040.0
2010-05-17 11:00:00	NVDA	Stock	0.325	0.3256	0.317	0.3175	81429880.0
2010-05-17 12:00:00	NVDA	Stock	0.3173	0.3185	0.3145	0.316	102740360.0
2010-05-17 13:00:00	NVDA	Stock	0.3158	0.3195	0.3155	0.3193	68718880.0
2010-05-17 14:00:00	NVDA	Stock	0.3193	0.324	0.3188	0.3233	115889800.0
2010-05-17 15:00:00	NVDA	Stock	0.3233	0.326	0.3213	0.3248	212928440.0
2010-05-17 16:00:00	NVDA	Stock	0.3248	0.3254	0.3207	0.322	7365480.0
2010-05-17 17:00:00	NVDA	Stock	0.3245	0.3263	0.3245	0.325	147640.0
2010-05-17 18:00:00	NVDA	Stock	0.3245	0.3245	0.3245	0.3245	48000.0
2010-05-17 19:00:00	NVDA	Stock	0.3238	0.3238	0.3233	0.3233	198000.0
2010-05-17 08:00:00	AMZN	Stock	6.425	6.425	6.392	6.41	35700.0
2010-05-17 09:00:00	AMZN	Stock	6.4165	6.462	6.373	6.4015	12042380.0
2010-05-17 10:00:00	AMZN	Stock	6.401	6.4975	6.388	6.428	20623320.0
2010-05-17 11:00:00	AMZN	Stock	6.4282	6.435	6.3445	6.3461	13132460.0
2010-05-17 12:00:00	AMZN	Stock	6.346	6.3665	6.29	6.327	10619460.0
2010-05-17 13:00:00	AMZN	Stock	6.329	6.3825	6.314	6.329	9975080.0
2010-05-17 14:00:00	AMZN	Stock	6.329	6.4075	6.3255	6.4035	16741660.0

> showing 50 of 43,585 rows — these rows as CSV

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