PREVIEW / futures_1hour / 2017-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-28.parquet
  size:    50 KB
  rows:    1,639

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-28 00:00:00	ES	Futures	2937.18	2938.28	2936.64	2936.91	2727.0
2017-12-28 01:00:00	ES	Futures	2936.91	2937.73	2936.91	2937.73	1331.0
2017-12-28 02:00:00	ES	Futures	2937.73	2938.55	2937.46	2938.28	2555.0
2017-12-28 03:00:00	ES	Futures	2938.55	2938.55	2937.73	2938.0	6635.0
2017-12-28 04:00:00	ES	Futures	2938.0	2939.1	2937.73	2938.0	7491.0
2017-12-28 05:00:00	ES	Futures	2938.0	2938.82	2937.73	2938.0	4509.0
2017-12-28 06:00:00	ES	Futures	2938.0	2939.37	2938.0	2939.1	4351.0
2017-12-28 07:00:00	ES	Futures	2939.1	2939.37	2938.28	2938.55	5377.0
2017-12-28 08:00:00	ES	Futures	2938.28	2939.37	2937.46	2939.1	12512.0
2017-12-28 09:00:00	ES	Futures	2939.37	2939.92	2934.72	2935.82	83524.0
2017-12-28 10:00:00	ES	Futures	2935.82	2936.36	2933.63	2935.54	78619.0
2017-12-28 11:00:00	ES	Futures	2935.54	2936.36	2933.9	2935.82	59036.0
2017-12-28 12:00:00	ES	Futures	2935.82	2935.82	2934.72	2935.27	26844.0
2017-12-28 13:00:00	ES	Futures	2935.0	2935.54	2933.63	2934.45	28296.0
2017-12-28 14:00:00	ES	Futures	2934.18	2935.54	2933.36	2935.0	30426.0
2017-12-28 15:00:00	ES	Futures	2935.0	2938.28	2934.45	2937.46	106281.0
2017-12-28 16:00:00	ES	Futures	2937.73	2937.73	2935.54	2935.82	41850.0
2017-12-28 18:00:00	ES	Futures	2935.27	2938.28	2935.27	2937.18	6033.0
2017-12-28 19:00:00	ES	Futures	2937.18	2938.55	2936.91	2938.0	2960.0
2017-12-28 20:00:00	ES	Futures	2938.28	2939.1	2937.73	2938.55	2671.0
2017-12-28 21:00:00	ES	Futures	2938.28	2938.55	2937.18	2938.28	2633.0
2017-12-28 22:00:00	ES	Futures	2938.55	2938.82	2938.0	2938.55	1041.0
2017-12-28 23:00:00	ES	Futures	2938.55	2938.82	2938.28	2938.28	1064.0
2017-12-28 00:00:00	NQ	Futures	7663.7	7666.37	7661.62	7663.7	759.0
2017-12-28 01:00:00	NQ	Futures	7663.7	7665.18	7661.92	7662.81	500.0
2017-12-28 02:00:00	NQ	Futures	7663.11	7667.85	7662.22	7666.07	717.0
2017-12-28 03:00:00	NQ	Futures	7666.37	7669.93	7664.29	7668.15	1451.0
2017-12-28 04:00:00	NQ	Futures	7668.15	7673.78	7668.15	7670.52	1403.0
2017-12-28 05:00:00	NQ	Futures	7670.22	7672.3	7669.04	7671.71	781.0
2017-12-28 06:00:00	NQ	Futures	7671.71	7677.64	7671.41	7676.45	1495.0
2017-12-28 07:00:00	NQ	Futures	7676.75	7684.76	7675.86	7678.53	2700.0
2017-12-28 08:00:00	NQ	Futures	7678.53	7678.53	7672.0	7675.86	3209.0
2017-12-28 09:00:00	NQ	Futures	7675.86	7675.86	7658.36	7659.84	24635.0
2017-12-28 10:00:00	NQ	Futures	7659.84	7661.03	7644.42	7651.84	25287.0
2017-12-28 11:00:00	NQ	Futures	7651.84	7660.14	7648.87	7656.28	19020.0
2017-12-28 12:00:00	NQ	Futures	7655.99	7658.36	7653.32	7655.39	7083.0
2017-12-28 13:00:00	NQ	Futures	7655.39	7655.69	7646.79	7649.17	7734.0
2017-12-28 14:00:00	NQ	Futures	7649.17	7649.76	7642.94	7645.61	8460.0
2017-12-28 15:00:00	NQ	Futures	7645.31	7653.61	7644.42	7651.54	16787.0
2017-12-28 16:00:00	NQ	Futures	7651.84	7651.84	7643.83	7645.9	5269.0
2017-12-28 18:00:00	NQ	Futures	7645.61	7652.43	7643.83	7650.35	1208.0
2017-12-28 19:00:00	NQ	Futures	7650.35	7653.61	7649.46	7652.13	600.0
2017-12-28 20:00:00	NQ	Futures	7652.13	7654.8	7649.76	7651.54	737.0
2017-12-28 21:00:00	NQ	Futures	7651.54	7651.84	7646.79	7650.65	546.0
2017-12-28 22:00:00	NQ	Futures	7650.95	7651.84	7648.57	7651.84	412.0
2017-12-28 23:00:00	NQ	Futures	7651.54	7651.84	7648.57	7649.46	447.0
2017-12-28 00:00:00	YM	Futures	26955.7	26984.0	26955.7	26970.9	2406.0
2017-12-28 01:00:00	YM	Futures	26970.9	26973.1	26954.6	26965.5	1018.0
2017-12-28 02:00:00	YM	Futures	26964.4	26976.4	26962.2	26970.9	595.0
2017-12-28 03:00:00	YM	Futures	26972.0	26985.1	26969.8	26974.2	972.0

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

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