PREVIEW / futures_1hour / 2017-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-11.parquet
  size:    49 KB
  rows:    1,534

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
2017-09-11 00:00:00	ES	Futures	2706.06	2706.61	2704.69	2704.69	1562.0
2017-09-11 01:00:00	ES	Futures	2704.42	2705.24	2703.87	2704.42	1580.0
2017-09-11 02:00:00	ES	Futures	2704.42	2706.06	2704.15	2704.42	3794.0
2017-09-11 03:00:00	ES	Futures	2704.15	2706.61	2703.87	2705.24	9758.0
2017-09-11 04:00:00	ES	Futures	2705.24	2707.97	2704.69	2707.7	5675.0
2017-09-11 05:00:00	ES	Futures	2707.43	2707.43	2706.33	2707.15	4584.0
2017-09-11 06:00:00	ES	Futures	2707.15	2707.7	2706.61	2706.88	4414.0
2017-09-11 07:00:00	ES	Futures	2707.15	2707.15	2704.15	2704.69	6750.0
2017-09-11 08:00:00	ES	Futures	2704.69	2706.33	2704.42	2705.79	7630.0
2017-09-11 09:00:00	ES	Futures	2705.79	2713.99	2705.51	2712.35	70140.0
2017-09-11 10:00:00	ES	Futures	2712.62	2715.35	2712.07	2712.62	42822.0
2017-09-11 11:00:00	ES	Futures	2712.89	2716.99	2712.35	2716.45	32959.0
2017-09-11 12:00:00	ES	Futures	2716.45	2721.09	2715.63	2718.63	32965.0
2017-09-11 13:00:00	ES	Futures	2718.91	2720.27	2718.63	2719.18	21161.0
2017-09-11 14:00:00	ES	Futures	2719.45	2720.0	2717.81	2718.09	21760.0
2017-09-11 15:00:00	ES	Futures	2718.09	2720.0	2717.27	2719.18	61374.0
2017-09-11 16:00:00	ES	Futures	2719.45	2721.37	2718.36	2720.55	39665.0
2017-09-11 18:00:00	ES	Futures	2720.55	2721.09	2719.73	2720.0	3085.0
2017-09-11 19:00:00	ES	Futures	2720.27	2721.09	2719.45	2720.82	1359.0
2017-09-11 20:00:00	ES	Futures	2720.82	2722.73	2720.0	2721.37	4225.0
2017-09-11 21:00:00	ES	Futures	2721.37	2721.64	2719.73	2719.73	1547.0
2017-09-11 22:00:00	ES	Futures	2720.0	2720.27	2719.18	2720.0	906.0
2017-09-11 23:00:00	ES	Futures	2720.0	2720.27	2718.91	2719.73	1258.0
2017-09-11 00:00:00	NQ	Futures	7090.65	7091.84	7086.78	7087.08	428.0
2017-09-11 01:00:00	NQ	Futures	7087.37	7088.56	7085.59	7087.37	388.0
2017-09-11 02:00:00	NQ	Futures	7087.37	7092.14	7084.99	7086.18	992.0
2017-09-11 03:00:00	NQ	Futures	7085.88	7093.92	7084.1	7091.54	1752.0
2017-09-11 04:00:00	NQ	Futures	7091.54	7100.18	7089.16	7099.88	1945.0
2017-09-11 05:00:00	NQ	Futures	7099.58	7102.86	7097.2	7101.66	1426.0
2017-09-11 06:00:00	NQ	Futures	7101.37	7102.56	7098.39	7100.47	501.0
2017-09-11 07:00:00	NQ	Futures	7099.88	7099.88	7090.35	7091.84	1355.0
2017-09-11 08:00:00	NQ	Futures	7092.43	7098.39	7092.14	7098.39	1468.0
2017-09-11 09:00:00	NQ	Futures	7098.39	7130.25	7096.01	7125.78	17102.0
2017-09-11 10:00:00	NQ	Futures	7125.78	7136.2	7106.43	7109.41	14049.0
2017-09-11 11:00:00	NQ	Futures	7109.11	7117.15	7101.07	7115.66	9659.0
2017-09-11 12:00:00	NQ	Futures	7115.66	7128.46	7112.68	7124.89	4830.0
2017-09-11 13:00:00	NQ	Futures	7125.78	7127.87	7120.13	7124.59	2902.0
2017-09-11 14:00:00	NQ	Futures	7124.89	7128.16	7114.17	7117.45	3973.0
2017-09-11 15:00:00	NQ	Futures	7117.74	7125.19	7115.06	7121.91	6869.0
2017-09-11 16:00:00	NQ	Futures	7121.61	7132.04	7119.83	7128.16	2926.0
2017-09-11 18:00:00	NQ	Futures	7123.7	7129.65	7123.4	7128.16	446.0
2017-09-11 19:00:00	NQ	Futures	7127.57	7131.14	7124.89	7130.25	222.0
2017-09-11 20:00:00	NQ	Futures	7130.25	7136.5	7126.08	7134.42	543.0
2017-09-11 21:00:00	NQ	Futures	7134.72	7135.01	7127.87	7128.46	323.0
2017-09-11 22:00:00	NQ	Futures	7129.95	7130.55	7124.89	7128.16	253.0
2017-09-11 23:00:00	NQ	Futures	7127.57	7128.16	7124.29	7127.27	148.0
2017-09-11 00:00:00	YM	Futures	23814.8	23818.1	23800.7	23800.7	606.0
2017-09-11 01:00:00	YM	Futures	23800.7	23806.1	23797.4	23801.8	476.0
2017-09-11 02:00:00	YM	Futures	23800.7	23820.3	23800.7	23809.4	2076.0
2017-09-11 03:00:00	YM	Futures	23808.3	23824.6	23802.9	23805.1	2570.0

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

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