PREVIEW / futures_daily / 2016-10-20

all futures daily files

  file:    by_date/futures_daily/2016/2016-10-20.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-10-20	ES	Futures	2311.91	2319.48	2300.28	2311.37	1611098.0
2016-10-20	NQ	Futures	5690.33	5712.72	5655.56	5708.59	248117.0
2016-10-20	YM	Futures	19034.2	19087.8	18950.2	19014.3	156282.0
2016-10-20	CL	Futures	56.28	56.56	55.04	55.25	548947.0
2016-10-20	GC	Futures	1630.2	1637.0	1623.7	1626.2	137042.0
2016-10-20	ZN	Futures	126.77008	126.937283	126.587677	126.739679	1068248.0
2016-10-20	A6	Futures	0.78693	0.78826	0.77652	0.77703	113793.0
2016-10-20	AD	Futures	0.78103	0.78108	0.77432	0.77489	72164.0
2016-10-20	ALI	Futures	2156.15	2159.99	2156.15	2159.99	5.0
2016-10-20	B	Futures	40.71	40.8	39.6	39.76	279308.0
2016-10-20	B6	Futures	1.2943	1.2959	1.2866	1.2909	87803.0
2016-10-20	BFX	Futures	4271.8	4288.5	4258.7	4286.1	52.0
2016-10-20	BR	Futures	0.21472	0.21623	0.21393	0.21575	25.0
2016-10-20	BZ	Futures	40.5	40.54	39.38	39.54	29822.0
2016-10-20	C	Futures	2387.0	2409.0	2366.0	2386.0	6189.0
2016-10-20	CB	Futures	227.529	229.017	226.568	226.909	34.0
2016-10-20	CC	Futures	2022.0	2032.0	1978.0	2010.0	22135.0
2016-10-20	CNH	Futures	7.2717	7.2827	7.27	7.2729	154.0
2016-10-20	CSC	Futures	3.711	3.711	3.688	3.693	29.0
2016-10-20	CT	Futures	79.66	80.43	77.24	78.2	23216.0
2016-10-20	DC	Futures	29.26	29.26	28.94	29.04	199.0
2016-10-20	DX	Futures	91.104	91.583	90.89	91.503	32380.0
2016-10-20	E1	Futures	1.26375	1.26973	1.25777	1.25814	29933.0
2016-10-20	E6	Futures	1.27498	1.28269	1.26826	1.26947	208172.0
2016-10-20	E7	Futures	1.2681	1.2756	1.2613	1.2626	4997.0
2016-10-20	EBM	Futures	192.11	192.7	191.23	191.23	9186.0
2016-10-20	ED	Futures	95.6538	95.6538	95.6297	95.6345	212021.0
2016-10-20	ER	Futures	98.279	98.288	98.274	98.288	96738.0
2016-10-20	EW	Futures	1627.1	1632.6	1614.3	1622.6	12391.0
2016-10-20	FBON	Futures	124.26	124.4	123.94	124.4	1063.0
2016-10-20	FBTP	Futures	108.38	108.64	108.1	108.59	135562.0
2016-10-20	FBTS	Futures	101.221	101.23	101.158	101.203	22311.0
2016-10-20	FCE	Futures	4029.9	4053.5	4005.0	4040.6	70887.0
2016-10-20	FDAX	Futures	11282.3	11354.2	11185.6	11301.9	88238.0
2016-10-20	FDXM	Futures	11260.6	11329.2	11161.5	11277.5	26688.0
2016-10-20	FESX	Futures	2447.8	2466.2	2431.8	2455.8	1095032.0
2016-10-20	FGBL	Futures	149.45	150.04	149.05	150.0	840423.0
2016-10-20	FGBM	Futures	128.82	128.94	128.62	128.93	558365.0
2016-10-20	FGBS	Futures	111.942	111.947	111.887	111.942	228930.0
2016-10-20	FGBX	Futures	181.0	183.43	179.82	183.37	56513.0
2016-10-20	FMWO	Futures	5695.3	5703.8	5682.0	5684.4	54.0
2016-10-20	FOAT	Futures	137.24	137.78	136.89	137.75	127142.0
2016-10-20	FTDX	Futures	1749.4	1749.4	1737.2	1747.5	100.0
2016-10-20	FTI	Futures	417.11	418.77	414.26	417.71	16143.0
2016-10-20	FTUK	Futures	5901.4	5926.3	5882.8	5900.1	94766.0
2016-10-20	FVSA	Futures	1382.05	1394.42	1348.04	1351.13	33273.0
2016-10-20	FXXP	Futures	283.2	284.1	280.5	283.1	24305.0
2016-10-20	G	Futures	112.96	113.25	112.48	113.13	183319.0
2016-10-20	GF	Futures	246.803	255.823	246.803	255.232	5394.0
2016-10-20	GSCI	Futures	520.5	520.5	518.08	518.08	318.0

> showing 50 of 109 rows — these rows as CSV

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