PREVIEW / futures_1hour / 2016-09-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	2345.32	2346.14	2344.78	2345.87	1539.0
2016-09-26 01:00:00	ES	Futures	2346.14	2346.14	2343.14	2343.42	4334.0
2016-09-26 02:00:00	ES	Futures	2343.69	2345.05	2343.14	2344.78	7860.0
2016-09-26 03:00:00	ES	Futures	2344.78	2344.78	2333.62	2336.34	51046.0
2016-09-26 04:00:00	ES	Futures	2336.07	2337.43	2333.62	2336.89	34136.0
2016-09-26 05:00:00	ES	Futures	2337.16	2338.25	2334.98	2335.53	14761.0
2016-09-26 06:00:00	ES	Futures	2335.53	2339.06	2335.53	2338.25	14960.0
2016-09-26 07:00:00	ES	Futures	2338.25	2339.61	2337.16	2338.79	14255.0
2016-09-26 08:00:00	ES	Futures	2338.79	2339.88	2336.61	2337.43	27906.0
2016-09-26 09:00:00	ES	Futures	2337.7	2339.06	2330.36	2331.99	213521.0
2016-09-26 10:00:00	ES	Futures	2332.26	2339.34	2330.9	2335.53	232339.0
2016-09-26 11:00:00	ES	Futures	2335.8	2336.34	2329.0	2331.44	177908.0
2016-09-26 12:00:00	ES	Futures	2331.44	2334.71	2330.36	2333.08	96076.0
2016-09-26 13:00:00	ES	Futures	2332.81	2333.08	2326.55	2328.72	131379.0
2016-09-26 14:00:00	ES	Futures	2328.72	2330.9	2326.55	2327.91	113943.0
2016-09-26 15:00:00	ES	Futures	2327.91	2331.44	2325.46	2327.91	324091.0
2016-09-26 16:00:00	ES	Futures	2327.91	2329.81	2327.36	2328.72	97373.0
2016-09-26 18:00:00	ES	Futures	2328.18	2330.63	2327.64	2327.64	4558.0
2016-09-26 19:00:00	ES	Futures	2327.91	2329.27	2327.36	2327.64	2624.0
2016-09-26 20:00:00	ES	Futures	2327.64	2327.64	2321.65	2323.55	14869.0
2016-09-26 21:00:00	ES	Futures	2323.55	2337.43	2323.28	2336.34	33436.0
2016-09-26 22:00:00	ES	Futures	2336.61	2342.6	2336.07	2339.34	32373.0
2016-09-26 23:00:00	ES	Futures	2339.34	2344.23	2339.06	2343.42	12605.0
2016-09-26 00:00:00	NQ	Futures	5783.82	5786.21	5782.33	5785.91	312.0
2016-09-26 01:00:00	NQ	Futures	5785.91	5786.21	5778.75	5780.54	622.0
2016-09-26 02:00:00	NQ	Futures	5780.54	5783.82	5779.34	5782.33	1507.0
2016-09-26 03:00:00	NQ	Futures	5783.22	5783.22	5752.49	5758.46	8656.0
2016-09-26 04:00:00	NQ	Futures	5758.76	5762.04	5750.7	5759.65	5037.0
2016-09-26 05:00:00	NQ	Futures	5759.06	5763.53	5756.07	5756.97	2067.0
2016-09-26 06:00:00	NQ	Futures	5756.97	5765.32	5756.67	5762.64	2793.0
2016-09-26 07:00:00	NQ	Futures	5762.64	5766.22	5760.25	5764.73	2382.0
2016-09-26 08:00:00	NQ	Futures	5764.43	5766.81	5759.65	5760.55	2897.0
2016-09-26 09:00:00	NQ	Futures	5760.85	5763.23	5742.05	5748.02	29962.0
2016-09-26 10:00:00	NQ	Futures	5748.32	5768.31	5743.25	5753.99	31518.0
2016-09-26 11:00:00	NQ	Futures	5753.99	5755.48	5738.47	5745.33	28670.0
2016-09-26 12:00:00	NQ	Futures	5745.63	5755.48	5742.65	5751.3	21436.0
2016-09-26 13:00:00	NQ	Futures	5751.0	5751.9	5736.98	5742.65	14572.0
2016-09-26 14:00:00	NQ	Futures	5742.95	5749.81	5741.75	5744.74	16966.0
2016-09-26 15:00:00	NQ	Futures	5744.74	5752.49	5741.16	5744.74	27091.0
2016-09-26 16:00:00	NQ	Futures	5744.74	5749.81	5742.95	5747.12	6556.0
2016-09-26 18:00:00	NQ	Futures	5744.44	5749.81	5742.65	5742.65	469.0
2016-09-26 19:00:00	NQ	Futures	5743.25	5746.23	5741.46	5742.35	327.0
2016-09-26 20:00:00	NQ	Futures	5742.05	5742.35	5728.93	5734.0	2210.0
2016-09-26 21:00:00	NQ	Futures	5734.0	5766.22	5732.8	5763.23	4623.0
2016-09-26 22:00:00	NQ	Futures	5763.53	5777.55	5762.94	5769.5	4553.0
2016-09-26 23:00:00	NQ	Futures	5769.8	5783.22	5769.2	5780.24	2043.0
2016-09-26 00:00:00	YM	Futures	19633.1	19641.8	19629.9	19640.7	419.0
2016-09-26 01:00:00	YM	Futures	19640.7	19641.8	19614.8	19618.0	801.0
2016-09-26 02:00:00	YM	Futures	19618.0	19629.9	19613.7	19623.4	1231.0
2016-09-26 03:00:00	YM	Futures	19624.5	19624.5	19526.1	19545.6	6969.0

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

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