PREVIEW / stock_1hour / 2013-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-31.parquet
  size:    1.0 MB
  rows:    47,134
  symbols: 3,543

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
2013-10-31 04:00:00	AAPL	Stock	18.6907	18.6907	18.6907	18.6907	2800.0
2013-10-31 05:00:00	AAPL	Stock	18.6939	18.6939	18.6939	18.6939	2800.0
2013-10-31 06:00:00	AAPL	Stock	18.7446	18.7464	18.7446	18.7464	25200.0
2013-10-31 07:00:00	AAPL	Stock	18.7239	18.7893	18.7239	18.7629	301812.0
2013-10-31 08:00:00	AAPL	Stock	18.7589	18.7857	18.7232	18.7668	1165780.0
2013-10-31 09:00:00	AAPL	Stock	18.7554	18.7693	18.6168	18.6229	43777356.0
2013-10-31 10:00:00	AAPL	Stock	18.6211	18.7461	18.6207	18.7261	43384880.0
2013-10-31 11:00:00	AAPL	Stock	18.7225	18.8389	18.72	18.7701	35828604.0
2013-10-31 12:00:00	AAPL	Stock	18.77	18.8154	18.7375	18.7529	20378176.0
2013-10-31 13:00:00	AAPL	Stock	18.7543	18.7714	18.6925	18.7124	21110656.0
2013-10-31 14:00:00	AAPL	Stock	18.7143	18.7721	18.7065	18.7164	19029304.0
2013-10-31 15:00:00	AAPL	Stock	18.7114	18.7404	18.6543	18.6561	41757828.0
2013-10-31 16:00:00	AAPL	Stock	18.6561	18.7246	18.6479	18.6607	19620216.0
2013-10-31 17:00:00	AAPL	Stock	18.6607	18.6639	18.6554	18.6636	443604.0
2013-10-31 18:00:00	AAPL	Stock	18.6636	18.6729	18.6554	18.6729	151312.0
2013-10-31 19:00:00	AAPL	Stock	18.6729	18.6786	18.6679	18.6786	357868.0
2013-10-31 08:00:00	MSFT	Stock	35.5	35.56	35.48	35.56	3286.0
2013-10-31 09:00:00	MSFT	Stock	35.56	35.68	35.34	35.45	4443221.0
2013-10-31 10:00:00	MSFT	Stock	35.45	35.69	35.41	35.64	5808150.0
2013-10-31 11:00:00	MSFT	Stock	35.64	35.67	35.55	35.585	2927590.0
2013-10-31 12:00:00	MSFT	Stock	35.585	35.64	35.5	35.53	3046012.0
2013-10-31 13:00:00	MSFT	Stock	35.525	35.55	35.51	35.525	2576892.0
2013-10-31 14:00:00	MSFT	Stock	35.53	35.61	35.51	35.53	3292719.0
2013-10-31 15:00:00	MSFT	Stock	35.52	35.57	35.35	35.36	10824375.0
2013-10-31 16:00:00	MSFT	Stock	35.36	35.54	35.338	35.54	5334189.0
2013-10-31 17:00:00	MSFT	Stock	35.35	35.42	35.35	35.42	67813.0
2013-10-31 18:00:00	MSFT	Stock	35.42	35.42	35.37	35.39	6380.0
2013-10-31 19:00:00	MSFT	Stock	35.39	35.39	35.39	35.39	900.0
2013-10-31 09:00:00	NVDA	Stock	0.3805	0.3838	0.3798	0.3798	20747840.0
2013-10-31 10:00:00	NVDA	Stock	0.3798	0.383	0.3795	0.3808	34655400.0
2013-10-31 11:00:00	NVDA	Stock	0.3808	0.3815	0.38	0.3803	23456360.0
2013-10-31 12:00:00	NVDA	Stock	0.38	0.3808	0.379	0.379	25103480.0
2013-10-31 13:00:00	NVDA	Stock	0.379	0.3815	0.379	0.38	38128400.0
2013-10-31 14:00:00	NVDA	Stock	0.38	0.3826	0.3798	0.3822	36588160.0
2013-10-31 15:00:00	NVDA	Stock	0.382	0.3821	0.3793	0.3795	82661280.0
2013-10-31 16:00:00	NVDA	Stock	0.3795	0.3803	0.3792	0.3803	24033000.0
2013-10-31 17:00:00	NVDA	Stock	0.3795	0.3795	0.3795	0.3795	202240.0
2013-10-31 08:00:00	AMZN	Stock	18.0	18.095	18.0	18.04	30560.0
2013-10-31 09:00:00	AMZN	Stock	17.988	18.2	17.955	17.965	5760120.0
2013-10-31 10:00:00	AMZN	Stock	17.9695	18.192	17.95	18.174	9683280.0
2013-10-31 11:00:00	AMZN	Stock	18.1685	18.215	18.1125	18.183	8424220.0
2013-10-31 12:00:00	AMZN	Stock	18.188	18.3	18.1485	18.2232	5759840.0
2013-10-31 13:00:00	AMZN	Stock	18.2235	18.265	18.2045	18.219	2354500.0
2013-10-31 14:00:00	AMZN	Stock	18.211	18.298	18.211	18.2448	3274400.0
2013-10-31 15:00:00	AMZN	Stock	18.2425	18.264	18.202	18.202	8371200.0
2013-10-31 16:00:00	AMZN	Stock	18.202	18.2605	18.1732	18.2135	5428120.0
2013-10-31 17:00:00	AMZN	Stock	18.2015	18.235	18.2015	18.235	79160.0
2013-10-31 18:00:00	AMZN	Stock	18.2125	18.2125	18.2125	18.2125	2000.0
2013-10-31 04:00:00	META	Stock	48.97	50.45	48.85	50.22	183753.0
2013-10-31 05:00:00	META	Stock	50.27	50.29	49.86	50.2	63046.0

> showing 50 of 47,134 rows — these rows as CSV

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