PREVIEW / futures_1hour / 2016-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-13.parquet
  size:    53 KB
  rows:    1,621

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-10-13 00:00:00	ES	Futures	2306.14	2306.96	2304.51	2306.96	5553.0
2016-10-13 01:00:00	ES	Futures	2306.96	2306.96	2303.15	2304.78	7736.0
2016-10-13 02:00:00	ES	Futures	2304.51	2307.77	2303.42	2305.6	14019.0
2016-10-13 03:00:00	ES	Futures	2305.6	2306.69	2300.16	2300.97	42778.0
2016-10-13 04:00:00	ES	Futures	2301.24	2306.41	2301.24	2306.14	23361.0
2016-10-13 05:00:00	ES	Futures	2305.87	2308.86	2305.6	2306.41	20638.0
2016-10-13 06:00:00	ES	Futures	2306.69	2307.77	2305.05	2306.96	15130.0
2016-10-13 07:00:00	ES	Futures	2307.23	2308.05	2304.78	2307.77	20056.0
2016-10-13 08:00:00	ES	Futures	2307.77	2308.32	2301.52	2303.96	59340.0
2016-10-13 09:00:00	ES	Futures	2303.69	2307.23	2294.71	2296.62	361880.0
2016-10-13 10:00:00	ES	Futures	2296.89	2303.69	2293.9	2301.79	376124.0
2016-10-13 11:00:00	ES	Futures	2301.52	2307.77	2296.89	2305.33	269226.0
2016-10-13 12:00:00	ES	Futures	2305.33	2312.67	2303.42	2311.31	175531.0
2016-10-13 13:00:00	ES	Futures	2311.31	2316.21	2307.77	2315.94	140835.0
2016-10-13 14:00:00	ES	Futures	2316.21	2320.56	2314.03	2319.2	175534.0
2016-10-13 15:00:00	ES	Futures	2319.2	2320.29	2311.31	2314.03	283209.0
2016-10-13 16:00:00	ES	Futures	2314.03	2315.39	2313.22	2313.76	100064.0
2016-10-13 18:00:00	ES	Futures	2314.03	2314.03	2311.86	2313.49	4398.0
2016-10-13 19:00:00	ES	Futures	2313.76	2314.3	2312.67	2312.67	3281.0
2016-10-13 20:00:00	ES	Futures	2312.94	2314.03	2309.68	2311.04	8272.0
2016-10-13 21:00:00	ES	Futures	2311.04	2316.75	2310.77	2315.12	11235.0
2016-10-13 22:00:00	ES	Futures	2315.39	2315.39	2311.04	2314.58	7328.0
2016-10-13 23:00:00	ES	Futures	2314.58	2315.66	2313.22	2315.12	4466.0
2016-10-13 00:00:00	NQ	Futures	5710.13	5711.32	5706.55	5711.32	922.0
2016-10-13 01:00:00	NQ	Futures	5711.62	5711.92	5703.27	5706.85	1421.0
2016-10-13 02:00:00	NQ	Futures	5705.95	5714.61	5703.57	5710.13	2506.0
2016-10-13 03:00:00	NQ	Futures	5710.13	5711.62	5697.0	5699.99	5272.0
2016-10-13 04:00:00	NQ	Futures	5700.29	5709.83	5699.99	5708.94	3645.0
2016-10-13 05:00:00	NQ	Futures	5708.64	5714.61	5706.85	5708.64	2118.0
2016-10-13 06:00:00	NQ	Futures	5709.24	5711.92	5706.55	5710.73	1553.0
2016-10-13 07:00:00	NQ	Futures	5710.73	5713.41	5706.55	5711.32	2621.0
2016-10-13 08:00:00	NQ	Futures	5711.62	5713.11	5699.69	5704.46	7060.0
2016-10-13 09:00:00	NQ	Futures	5704.76	5711.03	5675.23	5682.09	54660.0
2016-10-13 10:00:00	NQ	Futures	5682.09	5700.29	5673.73	5691.34	60106.0
2016-10-13 11:00:00	NQ	Futures	5691.34	5710.43	5680.89	5707.45	39380.0
2016-10-13 12:00:00	NQ	Futures	5707.15	5723.26	5702.08	5718.78	21686.0
2016-10-13 13:00:00	NQ	Futures	5718.78	5729.52	5709.53	5729.22	18263.0
2016-10-13 14:00:00	NQ	Futures	5729.22	5740.56	5724.45	5738.47	22422.0
2016-10-13 15:00:00	NQ	Futures	5738.77	5741.16	5717.29	5725.05	30955.0
2016-10-13 16:00:00	NQ	Futures	5725.35	5727.43	5721.17	5721.77	6561.0
2016-10-13 18:00:00	NQ	Futures	5723.26	5726.24	5719.98	5724.15	1144.0
2016-10-13 19:00:00	NQ	Futures	5724.45	5726.84	5719.98	5719.98	538.0
2016-10-13 20:00:00	NQ	Futures	5720.27	5724.15	5711.62	5715.5	1687.0
2016-10-13 21:00:00	NQ	Futures	5715.8	5729.82	5715.2	5726.24	1767.0
2016-10-13 22:00:00	NQ	Futures	5726.54	5726.54	5716.69	5724.15	943.0
2016-10-13 23:00:00	NQ	Futures	5724.45	5725.94	5720.57	5724.45	637.0
2016-10-13 00:00:00	YM	Futures	19406.2	19412.7	19394.3	19411.6	1219.0
2016-10-13 01:00:00	YM	Futures	19411.6	19413.7	19379.2	19392.1	1799.0
2016-10-13 02:00:00	YM	Futures	19391.0	19418.1	19381.3	19398.6	2702.0
2016-10-13 03:00:00	YM	Futures	19398.6	19406.2	19359.7	19367.3	5792.0

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

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