PREVIEW / stock_1hour / 2014-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-16.parquet
  size:    1.1 MB
  rows:    49,791
  symbols: 3,562

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
2014-10-16 04:00:00	AAPL	Stock	24.2525	24.2525	24.1525	24.2	26872.0
2014-10-16 05:00:00	AAPL	Stock	24.21	24.21	23.875	23.9025	115044.0
2014-10-16 06:00:00	AAPL	Stock	24.0	24.0	23.4375	23.7125	638520.0
2014-10-16 07:00:00	AAPL	Stock	23.75	24.0225	23.725	23.925	894640.0
2014-10-16 08:00:00	AAPL	Stock	23.92	24.04	23.7375	23.945	2071308.0
2014-10-16 09:00:00	AAPL	Stock	23.945	24.1875	23.855	24.0837	37614668.0
2014-10-16 10:00:00	AAPL	Stock	24.0875	24.2475	23.8525	24.1412	52419984.0
2014-10-16 11:00:00	AAPL	Stock	24.1425	24.3325	24.0225	24.09	35542436.0
2014-10-16 12:00:00	AAPL	Stock	24.09	24.275	24.0625	24.2502	23690064.0
2014-10-16 13:00:00	AAPL	Stock	24.25	24.43	24.185	24.22	40149736.0
2014-10-16 14:00:00	AAPL	Stock	24.22	24.2875	23.97	23.975	29990996.0
2014-10-16 15:00:00	AAPL	Stock	23.975	24.16	23.95	24.065	40011032.0
2014-10-16 16:00:00	AAPL	Stock	24.065	24.385	23.915	24.1532	9273140.0
2014-10-16 17:00:00	AAPL	Stock	24.05	24.065	21.3492	24.0075	374600.0
2014-10-16 18:00:00	AAPL	Stock	24.0225	24.085	24.0225	24.0625	154048.0
2014-10-16 19:00:00	AAPL	Stock	24.0625	24.0925	24.01	24.0525	57640.0
2014-10-16 06:00:00	MSFT	Stock	42.41	42.45	42.4	42.45	5700.0
2014-10-16 07:00:00	MSFT	Stock	42.45	42.55	42.35	42.51	35370.0
2014-10-16 08:00:00	MSFT	Stock	42.55	42.8	42.55	42.62	268791.0
2014-10-16 09:00:00	MSFT	Stock	42.65	43.08	42.4	42.9	5497961.0
2014-10-16 10:00:00	MSFT	Stock	42.896	42.93	42.37	42.63	8304825.0
2014-10-16 11:00:00	MSFT	Stock	42.63	42.72	42.42	42.48	7087115.0
2014-10-16 12:00:00	MSFT	Stock	42.48	42.53	42.22	42.52	4860182.0
2014-10-16 13:00:00	MSFT	Stock	42.52	42.807	42.52	42.65	5821973.0
2014-10-16 14:00:00	MSFT	Stock	42.65	42.86	42.62	42.714	4060747.0
2014-10-16 15:00:00	MSFT	Stock	42.715	42.96	42.59	42.715	7085601.0
2014-10-16 16:00:00	MSFT	Stock	42.74	42.87	42.5	42.74	3678500.0
2014-10-16 17:00:00	MSFT	Stock	42.6	42.74	42.55	42.55	21919.0
2014-10-16 18:00:00	MSFT	Stock	42.64	42.74	42.64	42.74	25331.0
2014-10-16 19:00:00	MSFT	Stock	42.7	42.7	42.7	42.7	600.0
2014-10-16 08:00:00	NVDA	Stock	0.4302	0.4315	0.4162	0.4215	120000.0
2014-10-16 09:00:00	NVDA	Stock	0.4275	0.4361	0.4272	0.4353	28269840.0
2014-10-16 10:00:00	NVDA	Stock	0.4352	0.4382	0.4318	0.435	55894480.0
2014-10-16 11:00:00	NVDA	Stock	0.4349	0.4412	0.4338	0.4378	54344920.0
2014-10-16 12:00:00	NVDA	Stock	0.4375	0.4379	0.4338	0.4376	26879840.0
2014-10-16 13:00:00	NVDA	Stock	0.4375	0.441	0.4375	0.4382	41785880.0
2014-10-16 14:00:00	NVDA	Stock	0.4385	0.439	0.435	0.4362	28746040.0
2014-10-16 15:00:00	NVDA	Stock	0.436	0.4391	0.435	0.4362	89067800.0
2014-10-16 16:00:00	NVDA	Stock	0.4362	0.441	0.4358	0.4362	15072560.0
2014-10-16 17:00:00	NVDA	Stock	0.434	0.434	0.434	0.434	24000.0
2014-10-16 05:00:00	AMZN	Stock	14.912	14.912	14.912	14.912	2000.0
2014-10-16 06:00:00	AMZN	Stock	14.912	14.912	14.75	14.7625	230100.0
2014-10-16 07:00:00	AMZN	Stock	14.7655	14.825	14.7655	14.8	97760.0
2014-10-16 08:00:00	AMZN	Stock	14.8115	14.9	14.7525	14.8	354100.0
2014-10-16 09:00:00	AMZN	Stock	14.8485	15.1655	14.6835	15.023	21100580.0
2014-10-16 10:00:00	AMZN	Stock	15.0312	15.159	14.892	15.1165	15804800.0
2014-10-16 11:00:00	AMZN	Stock	15.1165	15.2204	15.006	15.081	8686900.0
2014-10-16 12:00:00	AMZN	Stock	15.0755	15.166	15.018	15.15	6377700.0
2014-10-16 13:00:00	AMZN	Stock	15.161	15.341	15.147	15.178	10721280.0
2014-10-16 14:00:00	AMZN	Stock	15.1805	15.2105	15.107	15.131	7830760.0

> showing 50 of 49,791 rows — these rows as CSV

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