PREVIEW / futures_daily / 2018-10-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-18.parquet
  size:    10 KB
  rows:    114

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-10-18	ES	Futures	3051.0	3052.63	2989.46	3006.54	2218738.0
2018-10-18	NQ	Futures	8488.14	8490.17	8240.44	8290.68	705908.0
2018-10-18	YM	Futures	27067.4	27090.6	26554.6	26727.3	314790.0
2018-10-18	CL	Futures	72.89	72.94	71.42	71.61	531313.0
2018-10-18	GC	Futures	1553.2	1563.5	1548.4	1559.1	243105.0
2018-10-18	ZN	Futures	117.39405	117.814259	117.316233	117.674189	2331342.0
2018-10-18	A6	Futures	0.7321	0.73621	0.73066	0.73158	103115.0
2018-10-18	AD	Futures	0.77739	0.77754	0.77335	0.77401	66428.0
2018-10-18	B	Futures	58.95	59.01	57.82	58.26	359005.0
2018-10-18	B6	Futures	1.3518	1.3541	1.3421	1.3438	113979.0
2018-10-18	BR	Futures	0.20601	0.20662	0.20479	0.20479	98.0
2018-10-18	BTC	Futures	9278.7	9350.8	9134.4	9220.9	2759.0
2018-10-18	BZ	Futures	58.58	58.58	57.39	57.82	41270.0
2018-10-18	C	Futures	1498.0	1498.0	1459.0	1464.0	9019.0
2018-10-18	CB	Futures	270.546	270.606	270.366	270.366	30.0
2018-10-18	CC	Futures	1546.0	1548.0	1492.0	1498.0	25072.0
2018-10-18	CNH	Futures	6.9778	7.0047	6.9777	6.9959	750.0
2018-10-18	CSC	Futures	3.09	3.108	3.074	3.082	65.0
2018-10-18	CT	Futures	87.46	88.0	86.8	87.61	14282.0
2018-10-18	DC	Futures	26.03	26.03	25.78	25.89	287.0
2018-10-18	DX	Futures	90.595	90.947	90.448	90.854	23261.0
2018-10-18	E1	Futures	1.19734	1.20078	1.19426	1.19675	29574.0
2018-10-18	E6	Futures	1.28417	1.28751	1.27872	1.2805	232722.0
2018-10-18	E7	Futures	1.2782	1.2811	1.2725	1.2742	4018.0
2018-10-18	EBM	Futures	210.01	210.53	208.72	209.24	19482.0
2018-10-18	ED	Futures	95.0134	95.0183	94.9646	94.9694	1068177.0
2018-10-18	ER	Futures	98.381	98.386	98.367	98.381	146738.0
2018-10-18	EW	Futures	2015.1	2015.1	1977.1	1982.9	18483.0
2018-10-18	FBON	Futures	126.4	126.48	125.56	125.67	1821.0
2018-10-18	FBTP	Futures	103.39	103.68	102.06	102.58	121816.0
2018-10-18	FBTS	Futures	101.31	101.497	100.766	100.935	94312.0
2018-10-18	FCE	Futures	4601.2	4630.7	4541.2	4578.3	88786.0
2018-10-18	FDAX	Futures	12291.4	12390.2	12068.4	12175.2	134243.0
2018-10-18	FDXM	Futures	12079.5	12173.5	11859.4	11964.3	67172.0
2018-10-18	FESX	Futures	2714.2	2728.5	2667.2	2690.7	1350541.0
2018-10-18	FGBL	Futures	152.06	153.07	151.99	152.66	832964.0
2018-10-18	FGBM	Futures	130.62	131.1	130.6	130.92	509012.0
2018-10-18	FGBS	Futures	112.603	112.744	112.603	112.693	529509.0
2018-10-18	FGBX	Futures	175.23	177.39	174.95	176.52	43317.0
2018-10-18	FMWO	Futures	6931.2	6962.4	6836.1	6899.9	8066.0
2018-10-18	FOAT	Futures	139.44	139.98	139.43	139.75	181089.0
2018-10-18	FTDX	Futures	2617.2	2650.6	2583.8	2605.9	451.0
2018-10-18	FTI	Futures	490.28	491.96	483.38	486.96	26121.0
2018-10-18	FTUK	Futures	6282.7	6302.3	6215.2	6262.6	109589.0
2018-10-18	FVSA	Futures	329.16	354.85	325.35	340.58	34535.0
2018-10-18	FXXP	Futures	313.6	315.8	309.9	312.1	68740.0
2018-10-18	G	Futures	113.53	114.22	113.53	113.93	242790.0
2018-10-18	GF	Futures	319.69	321.769	317.87	321.093	3824.0
2018-10-18	GSCI	Futures	539.77	542.22	539.48	541.02	38.0
2018-10-18	HE	Futures	72.982	72.982	69.794	70.197	25760.0

> showing 50 of 114 rows — these rows as CSV

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