PREVIEW / futures_1hour / 2017-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-07.parquet
  size:    51 KB
  rows:    1,626

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-03-07 00:00:00	ES	Futures	2591.03	2591.85	2590.49	2590.76	2248.0
2017-03-07 01:00:00	ES	Futures	2590.76	2591.58	2590.76	2591.3	932.0
2017-03-07 02:00:00	ES	Futures	2591.03	2591.3	2589.67	2589.94	4963.0
2017-03-07 03:00:00	ES	Futures	2589.94	2589.94	2587.76	2589.4	14043.0
2017-03-07 04:00:00	ES	Futures	2589.4	2590.21	2587.49	2588.3	10506.0
2017-03-07 05:00:00	ES	Futures	2588.03	2589.67	2586.94	2587.49	11411.0
2017-03-07 06:00:00	ES	Futures	2587.21	2588.58	2586.67	2587.21	9245.0
2017-03-07 07:00:00	ES	Futures	2587.21	2588.85	2587.21	2587.76	9562.0
2017-03-07 08:00:00	ES	Futures	2587.76	2588.85	2585.85	2588.3	33379.0
2017-03-07 09:00:00	ES	Futures	2588.03	2588.3	2581.76	2584.21	186836.0
2017-03-07 10:00:00	ES	Futures	2584.21	2591.03	2583.67	2587.76	207730.0
2017-03-07 11:00:00	ES	Futures	2588.03	2588.85	2582.58	2585.3	146531.0
2017-03-07 12:00:00	ES	Futures	2585.3	2586.4	2582.85	2586.12	79484.0
2017-03-07 13:00:00	ES	Futures	2586.12	2588.03	2584.21	2584.76	67742.0
2017-03-07 14:00:00	ES	Futures	2584.49	2587.76	2584.21	2587.21	75658.0
2017-03-07 15:00:00	ES	Futures	2586.94	2587.49	2579.85	2582.85	266965.0
2017-03-07 16:00:00	ES	Futures	2582.85	2583.39	2581.49	2581.49	69914.0
2017-03-07 18:00:00	ES	Futures	2581.21	2581.76	2578.48	2579.03	10629.0
2017-03-07 19:00:00	ES	Futures	2579.03	2579.3	2576.3	2578.48	11581.0
2017-03-07 20:00:00	ES	Futures	2578.48	2579.3	2574.39	2576.3	16752.0
2017-03-07 21:00:00	ES	Futures	2576.58	2577.67	2576.3	2577.67	4378.0
2017-03-07 22:00:00	ES	Futures	2577.67	2578.76	2576.3	2576.58	6100.0
2017-03-07 23:00:00	ES	Futures	2576.58	2577.39	2575.21	2576.85	6311.0
2017-03-07 00:00:00	NQ	Futures	6399.56	6401.35	6398.66	6399.26	482.0
2017-03-07 01:00:00	NQ	Futures	6399.26	6401.35	6399.26	6400.15	378.0
2017-03-07 02:00:00	NQ	Futures	6400.15	6400.15	6395.68	6396.87	1424.0
2017-03-07 03:00:00	NQ	Futures	6396.87	6396.87	6390.01	6393.29	2868.0
2017-03-07 04:00:00	NQ	Futures	6393.29	6395.38	6389.12	6390.01	1529.0
2017-03-07 05:00:00	NQ	Futures	6390.31	6392.99	6386.73	6387.03	1930.0
2017-03-07 06:00:00	NQ	Futures	6387.03	6388.82	6385.24	6387.03	1550.0
2017-03-07 07:00:00	NQ	Futures	6387.03	6390.31	6386.73	6387.33	1172.0
2017-03-07 08:00:00	NQ	Futures	6387.33	6389.71	6382.55	6387.03	3394.0
2017-03-07 09:00:00	NQ	Futures	6386.73	6392.4	6376.88	6386.43	29576.0
2017-03-07 10:00:00	NQ	Futures	6386.13	6412.98	6384.64	6406.42	35338.0
2017-03-07 11:00:00	NQ	Futures	6406.42	6407.31	6387.03	6390.31	22515.0
2017-03-07 12:00:00	NQ	Futures	6390.61	6391.5	6381.06	6390.91	14173.0
2017-03-07 13:00:00	NQ	Futures	6390.61	6398.07	6389.41	6390.01	11565.0
2017-03-07 14:00:00	NQ	Futures	6390.01	6396.87	6388.22	6394.78	10360.0
2017-03-07 15:00:00	NQ	Futures	6394.78	6396.57	6373.9	6384.94	28226.0
2017-03-07 16:00:00	NQ	Futures	6384.64	6387.33	6381.96	6384.64	4610.0
2017-03-07 18:00:00	NQ	Futures	6384.04	6384.04	6376.88	6378.08	1269.0
2017-03-07 19:00:00	NQ	Futures	6378.08	6378.97	6371.51	6375.99	1992.0
2017-03-07 20:00:00	NQ	Futures	6375.69	6377.78	6364.65	6370.92	3702.0
2017-03-07 21:00:00	NQ	Futures	6370.92	6375.39	6370.92	6375.09	1207.0
2017-03-07 22:00:00	NQ	Futures	6375.39	6378.38	6372.71	6372.71	1599.0
2017-03-07 23:00:00	NQ	Futures	6372.71	6376.29	6369.72	6375.09	1263.0
2017-03-07 00:00:00	YM	Futures	22736.7	22742.1	22731.3	22732.4	625.0
2017-03-07 01:00:00	YM	Futures	22733.4	22739.9	22733.4	22736.7	395.0
2017-03-07 02:00:00	YM	Futures	22736.7	22736.7	22725.8	22730.2	1317.0
2017-03-07 03:00:00	YM	Futures	22730.2	22730.2	22711.7	22724.8	3162.0

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

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