PREVIEW / futures_daily / 2017-10-30

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-30.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-10-30	ES	Futures	2801.36	2804.35	2790.48	2793.47	1237600.0
2017-10-30	NQ	Futures	7293.75	7343.08	7285.23	7311.08	360344.0
2017-10-30	YM	Futures	24669.1	24695.5	24577.2	24595.2	117371.0
2017-10-30	CL	Futures	54.62	54.92	54.2	54.61	565043.0
2017-10-30	GC	Futures	1621.4	1628.6	1615.7	1625.8	260077.0
2017-10-30	ZN	Futures	122.977596	123.285695	122.962191	123.254885	1242395.0
2017-10-30	A6	Futures	0.78907	0.79093	0.78722	0.7901	72526.0
2017-10-30	AD	Futures	0.79382	0.79443	0.79138	0.793	61216.0
2017-10-30	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-30	B	Futures	42.6	42.93	42.38	42.86	331677.0
2017-10-30	B6	Futures	1.371	1.3798	1.37	1.3782	97537.0
2017-10-30	BR	Futures	0.23189	0.23207	0.22853	0.22955	3062.0
2017-10-30	BZ	Futures	42.29	42.55	42.01	42.48	24463.0
2017-10-30	C	Futures	1541.0	1541.0	1517.0	1537.0	12459.0
2017-10-30	CB	Futures	296.667	296.667	294.462	295.407	60.0
2017-10-30	CC	Futures	1573.0	1575.0	1540.0	1573.0	23757.0
2017-10-30	CNH	Futures	6.8392	6.8418	6.8322	6.8322	15.0
2017-10-30	CSC	Futures	3.445	3.478	3.445	3.476	37.0
2017-10-30	CT	Futures	79.87	81.28	79.81	80.62	15684.0
2017-10-30	DC	Futures	27.87	28.32	27.87	28.32	216.0
2017-10-30	DX	Futures	88.625	88.686	88.209	88.33	22353.0
2017-10-30	E1	Futures	1.22944	1.23396	1.22687	1.23262	27625.0
2017-10-30	E6	Futures	1.32737	1.3337	1.32634	1.33147	210053.0
2017-10-30	E7	Futures	1.3205	1.3268	1.3194	1.3245	2859.0
2017-10-30	EBM	Futures	175.86	176.4	175.32	176.4	12798.0
2017-10-30	ED	Futures	95.4939	95.4988	95.4891	95.4939	176663.0
2017-10-30	ER	Futures	98.347	98.347	98.342	98.342	11286.0
2017-10-30	EW	Futures	1952.6	1954.0	1934.7	1939.6	13078.0
2017-10-30	FBON	Futures	125.56	126.15	125.56	126.1	781.0
2017-10-30	FBTP	Futures	111.29	112.26	111.23	112.24	136010.0
2017-10-30	FBTS	Futures	103.558	103.631	103.558	103.622	65008.0
2017-10-30	FCE	Futures	4917.6	4933.7	4912.2	4921.1	50338.0
2017-10-30	FDAX	Futures	13874.0	13925.6	13873.5	13896.6	49082.0
2017-10-30	FDXM	Futures	13761.6	13813.8	13758.5	13779.4	16132.0
2017-10-30	FESX	Futures	2971.9	2988.2	2971.9	2980.1	620921.0
2017-10-30	FEU3	Futures	99.011	99.016	99.011	99.016	5.0
2017-10-30	FGBL	Futures	150.25	150.48	150.02	150.45	585568.0
2017-10-30	FGBM	Futures	130.11	130.14	130.02	130.13	404139.0
2017-10-30	FGBS	Futures	112.577	112.582	112.547	112.557	234615.0
2017-10-30	FGBX	Futures	168.2	168.91	167.6	168.81	46217.0
2017-10-30	FMWO	Futures	6762.8	6762.8	6754.5	6758.1	1654.0
2017-10-30	FOAT	Futures	137.69	138.0	137.53	137.97	93831.0
2017-10-30	FTDX	Futures	2534.4	2550.4	2534.4	2539.9	140.0
2017-10-30	FTI	Futures	507.24	508.12	506.63	507.51	15601.0
2017-10-30	FTUK	Futures	6482.4	6484.2	6460.3	6467.3	63157.0
2017-10-30	FVSA	Futures	347.88	350.44	338.93	347.88	10818.0
2017-10-30	FXXP	Futures	333.2	334.6	332.9	333.9	18190.0
2017-10-30	G	Futures	113.59	113.88	113.53	113.86	120915.0
2017-10-30	GF	Futures	341.489	345.476	339.98	341.219	4379.0
2017-10-30	GSCI	Futures	487.11	487.23	486.41	487.06	753.0

> showing 50 of 109 rows — these rows as CSV

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