PREVIEW / futures_1hour / 2016-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-18.parquet
  size:    47 KB
  rows:    1,352

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-18 00:00:00	ES	Futures	2374.16	2375.52	2373.89	2374.98	2217.0
2016-11-18 01:00:00	ES	Futures	2374.98	2376.07	2374.16	2375.52	1868.0
2016-11-18 02:00:00	ES	Futures	2375.79	2377.15	2374.98	2376.34	6257.0
2016-11-18 03:00:00	ES	Futures	2376.34	2377.15	2370.62	2371.44	30579.0
2016-11-18 04:00:00	ES	Futures	2371.44	2372.53	2368.72	2371.71	20279.0
2016-11-18 05:00:00	ES	Futures	2371.98	2372.8	2370.9	2372.53	11989.0
2016-11-18 06:00:00	ES	Futures	2372.53	2374.16	2372.26	2373.62	9281.0
2016-11-18 07:00:00	ES	Futures	2373.62	2379.87	2373.62	2378.79	27895.0
2016-11-18 08:00:00	ES	Futures	2378.79	2379.06	2375.25	2377.43	32704.0
2016-11-18 09:00:00	ES	Futures	2377.7	2380.69	2375.52	2376.07	218964.0
2016-11-18 10:00:00	ES	Futures	2376.34	2378.79	2370.62	2371.44	209384.0
2016-11-18 11:00:00	ES	Futures	2371.44	2373.07	2369.81	2370.62	146513.0
2016-11-18 12:00:00	ES	Futures	2370.62	2373.35	2370.35	2373.35	74969.0
2016-11-18 13:00:00	ES	Futures	2373.07	2374.98	2372.8	2373.07	66573.0
2016-11-18 14:00:00	ES	Futures	2373.35	2373.89	2371.71	2371.98	88695.0
2016-11-18 15:00:00	ES	Futures	2372.26	2375.52	2369.81	2372.26	204859.0
2016-11-18 16:00:00	ES	Futures	2372.53	2373.89	2371.17	2372.8	75089.0
2016-11-18 00:00:00	NQ	Futures	5759.65	5764.13	5759.65	5762.64	545.0
2016-11-18 01:00:00	NQ	Futures	5761.74	5764.13	5758.76	5763.53	415.0
2016-11-18 02:00:00	NQ	Futures	5763.83	5770.1	5762.64	5766.81	1632.0
2016-11-18 03:00:00	NQ	Futures	5766.52	5768.6	5753.69	5755.18	3883.0
2016-11-18 04:00:00	NQ	Futures	5755.18	5757.27	5746.83	5755.48	3119.0
2016-11-18 05:00:00	NQ	Futures	5756.07	5758.46	5752.79	5758.46	1490.0
2016-11-18 06:00:00	NQ	Futures	5758.16	5761.15	5755.78	5758.46	1470.0
2016-11-18 07:00:00	NQ	Futures	5758.46	5773.08	5758.46	5768.31	3947.0
2016-11-18 08:00:00	NQ	Futures	5768.31	5768.31	5759.06	5763.53	7332.0
2016-11-18 09:00:00	NQ	Futures	5763.83	5776.36	5755.18	5755.48	30794.0
2016-11-18 10:00:00	NQ	Futures	5755.18	5762.94	5731.61	5739.07	33227.0
2016-11-18 11:00:00	NQ	Futures	5739.37	5743.54	5734.3	5738.47	20534.0
2016-11-18 12:00:00	NQ	Futures	5738.47	5749.21	5737.88	5748.91	11733.0
2016-11-18 13:00:00	NQ	Futures	5748.62	5750.11	5739.96	5740.86	9597.0
2016-11-18 14:00:00	NQ	Futures	5740.86	5745.33	5739.37	5740.26	11060.0
2016-11-18 15:00:00	NQ	Futures	5740.56	5746.83	5732.21	5736.98	15446.0
2016-11-18 16:00:00	NQ	Futures	5737.58	5741.75	5733.4	5739.07	6254.0
2016-11-18 00:00:00	YM	Futures	20377.8	20389.7	20375.6	20385.3	682.0
2016-11-18 01:00:00	YM	Futures	20384.3	20391.8	20376.7	20390.7	605.0
2016-11-18 02:00:00	YM	Futures	20389.7	20399.4	20386.4	20395.1	1617.0
2016-11-18 03:00:00	YM	Futures	20394.0	20400.5	20354.0	20359.4	4958.0
2016-11-18 04:00:00	YM	Futures	20360.5	20369.1	20343.2	20361.6	3604.0
2016-11-18 05:00:00	YM	Futures	20362.6	20371.3	20356.2	20367.0	1526.0
2016-11-18 06:00:00	YM	Futures	20365.9	20377.8	20365.9	20371.3	1367.0
2016-11-18 07:00:00	YM	Futures	20372.4	20411.3	20372.4	20401.6	4140.0
2016-11-18 08:00:00	YM	Futures	20401.6	20402.6	20379.9	20394.0	4651.0
2016-11-18 09:00:00	YM	Futures	20394.0	20410.2	20371.3	20396.2	19346.0
2016-11-18 10:00:00	YM	Futures	20397.2	20414.5	20358.3	20362.6	19956.0
2016-11-18 11:00:00	YM	Futures	20363.7	20374.5	20346.4	20357.2	11972.0
2016-11-18 12:00:00	YM	Futures	20357.2	20371.3	20348.6	20369.1	6412.0
2016-11-18 13:00:00	YM	Futures	20369.1	20387.5	20364.8	20371.3	5368.0
2016-11-18 14:00:00	YM	Futures	20371.3	20379.9	20362.6	20370.2	6163.0
2016-11-18 15:00:00	YM	Futures	20370.2	20391.8	20350.8	20363.7	10777.0

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

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