PREVIEW / stock_1hour / 2010-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-22.parquet
  size:    913 KB
  rows:    44,473
  symbols: 3,491

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-10-22 05:00:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	22400.0
2010-10-22 07:00:00	AAPL	Stock	10.9925	11.025	10.9925	11.025	180264.0
2010-10-22 08:00:00	AAPL	Stock	11.0214	11.0429	11.0039	11.0357	2682344.0
2010-10-22 09:00:00	AAPL	Stock	11.0357	11.0814	10.9939	11.0136	63785680.0
2010-10-22 10:00:00	AAPL	Stock	11.0139	11.0568	10.9689	11.0405	68166392.0
2010-10-22 11:00:00	AAPL	Stock	11.0393	11.0536	11.0071	11.0071	41555780.0
2010-10-22 12:00:00	AAPL	Stock	11.0076	11.0264	11.0007	11.0077	30763628.0
2010-10-22 13:00:00	AAPL	Stock	11.0061	11.0179	10.9821	10.9861	31270568.0
2010-10-22 14:00:00	AAPL	Stock	10.9868	11.0357	10.9821	11.0111	38722964.0
2010-10-22 15:00:00	AAPL	Stock	11.0111	11.0175	10.9393	10.9957	74378668.0
2010-10-22 16:00:00	AAPL	Stock	10.9932	11.0456	10.9736	10.9811	14339388.0
2010-10-22 17:00:00	AAPL	Stock	10.9836	10.9954	10.9793	10.9889	627732.0
2010-10-22 18:00:00	AAPL	Stock	10.9821	10.9839	10.9471	10.95	1152032.0
2010-10-22 19:00:00	AAPL	Stock	10.95	10.9839	10.9482	10.9839	1471652.0
2010-10-22 07:00:00	MSFT	Stock	25.55	25.55	25.31	25.49	2825.0
2010-10-22 08:00:00	MSFT	Stock	25.46	25.55	25.4	25.51	70764.0
2010-10-22 09:00:00	MSFT	Stock	25.51	25.54	25.31	25.315	3444726.0
2010-10-22 10:00:00	MSFT	Stock	25.315	25.38	25.27	25.36	4694708.0
2010-10-22 11:00:00	MSFT	Stock	25.353	25.36	25.3	25.327	2541640.0
2010-10-22 12:00:00	MSFT	Stock	25.326	25.43	25.32	25.425	2078391.0
2010-10-22 13:00:00	MSFT	Stock	25.425	25.43	25.33	25.33	2049142.0
2010-10-22 14:00:00	MSFT	Stock	25.334	25.35	25.3	25.3	3022005.0
2010-10-22 15:00:00	MSFT	Stock	25.302	25.39	25.3	25.39	5209569.0
2010-10-22 16:00:00	MSFT	Stock	25.39	25.49	25.329	25.46	1528223.0
2010-10-22 17:00:00	MSFT	Stock	25.4	25.5	25.39	25.45	36364.0
2010-10-22 18:00:00	MSFT	Stock	25.38	25.44	25.38	25.44	6400.0
2010-10-22 19:00:00	MSFT	Stock	25.44	25.44	25.4	25.4	400.0
2010-10-22 07:00:00	NVDA	Stock	0.2772	0.2932	0.277	0.2848	374400.0
2010-10-22 08:00:00	NVDA	Stock	0.2778	0.2812	0.2778	0.2805	88000.0
2010-10-22 09:00:00	NVDA	Stock	0.2795	0.2838	0.276	0.2822	132700240.0
2010-10-22 10:00:00	NVDA	Stock	0.2821	0.29	0.2808	0.2895	238406600.0
2010-10-22 11:00:00	NVDA	Stock	0.2896	0.2938	0.2885	0.2934	185869040.0
2010-10-22 12:00:00	NVDA	Stock	0.2935	0.296	0.293	0.2948	157979760.0
2010-10-22 13:00:00	NVDA	Stock	0.295	0.2972	0.292	0.292	167036880.0
2010-10-22 14:00:00	NVDA	Stock	0.2922	0.2946	0.292	0.294	129989440.0
2010-10-22 15:00:00	NVDA	Stock	0.2938	0.2958	0.2932	0.2948	278144680.0
2010-10-22 16:00:00	NVDA	Stock	0.295	0.2965	0.291	0.2955	8577240.0
2010-10-22 17:00:00	NVDA	Stock	0.295	0.296	0.2948	0.2955	320800.0
2010-10-22 18:00:00	NVDA	Stock	0.2962	0.2962	0.2958	0.2958	56000.0
2010-10-22 19:00:00	NVDA	Stock	0.2958	0.2958	0.295	0.295	90720.0
2010-10-22 04:00:00	AMZN	Stock	8.0205	8.0205	8.0205	8.0205	2000.0
2010-10-22 05:00:00	AMZN	Stock	7.941	7.941	7.941	7.941	2400.0
2010-10-22 06:00:00	AMZN	Stock	7.973	7.9995	7.97	7.975	50000.0
2010-10-22 07:00:00	AMZN	Stock	7.965	7.9965	7.95	7.9655	69300.0
2010-10-22 08:00:00	AMZN	Stock	7.9655	8.2425	7.885	8.212	9098660.0
2010-10-22 09:00:00	AMZN	Stock	8.2185	8.344	8.1135	8.241	76269700.0
2010-10-22 10:00:00	AMZN	Stock	8.24	8.4155	8.144	8.4021	72687660.0
2010-10-22 11:00:00	AMZN	Stock	8.402	8.431	8.3735	8.4085	34744660.0
2010-10-22 12:00:00	AMZN	Stock	8.4065	8.5085	8.4055	8.4676	43459520.0
2010-10-22 13:00:00	AMZN	Stock	8.4705	8.494	8.4245	8.4295	14179580.0

> showing 50 of 44,473 rows — these rows as CSV

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