PREVIEW / futures_daily / 2018-07-11

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-11.parquet
  size:    10 KB
  rows:    115

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-07-11	ES	Futures	3020.17	3027.77	3003.87	3012.84	1369176.0
2018-07-11	NQ	Futures	8468.53	8499.43	8399.74	8457.16	373366.0
2018-07-11	YM	Futures	26081.0	26136.8	25932.4	26014.6	220425.0
2018-07-11	CL	Futures	75.16	75.22	70.92	71.29	861726.0
2018-07-11	GC	Futures	1604.4	1605.2	1585.3	1588.7	299639.0
2018-07-11	ZN	Futures	119.572231	119.743159	119.416841	119.58777	1588869.0
2018-07-11	A6	Futures	0.76491	0.76501	0.7573	0.75863	114824.0
2018-07-11	AD	Futures	0.77249	0.77675	0.76723	0.76829	107732.0
2018-07-11	B	Futures	58.11	58.15	53.88	54.14	560842.0
2018-07-11	B6	Futures	1.3736	1.3747	1.365	1.3669	100682.0
2018-07-11	BR	Futures	0.19809	0.19828	0.1955	0.1955	55.0
2018-07-11	BTC	Futures	9053.3	9088.9	8896.6	9017.7	2719.0
2018-07-11	BZ	Futures	57.84	57.88	53.59	53.85	48913.0
2018-07-11	C	Futures	1723.0	1734.0	1711.0	1723.0	9316.0
2018-07-11	CB	Futures	270.753	270.753	269.044	269.194	20.0
2018-07-11	CC	Futures	1771.0	1785.0	1753.0	1778.0	16155.0
2018-07-11	CNH	Futures	6.7525	6.8005	6.7489	6.7943	166.0
2018-07-11	CSC	Futures	3.186	3.218	3.186	3.202	47.0
2018-07-11	CT	Futures	97.15	97.15	95.61	95.64	61.0
2018-07-11	DC	Futures	25.0	25.36	24.91	25.18	147.0
2018-07-11	DX	Futures	88.985	89.534	88.857	89.488	25186.0
2018-07-11	E1	Futures	1.21102	1.21317	1.20576	1.20648	27187.0
2018-07-11	E6	Futures	1.31956	1.32152	1.31101	1.31185	253616.0
2018-07-11	E7	Futures	1.3127	1.3147	1.3044	1.3052	4403.0
2018-07-11	EBM	Futures	188.05	189.36	186.74	187.0	21822.0
2018-07-11	ED	Futures	94.9815	94.9864	94.9767	94.9815	147939.0
2018-07-11	ER	Futures	98.367	98.367	98.362	98.367	22900.0
2018-07-11	EW	Futures	2120.9	2126.2	2109.2	2110.9	13696.0
2018-07-11	FBON	Futures	129.49	129.6	129.17	129.27	218.0
2018-07-11	FBTP	Futures	107.91	108.24	107.75	107.96	42650.0
2018-07-11	FBTS	Futures	102.401	102.652	102.318	102.494	24725.0
2018-07-11	FCE	Futures	4855.0	4855.0	4798.8	4810.5	71666.0
2018-07-11	FDAX	Futures	13063.5	13076.1	12937.6	12978.9	95619.0
2018-07-11	FDIV	Futures	149.08	149.08	148.82	148.82	23.0
2018-07-11	FDXM	Futures	12898.7	12911.1	12771.8	12813.1	33108.0
2018-07-11	FESX	Futures	2876.4	2877.3	2844.7	2855.6	922160.0
2018-07-11	FGBL	Futures	153.2	153.4	153.02	153.15	547602.0
2018-07-11	FGBM	Futures	131.18	131.23	131.05	131.09	329210.0
2018-07-11	FGBS	Futures	112.734	112.744	112.688	112.693	250278.0
2018-07-11	FGBX	Futures	178.16	178.64	177.68	177.96	36695.0
2018-07-11	FMWO	Futures	7053.1	7085.7	7046.1	7059.0	1741.0
2018-07-11	FOAT	Futures	141.26	141.49	141.16	141.28	73896.0
2018-07-11	FTDX	Futures	2727.4	2740.2	2719.1	2739.2	433.0
2018-07-11	FTI	Futures	511.04	511.04	507.02	507.8	38.0
2018-07-11	FTUK	Futures	6781.8	6781.8	6686.9	6710.9	97617.0
2018-07-11	FVSA	Futures	276.98	285.73	269.21	281.84	32704.0
2018-07-11	FXXP	Futures	330.7	330.8	327.7	328.6	45182.0
2018-07-11	G	Futures	115.54	115.55	115.19	115.34	198302.0
2018-07-11	GF	Futures	314.568	314.672	306.23	309.493	10632.0
2018-07-11	GSCI	Futures	530.69	530.75	514.23	514.23	2872.0

> showing 50 of 115 rows — these rows as CSV

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