PREVIEW / futures_1hour / 2016-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-07.parquet
  size:    53 KB
  rows:    1,603

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
2016-12-07 00:00:00	ES	Futures	2405.18	2406.54	2404.91	2406.27	2057.0
2016-12-07 01:00:00	ES	Futures	2406.27	2407.35	2405.99	2407.08	2938.0
2016-12-07 02:00:00	ES	Futures	2407.08	2408.44	2405.72	2407.9	9854.0
2016-12-07 03:00:00	ES	Futures	2407.9	2408.17	2404.91	2406.81	23358.0
2016-12-07 04:00:00	ES	Futures	2406.81	2408.17	2405.72	2406.27	13487.0
2016-12-07 05:00:00	ES	Futures	2406.54	2407.35	2405.99	2405.99	8242.0
2016-12-07 06:00:00	ES	Futures	2405.99	2406.81	2405.45	2405.99	7789.0
2016-12-07 07:00:00	ES	Futures	2405.99	2406.27	2404.09	2404.91	11679.0
2016-12-07 08:00:00	ES	Futures	2404.91	2404.91	2401.64	2404.09	34684.0
2016-12-07 09:00:00	ES	Futures	2404.09	2405.72	2402.73	2403.27	155672.0
2016-12-07 10:00:00	ES	Futures	2403.27	2409.26	2403.0	2408.72	235684.0
2016-12-07 11:00:00	ES	Futures	2408.72	2413.34	2407.35	2413.07	185555.0
2016-12-07 12:00:00	ES	Futures	2413.07	2418.24	2411.98	2417.97	164205.0
2016-12-07 13:00:00	ES	Futures	2418.24	2431.57	2417.69	2430.75	417684.0
2016-12-07 14:00:00	ES	Futures	2430.75	2432.93	2428.31	2431.84	255785.0
2016-12-07 15:00:00	ES	Futures	2431.57	2439.19	2429.39	2437.56	417801.0
2016-12-07 16:00:00	ES	Futures	2437.83	2438.1	2432.66	2434.02	135745.0
2016-12-07 18:00:00	ES	Futures	2434.02	2434.83	2432.11	2434.29	10880.0
2016-12-07 19:00:00	ES	Futures	2434.29	2435.92	2434.29	2435.11	6136.0
2016-12-07 20:00:00	ES	Futures	2435.38	2435.38	2434.29	2435.38	4548.0
2016-12-07 21:00:00	ES	Futures	2435.38	2437.28	2434.29	2436.2	5073.0
2016-12-07 22:00:00	ES	Futures	2436.47	2436.47	2434.02	2435.11	3954.0
2016-12-07 23:00:00	ES	Futures	2435.38	2436.47	2434.83	2435.92	2119.0
2016-12-07 00:00:00	NQ	Futures	5711.92	5716.1	5711.92	5715.2	178.0
2016-12-07 01:00:00	NQ	Futures	5715.2	5718.78	5715.2	5717.89	312.0
2016-12-07 02:00:00	NQ	Futures	5718.48	5722.36	5715.5	5721.47	1183.0
2016-12-07 03:00:00	NQ	Futures	5720.87	5721.47	5714.01	5718.48	1585.0
2016-12-07 04:00:00	NQ	Futures	5718.78	5720.87	5714.01	5715.8	1171.0
2016-12-07 05:00:00	NQ	Futures	5716.1	5717.59	5714.01	5714.31	494.0
2016-12-07 06:00:00	NQ	Futures	5714.01	5716.1	5713.11	5713.71	579.0
2016-12-07 07:00:00	NQ	Futures	5714.01	5714.9	5709.83	5710.43	1049.0
2016-12-07 08:00:00	NQ	Futures	5710.73	5710.73	5698.2	5700.29	5017.0
2016-12-07 09:00:00	NQ	Futures	5700.29	5709.53	5684.47	5684.77	31441.0
2016-12-07 10:00:00	NQ	Futures	5684.77	5719.08	5684.47	5713.41	38222.0
2016-12-07 11:00:00	NQ	Futures	5713.71	5719.68	5701.78	5718.78	20026.0
2016-12-07 12:00:00	NQ	Futures	5718.78	5737.58	5715.8	5736.98	17043.0
2016-12-07 13:00:00	NQ	Futures	5736.98	5762.64	5735.79	5760.25	37789.0
2016-12-07 14:00:00	NQ	Futures	5760.25	5781.43	5754.28	5779.64	26173.0
2016-12-07 15:00:00	NQ	Futures	5779.94	5793.37	5772.78	5787.1	34301.0
2016-12-07 16:00:00	NQ	Futures	5787.1	5789.19	5776.36	5782.03	9285.0
2016-12-07 18:00:00	NQ	Futures	5781.13	5782.03	5773.68	5779.94	1223.0
2016-12-07 19:00:00	NQ	Futures	5779.64	5786.5	5779.34	5783.82	722.0
2016-12-07 20:00:00	NQ	Futures	5783.52	5785.01	5780.24	5782.92	531.0
2016-12-07 21:00:00	NQ	Futures	5782.92	5788.89	5781.73	5787.1	580.0
2016-12-07 22:00:00	NQ	Futures	5786.8	5786.8	5782.63	5785.61	870.0
2016-12-07 23:00:00	NQ	Futures	5785.01	5788.29	5784.12	5786.8	364.0
2016-12-07 00:00:00	YM	Futures	20783.1	20793.9	20782.0	20791.7	455.0
2016-12-07 01:00:00	YM	Futures	20791.7	20797.1	20789.6	20797.1	460.0
2016-12-07 02:00:00	YM	Futures	20797.1	20818.7	20790.6	20815.5	2297.0
2016-12-07 03:00:00	YM	Futures	20814.4	20816.6	20795.0	20813.3	3888.0

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

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