PREVIEW / futures_daily / 2016-11-17

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-17.parquet
  size:    9 KB
  rows:    109

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-11-17	ES	Futures	2349.77	2363.83	2348.96	2362.48	1350348.0
2016-11-17	NQ	Futures	5635.23	5694.16	5631.1	5690.62	190166.0
2016-11-17	YM	Futures	19775.5	19820.7	19753.5	19813.3	119808.0
2016-11-17	CL	Futures	49.5	50.84	49.06	49.61	490898.0
2016-11-17	GC	Futures	1571.4	1579.5	1553.1	1561.3	237789.0
2016-11-17	ZN	Futures	123.061219	123.319623	122.407608	122.650812	1606222.0
2016-11-17	A6	Futures	0.76356	0.76479	0.75407	0.75561	114715.0
2016-11-17	AD	Futures	0.7626	0.76459	0.75742	0.75901	65838.0
2016-11-17	ALI	Futures	2316.84	2316.84	2316.84	2316.84	0.0
2016-11-17	B	Futures	35.28	36.17	34.92	35.31	280944.0
2016-11-17	B6	Futures	1.3104	1.3176	1.3069	1.3077	118633.0
2016-11-17	BFX	Futures	4105.0	4125.3	4091.3	4125.3	3.0
2016-11-17	BR	Futures	0.19961	0.20119	0.19883	0.19917	3694.0
2016-11-17	BZ	Futures	35.11	35.99	34.79	35.15	39989.0
2016-11-17	C	Futures	2165.0	2173.0	2117.0	2167.0	5230.0
2016-11-17	CB	Futures	246.686	249.755	246.686	248.639	18.0
2016-11-17	CC	Futures	1839.0	1848.0	1795.0	1842.0	23003.0
2016-11-17	CNH	Futures	7.4089	7.4231	7.4059	7.4231	52.0
2016-11-17	CSC	Futures	3.969	4.02	3.958	4.02	69.0
2016-11-17	CT	Futures	80.95	82.33	79.52	82.21	7992.0
2016-11-17	DC	Futures	31.5	32.11	31.48	31.96	384.0
2016-11-17	DX	Futures	93.337	94.012	93.054	93.953	55291.0
2016-11-17	E1	Futures	1.24568	1.24842	1.23858	1.23883	27357.0
2016-11-17	E6	Futures	1.24171	1.24699	1.23238	1.23325	226961.0
2016-11-17	E7	Futures	1.2351	1.2402	1.2256	1.2266	5574.0
2016-11-17	EBM	Futures	193.0	194.17	192.7	193.88	19149.0
2016-11-17	ED	Futures	95.6104	95.6176	95.6007	95.6031	331880.0
2016-11-17	ER	Futures	98.274	98.279	98.269	98.274	60494.0
2016-11-17	EW	Futures	1696.3	1708.8	1696.3	1706.5	13881.0
2016-11-17	FBON	Futures	120.58	120.67	119.76	119.95	269.0
2016-11-17	FBTP	Futures	103.46	103.69	102.63	102.87	129703.0
2016-11-17	FBTS	Futures	100.709	100.754	100.646	100.664	40303.0
2016-11-17	FCE	Futures	3976.2	4007.6	3953.3	3993.0	61680.0
2016-11-17	FDAX	Futures	11282.9	11342.0	11198.9	11287.1	85176.0
2016-11-17	FDXM	Futures	11257.4	11314.4	11178.4	11262.7	21382.0
2016-11-17	FESX	Futures	2427.0	2444.6	2411.0	2432.6	962288.0
2016-11-17	FGBL	Futures	146.62	146.96	146.41	146.79	796998.0
2016-11-17	FGBM	Futures	127.98	128.07	127.94	128.04	575168.0
2016-11-17	FGBS	Futures	111.862	111.887	111.857	111.882	345608.0
2016-11-17	FGBX	Futures	173.08	174.38	172.3	173.38	51922.0
2016-11-17	FMWO	Futures	5679.6	5705.0	5679.6	5697.7	1108.0
2016-11-17	FOAT	Futures	132.68	133.09	132.22	132.55	158192.0
2016-11-17	FTDX	Futures	1681.3	1699.9	1679.8	1687.7	176.0
2016-11-17	FTI	Futures	409.91	413.14	407.49	411.73	16485.0
2016-11-17	FTUK	Futures	5690.8	5740.2	5686.6	5725.4	94453.0
2016-11-17	FVSA	Futures	1379.31	1379.31	1329.04	1338.46	29541.0
2016-11-17	FXXP	Futures	279.2	282.0	278.3	281.0	30336.0
2016-11-17	G	Futures	110.91	110.97	110.21	110.56	175579.0
2016-11-17	GF	Futures	279.742	282.252	277.623	278.683	5888.0
2016-11-17	GSCI	Futures	492.8	493.07	487.08	487.08	117.0

> showing 50 of 109 rows — these rows as CSV

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