PREVIEW / futures_1hour / 2017-11-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	2813.0	2814.64	2812.18	2812.73	4872.0
2017-11-15 01:00:00	ES	Futures	2812.73	2814.1	2811.09	2811.64	5831.0
2017-11-15 02:00:00	ES	Futures	2811.64	2811.91	2808.9	2809.45	21343.0
2017-11-15 03:00:00	ES	Futures	2809.45	2811.09	2807.26	2808.9	50298.0
2017-11-15 04:00:00	ES	Futures	2808.9	2810.27	2805.62	2808.08	33080.0
2017-11-15 05:00:00	ES	Futures	2808.35	2809.45	2803.43	2805.07	34785.0
2017-11-15 06:00:00	ES	Futures	2805.34	2807.53	2804.8	2806.44	20008.0
2017-11-15 07:00:00	ES	Futures	2806.16	2809.72	2806.16	2809.17	27474.0
2017-11-15 08:00:00	ES	Futures	2809.17	2811.91	2806.44	2808.63	51634.0
2017-11-15 09:00:00	ES	Futures	2808.9	2808.9	2796.32	2799.6	362145.0
2017-11-15 10:00:00	ES	Futures	2799.33	2810.54	2798.5	2810.54	309589.0
2017-11-15 11:00:00	ES	Futures	2810.54	2813.82	2809.45	2811.64	158342.0
2017-11-15 12:00:00	ES	Futures	2811.64	2811.64	2807.81	2810.54	86426.0
2017-11-15 13:00:00	ES	Futures	2810.54	2811.09	2806.98	2807.53	70919.0
2017-11-15 14:00:00	ES	Futures	2807.53	2809.72	2805.89	2809.17	78352.0
2017-11-15 15:00:00	ES	Futures	2809.17	2811.64	2803.16	2805.34	355772.0
2017-11-15 16:00:00	ES	Futures	2805.07	2807.53	2804.52	2805.89	165662.0
2017-11-15 18:00:00	ES	Futures	2805.89	2806.71	2803.7	2805.34	9300.0
2017-11-15 19:00:00	ES	Futures	2805.34	2810.54	2804.8	2808.9	13786.0
2017-11-15 20:00:00	ES	Futures	2808.9	2810.81	2808.35	2810.27	6452.0
2017-11-15 21:00:00	ES	Futures	2810.27	2812.18	2809.99	2811.09	6822.0
2017-11-15 22:00:00	ES	Futures	2811.09	2812.46	2809.72	2811.09	7748.0
2017-11-15 23:00:00	ES	Futures	2811.09	2812.46	2811.09	2811.91	4843.0
2017-11-15 00:00:00	NQ	Futures	7464.26	7469.91	7461.88	7466.04	1292.0
2017-11-15 01:00:00	NQ	Futures	7465.75	7468.13	7460.99	7461.88	1280.0
2017-11-15 02:00:00	NQ	Futures	7461.88	7462.77	7452.36	7452.96	4346.0
2017-11-15 03:00:00	NQ	Futures	7452.96	7457.12	7446.71	7450.28	5324.0
2017-11-15 04:00:00	NQ	Futures	7450.58	7456.53	7442.85	7452.36	5135.0
2017-11-15 05:00:00	NQ	Futures	7452.66	7455.64	7443.44	7446.12	4338.0
2017-11-15 06:00:00	NQ	Futures	7446.42	7452.66	7446.12	7450.88	2359.0
2017-11-15 07:00:00	NQ	Futures	7450.58	7467.23	7450.28	7464.26	5807.0
2017-11-15 08:00:00	NQ	Futures	7463.67	7469.61	7453.55	7462.18	10471.0
2017-11-15 09:00:00	NQ	Futures	7462.18	7462.77	7412.51	7423.22	79055.0
2017-11-15 10:00:00	NQ	Futures	7423.22	7463.37	7420.84	7463.07	75790.0
2017-11-15 11:00:00	NQ	Futures	7463.07	7472.89	7457.72	7466.34	50897.0
2017-11-15 12:00:00	NQ	Futures	7466.34	7466.64	7453.85	7461.88	37343.0
2017-11-15 13:00:00	NQ	Futures	7461.88	7462.48	7448.5	7456.83	21068.0
2017-11-15 14:00:00	NQ	Futures	7457.12	7466.34	7452.66	7464.56	18182.0
2017-11-15 15:00:00	NQ	Futures	7464.56	7470.51	7436.9	7451.47	48101.0
2017-11-15 16:00:00	NQ	Futures	7451.17	7455.64	7448.79	7452.07	11306.0
2017-11-15 18:00:00	NQ	Futures	7452.66	7455.93	7448.2	7451.47	1385.0
2017-11-15 19:00:00	NQ	Futures	7451.47	7470.21	7450.58	7463.07	3366.0
2017-11-15 20:00:00	NQ	Futures	7463.37	7468.42	7462.48	7467.23	1400.0
2017-11-15 21:00:00	NQ	Futures	7467.53	7472.59	7466.04	7471.1	1818.0
2017-11-15 22:00:00	NQ	Futures	7470.8	7477.64	7469.32	7472.89	2410.0
2017-11-15 23:00:00	NQ	Futures	7472.89	7477.35	7471.7	7475.86	1496.0
2017-11-15 00:00:00	YM	Futures	25360.4	25378.9	25355.0	25369.1	1614.0
2017-11-15 01:00:00	YM	Futures	25368.1	25377.8	25352.8	25357.2	1270.0
2017-11-15 02:00:00	YM	Futures	25357.2	25360.4	25334.3	25338.7	2912.0
2017-11-15 03:00:00	YM	Futures	25338.7	25346.3	25314.8	25320.2	4655.0

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

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