PREVIEW / futures_1hour / 2016-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-16.parquet
  size:    55 KB
  rows:    1,645

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
2016-11-16 00:00:00	ES	Futures	2374.43	2375.25	2371.98	2372.26	5347.0
2016-11-16 01:00:00	ES	Futures	2372.26	2373.89	2371.71	2373.62	3470.0
2016-11-16 02:00:00	ES	Futures	2373.62	2373.62	2368.72	2369.26	15169.0
2016-11-16 03:00:00	ES	Futures	2369.54	2371.71	2367.63	2368.99	26568.0
2016-11-16 04:00:00	ES	Futures	2368.99	2370.35	2367.09	2367.36	17036.0
2016-11-16 05:00:00	ES	Futures	2367.63	2369.54	2367.09	2369.26	12472.0
2016-11-16 06:00:00	ES	Futures	2369.26	2369.54	2364.64	2365.18	15104.0
2016-11-16 07:00:00	ES	Futures	2365.45	2365.45	2360.56	2363.82	36286.0
2016-11-16 08:00:00	ES	Futures	2364.09	2364.64	2361.1	2362.19	43224.0
2016-11-16 09:00:00	ES	Futures	2361.92	2367.36	2360.29	2362.46	221405.0
2016-11-16 10:00:00	ES	Futures	2362.46	2368.45	2361.65	2366.54	217601.0
2016-11-16 11:00:00	ES	Futures	2366.54	2366.82	2361.92	2363.28	167513.0
2016-11-16 12:00:00	ES	Futures	2363.55	2364.64	2360.56	2363.55	95622.0
2016-11-16 13:00:00	ES	Futures	2363.55	2364.37	2360.83	2363.82	80653.0
2016-11-16 14:00:00	ES	Futures	2363.82	2366.54	2363.28	2365.73	87323.0
2016-11-16 15:00:00	ES	Futures	2365.73	2367.9	2363.55	2366.0	169859.0
2016-11-16 16:00:00	ES	Futures	2366.27	2366.82	2363.82	2364.09	61290.0
2016-11-16 18:00:00	ES	Futures	2364.37	2365.73	2363.55	2364.64	3432.0
2016-11-16 19:00:00	ES	Futures	2364.64	2365.45	2364.37	2365.18	1880.0
2016-11-16 20:00:00	ES	Futures	2365.18	2370.08	2364.91	2369.26	11093.0
2016-11-16 21:00:00	ES	Futures	2369.54	2370.62	2367.9	2367.9	6853.0
2016-11-16 22:00:00	ES	Futures	2367.9	2368.99	2367.36	2367.9	3985.0
2016-11-16 23:00:00	ES	Futures	2367.63	2367.9	2366.0	2366.54	3319.0
2016-11-16 00:00:00	NQ	Futures	5704.46	5705.06	5693.72	5694.62	1017.0
2016-11-16 01:00:00	NQ	Futures	5694.02	5697.6	5692.83	5697.0	694.0
2016-11-16 02:00:00	NQ	Futures	5696.71	5699.99	5680.3	5680.6	3183.0
2016-11-16 03:00:00	NQ	Futures	5680.89	5685.07	5673.73	5678.51	3560.0
2016-11-16 04:00:00	NQ	Futures	5678.51	5682.39	5673.73	5674.93	2245.0
2016-11-16 05:00:00	NQ	Futures	5674.93	5685.07	5674.03	5682.68	1837.0
2016-11-16 06:00:00	NQ	Futures	5683.28	5683.58	5668.66	5671.05	2164.0
2016-11-16 07:00:00	NQ	Futures	5671.05	5671.94	5660.61	5668.36	4108.0
2016-11-16 08:00:00	NQ	Futures	5668.66	5673.14	5656.73	5658.82	6724.0
2016-11-16 09:00:00	NQ	Futures	5659.41	5702.08	5651.96	5676.42	37937.0
2016-11-16 10:00:00	NQ	Futures	5676.42	5718.19	5675.82	5710.43	37469.0
2016-11-16 11:00:00	NQ	Futures	5710.13	5721.77	5695.81	5712.22	27326.0
2016-11-16 12:00:00	NQ	Futures	5712.22	5721.17	5704.46	5714.01	19767.0
2016-11-16 13:00:00	NQ	Futures	5714.01	5717.29	5703.57	5713.41	9742.0
2016-11-16 14:00:00	NQ	Futures	5713.11	5718.48	5707.15	5715.8	9123.0
2016-11-16 15:00:00	NQ	Futures	5716.1	5721.47	5711.62	5717.29	15794.0
2016-11-16 16:00:00	NQ	Futures	5717.29	5718.48	5705.06	5709.24	5683.0
2016-11-16 18:00:00	NQ	Futures	5705.95	5708.34	5705.36	5707.45	646.0
2016-11-16 19:00:00	NQ	Futures	5707.15	5710.13	5706.85	5709.53	325.0
2016-11-16 20:00:00	NQ	Futures	5709.53	5725.05	5708.94	5725.05	2187.0
2016-11-16 21:00:00	NQ	Futures	5725.05	5726.84	5719.68	5723.85	2320.0
2016-11-16 22:00:00	NQ	Futures	5723.85	5726.84	5723.26	5724.45	1242.0
2016-11-16 23:00:00	NQ	Futures	5724.75	5725.64	5723.26	5724.45	1111.0
2016-11-16 00:00:00	YM	Futures	20409.1	20415.6	20399.4	20400.5	1054.0
2016-11-16 01:00:00	YM	Futures	20401.6	20409.1	20397.2	20407.0	726.0
2016-11-16 02:00:00	YM	Futures	20405.9	20407.0	20375.6	20381.0	2602.0
2016-11-16 03:00:00	YM	Futures	20382.1	20398.3	20373.5	20386.4	4502.0

> showing 50 of 1,645 rows — these rows as CSV

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