PREVIEW / futures_1hour / 2016-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-17.parquet
  size:    52 KB
  rows:    1,602

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-17 00:00:00	ES	Futures	2309.13	2309.68	2307.77	2307.77	2323.0
2016-10-17 01:00:00	ES	Futures	2308.05	2309.13	2306.96	2308.05	3780.0
2016-10-17 02:00:00	ES	Futures	2308.05	2309.41	2306.41	2308.59	9707.0
2016-10-17 03:00:00	ES	Futures	2308.59	2312.13	2306.14	2308.86	24482.0
2016-10-17 04:00:00	ES	Futures	2308.86	2309.68	2306.41	2308.32	10736.0
2016-10-17 05:00:00	ES	Futures	2308.32	2308.59	2305.05	2307.77	13018.0
2016-10-17 06:00:00	ES	Futures	2307.77	2310.22	2306.41	2309.95	10501.0
2016-10-17 07:00:00	ES	Futures	2309.95	2314.03	2308.86	2312.13	18113.0
2016-10-17 08:00:00	ES	Futures	2312.13	2314.85	2310.49	2314.03	36373.0
2016-10-17 09:00:00	ES	Futures	2314.03	2318.11	2308.05	2309.68	234315.0
2016-10-17 10:00:00	ES	Futures	2309.41	2317.02	2308.05	2311.86	200390.0
2016-10-17 11:00:00	ES	Futures	2311.86	2314.3	2309.13	2312.94	122614.0
2016-10-17 12:00:00	ES	Futures	2312.94	2313.49	2308.59	2309.95	80789.0
2016-10-17 13:00:00	ES	Futures	2309.68	2311.04	2304.78	2305.6	99128.0
2016-10-17 14:00:00	ES	Futures	2305.33	2310.49	2305.05	2310.22	90407.0
2016-10-17 15:00:00	ES	Futures	2309.95	2310.22	2305.87	2307.5	149670.0
2016-10-17 16:00:00	ES	Futures	2307.23	2311.86	2307.23	2309.13	87498.0
2016-10-17 18:00:00	ES	Futures	2309.95	2310.49	2307.5	2309.68	4433.0
2016-10-17 19:00:00	ES	Futures	2309.68	2312.13	2309.41	2311.86	2735.0
2016-10-17 20:00:00	ES	Futures	2311.86	2315.94	2311.58	2314.85	10604.0
2016-10-17 21:00:00	ES	Futures	2315.12	2317.84	2314.58	2317.3	9918.0
2016-10-17 22:00:00	ES	Futures	2317.3	2317.84	2316.21	2316.75	3227.0
2016-10-17 23:00:00	ES	Futures	2316.48	2317.57	2315.94	2317.02	4877.0
2016-10-17 00:00:00	NQ	Futures	5717.29	5719.08	5713.71	5714.31	502.0
2016-10-17 01:00:00	NQ	Futures	5714.31	5718.48	5712.22	5714.61	1004.0
2016-10-17 02:00:00	NQ	Futures	5714.9	5717.89	5709.53	5714.61	1721.0
2016-10-17 03:00:00	NQ	Futures	5714.9	5722.96	5707.15	5713.41	4176.0
2016-10-17 04:00:00	NQ	Futures	5713.41	5716.99	5708.34	5712.82	1343.0
2016-10-17 05:00:00	NQ	Futures	5712.52	5713.71	5705.66	5711.92	1387.0
2016-10-17 06:00:00	NQ	Futures	5711.62	5716.4	5708.64	5715.8	1250.0
2016-10-17 07:00:00	NQ	Futures	5715.8	5725.05	5713.11	5721.77	2336.0
2016-10-17 08:00:00	NQ	Futures	5721.77	5730.12	5720.57	5728.33	5603.0
2016-10-17 09:00:00	NQ	Futures	5728.63	5734.3	5709.24	5711.62	31793.0
2016-10-17 10:00:00	NQ	Futures	5711.32	5740.56	5710.43	5728.93	30455.0
2016-10-17 11:00:00	NQ	Futures	5729.22	5734.3	5721.47	5729.52	18614.0
2016-10-17 12:00:00	NQ	Futures	5729.82	5732.8	5719.38	5723.56	12805.0
2016-10-17 13:00:00	NQ	Futures	5723.26	5726.84	5711.03	5712.52	17122.0
2016-10-17 14:00:00	NQ	Futures	5712.52	5724.15	5712.22	5722.66	11726.0
2016-10-17 15:00:00	NQ	Futures	5722.96	5723.26	5713.11	5716.99	16537.0
2016-10-17 16:00:00	NQ	Futures	5716.69	5737.28	5716.4	5731.01	11106.0
2016-10-17 18:00:00	NQ	Futures	5730.72	5734.89	5727.73	5732.8	1158.0
2016-10-17 19:00:00	NQ	Futures	5732.51	5737.88	5731.91	5737.58	564.0
2016-10-17 20:00:00	NQ	Futures	5737.28	5745.93	5736.38	5745.04	1707.0
2016-10-17 21:00:00	NQ	Futures	5745.04	5751.3	5743.84	5748.62	1811.0
2016-10-17 22:00:00	NQ	Futures	5748.91	5750.41	5746.23	5748.32	1035.0
2016-10-17 23:00:00	NQ	Futures	5748.02	5749.21	5745.04	5748.32	761.0
2016-10-17 00:00:00	YM	Futures	19475.3	19478.6	19464.5	19464.5	487.0
2016-10-17 01:00:00	YM	Futures	19466.7	19476.4	19459.1	19465.6	1439.0
2016-10-17 02:00:00	YM	Futures	19465.6	19475.3	19452.6	19467.8	1607.0
2016-10-17 03:00:00	YM	Futures	19468.9	19495.9	19448.3	19469.9	4500.0

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

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