PREVIEW / futures_daily / 2016-09-30

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-30.parquet
  size:    9 KB
  rows:    110

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-09-30	ES	Futures	2320.83	2345.17	2310.02	2336.79	1989690.0
2016-09-30	NQ	Futures	5703.29	5757.8	5670.88	5739.83	248154.0
2016-09-30	YM	Futures	18978.6	19198.0	18889.3	19130.8	166300.0
2016-09-30	CL	Futures	52.66	53.26	51.87	53.19	496515.0
2016-09-30	GC	Futures	1698.2	1708.3	1688.4	1689.9	214117.0
2016-09-30	ZN	Futures	127.925299	128.153303	127.499692	127.560493	1671048.0
2016-09-30	A6	Futures	0.77744	0.78152	0.77295	0.7805	99308.0
2016-09-30	AD	Futures	0.7795	0.78318	0.77663	0.78139	71569.0
2016-09-30	ALI	Futures	2214.73	2215.37	2212.51	2215.37	10.0
2016-09-30	B	Futures	38.51	38.9	37.84	38.84	307875.0
2016-09-30	B6	Futures	1.3667	1.373	1.3638	1.3683	120833.0
2016-09-30	BFX	Futures	4131.8	4218.2	4131.8	4218.2	7.0
2016-09-30	BR	Futures	0.20746	0.20852	0.20712	0.20742	59.0
2016-09-30	BZ	Futures	38.27	38.68	37.64	38.62	27308.0
2016-09-30	C	Futures	2355.0	2377.0	2338.0	2371.0	11546.0
2016-09-30	CB	Futures	244.392	244.392	241.168	241.788	22.0
2016-09-30	CC	Futures	2014.0	2057.0	2003.0	2042.0	23648.0
2016-09-30	CNH	Futures	7.2024	7.2024	7.195	7.195	2.0
2016-09-30	CSC	Futures	3.758	3.767	3.753	3.764	16.0
2016-09-30	CT	Futures	75.68	76.62	75.19	76.27	16304.0
2016-09-30	DC	Futures	29.46	29.7	29.42	29.65	114.0
2016-09-30	DX	Futures	88.856	89.252	88.651	88.777	32731.0
2016-09-30	E1	Futures	1.29552	1.29677	1.24519	1.28954	42530.0
2016-09-30	E6	Futures	1.30454	1.30883	1.29735	1.30727	252917.0
2016-09-30	E7	Futures	1.2977	1.3017	1.2904	1.3002	3431.0
2016-09-30	EBM	Futures	190.06	190.35	187.7	188.88	20849.0
2016-09-30	ED	Futures	95.6586	95.6635	95.649	95.6538	187813.0
2016-09-30	ER	Futures	98.264	98.274	98.254	98.269	104336.0
2016-09-30	EW	Futures	1635.7	1655.1	1627.3	1648.8	23101.0
2016-09-30	FBON	Futures	125.35	125.65	124.96	125.57	916.0
2016-09-30	FBTP	Futures	109.91	110.19	109.45	110.07	90653.0
2016-09-30	FBTS	Futures	101.311	101.329	101.257	101.32	16458.0
2016-09-30	FCE	Futures	3898.6	3965.8	3856.9	3951.6	146568.0
2016-09-30	FDAX	Futures	10821.1	11141.8	10750.8	11109.0	135702.0
2016-09-30	FDXM	Futures	10801.9	11116.2	10729.2	11085.0	54961.0
2016-09-30	FESX	Futures	2353.3	2402.9	2330.1	2398.1	1809294.0
2016-09-30	FEU3	Futures	98.947	98.947	98.947	98.947	5.0
2016-09-30	FGBL	Futures	151.65	151.89	151.15	151.29	899096.0
2016-09-30	FGBM	Futures	129.44	129.47	129.25	129.27	471014.0
2016-09-30	FGBS	Futures	112.017	112.032	111.977	111.982	321327.0
2016-09-30	FGBX	Futures	189.83	191.03	187.97	188.67	56042.0
2016-09-30	FMWO	Futures	5694.1	5775.1	5688.0	5770.3	389.0
2016-09-30	FOAT	Futures	139.04	139.2	138.73	138.84	149910.0
2016-09-30	FTDX	Futures	1734.7	1766.1	1728.3	1764.1	339.0
2016-09-30	FTI	Futures	409.31	416.0	405.59	414.67	44637.0
2016-09-30	FTUK	Futures	5765.9	5811.5	5715.3	5788.7	148479.0
2016-09-30	FVSA	Futures	1633.74	1701.67	1519.35	1530.07	25208.0
2016-09-30	FXXP	Futures	278.4	282.7	276.7	282.2	40234.0
2016-09-30	G	Futures	116.93	117.03	115.98	116.17	240533.0
2016-09-30	GF	Futures	262.408	263.543	253.744	254.053	4425.0

> showing 50 of 110 rows — these rows as CSV

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