PREVIEW / futures_1hour / 2016-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-08.parquet
  size:    46 KB
  rows:    1,314

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-07-08 00:00:00	ES	Futures	2266.03	2266.58	2264.41	2266.03	4433.0
2016-07-08 01:00:00	ES	Futures	2266.03	2267.39	2265.22	2266.58	2829.0
2016-07-08 02:00:00	ES	Futures	2266.3	2268.47	2265.76	2267.66	7511.0
2016-07-08 03:00:00	ES	Futures	2267.93	2274.98	2266.03	2272.27	36363.0
2016-07-08 04:00:00	ES	Futures	2272.54	2274.98	2269.29	2270.64	20058.0
2016-07-08 05:00:00	ES	Futures	2270.64	2274.17	2267.39	2273.63	22087.0
2016-07-08 06:00:00	ES	Futures	2273.63	2275.25	2271.73	2274.98	13890.0
2016-07-08 07:00:00	ES	Futures	2274.98	2276.61	2273.36	2275.25	23286.0
2016-07-08 08:00:00	ES	Futures	2275.25	2288.81	2274.17	2286.92	145302.0
2016-07-08 09:00:00	ES	Futures	2286.92	2289.63	2281.76	2288.27	362001.0
2016-07-08 10:00:00	ES	Futures	2288.0	2294.78	2287.73	2294.24	317904.0
2016-07-08 11:00:00	ES	Futures	2294.24	2298.03	2293.42	2296.68	186358.0
2016-07-08 12:00:00	ES	Futures	2296.68	2297.76	2295.32	2297.22	93198.0
2016-07-08 13:00:00	ES	Futures	2297.22	2300.47	2296.95	2299.66	104319.0
2016-07-08 14:00:00	ES	Futures	2299.39	2305.63	2298.85	2303.19	180778.0
2016-07-08 15:00:00	ES	Futures	2303.19	2303.73	2299.39	2302.1	287249.0
2016-07-08 16:00:00	ES	Futures	2302.1	2302.37	2299.39	2300.47	102590.0
2016-07-08 00:00:00	NQ	Futures	5298.76	5299.95	5293.1	5299.06	1036.0
2016-07-08 01:00:00	NQ	Futures	5298.76	5303.53	5298.16	5302.04	706.0
2016-07-08 02:00:00	NQ	Futures	5301.74	5306.81	5299.95	5304.72	1140.0
2016-07-08 03:00:00	NQ	Futures	5304.72	5324.39	5299.95	5317.24	4390.0
2016-07-08 04:00:00	NQ	Futures	5316.94	5323.2	5303.83	5306.81	4689.0
2016-07-08 05:00:00	NQ	Futures	5306.81	5314.26	5296.97	5312.77	4105.0
2016-07-08 06:00:00	NQ	Futures	5312.77	5318.13	5309.49	5316.35	1461.0
2016-07-08 07:00:00	NQ	Futures	5316.64	5319.33	5314.56	5316.35	3930.0
2016-07-08 08:00:00	NQ	Futures	5315.75	5342.87	5312.17	5337.21	18360.0
2016-07-08 09:00:00	NQ	Futures	5337.21	5360.16	5325.88	5354.79	55590.0
2016-07-08 10:00:00	NQ	Futures	5355.09	5372.98	5352.71	5372.08	38968.0
2016-07-08 11:00:00	NQ	Futures	5372.38	5381.32	5370.29	5375.96	22557.0
2016-07-08 12:00:00	NQ	Futures	5376.25	5378.34	5371.49	5375.36	11949.0
2016-07-08 13:00:00	NQ	Futures	5375.36	5382.22	5375.06	5381.62	9898.0
2016-07-08 14:00:00	NQ	Futures	5381.62	5392.65	5378.34	5387.88	16156.0
2016-07-08 15:00:00	NQ	Futures	5387.88	5391.75	5381.62	5389.07	25588.0
2016-07-08 16:00:00	NQ	Futures	5388.77	5389.96	5383.71	5385.2	6523.0
2016-07-08 00:00:00	YM	Futures	19148.9	19155.4	19137.1	19146.8	950.0
2016-07-08 01:00:00	YM	Futures	19147.8	19158.6	19144.6	19151.1	627.0
2016-07-08 02:00:00	YM	Futures	19151.1	19165.1	19145.7	19161.8	904.0
2016-07-08 03:00:00	YM	Futures	19161.8	19221.0	19146.8	19202.7	4838.0
2016-07-08 04:00:00	YM	Futures	19201.6	19217.8	19175.8	19186.6	2378.0
2016-07-08 05:00:00	YM	Futures	19186.6	19212.4	19166.1	19208.1	2135.0
2016-07-08 06:00:00	YM	Futures	19208.1	19216.7	19193.0	19213.5	1733.0
2016-07-08 07:00:00	YM	Futures	19214.6	19235.0	19201.6	19224.2	2231.0
2016-07-08 08:00:00	YM	Futures	19224.2	19325.4	19211.3	19306.0	16937.0
2016-07-08 09:00:00	YM	Futures	19305.0	19338.3	19270.5	19322.2	30261.0
2016-07-08 10:00:00	YM	Futures	19323.3	19357.7	19320.0	19345.9	25172.0
2016-07-08 11:00:00	YM	Futures	19346.9	19385.7	19340.5	19379.2	17191.0
2016-07-08 12:00:00	YM	Futures	19378.1	19396.4	19367.4	19388.9	9793.0
2016-07-08 13:00:00	YM	Futures	19388.9	19414.7	19388.9	19408.3	9538.0
2016-07-08 14:00:00	YM	Futures	19409.4	19456.7	19404.0	19435.2	16291.0
2016-07-08 15:00:00	YM	Futures	19437.3	19440.6	19410.4	19427.7	17204.0

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

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