PREVIEW / futures_1hour / 2017-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-21.parquet
  size:    51 KB
  rows:    1,635

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-21 00:00:00	ES	Futures	2933.08	2933.36	2932.26	2932.54	1999.0
2017-12-21 01:00:00	ES	Futures	2932.81	2933.08	2932.26	2932.54	1256.0
2017-12-21 02:00:00	ES	Futures	2932.54	2934.18	2931.99	2932.81	4993.0
2017-12-21 03:00:00	ES	Futures	2932.81	2933.63	2930.9	2933.08	14264.0
2017-12-21 04:00:00	ES	Futures	2933.08	2933.63	2932.54	2933.36	7874.0
2017-12-21 05:00:00	ES	Futures	2933.63	2935.82	2933.36	2935.54	9779.0
2017-12-21 06:00:00	ES	Futures	2935.27	2938.0	2935.27	2937.73	12700.0
2017-12-21 07:00:00	ES	Futures	2937.73	2938.0	2936.91	2936.91	7455.0
2017-12-21 08:00:00	ES	Futures	2936.91	2940.46	2936.91	2939.64	17332.0
2017-12-21 09:00:00	ES	Futures	2939.37	2941.56	2935.27	2936.36	118810.0
2017-12-21 10:00:00	ES	Futures	2936.36	2944.02	2936.09	2941.83	119000.0
2017-12-21 11:00:00	ES	Futures	2941.83	2945.11	2940.74	2943.47	83371.0
2017-12-21 12:00:00	ES	Futures	2943.47	2945.66	2942.38	2945.38	54096.0
2017-12-21 13:00:00	ES	Futures	2945.38	2947.57	2945.11	2945.93	55421.0
2017-12-21 14:00:00	ES	Futures	2945.66	2945.93	2942.92	2945.11	54786.0
2017-12-21 15:00:00	ES	Futures	2944.84	2945.11	2937.46	2939.1	163280.0
2017-12-21 16:00:00	ES	Futures	2939.37	2940.74	2937.18	2938.0	60460.0
2017-12-21 18:00:00	ES	Futures	2937.46	2941.28	2937.18	2940.19	6485.0
2017-12-21 19:00:00	ES	Futures	2940.19	2940.74	2938.55	2940.46	4531.0
2017-12-21 20:00:00	ES	Futures	2940.74	2941.56	2940.19	2940.46	3501.0
2017-12-21 21:00:00	ES	Futures	2940.46	2941.01	2939.92	2940.46	1470.0
2017-12-21 22:00:00	ES	Futures	2940.46	2941.01	2939.92	2940.74	1036.0
2017-12-21 23:00:00	ES	Futures	2941.01	2942.1	2940.19	2942.1	2606.0
2017-12-21 00:00:00	NQ	Futures	7695.43	7695.73	7690.69	7695.14	735.0
2017-12-21 01:00:00	NQ	Futures	7695.14	7696.92	7692.17	7694.54	447.0
2017-12-21 02:00:00	NQ	Futures	7693.95	7700.77	7691.58	7694.25	1281.0
2017-12-21 03:00:00	NQ	Futures	7694.25	7695.43	7685.35	7692.77	3409.0
2017-12-21 04:00:00	NQ	Futures	7693.36	7696.32	7689.8	7694.25	1594.0
2017-12-21 05:00:00	NQ	Futures	7694.54	7697.21	7692.77	7694.25	2357.0
2017-12-21 06:00:00	NQ	Futures	7694.25	7706.11	7694.25	7703.15	2206.0
2017-12-21 07:00:00	NQ	Futures	7703.44	7709.37	7701.37	7706.41	1942.0
2017-12-21 08:00:00	NQ	Futures	7706.41	7712.64	7703.15	7708.78	3478.0
2017-12-21 09:00:00	NQ	Futures	7708.48	7720.65	7690.1	7696.32	44681.0
2017-12-21 10:00:00	NQ	Futures	7696.62	7716.2	7692.77	7702.26	39854.0
2017-12-21 11:00:00	NQ	Futures	7702.55	7727.47	7701.37	7720.05	25177.0
2017-12-21 12:00:00	NQ	Futures	7720.05	7729.25	7715.9	7728.06	12576.0
2017-12-21 13:00:00	NQ	Futures	7728.06	7736.07	7727.17	7728.65	12213.0
2017-12-21 14:00:00	NQ	Futures	7728.65	7728.95	7712.93	7717.68	15210.0
2017-12-21 15:00:00	NQ	Futures	7717.68	7720.65	7696.92	7703.74	26241.0
2017-12-21 16:00:00	NQ	Futures	7703.74	7707.3	7698.1	7698.7	5939.0
2017-12-21 18:00:00	NQ	Futures	7699.29	7709.37	7698.7	7706.11	1042.0
2017-12-21 19:00:00	NQ	Futures	7705.82	7707.59	7701.37	7707.3	874.0
2017-12-21 20:00:00	NQ	Futures	7707.3	7710.86	7705.52	7706.41	792.0
2017-12-21 21:00:00	NQ	Futures	7706.41	7709.97	7705.82	7706.11	533.0
2017-12-21 22:00:00	NQ	Futures	7706.41	7707.0	7703.74	7706.11	530.0
2017-12-21 23:00:00	NQ	Futures	7706.11	7710.56	7705.52	7709.67	553.0
2017-12-21 00:00:00	YM	Futures	26892.7	26901.4	26889.4	26900.3	728.0
2017-12-21 01:00:00	YM	Futures	26901.4	26901.4	26891.6	26892.7	424.0
2017-12-21 02:00:00	YM	Futures	26892.7	26907.9	26886.2	26889.4	1102.0
2017-12-21 03:00:00	YM	Futures	26888.3	26890.5	26861.2	26877.5	2744.0

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

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