PREVIEW / futures_1hour / 2017-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-31.parquet
  size:    53 KB
  rows:    1,666

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-05-31 00:00:00	ES	Futures	2635.01	2635.28	2634.46	2635.01	1091.0
2017-05-31 01:00:00	ES	Futures	2635.01	2635.28	2634.19	2634.46	2053.0
2017-05-31 02:00:00	ES	Futures	2634.19	2636.1	2634.19	2635.83	6503.0
2017-05-31 03:00:00	ES	Futures	2635.83	2636.92	2634.19	2635.28	16396.0
2017-05-31 04:00:00	ES	Futures	2635.28	2636.1	2634.19	2634.74	8888.0
2017-05-31 05:00:00	ES	Futures	2635.01	2635.28	2633.64	2634.74	9544.0
2017-05-31 06:00:00	ES	Futures	2634.46	2637.2	2633.92	2636.38	18097.0
2017-05-31 07:00:00	ES	Futures	2636.65	2639.38	2636.38	2638.29	17929.0
2017-05-31 08:00:00	ES	Futures	2638.29	2640.47	2638.29	2639.38	22759.0
2017-05-31 09:00:00	ES	Futures	2639.38	2639.93	2627.91	2628.73	213920.0
2017-05-31 10:00:00	ES	Futures	2628.73	2633.1	2625.18	2632.83	366555.0
2017-05-31 11:00:00	ES	Futures	2632.55	2633.37	2626.82	2630.09	229613.0
2017-05-31 12:00:00	ES	Futures	2630.09	2632.01	2628.45	2629.0	99410.0
2017-05-31 13:00:00	ES	Futures	2629.0	2632.55	2628.18	2629.0	100294.0
2017-05-31 14:00:00	ES	Futures	2629.0	2631.73	2626.27	2630.09	119743.0
2017-05-31 15:00:00	ES	Futures	2630.09	2635.01	2629.0	2633.37	307780.0
2017-05-31 16:00:00	ES	Futures	2633.64	2638.56	2633.37	2637.74	148212.0
2017-05-31 18:00:00	ES	Futures	2637.2	2637.74	2635.56	2635.83	6357.0
2017-05-31 19:00:00	ES	Futures	2635.83	2636.92	2635.28	2635.56	3259.0
2017-05-31 20:00:00	ES	Futures	2635.56	2637.47	2635.28	2636.92	5804.0
2017-05-31 21:00:00	ES	Futures	2636.92	2638.01	2634.46	2634.74	9834.0
2017-05-31 22:00:00	ES	Futures	2634.74	2636.65	2633.64	2636.38	7558.0
2017-05-31 23:00:00	ES	Futures	2636.38	2636.92	2635.83	2636.38	1796.0
2017-05-31 00:00:00	NQ	Futures	6912.98	6914.47	6912.08	6912.38	373.0
2017-05-31 01:00:00	NQ	Futures	6912.68	6914.47	6910.59	6912.08	541.0
2017-05-31 02:00:00	NQ	Futures	6912.38	6916.55	6912.38	6916.26	894.0
2017-05-31 03:00:00	NQ	Futures	6916.26	6919.24	6911.49	6915.36	2554.0
2017-05-31 04:00:00	NQ	Futures	6915.36	6916.85	6912.38	6914.47	1121.0
2017-05-31 05:00:00	NQ	Futures	6914.17	6916.85	6911.78	6915.36	1211.0
2017-05-31 06:00:00	NQ	Futures	6915.66	6923.41	6913.87	6922.52	3276.0
2017-05-31 07:00:00	NQ	Futures	6922.82	6933.25	6922.52	6930.27	4052.0
2017-05-31 08:00:00	NQ	Futures	6930.27	6939.81	6929.97	6935.93	5729.0
2017-05-31 09:00:00	NQ	Futures	6935.93	6939.81	6888.83	6890.91	46553.0
2017-05-31 10:00:00	NQ	Futures	6891.21	6904.33	6873.62	6902.24	77891.0
2017-05-31 11:00:00	NQ	Futures	6902.24	6907.61	6888.23	6901.05	46966.0
2017-05-31 12:00:00	NQ	Futures	6901.05	6907.01	6890.91	6892.7	21989.0
2017-05-31 13:00:00	NQ	Futures	6892.7	6904.63	6892.7	6896.28	19239.0
2017-05-31 14:00:00	NQ	Futures	6896.28	6898.07	6881.37	6891.51	25082.0
2017-05-31 15:00:00	NQ	Futures	6891.81	6910.29	6890.32	6907.61	40457.0
2017-05-31 16:00:00	NQ	Futures	6907.91	6924.6	6907.91	6922.52	15634.0
2017-05-31 18:00:00	NQ	Futures	6922.52	6922.52	6916.85	6917.15	1600.0
2017-05-31 19:00:00	NQ	Futures	6917.15	6919.24	6917.15	6917.75	887.0
2017-05-31 20:00:00	NQ	Futures	6917.75	6924.01	6917.15	6922.52	2060.0
2017-05-31 21:00:00	NQ	Futures	6922.52	6926.39	6917.45	6917.75	2838.0
2017-05-31 22:00:00	NQ	Futures	6918.05	6923.11	6914.47	6921.92	1646.0
2017-05-31 23:00:00	NQ	Futures	6921.92	6923.71	6920.73	6921.92	630.0
2017-05-31 00:00:00	YM	Futures	22848.7	22850.9	22844.3	22846.5	289.0
2017-05-31 01:00:00	YM	Futures	22846.5	22849.8	22842.2	22845.4	432.0
2017-05-31 02:00:00	YM	Futures	22846.5	22859.6	22846.5	22859.6	1097.0
2017-05-31 03:00:00	YM	Futures	22858.5	22865.0	22831.3	22841.1	3358.0

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

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