PREVIEW / futures_daily / 2020-07-07

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-07.parquet
  size:    10 KB
  rows:    119

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
2020-07-07	ES	Futures	3568.11	3583.87	3525.9	3530.4	1333466.0
2020-07-07	NQ	Futures	12302.78	12412.46	12193.39	12224.15	465212.0
2020-07-07	YM	Futures	28042.9	28164.0	27586.4	27617.5	192273.0
2020-07-07	CL	Futures	29.49	29.69	28.93	29.45	256596.0
2020-07-07	GC	Futures	2153.8	2174.1	2138.5	2173.0	221733.0
2020-07-07	ZN	Futures	137.768947	138.078644	137.691522	137.954765	795282.0
2020-07-07	A6	Futures	0.71771	0.71998	0.71216	0.71596	89403.0
2020-07-07	AD	Futures	0.74987	0.75068	0.74586	0.74683	52122.0
2020-07-07	ALI	Futures	1980.37	1985.81	1976.74	1982.78	83.0
2020-07-07	B	Futures	28.1	28.31	27.66	28.07	183230.0
2020-07-07	B6	Futures	1.2685	1.2792	1.2659	1.2752	87283.0
2020-07-07	BR	Futures	0.14722	0.14888	0.14572	0.1473	121.0
2020-07-07	BTC	Futures	12877.6	13022.2	12739.9	12795.0	2975.0
2020-07-07	BZ	Futures	27.48	27.68	27.04	27.44	18827.0
2020-07-07	C	Futures	1494.0	1516.0	1425.0	1425.0	1892.0
2020-07-07	CB	Futures	202.877	202.877	201.673	201.941	47.0
2020-07-07	CC	Futures	1409.0	1419.0	1397.0	1409.0	14497.0
2020-07-07	CNH	Futures	6.9349	6.9458	6.9198	6.9387	325.0
2020-07-07	CSC	Futures	3.983	4.002	3.915	3.962	84.0
2020-07-07	CT	Futures	64.27	64.63	64.27	64.46	8.0
2020-07-07	DC	Futures	32.42	33.09	32.23	32.63	379.0
2020-07-07	DX	Futures	93.406	93.797	93.266	93.54	16285.0
2020-07-07	E1	Futures	1.20808	1.20967	1.20377	1.20808	19820.0
2020-07-07	E6	Futures	1.21535	1.21787	1.20988	1.21289	172637.0
2020-07-07	E7	Futures	1.2093	1.2116	1.2039	1.2069	6359.0
2020-07-07	EBM	Futures	217.96	221.55	217.66	221.25	22933.0
2020-07-07	ED	Futures	96.4137	96.4233	96.4088	96.4185	123612.0
2020-07-07	ER	Futures	98.382	98.386	98.377	98.377	33198.0
2020-07-07	ESG	Futures	287.25	288.73	285.06	285.06	110.0
2020-07-07	EW	Futures	1906.5	1917.1	1868.5	1870.0	13198.0
2020-07-07	FBON	Futures	145.54	145.56	145.07	145.47	243.0
2020-07-07	FBTP	Futures	130.25	130.6	130.04	130.47	62093.0
2020-07-07	FBTS	Futures	108.386	108.512	108.386	108.483	31403.0
2020-07-07	FCE	Futures	4941.3	4950.1	4898.2	4934.5	51619.0
2020-07-07	FDAX	Futures	13559.2	13604.4	13284.6	13394.0	75478.0
2020-07-07	FDXM	Futures	13504.0	13553.7	13235.1	13345.7	43505.0
2020-07-07	FESX	Futures	3090.6	3098.9	3032.4	3058.3	658769.0
2020-07-07	FGBL	Futures	168.23	168.45	167.89	168.05	413698.0
2020-07-07	FGBM	Futures	134.75	134.83	134.61	134.63	322583.0
2020-07-07	FGBS	Futures	112.764	112.785	112.734	112.734	183568.0
2020-07-07	FGBX	Futures	224.56	226.09	224.15	225.08	38601.0
2020-07-07	FMWO	Futures	7915.2	7930.7	7841.8	7929.5	3500.0
2020-07-07	FOAT	Futures	155.64	155.74	155.16	155.46	119647.0
2020-07-07	FTDX	Futures	3086.9	3086.9	3055.2	3084.3	25.0
2020-07-07	FTI	Futures	534.38	535.21	530.34	533.64	22162.0
2020-07-07	FTUK	Futures	5934.5	5938.3	5778.6	5818.3	73291.0
2020-07-07	FVSA	Futures	259.67	267.3	251.15	252.05	9765.0
2020-07-07	FXXP	Futures	339.6	340.0	336.7	339.5	41609.0
2020-07-07	G	Futures	126.96	127.29	126.85	127.08	184602.0
2020-07-07	GF	Futures	263.294	264.408	261.404	261.549	3779.0

> showing 50 of 119 rows — these rows as CSV

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