PREVIEW / futures_1hour / 2017-12-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	2947.57	2948.12	2947.3	2947.57	2963.0
2017-12-19 01:00:00	ES	Futures	2947.57	2947.57	2946.48	2946.48	3402.0
2017-12-19 02:00:00	ES	Futures	2946.48	2947.57	2946.48	2946.75	2978.0
2017-12-19 03:00:00	ES	Futures	2946.75	2949.76	2946.75	2949.48	12011.0
2017-12-19 04:00:00	ES	Futures	2949.48	2949.76	2948.66	2948.94	5537.0
2017-12-19 05:00:00	ES	Futures	2948.94	2949.21	2947.84	2948.94	6397.0
2017-12-19 06:00:00	ES	Futures	2948.66	2948.66	2947.3	2947.84	6465.0
2017-12-19 07:00:00	ES	Futures	2947.57	2948.94	2947.3	2948.66	7440.0
2017-12-19 08:00:00	ES	Futures	2948.94	2949.76	2948.12	2948.39	15605.0
2017-12-19 09:00:00	ES	Futures	2948.39	2949.21	2941.01	2942.38	135595.0
2017-12-19 10:00:00	ES	Futures	2942.38	2944.29	2938.82	2940.74	154675.0
2017-12-19 11:00:00	ES	Futures	2940.74	2942.38	2937.18	2937.46	135431.0
2017-12-19 12:00:00	ES	Futures	2937.46	2939.37	2936.09	2939.1	91584.0
2017-12-19 13:00:00	ES	Futures	2939.37	2941.01	2938.28	2939.1	60697.0
2017-12-19 14:00:00	ES	Futures	2939.1	2941.28	2935.54	2936.91	79020.0
2017-12-19 15:00:00	ES	Futures	2936.91	2938.55	2933.36	2934.72	161128.0
2017-12-19 16:00:00	ES	Futures	2934.72	2937.46	2932.81	2935.0	66229.0
2017-12-19 18:00:00	ES	Futures	2935.27	2938.82	2934.72	2938.55	6928.0
2017-12-19 19:00:00	ES	Futures	2938.55	2939.92	2938.0	2939.37	6489.0
2017-12-19 20:00:00	ES	Futures	2939.1	2941.83	2939.1	2941.01	9443.0
2017-12-19 21:00:00	ES	Futures	2941.01	2941.28	2939.92	2940.46	3347.0
2017-12-19 22:00:00	ES	Futures	2940.46	2941.83	2940.19	2941.83	4051.0
2017-12-19 23:00:00	ES	Futures	2941.83	2942.38	2940.46	2941.01	5348.0
2017-12-19 00:00:00	NQ	Futures	7758.02	7759.8	7757.72	7758.91	660.0
2017-12-19 01:00:00	NQ	Futures	7758.31	7759.5	7755.64	7756.83	759.0
2017-12-19 02:00:00	NQ	Futures	7757.13	7758.91	7755.64	7757.13	581.0
2017-12-19 03:00:00	NQ	Futures	7757.13	7765.73	7757.13	7763.06	2544.0
2017-12-19 04:00:00	NQ	Futures	7762.76	7764.24	7758.91	7761.87	1360.0
2017-12-19 05:00:00	NQ	Futures	7761.58	7761.87	7756.83	7759.8	1287.0
2017-12-19 06:00:00	NQ	Futures	7759.5	7760.39	7753.86	7754.46	1196.0
2017-12-19 07:00:00	NQ	Futures	7754.46	7756.83	7752.38	7755.35	1479.0
2017-12-19 08:00:00	NQ	Futures	7755.64	7755.64	7744.67	7744.67	5266.0
2017-12-19 09:00:00	NQ	Futures	7744.37	7748.82	7715.9	7720.94	50871.0
2017-12-19 10:00:00	NQ	Futures	7720.94	7732.51	7702.26	7706.71	55311.0
2017-12-19 11:00:00	NQ	Futures	7706.41	7720.65	7693.95	7696.03	35922.0
2017-12-19 12:00:00	NQ	Futures	7696.32	7703.44	7687.43	7703.44	28804.0
2017-12-19 13:00:00	NQ	Futures	7703.44	7715.01	7699.88	7710.86	15754.0
2017-12-19 14:00:00	NQ	Futures	7710.86	7716.79	7697.51	7701.37	16998.0
2017-12-19 15:00:00	NQ	Futures	7701.37	7712.93	7690.99	7708.78	36255.0
2017-12-19 16:00:00	NQ	Futures	7708.78	7716.49	7707.3	7715.6	7916.0
2017-12-19 18:00:00	NQ	Futures	7716.2	7723.91	7713.82	7723.02	1324.0
2017-12-19 19:00:00	NQ	Futures	7722.42	7725.98	7720.35	7723.61	1072.0
2017-12-19 20:00:00	NQ	Futures	7723.91	7732.81	7723.91	7732.51	1972.0
2017-12-19 21:00:00	NQ	Futures	7732.51	7732.51	7730.14	7731.62	882.0
2017-12-19 22:00:00	NQ	Futures	7731.92	7733.99	7731.03	7733.7	758.0
2017-12-19 23:00:00	NQ	Futures	7733.7	7734.58	7729.54	7730.73	1096.0
2017-12-19 00:00:00	YM	Futures	27000.3	27016.6	26998.1	27001.4	1068.0
2017-12-19 01:00:00	YM	Futures	27000.3	27010.1	26992.7	26998.1	1265.0
2017-12-19 02:00:00	YM	Futures	26999.2	27007.9	26998.1	27004.6	654.0
2017-12-19 03:00:00	YM	Futures	27004.6	27040.5	27004.6	27036.1	2159.0

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

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