PREVIEW / futures_1hour / 2017-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-22.parquet
  size:    41 KB
  rows:    1,278

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-12-22 00:00:00	ES	Futures	2942.1	2942.38	2941.28	2941.28	2032.0
2017-12-22 01:00:00	ES	Futures	2941.28	2941.83	2940.74	2940.74	1403.0
2017-12-22 02:00:00	ES	Futures	2941.01	2941.56	2939.92	2941.28	3259.0
2017-12-22 03:00:00	ES	Futures	2941.01	2942.65	2941.01	2941.83	9457.0
2017-12-22 04:00:00	ES	Futures	2941.56	2942.65	2941.28	2941.83	5249.0
2017-12-22 05:00:00	ES	Futures	2941.56	2941.83	2940.46	2940.74	4026.0
2017-12-22 06:00:00	ES	Futures	2940.74	2942.1	2940.19	2941.56	4036.0
2017-12-22 07:00:00	ES	Futures	2941.56	2942.1	2939.64	2939.64	5898.0
2017-12-22 08:00:00	ES	Futures	2939.64	2941.01	2938.82	2939.1	13846.0
2017-12-22 09:00:00	ES	Futures	2939.1	2940.19	2935.27	2939.64	96424.0
2017-12-22 10:00:00	ES	Futures	2939.64	2939.92	2935.27	2936.91	81056.0
2017-12-22 11:00:00	ES	Futures	2936.91	2937.18	2932.54	2934.45	79210.0
2017-12-22 12:00:00	ES	Futures	2934.45	2936.64	2934.18	2935.27	27483.0
2017-12-22 13:00:00	ES	Futures	2935.0	2938.0	2935.0	2937.73	31865.0
2017-12-22 14:00:00	ES	Futures	2937.73	2939.37	2936.36	2938.55	42958.0
2017-12-22 15:00:00	ES	Futures	2938.82	2940.46	2937.18	2939.64	102611.0
2017-12-22 16:00:00	ES	Futures	2939.92	2940.19	2936.09	2937.73	57650.0
2017-12-22 00:00:00	NQ	Futures	7709.67	7710.86	7706.11	7709.97	815.0
2017-12-22 01:00:00	NQ	Futures	7709.97	7709.97	7701.96	7704.33	787.0
2017-12-22 02:00:00	NQ	Futures	7704.33	7708.48	7703.44	7708.19	887.0
2017-12-22 03:00:00	NQ	Futures	7708.19	7713.53	7707.0	7709.08	1435.0
2017-12-22 04:00:00	NQ	Futures	7709.37	7711.15	7707.3	7708.19	716.0
2017-12-22 05:00:00	NQ	Futures	7707.89	7710.26	7704.93	7705.22	559.0
2017-12-22 06:00:00	NQ	Futures	7704.93	7708.78	7701.96	7707.3	852.0
2017-12-22 07:00:00	NQ	Futures	7707.59	7708.78	7700.77	7701.66	1053.0
2017-12-22 08:00:00	NQ	Futures	7701.37	7705.52	7699.88	7700.18	2010.0
2017-12-22 09:00:00	NQ	Futures	7700.18	7703.44	7672.89	7695.14	41904.0
2017-12-22 10:00:00	NQ	Futures	7694.84	7696.92	7680.9	7692.77	26413.0
2017-12-22 11:00:00	NQ	Futures	7692.77	7694.84	7682.09	7687.13	20026.0
2017-12-22 12:00:00	NQ	Futures	7686.83	7687.72	7681.79	7685.65	10424.0
2017-12-22 13:00:00	NQ	Futures	7685.35	7696.03	7684.76	7694.54	8723.0
2017-12-22 14:00:00	NQ	Futures	7694.54	7699.29	7690.69	7698.99	8702.0
2017-12-22 15:00:00	NQ	Futures	7699.29	7701.96	7693.65	7699.59	18531.0
2017-12-22 16:00:00	NQ	Futures	7699.29	7699.88	7690.39	7691.58	5107.0
2017-12-22 00:00:00	YM	Futures	26992.7	26997.0	26955.7	26968.8	2323.0
2017-12-22 01:00:00	YM	Futures	26967.7	26968.8	26956.8	26960.1	477.0
2017-12-22 02:00:00	YM	Futures	26960.1	26962.2	26944.8	26954.6	1148.0
2017-12-22 03:00:00	YM	Futures	26955.7	26969.8	26950.3	26962.2	1672.0
2017-12-22 04:00:00	YM	Futures	26962.2	26969.8	26956.8	26962.2	541.0
2017-12-22 05:00:00	YM	Futures	26961.2	26963.3	26945.9	26950.3	639.0
2017-12-22 06:00:00	YM	Futures	26950.3	26963.3	26944.8	26955.7	696.0
2017-12-22 07:00:00	YM	Futures	26955.7	26960.1	26929.6	26930.7	1510.0
2017-12-22 08:00:00	YM	Futures	26930.7	26941.6	26913.3	26914.4	2476.0
2017-12-22 09:00:00	YM	Futures	26915.5	26937.2	26906.8	26930.7	11741.0
2017-12-22 10:00:00	YM	Futures	26930.7	26945.9	26911.2	26913.3	10701.0
2017-12-22 11:00:00	YM	Futures	26912.2	26918.8	26877.5	26893.8	8161.0
2017-12-22 12:00:00	YM	Futures	26894.9	26910.1	26879.6	26888.3	4218.0
2017-12-22 13:00:00	YM	Futures	26887.2	26905.7	26881.8	26900.3	3370.0
2017-12-22 14:00:00	YM	Futures	26900.3	26919.8	26889.4	26913.3	3935.0
2017-12-22 15:00:00	YM	Futures	26914.4	26929.6	26906.8	26926.4	6909.0

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

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