PREVIEW / futures_1hour / 2017-12-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	2940.46	2940.74	2939.1	2939.37	4024.0
2017-12-27 01:00:00	ES	Futures	2939.64	2939.64	2938.28	2938.55	1315.0
2017-12-27 02:00:00	ES	Futures	2938.28	2939.37	2938.28	2938.55	2835.0
2017-12-27 03:00:00	ES	Futures	2938.55	2941.01	2938.55	2940.46	9270.0
2017-12-27 04:00:00	ES	Futures	2940.46	2940.46	2938.55	2938.82	9418.0
2017-12-27 05:00:00	ES	Futures	2938.82	2941.01	2938.55	2940.46	7444.0
2017-12-27 06:00:00	ES	Futures	2940.19	2941.28	2939.37	2939.92	10497.0
2017-12-27 07:00:00	ES	Futures	2940.19	2940.46	2938.55	2938.55	5926.0
2017-12-27 08:00:00	ES	Futures	2938.82	2941.83	2938.0	2941.83	15785.0
2017-12-27 09:00:00	ES	Futures	2941.83	2941.83	2937.18	2938.55	73917.0
2017-12-27 10:00:00	ES	Futures	2938.55	2941.56	2938.55	2941.28	74090.0
2017-12-27 11:00:00	ES	Futures	2941.28	2942.1	2936.91	2937.46	85697.0
2017-12-27 12:00:00	ES	Futures	2937.18	2937.46	2934.72	2934.72	64299.0
2017-12-27 13:00:00	ES	Futures	2935.0	2935.82	2933.36	2935.27	52357.0
2017-12-27 14:00:00	ES	Futures	2935.27	2935.27	2932.26	2933.63	43207.0
2017-12-27 15:00:00	ES	Futures	2933.9	2935.82	2931.72	2935.27	108491.0
2017-12-27 16:00:00	ES	Futures	2935.54	2936.91	2935.0	2935.82	39798.0
2017-12-27 18:00:00	ES	Futures	2934.45	2936.64	2934.45	2936.36	3881.0
2017-12-27 19:00:00	ES	Futures	2936.36	2936.91	2936.09	2936.64	1590.0
2017-12-27 20:00:00	ES	Futures	2936.64	2936.91	2936.36	2936.64	1631.0
2017-12-27 21:00:00	ES	Futures	2936.91	2938.0	2936.64	2938.0	2411.0
2017-12-27 22:00:00	ES	Futures	2938.0	2938.28	2937.46	2938.0	2477.0
2017-12-27 23:00:00	ES	Futures	2938.0	2938.0	2936.64	2937.18	2750.0
2017-12-27 00:00:00	NQ	Futures	7673.19	7673.19	7669.33	7670.52	744.0
2017-12-27 01:00:00	NQ	Futures	7670.52	7670.82	7666.37	7666.66	551.0
2017-12-27 02:00:00	NQ	Futures	7666.66	7667.85	7663.7	7666.07	971.0
2017-12-27 03:00:00	NQ	Futures	7665.48	7674.38	7665.18	7673.78	1848.0
2017-12-27 04:00:00	NQ	Futures	7673.78	7674.97	7669.93	7671.41	1445.0
2017-12-27 05:00:00	NQ	Futures	7671.11	7676.45	7669.93	7674.97	1159.0
2017-12-27 06:00:00	NQ	Futures	7674.67	7676.75	7666.96	7667.55	1633.0
2017-12-27 07:00:00	NQ	Futures	7667.55	7668.44	7656.28	7659.25	2071.0
2017-12-27 08:00:00	NQ	Futures	7659.55	7674.08	7657.17	7673.49	4146.0
2017-12-27 09:00:00	NQ	Futures	7673.19	7673.78	7655.39	7672.3	27421.0
2017-12-27 10:00:00	NQ	Futures	7672.6	7682.38	7672.3	7677.05	22686.0
2017-12-27 11:00:00	NQ	Futures	7677.05	7680.31	7652.43	7655.1	22191.0
2017-12-27 12:00:00	NQ	Futures	7655.1	7662.81	7650.35	7655.1	13799.0
2017-12-27 13:00:00	NQ	Futures	7655.1	7658.06	7652.43	7657.17	10166.0
2017-12-27 14:00:00	NQ	Futures	7657.17	7657.77	7646.2	7649.46	13249.0
2017-12-27 15:00:00	NQ	Futures	7649.46	7653.61	7642.64	7650.65	20416.0
2017-12-27 16:00:00	NQ	Futures	7650.65	7657.77	7648.87	7654.5	6037.0
2017-12-27 18:00:00	NQ	Futures	7654.8	7659.25	7653.61	7657.17	659.0
2017-12-27 19:00:00	NQ	Futures	7657.47	7659.84	7656.28	7659.55	370.0
2017-12-27 20:00:00	NQ	Futures	7659.55	7662.22	7659.55	7660.73	749.0
2017-12-27 21:00:00	NQ	Futures	7661.03	7666.37	7660.73	7665.78	1039.0
2017-12-27 22:00:00	NQ	Futures	7665.78	7667.85	7665.48	7666.96	815.0
2017-12-27 23:00:00	NQ	Futures	7666.96	7666.96	7663.11	7663.7	694.0
2017-12-27 00:00:00	YM	Futures	26974.2	26977.5	26924.2	26939.4	4828.0
2017-12-27 01:00:00	YM	Futures	26940.5	26941.6	26928.5	26929.6	488.0
2017-12-27 02:00:00	YM	Futures	26928.5	26945.9	26927.5	26935.1	830.0
2017-12-27 03:00:00	YM	Futures	26935.1	26956.8	26934.0	26948.1	1291.0

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

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