PREVIEW / futures_1hour / 2017-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-07.parquet
  size:    53 KB
  rows:    1,646

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-11-07 00:00:00	ES	Futures	2836.26	2837.08	2835.16	2836.53	5406.0
2017-11-07 01:00:00	ES	Futures	2836.53	2837.9	2836.26	2837.08	4974.0
2017-11-07 02:00:00	ES	Futures	2836.8	2837.08	2834.61	2836.53	9852.0
2017-11-07 03:00:00	ES	Futures	2836.53	2836.53	2832.7	2833.79	23375.0
2017-11-07 04:00:00	ES	Futures	2833.52	2834.61	2832.15	2833.79	16458.0
2017-11-07 05:00:00	ES	Futures	2833.79	2833.79	2831.33	2832.7	16298.0
2017-11-07 06:00:00	ES	Futures	2832.7	2833.25	2831.61	2832.43	12775.0
2017-11-07 07:00:00	ES	Futures	2832.43	2832.7	2830.51	2831.33	18898.0
2017-11-07 08:00:00	ES	Futures	2831.33	2833.52	2831.06	2832.97	18445.0
2017-11-07 09:00:00	ES	Futures	2832.97	2837.9	2831.88	2835.98	144616.0
2017-11-07 10:00:00	ES	Futures	2836.26	2837.08	2829.14	2831.33	228013.0
2017-11-07 11:00:00	ES	Futures	2831.33	2833.52	2825.31	2825.86	139867.0
2017-11-07 12:00:00	ES	Futures	2826.13	2828.87	2823.95	2828.05	142844.0
2017-11-07 13:00:00	ES	Futures	2827.78	2830.51	2827.5	2828.6	62128.0
2017-11-07 14:00:00	ES	Futures	2828.6	2829.42	2826.41	2826.95	73061.0
2017-11-07 15:00:00	ES	Futures	2826.95	2831.33	2825.86	2831.06	133589.0
2017-11-07 16:00:00	ES	Futures	2830.78	2831.33	2829.14	2829.69	62862.0
2017-11-07 18:00:00	ES	Futures	2827.5	2827.78	2822.85	2823.95	19969.0
2017-11-07 19:00:00	ES	Futures	2823.95	2826.68	2823.12	2825.04	10578.0
2017-11-07 20:00:00	ES	Futures	2825.04	2827.23	2824.49	2826.95	7119.0
2017-11-07 21:00:00	ES	Futures	2826.95	2826.95	2825.86	2826.41	4446.0
2017-11-07 22:00:00	ES	Futures	2826.41	2827.5	2825.59	2826.95	4301.0
2017-11-07 23:00:00	ES	Futures	2826.68	2827.5	2826.13	2827.5	4330.0
2017-11-07 00:00:00	NQ	Futures	7525.23	7527.91	7521.96	7526.42	1105.0
2017-11-07 01:00:00	NQ	Futures	7527.02	7532.37	7526.12	7528.8	1351.0
2017-11-07 02:00:00	NQ	Futures	7528.21	7528.5	7520.77	7524.64	1743.0
2017-11-07 03:00:00	NQ	Futures	7524.34	7524.64	7510.66	7514.52	3075.0
2017-11-07 04:00:00	NQ	Futures	7514.23	7517.2	7504.11	7510.95	2796.0
2017-11-07 05:00:00	NQ	Futures	7510.95	7510.95	7502.03	7510.06	2598.0
2017-11-07 06:00:00	NQ	Futures	7510.06	7512.14	7506.79	7509.17	1770.0
2017-11-07 07:00:00	NQ	Futures	7509.17	7510.06	7501.14	7504.71	3522.0
2017-11-07 08:00:00	NQ	Futures	7504.41	7511.85	7503.52	7508.58	4668.0
2017-11-07 09:00:00	NQ	Futures	7508.58	7526.72	7502.92	7518.09	39113.0
2017-11-07 10:00:00	NQ	Futures	7518.09	7519.88	7498.17	7505.6	67431.0
2017-11-07 11:00:00	NQ	Futures	7505.3	7516.01	7493.11	7495.19	41577.0
2017-11-07 12:00:00	NQ	Futures	7495.19	7513.63	7490.43	7509.47	36038.0
2017-11-07 13:00:00	NQ	Futures	7509.17	7514.82	7507.68	7508.87	15392.0
2017-11-07 14:00:00	NQ	Futures	7508.87	7510.66	7502.33	7506.2	16803.0
2017-11-07 15:00:00	NQ	Futures	7505.9	7516.31	7499.65	7516.01	26610.0
2017-11-07 16:00:00	NQ	Futures	7515.71	7516.9	7510.95	7512.44	6556.0
2017-11-07 18:00:00	NQ	Futures	7507.39	7507.68	7496.68	7500.55	3038.0
2017-11-07 19:00:00	NQ	Futures	7500.84	7507.39	7497.57	7502.63	1686.0
2017-11-07 20:00:00	NQ	Futures	7502.33	7510.95	7501.73	7509.77	1439.0
2017-11-07 21:00:00	NQ	Futures	7509.47	7512.14	7507.68	7510.06	1282.0
2017-11-07 22:00:00	NQ	Futures	7510.06	7515.42	7508.58	7513.93	1125.0
2017-11-07 23:00:00	NQ	Futures	7513.63	7513.63	7510.36	7512.74	698.0
2017-11-07 00:00:00	YM	Futures	25601.9	25612.8	25596.5	25606.3	1427.0
2017-11-07 01:00:00	YM	Futures	25605.2	25622.6	25604.1	25616.1	1587.0
2017-11-07 02:00:00	YM	Futures	25616.1	25617.1	25594.3	25605.2	2244.0
2017-11-07 03:00:00	YM	Futures	25604.1	25604.1	25581.2	25585.6	1979.0

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

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