PREVIEW / futures_1hour / 2017-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-08.parquet
  size:    44 KB
  rows:    1,345

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-08 00:00:00	ES	Futures	2889.87	2892.34	2889.6	2891.51	4871.0
2017-12-08 01:00:00	ES	Futures	2891.51	2892.34	2890.97	2892.06	2470.0
2017-12-08 02:00:00	ES	Futures	2892.06	2892.88	2891.51	2892.06	4953.0
2017-12-08 03:00:00	ES	Futures	2891.79	2893.98	2891.24	2892.61	7228.0
2017-12-08 04:00:00	ES	Futures	2892.88	2894.8	2891.51	2894.8	5691.0
2017-12-08 05:00:00	ES	Futures	2894.8	2896.16	2893.98	2894.52	9450.0
2017-12-08 06:00:00	ES	Futures	2894.52	2894.8	2892.61	2892.88	4966.0
2017-12-08 07:00:00	ES	Futures	2892.61	2894.52	2892.06	2893.43	8107.0
2017-12-08 08:00:00	ES	Futures	2893.16	2899.17	2892.88	2897.81	30798.0
2017-12-08 09:00:00	ES	Futures	2897.81	2898.35	2894.25	2896.44	70912.0
2017-12-08 10:00:00	ES	Futures	2896.71	2897.81	2893.16	2897.81	50629.0
2017-12-08 11:00:00	ES	Futures	2897.81	2898.9	2893.7	2896.99	38131.0
2017-12-08 12:00:00	ES	Futures	2897.26	2901.91	2896.99	2899.45	35033.0
2017-12-08 13:00:00	ES	Futures	2899.72	2901.91	2898.9	2899.99	23575.0
2017-12-08 14:00:00	ES	Futures	2899.99	2900.27	2895.89	2897.53	26934.0
2017-12-08 15:00:00	ES	Futures	2897.81	2902.18	2896.44	2901.64	83368.0
2017-12-08 16:00:00	ES	Futures	2901.64	2902.46	2899.72	2901.64	42319.0
2017-12-08 00:00:00	NQ	Futures	7535.34	7556.46	7534.75	7552.59	3267.0
2017-12-08 01:00:00	NQ	Futures	7552.59	7565.38	7552.3	7565.38	1596.0
2017-12-08 02:00:00	NQ	Futures	7565.08	7565.38	7554.38	7554.97	1444.0
2017-12-08 03:00:00	NQ	Futures	7554.68	7560.03	7553.19	7556.16	1471.0
2017-12-08 04:00:00	NQ	Futures	7556.46	7560.33	7552.89	7559.73	1209.0
2017-12-08 05:00:00	NQ	Futures	7560.33	7565.98	7557.95	7560.62	1860.0
2017-12-08 06:00:00	NQ	Futures	7559.73	7561.22	7550.51	7550.81	961.0
2017-12-08 07:00:00	NQ	Futures	7551.7	7560.62	7549.92	7559.43	1616.0
2017-12-08 08:00:00	NQ	Futures	7558.54	7575.2	7553.78	7570.44	5640.0
2017-12-08 09:00:00	NQ	Futures	7570.74	7588.88	7568.06	7576.68	19665.0
2017-12-08 10:00:00	NQ	Futures	7576.68	7583.23	7570.14	7576.39	13830.0
2017-12-08 11:00:00	NQ	Futures	7576.68	7580.55	7546.05	7557.05	12584.0
2017-12-08 12:00:00	NQ	Futures	7556.76	7574.01	7554.08	7562.71	7939.0
2017-12-08 13:00:00	NQ	Futures	7563.0	7569.84	7557.35	7562.71	5399.0
2017-12-08 14:00:00	NQ	Futures	7563.0	7563.0	7536.83	7547.54	11312.0
2017-12-08 15:00:00	NQ	Futures	7547.24	7551.4	7537.72	7548.13	14557.0
2017-12-08 16:00:00	NQ	Futures	7548.43	7548.73	7540.4	7546.94	3965.0
2017-12-08 00:00:00	YM	Futures	26380.7	26398.1	26376.3	26389.4	539.0
2017-12-08 01:00:00	YM	Futures	26390.5	26397.0	26378.5	26386.1	454.0
2017-12-08 02:00:00	YM	Futures	26385.0	26391.6	26377.4	26379.6	768.0
2017-12-08 03:00:00	YM	Futures	26379.6	26393.7	26369.8	26377.4	918.0
2017-12-08 04:00:00	YM	Futures	26378.5	26399.2	26368.7	26399.2	900.0
2017-12-08 05:00:00	YM	Futures	26400.3	26427.5	26398.1	26411.1	1686.0
2017-12-08 06:00:00	YM	Futures	26410.1	26412.2	26386.1	26387.2	770.0
2017-12-08 07:00:00	YM	Futures	26388.3	26409.0	26376.3	26388.3	1026.0
2017-12-08 08:00:00	YM	Futures	26385.0	26446.0	26385.0	26435.1	3061.0
2017-12-08 09:00:00	YM	Futures	26434.0	26440.5	26366.6	26397.0	8191.0
2017-12-08 10:00:00	YM	Futures	26397.0	26426.4	26354.6	26424.2	6229.0
2017-12-08 11:00:00	YM	Futures	26424.2	26440.5	26398.1	26419.9	4962.0
2017-12-08 12:00:00	YM	Futures	26419.9	26462.3	26418.8	26425.3	3698.0
2017-12-08 13:00:00	YM	Futures	26425.3	26452.5	26419.9	26438.3	2985.0
2017-12-08 14:00:00	YM	Futures	26439.4	26446.0	26416.6	26430.7	2028.0
2017-12-08 15:00:00	YM	Futures	26431.8	26467.7	26420.9	26466.6	5394.0

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

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