PREVIEW / futures_daily / 2017-12-20

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-20.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-12-20	ES	Futures	2918.0	2929.68	2911.75	2914.47	981223.0
2017-12-20	NQ	Futures	7617.35	7646.63	7569.63	7599.78	276115.0
2017-12-20	YM	Futures	26124.7	26238.6	26055.1	26089.9	117525.0
2017-12-20	CL	Futures	57.65	58.11	57.43	58.08	420844.0
2017-12-20	GC	Futures	1603.5	1611.9	1603.0	1609.6	205618.0
2017-12-20	ZN	Futures	122.144878	122.252861	121.851779	121.882632	1289547.0
2017-12-20	A6	Futures	0.78794	0.78989	0.78691	0.78855	61613.0
2017-12-20	AD	Futures	0.7896	0.7933	0.78955	0.79269	47773.0
2017-12-20	B	Futures	45.35	45.89	45.23	45.87	222727.0
2017-12-20	B6	Futures	1.3977	1.401	1.3955	1.3979	81731.0
2017-12-20	BFX	Futures	4767.8	4767.8	4753.5	4753.5	1.0
2017-12-20	BZ	Futures	45.01	45.54	44.89	45.52	26006.0
2017-12-20	C	Futures	1289.0	1301.0	1278.0	1299.0	10851.0
2017-12-20	CB	Futures	277.046	277.046	276.12	276.12	64.0
2017-12-20	CC	Futures	1425.0	1442.0	1414.0	1441.0	16074.0
2017-12-20	CNH	Futures	6.7628	6.7628	6.7297	6.7297	34.0
2017-12-20	CSC	Futures	3.257	3.257	3.203	3.214	225.0
2017-12-20	CT	Futures	87.6	88.71	87.54	88.43	12087.0
2017-12-20	DC	Futures	25.55	25.61	25.11	25.22	535.0
2017-12-20	DX	Futures	87.369	87.449	87.102	87.234	20126.0
2017-12-20	E1	Futures	1.24208	1.24439	1.23735	1.23941	21029.0
2017-12-20	E6	Futures	1.35088	1.35768	1.34963	1.35513	203027.0
2017-12-20	E7	Futures	1.3441	1.3509	1.3428	1.3484	4285.0
2017-12-20	EBM	Futures	173.7	173.97	173.16	173.43	12576.0
2017-12-20	ED	Futures	95.3844	95.3844	95.3747	95.3796	194893.0
2017-12-20	ER	Futures	98.337	98.337	98.332	98.337	112883.0
2017-12-20	EW	Futures	2014.6	2024.7	2011.9	2019.4	10494.0
2017-12-20	FBON	Futures	126.52	127.0	126.35	126.53	410.0
2017-12-20	FBTP	Futures	112.09	112.35	111.45	111.68	87065.0
2017-12-20	FBTS	Futures	103.586	103.686	103.512	103.576	53421.0
2017-12-20	FCE	Futures	4818.6	4822.6	4773.8	4788.1	71712.0
2017-12-20	FDAX	Futures	13740.3	13750.2	13505.8	13540.6	91718.0
2017-12-20	FDXM	Futures	13769.8	13775.0	13528.7	13563.6	34404.0
2017-12-20	FESX	Futures	2922.1	2923.8	2887.0	2891.1	782931.0
2017-12-20	FGBL	Futures	150.47	150.58	149.75	149.9	680826.0
2017-12-20	FGBM	Futures	129.69	129.74	129.41	129.49	586955.0
2017-12-20	FGBS	Futures	112.422	112.437	112.392	112.407	360279.0
2017-12-20	FGBX	Futures	170.37	170.74	168.66	168.99	52151.0
2017-12-20	FMWO	Futures	6943.3	6950.3	6915.3	6923.5	615.0
2017-12-20	FOAT	Futures	139.23	139.29	138.42	138.57	110690.0
2017-12-20	FTDX	Futures	2556.8	2556.8	2519.4	2523.9	105.0
2017-12-20	FTI	Futures	511.86	511.91	504.5	506.63	24333.0
2017-12-20	FTUK	Futures	6536.2	6544.5	6509.5	6517.8	85397.0
2017-12-20	FVSA	Futures	271.8	288.66	269.7	286.55	42193.0
2017-12-20	FXXP	Futures	332.1	332.3	329.2	329.4	22555.0
2017-12-20	G	Futures	114.99	115.14	114.61	114.69	166099.0
2017-12-20	GF	Futures	313.923	313.923	304.788	306.518	7554.0
2017-12-20	GSCI	Futures	494.2	495.65	493.73	495.65	33.0
2017-12-20	HE	Futures	89.908	91.609	89.141	91.209	15446.0
2017-12-20	HG	Futures	3.7665	3.8449	3.7576	3.8258	123966.0

> showing 50 of 109 rows — these rows as CSV

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