PREVIEW / futures_1hour / 2017-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-24.parquet
  size:    52 KB
  rows:    1,643

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-24 00:00:00	ES	Futures	2617.8	2617.8	2616.98	2617.53	1240.0
2017-05-24 01:00:00	ES	Futures	2617.53	2618.35	2617.26	2618.35	1795.0
2017-05-24 02:00:00	ES	Futures	2618.08	2618.89	2617.53	2618.62	5641.0
2017-05-24 03:00:00	ES	Futures	2618.62	2621.35	2616.98	2620.81	19774.0
2017-05-24 04:00:00	ES	Futures	2620.81	2621.35	2619.17	2620.53	11560.0
2017-05-24 05:00:00	ES	Futures	2620.81	2621.08	2619.71	2620.53	6824.0
2017-05-24 06:00:00	ES	Futures	2620.53	2621.08	2618.89	2619.17	9460.0
2017-05-24 07:00:00	ES	Futures	2619.17	2619.99	2618.89	2619.71	5962.0
2017-05-24 08:00:00	ES	Futures	2619.99	2621.35	2619.71	2621.08	15527.0
2017-05-24 09:00:00	ES	Futures	2621.08	2622.72	2619.44	2620.53	112511.0
2017-05-24 10:00:00	ES	Futures	2620.81	2622.17	2618.62	2620.26	141812.0
2017-05-24 11:00:00	ES	Futures	2620.26	2621.9	2618.89	2620.26	93548.0
2017-05-24 12:00:00	ES	Futures	2619.99	2621.35	2619.44	2620.53	53112.0
2017-05-24 13:00:00	ES	Futures	2620.81	2621.08	2619.17	2620.53	46233.0
2017-05-24 14:00:00	ES	Futures	2620.53	2624.36	2617.8	2622.45	158009.0
2017-05-24 15:00:00	ES	Futures	2622.45	2626.54	2620.26	2624.9	191916.0
2017-05-24 16:00:00	ES	Futures	2624.9	2626.54	2623.54	2626.0	74104.0
2017-05-24 18:00:00	ES	Futures	2625.45	2626.54	2624.9	2626.0	3499.0
2017-05-24 19:00:00	ES	Futures	2626.0	2626.82	2625.45	2625.72	2251.0
2017-05-24 20:00:00	ES	Futures	2625.72	2626.54	2625.18	2626.27	4875.0
2017-05-24 21:00:00	ES	Futures	2626.0	2634.46	2625.72	2630.64	29120.0
2017-05-24 22:00:00	ES	Futures	2630.64	2633.64	2630.09	2632.55	9823.0
2017-05-24 23:00:00	ES	Futures	2632.55	2633.1	2631.73	2632.01	3447.0
2017-05-24 00:00:00	NQ	Futures	6807.73	6808.33	6805.35	6807.73	401.0
2017-05-24 01:00:00	NQ	Futures	6807.73	6809.22	6807.14	6808.93	399.0
2017-05-24 02:00:00	NQ	Futures	6808.63	6811.61	6808.03	6811.01	1006.0
2017-05-24 03:00:00	NQ	Futures	6810.71	6817.57	6806.84	6816.68	2997.0
2017-05-24 04:00:00	NQ	Futures	6816.68	6818.47	6813.7	6817.27	2157.0
2017-05-24 05:00:00	NQ	Futures	6817.27	6819.36	6815.78	6818.17	1343.0
2017-05-24 06:00:00	NQ	Futures	6818.17	6822.04	6816.68	6817.57	2428.0
2017-05-24 07:00:00	NQ	Futures	6817.57	6819.96	6816.38	6819.66	1520.0
2017-05-24 08:00:00	NQ	Futures	6819.66	6824.43	6818.76	6823.83	4007.0
2017-05-24 09:00:00	NQ	Futures	6823.83	6826.81	6809.82	6812.8	32480.0
2017-05-24 10:00:00	NQ	Futures	6812.21	6818.47	6805.65	6813.7	29565.0
2017-05-24 11:00:00	NQ	Futures	6813.4	6817.57	6806.54	6813.99	20330.0
2017-05-24 12:00:00	NQ	Futures	6813.99	6819.66	6813.4	6818.17	11180.0
2017-05-24 13:00:00	NQ	Futures	6818.17	6820.55	6812.21	6818.76	9905.0
2017-05-24 14:00:00	NQ	Futures	6819.06	6827.71	6811.61	6824.43	26005.0
2017-05-24 15:00:00	NQ	Futures	6824.43	6838.74	6820.55	6834.86	30073.0
2017-05-24 16:00:00	NQ	Futures	6835.16	6837.85	6831.88	6837.55	6015.0
2017-05-24 18:00:00	NQ	Futures	6835.16	6838.74	6834.86	6838.44	863.0
2017-05-24 19:00:00	NQ	Futures	6838.14	6841.12	6838.14	6839.63	723.0
2017-05-24 20:00:00	NQ	Futures	6839.93	6842.91	6839.63	6841.72	1476.0
2017-05-24 21:00:00	NQ	Futures	6841.72	6862.29	6840.83	6854.84	7173.0
2017-05-24 22:00:00	NQ	Futures	6854.84	6861.7	6852.45	6858.12	3132.0
2017-05-24 23:00:00	NQ	Futures	6858.12	6860.21	6858.12	6858.72	863.0
2017-05-24 00:00:00	YM	Futures	22720.5	22720.5	22713.9	22717.2	336.0
2017-05-24 01:00:00	YM	Futures	22718.3	22724.8	22716.1	22722.6	339.0
2017-05-24 02:00:00	YM	Futures	22722.6	22735.7	22720.5	22733.5	1564.0
2017-05-24 03:00:00	YM	Futures	22732.4	22757.4	22717.2	22749.8	3590.0

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

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