PREVIEW / futures_1hour / 2016-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-07.parquet
  size:    49 KB
  rows:    1,561

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-09-07 00:00:00	ES	Futures	2369.9	2370.44	2369.63	2370.17	1025.0
2016-09-07 01:00:00	ES	Futures	2369.9	2370.71	2369.9	2370.71	2845.0
2016-09-07 02:00:00	ES	Futures	2370.44	2370.71	2369.36	2369.63	8155.0
2016-09-07 03:00:00	ES	Futures	2369.9	2370.71	2367.73	2369.9	29998.0
2016-09-07 04:00:00	ES	Futures	2370.17	2371.53	2368.81	2369.36	18999.0
2016-09-07 05:00:00	ES	Futures	2369.36	2370.71	2368.27	2368.27	15739.0
2016-09-07 06:00:00	ES	Futures	2368.27	2369.36	2368.0	2368.27	10795.0
2016-09-07 07:00:00	ES	Futures	2368.27	2368.27	2366.92	2367.19	13843.0
2016-09-07 08:00:00	ES	Futures	2367.46	2368.54	2366.1	2368.27	34751.0
2016-09-07 09:00:00	ES	Futures	2368.54	2370.71	2366.37	2369.08	135921.0
2016-09-07 10:00:00	ES	Futures	2369.08	2372.07	2366.1	2367.46	274155.0
2016-09-07 11:00:00	ES	Futures	2367.19	2368.27	2364.2	2366.37	186676.0
2016-09-07 12:00:00	ES	Futures	2366.1	2366.92	2362.03	2364.2	141638.0
2016-09-07 13:00:00	ES	Futures	2364.47	2367.46	2363.66	2366.37	92124.0
2016-09-07 14:00:00	ES	Futures	2366.37	2369.36	2365.83	2368.27	103701.0
2016-09-07 15:00:00	ES	Futures	2368.27	2370.44	2368.0	2370.44	163741.0
2016-09-07 16:00:00	ES	Futures	2370.17	2370.71	2369.08	2369.9	64713.0
2016-09-07 18:00:00	ES	Futures	2369.63	2369.9	2368.81	2368.81	3045.0
2016-09-07 19:00:00	ES	Futures	2368.81	2369.36	2368.54	2369.08	1486.0
2016-09-07 20:00:00	ES	Futures	2369.36	2369.9	2369.08	2369.36	3818.0
2016-09-07 21:00:00	ES	Futures	2369.36	2369.63	2368.81	2369.36	2595.0
2016-09-07 22:00:00	ES	Futures	2369.36	2370.17	2369.08	2370.17	2317.0
2016-09-07 23:00:00	ES	Futures	2370.17	2370.17	2369.63	2369.9	1221.0
2016-09-07 00:00:00	NQ	Futures	5757.76	5759.25	5757.16	5758.06	407.0
2016-09-07 01:00:00	NQ	Futures	5758.36	5761.34	5757.76	5760.14	723.0
2016-09-07 02:00:00	NQ	Futures	5759.85	5761.34	5757.16	5758.36	1153.0
2016-09-07 03:00:00	NQ	Futures	5758.06	5762.83	5754.78	5762.23	4410.0
2016-09-07 04:00:00	NQ	Futures	5762.53	5767.6	5759.55	5763.42	3506.0
2016-09-07 05:00:00	NQ	Futures	5762.83	5766.4	5760.14	5761.04	2595.0
2016-09-07 06:00:00	NQ	Futures	5761.34	5764.32	5761.04	5761.63	1471.0
2016-09-07 07:00:00	NQ	Futures	5761.04	5761.63	5758.95	5759.55	1181.0
2016-09-07 08:00:00	NQ	Futures	5759.55	5761.93	5757.46	5761.63	3870.0
2016-09-07 09:00:00	NQ	Futures	5761.63	5767.89	5756.27	5761.34	28994.0
2016-09-07 10:00:00	NQ	Futures	5761.34	5769.68	5753.59	5755.97	36165.0
2016-09-07 11:00:00	NQ	Futures	5756.27	5759.25	5748.52	5753.29	22575.0
2016-09-07 12:00:00	NQ	Futures	5752.99	5753.89	5737.49	5744.05	18898.0
2016-09-07 13:00:00	NQ	Futures	5744.05	5750.01	5742.26	5747.63	12153.0
2016-09-07 14:00:00	NQ	Futures	5747.92	5753.29	5743.75	5749.12	15017.0
2016-09-07 15:00:00	NQ	Futures	5749.41	5759.85	5748.52	5759.55	17218.0
2016-09-07 16:00:00	NQ	Futures	5759.55	5759.85	5755.38	5756.57	5352.0
2016-09-07 18:00:00	NQ	Futures	5755.67	5757.76	5754.48	5754.78	388.0
2016-09-07 19:00:00	NQ	Futures	5754.78	5755.38	5753.59	5755.08	180.0
2016-09-07 20:00:00	NQ	Futures	5755.38	5755.67	5753.89	5754.78	489.0
2016-09-07 21:00:00	NQ	Futures	5754.78	5756.27	5753.59	5755.67	376.0
2016-09-07 22:00:00	NQ	Futures	5755.38	5757.16	5754.78	5756.87	266.0
2016-09-07 23:00:00	NQ	Futures	5756.87	5757.46	5756.27	5756.87	188.0
2016-09-07 00:00:00	YM	Futures	19934.5	19936.7	19933.5	19934.5	277.0
2016-09-07 01:00:00	YM	Futures	19936.7	19941.0	19934.5	19937.8	296.0
2016-09-07 02:00:00	YM	Futures	19937.8	19941.0	19929.2	19932.4	1156.0
2016-09-07 03:00:00	YM	Futures	19931.3	19946.4	19915.2	19938.9	3877.0

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

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