PREVIEW / futures_daily / 2017-11-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-16.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
2017-11-16	ES	Futures	2789.12	2816.58	2786.94	2811.69	1528865.0
2017-11-16	NQ	Futures	7358.35	7468.77	7353.95	7448.21	339694.0
2017-11-16	YM	Futures	24562.4	24777.9	24545.5	24735.6	136359.0
2017-11-16	CL	Futures	55.57	55.89	55.2	55.41	438927.0
2017-11-16	GC	Futures	1626.1	1631.0	1622.2	1626.4	274425.0
2017-11-16	ZN	Futures	123.362719	123.362719	123.008406	123.100835	1145954.0
2017-11-16	A6	Futures	0.78022	0.78269	0.77848	0.78043	78813.0
2017-11-16	AD	Futures	0.79697	0.79962	0.79621	0.79814	56442.0
2017-11-16	B	Futures	43.77	43.96	43.32	43.4	314062.0
2017-11-16	B6	Futures	1.3743	1.3783	1.3705	1.3756	118460.0
2017-11-16	BFX	Futures	4729.0	4752.3	4725.5	4752.3	23.0
2017-11-16	BR	Futures	0.22766	0.23034	0.22747	0.22962	4387.0
2017-11-16	BZ	Futures	43.37	43.57	42.94	43.02	28684.0
2017-11-16	C	Futures	1551.0	1559.0	1546.0	1553.0	3900.0
2017-11-16	CB	Futures	286.998	286.998	284.888	284.888	49.0
2017-11-16	CC	Futures	1591.0	1606.0	1591.0	1597.0	12676.0
2017-11-16	CNH	Futures	6.8198	6.8228	6.814	6.814	10.0
2017-11-16	CSC	Futures	3.439	3.439	3.387	3.396	53.0
2017-11-16	CT	Futures	80.95	81.63	80.8	81.29	11003.0
2017-11-16	DC	Futures	27.78	27.87	27.32	27.36	474.0
2017-11-16	DX	Futures	87.704	87.826	87.615	87.768	12190.0
2017-11-16	E1	Futures	1.238	1.23934	1.23164	1.23274	20427.0
2017-11-16	E6	Futures	1.34665	1.34865	1.34357	1.3446	178838.0
2017-11-16	E7	Futures	1.3381	1.3416	1.3366	1.3376	3122.0
2017-11-16	EBM	Futures	172.08	172.35	171.27	171.27	21753.0
2017-11-16	ED	Futures	95.477	95.477	95.4648	95.4673	345385.0
2017-11-16	ER	Futures	98.342	98.347	98.342	98.347	40213.0
2017-11-16	EW	Futures	1932.0	1956.8	1930.8	1951.4	17951.0
2017-11-16	FBON	Futures	125.77	125.81	125.5	125.75	564.0
2017-11-16	FBTP	Futures	112.47	112.55	112.11	112.33	97991.0
2017-11-16	FBTS	Futures	103.768	103.768	103.732	103.759	38274.0
2017-11-16	FCE	Futures	4757.6	4789.9	4754.0	4776.9	64514.0
2017-11-16	FDAX	Futures	13678.0	13762.1	13665.9	13705.9	81675.0
2017-11-16	FDXM	Futures	13563.6	13646.0	13551.1	13590.2	23074.0
2017-11-16	FESX	Futures	2897.7	2915.6	2895.2	2904.2	886992.0
2017-11-16	FGBL	Futures	150.42	150.55	150.14	150.44	551299.0
2017-11-16	FGBM	Futures	130.07	130.11	129.97	130.07	381054.0
2017-11-16	FGBS	Futures	112.542	112.557	112.527	112.537	197978.0
2017-11-16	FGBX	Futures	168.69	168.81	167.75	168.5	42241.0
2017-11-16	FMWO	Futures	6742.7	6778.1	6742.7	6771.0	3563.0
2017-11-16	FOAT	Futures	138.5	138.67	138.27	138.59	138654.0
2017-11-16	FTDX	Futures	2475.5	2505.5	2470.5	2499.5	2254.0
2017-11-16	FTI	Futures	500.69	502.27	499.57	500.59	20054.0
2017-11-16	FTUK	Futures	6391.3	6416.5	6387.9	6405.6	84326.0
2017-11-16	FVSA	Futures	353.31	353.31	340.4	345.09	14968.0
2017-11-16	FXXP	Futures	325.2	327.6	325.0	326.7	21665.0
2017-11-16	G	Futures	114.33	114.37	114.06	114.16	168783.0
2017-11-16	GF	Futures	333.327	333.705	331.219	332.732	4363.0
2017-11-16	GSCI	Futures	489.66	490.42	488.61	488.61	35.0
2017-11-16	HE	Futures	90.698	90.882	88.409	88.741	17829.0

> showing 50 of 109 rows — these rows as CSV

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