PREVIEW / futures_1hour / 2016-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-08.parquet
  size:    52 KB
  rows:    1,596

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-08 00:00:00	ES	Futures	2370.17	2370.17	2369.63	2369.9	1906.0
2016-09-08 01:00:00	ES	Futures	2370.17	2371.25	2369.9	2371.25	3135.0
2016-09-08 02:00:00	ES	Futures	2371.25	2372.07	2370.44	2371.25	8189.0
2016-09-08 03:00:00	ES	Futures	2370.98	2374.24	2370.71	2372.88	23855.0
2016-09-08 04:00:00	ES	Futures	2373.15	2374.78	2372.61	2372.88	18199.0
2016-09-08 05:00:00	ES	Futures	2372.88	2373.15	2371.8	2372.07	12275.0
2016-09-08 06:00:00	ES	Futures	2372.07	2372.34	2370.71	2371.25	13650.0
2016-09-08 07:00:00	ES	Futures	2371.25	2371.53	2368.54	2368.81	22840.0
2016-09-08 08:00:00	ES	Futures	2368.81	2371.25	2365.02	2366.64	75903.0
2016-09-08 09:00:00	ES	Futures	2366.37	2366.92	2360.95	2362.03	305899.0
2016-09-08 10:00:00	ES	Futures	2362.3	2367.73	2360.14	2364.75	233422.0
2016-09-08 11:00:00	ES	Futures	2365.02	2369.08	2363.93	2366.37	212253.0
2016-09-08 12:00:00	ES	Futures	2366.64	2367.46	2362.85	2365.02	113332.0
2016-09-08 13:00:00	ES	Futures	2365.02	2365.56	2360.68	2363.66	93294.0
2016-09-08 14:00:00	ES	Futures	2363.93	2366.64	2362.3	2366.1	127492.0
2016-09-08 15:00:00	ES	Futures	2366.37	2366.64	2364.2	2364.47	154405.0
2016-09-08 16:00:00	ES	Futures	2364.47	2365.56	2361.49	2362.58	83607.0
2016-09-08 18:00:00	ES	Futures	2361.76	2362.03	2360.68	2361.76	2227.0
2016-09-08 19:00:00	ES	Futures	2361.76	2362.58	2361.49	2362.58	1002.0
2016-09-08 20:00:00	ES	Futures	2362.3	2362.85	2361.49	2361.49	3363.0
2016-09-08 21:00:00	ES	Futures	2361.76	2362.85	2361.22	2362.03	2315.0
2016-09-08 22:00:00	ES	Futures	2362.03	2362.58	2361.49	2362.3	2089.0
2016-09-08 23:00:00	ES	Futures	2362.3	2362.85	2362.03	2362.85	1446.0
2016-09-08 00:00:00	NQ	Futures	5757.16	5757.46	5755.08	5757.16	280.0
2016-09-08 01:00:00	NQ	Futures	5757.46	5759.85	5756.87	5758.65	622.0
2016-09-08 02:00:00	NQ	Futures	5758.95	5761.34	5757.16	5758.36	1282.0
2016-09-08 03:00:00	NQ	Futures	5758.36	5766.4	5756.87	5763.42	2857.0
2016-09-08 04:00:00	NQ	Futures	5763.42	5766.7	5761.34	5762.53	1840.0
2016-09-08 05:00:00	NQ	Futures	5762.53	5763.13	5759.85	5760.44	910.0
2016-09-08 06:00:00	NQ	Futures	5760.14	5761.34	5757.46	5759.25	1266.0
2016-09-08 07:00:00	NQ	Futures	5759.25	5759.55	5751.8	5752.99	2336.0
2016-09-08 08:00:00	NQ	Futures	5752.99	5758.95	5744.05	5747.63	10553.0
2016-09-08 09:00:00	NQ	Futures	5747.33	5748.82	5720.8	5724.97	42878.0
2016-09-08 10:00:00	NQ	Futures	5725.27	5740.47	5716.93	5732.43	31645.0
2016-09-08 11:00:00	NQ	Futures	5732.72	5741.67	5726.46	5734.51	26141.0
2016-09-08 12:00:00	NQ	Futures	5734.51	5736.3	5723.19	5725.27	14506.0
2016-09-08 13:00:00	NQ	Futures	5724.97	5726.76	5710.07	5720.21	17464.0
2016-09-08 14:00:00	NQ	Futures	5720.21	5729.74	5716.93	5728.85	16627.0
2016-09-08 15:00:00	NQ	Futures	5728.85	5730.34	5723.78	5725.57	15871.0
2016-09-08 16:00:00	NQ	Futures	5725.57	5727.06	5713.95	5719.31	6362.0
2016-09-08 18:00:00	NQ	Futures	5717.82	5719.61	5714.24	5716.63	467.0
2016-09-08 19:00:00	NQ	Futures	5715.73	5718.72	5715.73	5718.42	222.0
2016-09-08 20:00:00	NQ	Futures	5718.12	5719.91	5715.44	5715.73	339.0
2016-09-08 21:00:00	NQ	Futures	5715.73	5719.91	5714.84	5717.82	441.0
2016-09-08 22:00:00	NQ	Futures	5717.82	5719.01	5716.63	5719.01	366.0
2016-09-08 23:00:00	NQ	Futures	5719.01	5719.91	5717.82	5718.42	355.0
2016-09-08 00:00:00	YM	Futures	19924.9	19925.9	19920.6	19924.9	411.0
2016-09-08 01:00:00	YM	Futures	19924.9	19936.7	19924.9	19933.5	679.0
2016-09-08 02:00:00	YM	Futures	19933.5	19941.0	19931.3	19935.6	849.0
2016-09-08 03:00:00	YM	Futures	19934.5	19958.2	19931.3	19950.7	2834.0

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

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