PREVIEW / futures_1hour / 2017-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-26.parquet
  size:    39 KB
  rows:    1,220

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-26 00:00:00	ES	Futures	2936.36	2936.64	2935.82	2936.36	755.0
2017-12-26 01:00:00	ES	Futures	2936.36	2936.91	2936.36	2936.64	468.0
2017-12-26 02:00:00	ES	Futures	2936.36	2937.18	2936.36	2937.18	435.0
2017-12-26 03:00:00	ES	Futures	2936.91	2937.46	2936.64	2937.18	819.0
2017-12-26 04:00:00	ES	Futures	2937.18	2937.46	2936.91	2936.91	272.0
2017-12-26 05:00:00	ES	Futures	2936.91	2936.91	2936.36	2936.64	301.0
2017-12-26 06:00:00	ES	Futures	2936.64	2936.64	2935.54	2935.54	1105.0
2017-12-26 07:00:00	ES	Futures	2935.54	2936.09	2934.45	2935.27	3749.0
2017-12-26 08:00:00	ES	Futures	2935.27	2936.91	2933.9	2935.82	5976.0
2017-12-26 09:00:00	ES	Futures	2935.82	2939.1	2934.18	2937.18	71425.0
2017-12-26 10:00:00	ES	Futures	2937.18	2939.1	2935.82	2936.09	42419.0
2017-12-26 11:00:00	ES	Futures	2936.09	2937.73	2935.54	2937.18	29972.0
2017-12-26 12:00:00	ES	Futures	2937.18	2938.0	2936.09	2936.64	24488.0
2017-12-26 13:00:00	ES	Futures	2936.64	2937.73	2935.82	2936.36	26425.0
2017-12-26 14:00:00	ES	Futures	2936.64	2937.73	2935.82	2937.73	22411.0
2017-12-26 15:00:00	ES	Futures	2937.46	2938.28	2934.72	2937.73	79442.0
2017-12-26 16:00:00	ES	Futures	2938.0	2938.55	2936.64	2938.28	35473.0
2017-12-26 18:00:00	ES	Futures	2938.28	2939.1	2938.0	2938.82	2939.0
2017-12-26 19:00:00	ES	Futures	2939.1	2939.64	2938.28	2939.1	2324.0
2017-12-26 20:00:00	ES	Futures	2939.37	2939.92	2938.0	2938.55	4323.0
2017-12-26 21:00:00	ES	Futures	2938.55	2939.37	2938.28	2939.37	1737.0
2017-12-26 22:00:00	ES	Futures	2939.37	2940.46	2939.37	2939.37	2795.0
2017-12-26 23:00:00	ES	Futures	2939.64	2940.74	2939.37	2940.74	2582.0
2017-12-26 00:00:00	NQ	Futures	7684.16	7685.35	7682.98	7684.76	285.0
2017-12-26 01:00:00	NQ	Futures	7684.76	7686.24	7684.46	7684.76	248.0
2017-12-26 02:00:00	NQ	Futures	7685.05	7688.32	7684.46	7686.83	364.0
2017-12-26 03:00:00	NQ	Futures	7687.43	7687.43	7683.27	7685.05	435.0
2017-12-26 04:00:00	NQ	Futures	7685.05	7687.72	7684.46	7685.35	220.0
2017-12-26 05:00:00	NQ	Futures	7685.35	7685.65	7682.38	7682.98	249.0
2017-12-26 06:00:00	NQ	Futures	7682.38	7682.68	7668.74	7669.63	1486.0
2017-12-26 07:00:00	NQ	Futures	7669.93	7670.22	7647.68	7649.76	3961.0
2017-12-26 08:00:00	NQ	Futures	7650.06	7662.22	7647.09	7658.36	3942.0
2017-12-26 09:00:00	NQ	Futures	7658.36	7664.59	7631.07	7643.53	31043.0
2017-12-26 10:00:00	NQ	Futures	7643.53	7660.73	7641.45	7645.9	20550.0
2017-12-26 11:00:00	NQ	Futures	7645.9	7658.06	7642.64	7655.99	13949.0
2017-12-26 12:00:00	NQ	Futures	7656.28	7670.82	7653.91	7666.96	12242.0
2017-12-26 13:00:00	NQ	Futures	7666.96	7668.74	7661.03	7665.48	8601.0
2017-12-26 14:00:00	NQ	Futures	7665.48	7666.96	7661.33	7662.22	7354.0
2017-12-26 15:00:00	NQ	Futures	7662.51	7665.18	7654.21	7664.0	17394.0
2017-12-26 16:00:00	NQ	Futures	7664.0	7665.18	7660.14	7664.89	4323.0
2017-12-26 18:00:00	NQ	Futures	7665.48	7668.44	7664.89	7667.55	612.0
2017-12-26 19:00:00	NQ	Futures	7667.26	7670.52	7666.07	7670.22	621.0
2017-12-26 20:00:00	NQ	Futures	7670.52	7673.78	7665.48	7666.96	1453.0
2017-12-26 21:00:00	NQ	Futures	7666.66	7672.89	7666.66	7672.0	696.0
2017-12-26 22:00:00	NQ	Futures	7672.3	7678.23	7671.41	7672.89	918.0
2017-12-26 23:00:00	NQ	Futures	7672.6	7673.19	7671.11	7672.89	584.0
2017-12-26 00:00:00	YM	Futures	26902.5	26905.7	26894.9	26903.5	285.0
2017-12-26 01:00:00	YM	Futures	26903.5	26906.8	26901.4	26901.4	220.0
2017-12-26 02:00:00	YM	Futures	26901.4	26909.0	26899.2	26903.5	243.0
2017-12-26 03:00:00	YM	Futures	26902.5	26906.8	26898.1	26900.3	330.0

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

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