PREVIEW / futures_1hour / 2017-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-14.parquet
  size:    53 KB
  rows:    1,635

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-14 00:00:00	ES	Futures	2589.4	2589.94	2589.4	2589.67	1596.0
2017-03-14 01:00:00	ES	Futures	2589.67	2590.21	2588.3	2589.67	4978.0
2017-03-14 02:00:00	ES	Futures	2589.4	2590.21	2588.85	2589.94	2761.0
2017-03-14 03:00:00	ES	Futures	2589.67	2590.49	2589.12	2589.67	4106.0
2017-03-14 04:00:00	ES	Futures	2589.94	2589.94	2585.03	2585.57	21413.0
2017-03-14 05:00:00	ES	Futures	2585.57	2588.85	2585.3	2588.58	14117.0
2017-03-14 06:00:00	ES	Futures	2588.3	2588.85	2586.94	2588.3	8561.0
2017-03-14 07:00:00	ES	Futures	2588.03	2588.58	2585.3	2585.84	13948.0
2017-03-14 08:00:00	ES	Futures	2585.57	2586.12	2580.65	2583.11	53617.0
2017-03-14 09:00:00	ES	Futures	2583.39	2584.48	2578.47	2580.11	165120.0
2017-03-14 10:00:00	ES	Futures	2580.11	2580.11	2572.73	2577.65	263033.0
2017-03-14 11:00:00	ES	Futures	2577.38	2582.02	2574.37	2581.47	220319.0
2017-03-14 12:00:00	ES	Futures	2581.47	2582.02	2575.19	2576.56	136737.0
2017-03-14 13:00:00	ES	Futures	2576.56	2580.65	2576.28	2578.47	89915.0
2017-03-14 14:00:00	ES	Futures	2578.74	2581.2	2577.38	2578.74	83970.0
2017-03-14 15:00:00	ES	Futures	2579.02	2582.02	2578.47	2581.2	152568.0
2017-03-14 16:00:00	ES	Futures	2581.2	2582.84	2580.11	2582.29	55506.0
2017-03-14 18:00:00	ES	Futures	2582.29	2583.66	2582.29	2582.84	4232.0
2017-03-14 19:00:00	ES	Futures	2582.84	2583.11	2582.29	2582.84	2078.0
2017-03-14 20:00:00	ES	Futures	2583.11	2583.66	2582.29	2582.57	4491.0
2017-03-14 21:00:00	ES	Futures	2582.57	2583.11	2581.75	2583.11	3397.0
2017-03-14 22:00:00	ES	Futures	2583.39	2585.57	2582.57	2585.57	6352.0
2017-03-14 23:00:00	ES	Futures	2585.57	2585.84	2585.03	2585.57	1505.0
2017-03-14 00:00:00	NQ	Futures	6436.55	6438.34	6436.55	6437.74	375.0
2017-03-14 01:00:00	NQ	Futures	6437.74	6438.93	6434.76	6437.74	673.0
2017-03-14 02:00:00	NQ	Futures	6437.44	6438.93	6436.55	6438.04	663.0
2017-03-14 03:00:00	NQ	Futures	6438.34	6439.83	6436.55	6437.14	1192.0
2017-03-14 04:00:00	NQ	Futures	6437.44	6437.74	6427.9	6428.8	4018.0
2017-03-14 05:00:00	NQ	Futures	6428.5	6434.76	6428.2	6434.46	2134.0
2017-03-14 06:00:00	NQ	Futures	6434.16	6435.06	6430.88	6432.97	1398.0
2017-03-14 07:00:00	NQ	Futures	6433.27	6433.87	6428.8	6429.69	1788.0
2017-03-14 08:00:00	NQ	Futures	6429.1	6430.29	6418.36	6421.94	7951.0
2017-03-14 09:00:00	NQ	Futures	6421.94	6426.11	6409.42	6415.98	29479.0
2017-03-14 10:00:00	NQ	Futures	6415.98	6415.98	6396.3	6408.52	34698.0
2017-03-14 11:00:00	NQ	Futures	6408.82	6418.36	6401.96	6417.77	26122.0
2017-03-14 12:00:00	NQ	Futures	6417.77	6419.85	6405.54	6410.01	16375.0
2017-03-14 13:00:00	NQ	Futures	6410.01	6420.75	6409.42	6416.87	12990.0
2017-03-14 14:00:00	NQ	Futures	6416.87	6420.45	6412.7	6415.38	10399.0
2017-03-14 15:00:00	NQ	Futures	6415.38	6424.03	6414.78	6421.94	18936.0
2017-03-14 16:00:00	NQ	Futures	6422.24	6425.22	6419.55	6423.13	5319.0
2017-03-14 18:00:00	NQ	Futures	6423.73	6424.03	6421.94	6422.24	533.0
2017-03-14 19:00:00	NQ	Futures	6422.54	6422.83	6421.05	6422.54	314.0
2017-03-14 20:00:00	NQ	Futures	6422.54	6424.92	6421.94	6422.83	1240.0
2017-03-14 21:00:00	NQ	Futures	6422.83	6423.73	6420.45	6423.13	899.0
2017-03-14 22:00:00	NQ	Futures	6423.43	6428.5	6421.64	6428.5	1203.0
2017-03-14 23:00:00	NQ	Futures	6428.2	6429.69	6427.6	6428.8	461.0
2017-03-14 00:00:00	YM	Futures	22634.6	22642.2	22634.6	22640.0	515.0
2017-03-14 01:00:00	YM	Futures	22640.0	22641.1	22612.9	22629.2	4008.0
2017-03-14 02:00:00	YM	Futures	22629.2	22644.4	22622.6	22631.3	1954.0
2017-03-14 03:00:00	YM	Futures	22632.4	22641.1	22631.3	22635.7	839.0

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

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