PREVIEW / futures_1hour / 2017-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-20.parquet
  size:    52 KB
  rows:    1,629

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-20 00:00:00	ES	Futures	2941.28	2941.83	2940.46	2941.28	3840.0
2017-12-20 01:00:00	ES	Futures	2941.56	2942.1	2940.46	2940.74	2386.0
2017-12-20 02:00:00	ES	Futures	2940.74	2943.2	2940.19	2942.92	5903.0
2017-12-20 03:00:00	ES	Futures	2942.65	2943.74	2939.92	2942.92	17647.0
2017-12-20 04:00:00	ES	Futures	2943.2	2944.29	2942.38	2943.2	9154.0
2017-12-20 05:00:00	ES	Futures	2942.92	2944.56	2942.38	2944.02	6806.0
2017-12-20 06:00:00	ES	Futures	2944.02	2944.29	2941.56	2943.47	7385.0
2017-12-20 07:00:00	ES	Futures	2943.47	2944.56	2942.92	2943.74	8792.0
2017-12-20 08:00:00	ES	Futures	2943.74	2944.84	2943.2	2944.29	13491.0
2017-12-20 09:00:00	ES	Futures	2944.02	2947.02	2933.36	2937.73	201710.0
2017-12-20 10:00:00	ES	Futures	2937.46	2939.37	2928.98	2932.81	174739.0
2017-12-20 11:00:00	ES	Futures	2932.81	2936.91	2930.9	2934.18	91122.0
2017-12-20 12:00:00	ES	Futures	2934.45	2936.91	2932.26	2935.27	67768.0
2017-12-20 13:00:00	ES	Futures	2935.27	2939.1	2934.72	2937.18	51037.0
2017-12-20 14:00:00	ES	Futures	2937.18	2938.0	2931.99	2933.9	56724.0
2017-12-20 15:00:00	ES	Futures	2933.9	2936.36	2931.99	2933.08	120243.0
2017-12-20 16:00:00	ES	Futures	2933.08	2934.45	2931.44	2931.72	58124.0
2017-12-20 18:00:00	ES	Futures	2931.72	2933.63	2931.72	2933.36	6130.0
2017-12-20 19:00:00	ES	Futures	2933.36	2934.72	2931.99	2932.81	5578.0
2017-12-20 20:00:00	ES	Futures	2932.81	2934.45	2932.26	2934.18	3650.0
2017-12-20 21:00:00	ES	Futures	2933.9	2934.72	2932.81	2933.36	2946.0
2017-12-20 22:00:00	ES	Futures	2933.63	2934.18	2932.81	2933.36	2480.0
2017-12-20 23:00:00	ES	Futures	2933.36	2933.63	2932.26	2933.36	2465.0
2017-12-20 00:00:00	NQ	Futures	7730.73	7732.51	7728.36	7731.32	898.0
2017-12-20 01:00:00	NQ	Futures	7731.32	7732.51	7728.36	7729.84	530.0
2017-12-20 02:00:00	NQ	Futures	7729.54	7735.18	7727.17	7733.4	1289.0
2017-12-20 03:00:00	NQ	Futures	7733.4	7736.66	7725.98	7733.99	3168.0
2017-12-20 04:00:00	NQ	Futures	7734.29	7740.81	7732.21	7737.55	1979.0
2017-12-20 05:00:00	NQ	Futures	7737.55	7743.19	7736.96	7740.81	1621.0
2017-12-20 06:00:00	NQ	Futures	7741.11	7741.41	7735.18	7738.44	1495.0
2017-12-20 07:00:00	NQ	Futures	7738.74	7744.67	7738.74	7743.48	2419.0
2017-12-20 08:00:00	NQ	Futures	7743.19	7745.86	7742.3	7744.08	2992.0
2017-12-20 09:00:00	NQ	Futures	7743.78	7744.37	7673.49	7688.02	72091.0
2017-12-20 10:00:00	NQ	Futures	7687.72	7694.54	7667.85	7674.97	54726.0
2017-12-20 11:00:00	NQ	Futures	7674.97	7691.28	7672.6	7689.8	29234.0
2017-12-20 12:00:00	NQ	Futures	7690.1	7703.44	7688.91	7697.51	24136.0
2017-12-20 13:00:00	NQ	Futures	7697.81	7714.12	7696.03	7708.19	15333.0
2017-12-20 14:00:00	NQ	Futures	7708.19	7711.15	7692.77	7698.7	16121.0
2017-12-20 15:00:00	NQ	Futures	7698.7	7707.0	7693.36	7700.18	23812.0
2017-12-20 16:00:00	NQ	Futures	7699.88	7703.74	7692.47	7693.36	6677.0
2017-12-20 18:00:00	NQ	Futures	7695.73	7699.29	7682.98	7693.65	2136.0
2017-12-20 19:00:00	NQ	Futures	7693.36	7698.99	7688.91	7693.36	1388.0
2017-12-20 20:00:00	NQ	Futures	7693.36	7704.04	7692.47	7702.26	1465.0
2017-12-20 21:00:00	NQ	Futures	7701.37	7703.74	7694.84	7697.21	1087.0
2017-12-20 22:00:00	NQ	Futures	7697.81	7703.15	7697.21	7698.1	975.0
2017-12-20 23:00:00	NQ	Futures	7698.4	7698.7	7691.58	7695.73	730.0
2017-12-20 00:00:00	YM	Futures	26980.7	26989.4	26974.2	26986.1	766.0
2017-12-20 01:00:00	YM	Futures	26986.1	26989.4	26981.8	26981.8	367.0
2017-12-20 02:00:00	YM	Futures	26980.7	27007.9	26975.3	27004.6	1625.0
2017-12-20 03:00:00	YM	Futures	27003.5	27024.2	26999.2	27020.9	3266.0

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

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