PREVIEW / futures_1hour / 2016-12-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	2397.29	2397.56	2396.74	2397.29	2240.0
2016-12-06 01:00:00	ES	Futures	2397.29	2398.92	2397.29	2398.92	3276.0
2016-12-06 02:00:00	ES	Futures	2398.92	2398.92	2397.02	2397.02	4476.0
2016-12-06 03:00:00	ES	Futures	2397.29	2398.1	2394.57	2398.1	22332.0
2016-12-06 04:00:00	ES	Futures	2398.1	2400.01	2397.29	2399.74	13916.0
2016-12-06 05:00:00	ES	Futures	2399.74	2401.37	2398.38	2398.92	13578.0
2016-12-06 06:00:00	ES	Futures	2398.65	2400.83	2398.38	2400.01	11752.0
2016-12-06 07:00:00	ES	Futures	2400.28	2401.91	2398.65	2401.64	12717.0
2016-12-06 08:00:00	ES	Futures	2401.64	2404.09	2400.55	2402.46	28958.0
2016-12-06 09:00:00	ES	Futures	2402.73	2403.55	2395.66	2396.47	209030.0
2016-12-06 10:00:00	ES	Futures	2396.74	2400.28	2395.11	2399.19	264706.0
2016-12-06 11:00:00	ES	Futures	2399.19	2400.01	2397.02	2399.74	153158.0
2016-12-06 12:00:00	ES	Futures	2400.01	2403.55	2399.19	2402.46	140053.0
2016-12-06 13:00:00	ES	Futures	2402.46	2403.82	2400.83	2403.27	98036.0
2016-12-06 14:00:00	ES	Futures	2403.27	2405.18	2402.46	2405.18	83383.0
2016-12-06 15:00:00	ES	Futures	2404.91	2407.35	2402.19	2406.54	239472.0
2016-12-06 16:00:00	ES	Futures	2406.54	2407.08	2404.63	2406.81	84149.0
2016-12-06 18:00:00	ES	Futures	2406.54	2406.81	2405.45	2405.99	4487.0
2016-12-06 19:00:00	ES	Futures	2405.99	2406.81	2404.91	2406.54	5173.0
2016-12-06 20:00:00	ES	Futures	2406.54	2406.81	2404.36	2404.63	4688.0
2016-12-06 21:00:00	ES	Futures	2404.36	2404.63	2403.55	2404.09	3418.0
2016-12-06 22:00:00	ES	Futures	2404.09	2405.45	2403.82	2404.91	2657.0
2016-12-06 23:00:00	ES	Futures	2404.91	2405.45	2404.63	2405.45	2196.0
2016-12-06 00:00:00	NQ	Futures	5702.37	5704.76	5702.08	5704.76	356.0
2016-12-06 01:00:00	NQ	Futures	5704.46	5705.95	5703.87	5705.36	472.0
2016-12-06 02:00:00	NQ	Futures	5705.36	5706.55	5702.67	5702.97	432.0
2016-12-06 03:00:00	NQ	Futures	5702.97	5708.64	5695.51	5707.74	2188.0
2016-12-06 04:00:00	NQ	Futures	5708.04	5711.03	5704.76	5710.73	1186.0
2016-12-06 05:00:00	NQ	Futures	5711.03	5714.31	5706.25	5706.85	1357.0
2016-12-06 06:00:00	NQ	Futures	5706.85	5712.52	5705.95	5709.24	1164.0
2016-12-06 07:00:00	NQ	Futures	5709.53	5716.4	5705.66	5715.2	1750.0
2016-12-06 08:00:00	NQ	Futures	5714.9	5719.38	5713.11	5715.5	3897.0
2016-12-06 09:00:00	NQ	Futures	5715.5	5718.19	5690.14	5714.9	33534.0
2016-12-06 10:00:00	NQ	Futures	5714.31	5723.85	5696.41	5707.45	37300.0
2016-12-06 11:00:00	NQ	Futures	5707.15	5709.53	5689.55	5699.09	20901.0
2016-12-06 12:00:00	NQ	Futures	5699.09	5706.55	5694.62	5696.11	13959.0
2016-12-06 13:00:00	NQ	Futures	5696.11	5706.25	5694.62	5704.16	9756.0
2016-12-06 14:00:00	NQ	Futures	5704.46	5712.52	5702.08	5711.32	10479.0
2016-12-06 15:00:00	NQ	Futures	5711.62	5714.61	5701.18	5713.41	23716.0
2016-12-06 16:00:00	NQ	Futures	5713.11	5716.69	5709.53	5715.5	4701.0
2016-12-06 18:00:00	NQ	Futures	5714.61	5716.4	5713.11	5714.61	445.0
2016-12-06 19:00:00	NQ	Futures	5714.61	5716.69	5711.62	5716.69	833.0
2016-12-06 20:00:00	NQ	Futures	5716.69	5717.29	5710.13	5711.03	597.0
2016-12-06 21:00:00	NQ	Futures	5710.73	5711.03	5707.45	5708.94	313.0
2016-12-06 22:00:00	NQ	Futures	5708.94	5714.01	5708.94	5711.03	356.0
2016-12-06 23:00:00	NQ	Futures	5711.03	5712.82	5710.43	5712.22	225.0
2016-12-06 00:00:00	YM	Futures	20746.3	20750.6	20743.1	20750.6	508.0
2016-12-06 01:00:00	YM	Futures	20748.5	20758.2	20748.5	20758.2	584.0
2016-12-06 02:00:00	YM	Futures	20757.1	20760.4	20749.6	20751.7	1244.0
2016-12-06 03:00:00	YM	Futures	20751.7	20758.2	20733.4	20756.0	3710.0

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

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