PREVIEW / futures_1hour / 2016-11-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	2366.82	2368.18	2366.27	2367.63	3043.0
2016-11-17 01:00:00	ES	Futures	2367.63	2369.26	2366.82	2367.09	3917.0
2016-11-17 02:00:00	ES	Futures	2367.36	2367.9	2364.09	2364.09	7491.0
2016-11-17 03:00:00	ES	Futures	2364.09	2368.18	2363.82	2367.9	21679.0
2016-11-17 04:00:00	ES	Futures	2367.63	2368.18	2365.18	2366.54	11827.0
2016-11-17 05:00:00	ES	Futures	2366.54	2368.18	2364.91	2367.63	9298.0
2016-11-17 06:00:00	ES	Futures	2367.9	2368.72	2366.27	2366.54	7221.0
2016-11-17 07:00:00	ES	Futures	2366.54	2368.72	2365.73	2366.0	12619.0
2016-11-17 08:00:00	ES	Futures	2366.0	2366.82	2363.55	2366.27	35457.0
2016-11-17 09:00:00	ES	Futures	2366.54	2374.16	2366.0	2373.62	228203.0
2016-11-17 10:00:00	ES	Futures	2373.62	2373.89	2367.9	2369.54	214762.0
2016-11-17 11:00:00	ES	Futures	2369.54	2376.88	2369.54	2375.52	157331.0
2016-11-17 12:00:00	ES	Futures	2375.52	2378.51	2374.98	2375.79	121297.0
2016-11-17 13:00:00	ES	Futures	2376.07	2377.7	2374.43	2374.43	80323.0
2016-11-17 14:00:00	ES	Futures	2374.71	2376.07	2372.8	2374.71	131877.0
2016-11-17 15:00:00	ES	Futures	2374.98	2377.7	2373.89	2377.15	178741.0
2016-11-17 16:00:00	ES	Futures	2377.43	2378.24	2375.79	2377.97	82393.0
2016-11-17 18:00:00	ES	Futures	2376.88	2378.51	2375.52	2375.79	6693.0
2016-11-17 19:00:00	ES	Futures	2375.79	2377.43	2374.71	2375.52	8548.0
2016-11-17 20:00:00	ES	Futures	2375.25	2375.79	2373.07	2374.16	7875.0
2016-11-17 21:00:00	ES	Futures	2374.43	2375.25	2373.35	2374.71	5392.0
2016-11-17 22:00:00	ES	Futures	2374.98	2374.98	2373.62	2373.89	3330.0
2016-11-17 23:00:00	ES	Futures	2373.89	2374.98	2373.62	2374.16	1900.0
2016-11-17 00:00:00	NQ	Futures	5724.45	5727.73	5723.56	5726.54	780.0
2016-11-17 01:00:00	NQ	Futures	5726.84	5732.51	5723.26	5723.56	1738.0
2016-11-17 02:00:00	NQ	Futures	5723.85	5727.73	5718.19	5718.48	1753.0
2016-11-17 03:00:00	NQ	Futures	5718.19	5729.52	5717.29	5727.73	2872.0
2016-11-17 04:00:00	NQ	Futures	5728.03	5730.42	5714.9	5722.36	3486.0
2016-11-17 05:00:00	NQ	Futures	5722.66	5727.73	5717.59	5725.94	1540.0
2016-11-17 06:00:00	NQ	Futures	5726.24	5728.33	5719.08	5723.85	1807.0
2016-11-17 07:00:00	NQ	Futures	5723.56	5730.42	5718.78	5719.38	2625.0
2016-11-17 08:00:00	NQ	Futures	5719.08	5720.87	5705.95	5714.9	7288.0
2016-11-17 09:00:00	NQ	Futures	5715.2	5728.03	5701.78	5725.35	35412.0
2016-11-17 10:00:00	NQ	Futures	5725.64	5732.51	5715.2	5724.75	26628.0
2016-11-17 11:00:00	NQ	Futures	5725.05	5747.72	5722.96	5746.83	22921.0
2016-11-17 12:00:00	NQ	Futures	5746.83	5758.16	5743.84	5754.28	19870.0
2016-11-17 13:00:00	NQ	Futures	5753.99	5759.06	5750.11	5750.11	10455.0
2016-11-17 14:00:00	NQ	Futures	5750.41	5752.49	5739.37	5748.62	16390.0
2016-11-17 15:00:00	NQ	Futures	5748.62	5759.95	5746.53	5759.36	16959.0
2016-11-17 16:00:00	NQ	Futures	5759.65	5765.62	5753.39	5765.62	8974.0
2016-11-17 18:00:00	NQ	Futures	5762.34	5766.22	5760.25	5760.55	1072.0
2016-11-17 19:00:00	NQ	Futures	5760.85	5766.81	5758.16	5759.95	1994.0
2016-11-17 20:00:00	NQ	Futures	5760.25	5760.85	5753.69	5759.36	1490.0
2016-11-17 21:00:00	NQ	Futures	5759.36	5763.53	5755.78	5761.74	1078.0
2016-11-17 22:00:00	NQ	Futures	5761.74	5761.74	5758.76	5759.36	404.0
2016-11-17 23:00:00	NQ	Futures	5759.06	5761.44	5758.76	5760.25	241.0
2016-11-17 00:00:00	YM	Futures	20369.1	20381.0	20365.9	20376.7	1072.0
2016-11-17 01:00:00	YM	Futures	20376.7	20392.9	20373.5	20376.7	1005.0
2016-11-17 02:00:00	YM	Futures	20376.7	20381.0	20358.3	20358.3	1576.0
2016-11-17 03:00:00	YM	Futures	20357.2	20383.2	20354.0	20379.9	3249.0

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

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