PREVIEW / futures_1hour / 2017-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-21.parquet
  size:    51 KB
  rows:    1,634

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-21 00:00:00	ES	Futures	2825.59	2826.41	2824.49	2824.49	3931.0
2017-11-21 01:00:00	ES	Futures	2824.49	2824.77	2823.67	2824.22	5432.0
2017-11-21 02:00:00	ES	Futures	2824.22	2825.31	2823.67	2824.22	7407.0
2017-11-21 03:00:00	ES	Futures	2824.22	2825.31	2822.58	2824.22	21949.0
2017-11-21 04:00:00	ES	Futures	2823.95	2826.68	2823.12	2826.41	18118.0
2017-11-21 05:00:00	ES	Futures	2826.41	2831.61	2826.41	2831.33	33388.0
2017-11-21 06:00:00	ES	Futures	2831.33	2832.7	2830.24	2832.7	15702.0
2017-11-21 07:00:00	ES	Futures	2832.7	2834.89	2832.15	2834.07	33157.0
2017-11-21 08:00:00	ES	Futures	2833.79	2836.53	2833.79	2835.71	32585.0
2017-11-21 09:00:00	ES	Futures	2835.43	2840.91	2833.25	2839.54	163078.0
2017-11-21 10:00:00	ES	Futures	2839.81	2843.64	2838.99	2843.09	168760.0
2017-11-21 11:00:00	ES	Futures	2843.37	2843.92	2841.73	2843.09	87016.0
2017-11-21 12:00:00	ES	Futures	2843.37	2843.92	2842.27	2842.82	68249.0
2017-11-21 13:00:00	ES	Futures	2843.09	2845.56	2842.55	2843.09	73812.0
2017-11-21 14:00:00	ES	Futures	2843.09	2843.92	2842.55	2843.92	65123.0
2017-11-21 15:00:00	ES	Futures	2843.64	2844.19	2841.18	2842.82	188883.0
2017-11-21 16:00:00	ES	Futures	2842.55	2842.82	2840.09	2840.63	98846.0
2017-11-21 18:00:00	ES	Futures	2840.36	2841.73	2839.81	2841.18	4629.0
2017-11-21 19:00:00	ES	Futures	2840.91	2841.18	2838.99	2840.09	8547.0
2017-11-21 20:00:00	ES	Futures	2839.81	2840.91	2838.99	2840.09	6879.0
2017-11-21 21:00:00	ES	Futures	2839.81	2844.19	2839.81	2842.82	9191.0
2017-11-21 22:00:00	ES	Futures	2842.82	2843.37	2841.73	2842.27	3136.0
2017-11-21 23:00:00	ES	Futures	2842.27	2842.55	2840.91	2841.73	3244.0
2017-11-21 00:00:00	NQ	Futures	7520.47	7522.85	7517.2	7517.5	1425.0
2017-11-21 01:00:00	NQ	Futures	7517.5	7517.5	7514.23	7516.31	802.0
2017-11-21 02:00:00	NQ	Futures	7516.31	7518.39	7512.44	7515.42	1531.0
2017-11-21 03:00:00	NQ	Futures	7515.12	7515.42	7509.17	7512.44	2672.0
2017-11-21 04:00:00	NQ	Futures	7512.44	7521.66	7509.77	7520.77	2201.0
2017-11-21 05:00:00	NQ	Futures	7520.77	7536.53	7520.47	7535.64	5629.0
2017-11-21 06:00:00	NQ	Futures	7535.94	7539.8	7532.67	7537.13	2748.0
2017-11-21 07:00:00	NQ	Futures	7536.83	7547.24	7535.64	7545.75	6239.0
2017-11-21 08:00:00	NQ	Futures	7545.75	7552.59	7545.46	7550.81	7133.0
2017-11-21 09:00:00	NQ	Futures	7550.81	7584.12	7543.08	7582.04	46378.0
2017-11-21 10:00:00	NQ	Futures	7582.04	7591.55	7577.28	7589.47	37613.0
2017-11-21 11:00:00	NQ	Futures	7589.47	7595.42	7586.2	7592.74	19824.0
2017-11-21 12:00:00	NQ	Futures	7593.04	7595.12	7586.8	7588.28	15039.0
2017-11-21 13:00:00	NQ	Futures	7588.28	7596.31	7586.8	7591.26	12556.0
2017-11-21 14:00:00	NQ	Futures	7591.55	7593.34	7587.09	7592.74	13407.0
2017-11-21 15:00:00	NQ	Futures	7592.74	7593.34	7585.01	7592.15	26019.0
2017-11-21 16:00:00	NQ	Futures	7592.15	7593.34	7587.39	7589.18	7457.0
2017-11-21 18:00:00	NQ	Futures	7591.55	7594.53	7587.69	7593.93	1330.0
2017-11-21 19:00:00	NQ	Futures	7593.93	7595.12	7588.28	7590.96	1572.0
2017-11-21 20:00:00	NQ	Futures	7590.66	7592.74	7587.99	7589.47	1452.0
2017-11-21 21:00:00	NQ	Futures	7589.47	7599.58	7589.18	7597.5	2048.0
2017-11-21 22:00:00	NQ	Futures	7597.5	7598.69	7595.12	7596.02	714.0
2017-11-21 23:00:00	NQ	Futures	7596.31	7597.21	7592.15	7593.64	805.0
2017-11-21 00:00:00	YM	Futures	25452.9	25461.6	25447.5	25447.5	945.0
2017-11-21 01:00:00	YM	Futures	25447.5	25448.5	25438.8	25442.0	878.0
2017-11-21 02:00:00	YM	Futures	25442.0	25451.8	25430.1	25438.8	2058.0
2017-11-21 03:00:00	YM	Futures	25437.7	25451.8	25425.7	25438.8	3745.0

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

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