PREVIEW / futures_daily / 2018-04-30

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-30.parquet
  size:    9 KB
  rows:    111

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
2018-04-30	ES	Futures	2904.08	2916.86	2876.35	2878.53	1341086.0
2018-04-30	NQ	Futures	7804.45	7862.97	7719.59	7740.08	389473.0
2018-04-30	YM	Futures	25575.5	25764.1	25385.9	25419.6	186410.0
2018-04-30	CL	Futures	68.4	69.59	67.42	68.82	755186.0
2018-04-30	GC	Futures	1690.3	1692.7	1673.3	1684.2	295960.0
2018-04-30	ZN	Futures	118.594127	118.764722	118.485567	118.733705	1264395.0
2018-04-30	A6	Futures	0.77962	0.77972	0.77386	0.77427	94084.0
2018-04-30	AD	Futures	0.78905	0.79082	0.78662	0.78854	62698.0
2018-04-30	B	Futures	54.04	55.41	53.36	54.73	403899.0
2018-04-30	B6	Futures	1.4301	1.4315	1.4232	1.4267	117565.0
2018-04-30	BR	Futures	0.21972	0.22003	0.21641	0.2169	2158.0
2018-04-30	BTC	Futures	13165.1	13333.7	12835.1	13151.1	2999.0
2018-04-30	BZ	Futures	53.54	54.83	52.81	54.17	40915.0
2018-04-30	C	Futures	1711.0	1733.0	1699.0	1733.0	6858.0
2018-04-30	CB	Futures	301.662	301.848	301.662	301.848	5.0
2018-04-30	CC	Futures	2062.0	2071.0	1997.0	2060.0	26947.0
2018-04-30	CNH	Futures	6.4125	6.4275	6.4125	6.4145	10.0
2018-04-30	CSC	Futures	3.438	3.461	3.436	3.461	26.0
2018-04-30	CT	Futures	96.1	96.32	94.71	95.31	14139.0
2018-04-30	DC	Futures	27.87	28.09	27.85	28.09	139.0
2018-04-30	DX	Futures	86.15	86.495	86.089	86.419	23564.0
2018-04-30	E1	Futures	1.22381	1.22465	1.21875	1.22032	25070.0
2018-04-30	E6	Futures	1.371	1.37218	1.36379	1.3657	222888.0
2018-04-30	E7	Futures	1.3638	1.3649	1.3564	1.3584	3093.0
2018-04-30	EBM	Futures	179.62	181.23	179.62	180.69	20563.0
2018-04-30	ED	Futures	94.9549	94.9597	94.9354	94.9403	209225.0
2018-04-30	ER	Futures	98.342	98.347	98.342	98.342	21044.0
2018-04-30	EW	Futures	2004.3	2015.6	1979.7	1982.6	16169.0
2018-04-30	FBON	Futures	129.7	129.75	129.21	129.52	451.0
2018-04-30	FBTP	Futures	116.17	116.19	115.39	115.8	125745.0
2018-04-30	FBTS	Futures	104.297	104.297	104.223	104.26	91919.0
2018-04-30	FCE	Futures	4846.7	4882.0	4838.7	4880.2	56030.0
2018-04-30	FDAX	Futures	13113.8	13127.8	13054.6	13103.9	70702.0
2018-04-30	FDIV	Futures	153.08	153.13	152.81	152.81	140.0
2018-04-30	FDXM	Futures	12999.6	13010.9	12937.8	12987.3	19944.0
2018-04-30	FESX	Futures	2882.2	2898.1	2876.4	2893.9	847436.0
2018-04-30	FGBL	Futures	149.29	149.54	149.04	149.38	606831.0
2018-04-30	FGBM	Futures	129.48	129.62	129.37	129.56	326317.0
2018-04-30	FGBS	Futures	112.507	112.532	112.482	112.517	234989.0
2018-04-30	FGBX	Futures	169.25	169.58	168.71	169.21	45443.0
2018-04-30	FMWO	Futures	6980.7	6983.0	6939.8	6972.5	369.0
2018-04-30	FOAT	Futures	138.54	138.66	138.26	138.59	86575.0
2018-04-30	FTDX	Futures	2607.3	2607.3	2583.0	2593.4	117.0
2018-04-30	FTI	Futures	509.65	510.81	508.32	510.58	17984.0
2018-04-30	FTUK	Futures	6614.8	6626.3	6579.0	6591.8	118902.0
2018-04-30	FVSA	Futures	334.09	343.27	328.35	335.23	24797.0
2018-04-30	FXXP	Futures	328.8	329.8	328.2	329.4	34640.0
2018-04-30	G	Futures	113.54	113.9	113.41	113.79	218432.0
2018-04-30	GF	Futures	307.306	307.736	300.957	301.657	1816.0
2018-04-30	GSCI	Futures	530.23	537.55	529.5	534.62	798.0

> showing 50 of 111 rows — these rows as CSV

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