PREVIEW / futures_daily / 2017-12-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-07.parquet
  size:    9 KB
  rows:    110

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-07	ES	Futures	2861.18	2872.87	2856.56	2870.97	1345485.0
2017-12-07	NQ	Futures	7397.7	7441.75	7386.84	7427.07	325352.0
2017-12-07	YM	Futures	25520.2	25621.6	25421.0	25587.8	127113.0
2017-12-07	CL	Futures	56.06	56.84	55.88	56.75	557325.0
2017-12-07	GC	Futures	1604.0	1606.0	1579.4	1588.7	326470.0
2017-12-07	ZN	Futures	122.915976	123.100835	122.761927	122.761927	15164.0
2017-12-07	A6	Futures	0.77796	0.77878	0.77199	0.7722	85109.0
2017-12-07	AD	Futures	0.79539	0.79585	0.79077	0.79112	73507.0
2017-12-07	B	Futures	43.55	44.23	43.44	44.19	238964.0
2017-12-07	B6	Futures	1.3952	1.4065	1.3891	1.4045	206118.0
2017-12-07	BR	Futures	0.22888	0.22888	0.2282	0.22877	15.0
2017-12-07	BZ	Futures	43.17	43.89	43.12	43.85	19281.0
2017-12-07	C	Futures	1311.0	1334.0	1295.0	1297.0	3787.0
2017-12-07	CB	Futures	281.679	281.679	280.042	280.475	11.0
2017-12-07	CC	Futures	1425.0	1441.0	1394.0	1403.0	27883.0
2017-12-07	CNH	Futures	6.7996	6.7996	6.7923	6.7923	241.0
2017-12-07	CSC	Futures	3.344	3.381	3.338	3.376	79.0
2017-12-07	CT	Futures	85.07	86.74	84.21	86.7	26597.0
2017-12-07	DC	Futures	26.7	26.92	26.5	26.92	88.0
2017-12-07	DX	Futures	87.498	87.699	87.433	87.689	14810.0
2017-12-07	E1	Futures	1.23628	1.23922	1.22993	1.23029	25226.0
2017-12-07	E6	Futures	1.34739	1.34882	1.3438	1.34403	197235.0
2017-12-07	E7	Futures	1.3403	1.3418	1.3368	1.337	8360.0
2017-12-07	EBM	Futures	173.43	173.7	172.89	173.43	10029.0
2017-12-07	ED	Futures	95.4285	95.4309	95.4188	95.4212	224185.0
2017-12-07	ER	Futures	98.342	98.347	98.337	98.342	43028.0
2017-12-07	EW	Futures	1988.6	2006.7	1985.4	2002.1	23999.0
2017-12-07	FBON	Futures	126.87	127.17	126.7	126.75	343.0
2017-12-07	FBTP	Futures	113.94	114.43	113.82	114.34	91678.0
2017-12-07	FBTS	Futures	103.979	104.015	103.961	104.015	38132.0
2017-12-07	FCE	Futures	4821.2	4836.9	4808.7	4825.7	64046.0
2017-12-07	FDAX	Futures	13705.9	13776.3	13648.1	13711.7	85670.0
2017-12-07	FDXM	Futures	13592.8	13658.5	13533.4	13595.9	29359.0
2017-12-07	FESX	Futures	2909.9	2920.5	2900.9	2914.0	1007907.0
2017-12-07	FEU3	Futures	99.006	99.006	99.006	99.006	225.0
2017-12-07	FGBL	Futures	151.41	151.69	151.27	151.67	604388.0
2017-12-07	FGBM	Futures	130.35	130.49	130.34	130.48	447025.0
2017-12-07	FGBS	Futures	112.597	112.643	112.587	112.633	296680.0
2017-12-07	FGBX	Futures	172.57	172.96	171.42	172.65	63008.0
2017-12-07	FMWO	Futures	6864.3	6878.5	6847.8	6869.1	6183.0
2017-12-07	FOAT	Futures	140.02	140.32	139.91	140.32	114508.0
2017-12-07	FTDX	Futures	2479.0	2486.5	2473.5	2482.0	99.0
2017-12-07	FTI	Futures	504.49	506.44	503.24	505.56	20569.0
2017-12-07	FTUK	Futures	6374.8	6395.7	6335.8	6350.1	184671.0
2017-12-07	FVSA	Futures	311.05	320.44	306.36	308.71	16233.0
2017-12-07	FXXP	Futures	328.3	329.5	327.7	328.4	27258.0
2017-12-07	G	Futures	114.87	115.05	114.56	114.78	195231.0
2017-12-07	GF	Futures	315.707	317.112	313.274	316.355	7860.0
2017-12-07	GSCI	Futures	484.47	485.92	484.17	485.81	2200.0
2017-12-07	HE	Futures	91.743	92.443	90.909	91.342	21710.0

> showing 50 of 110 rows — these rows as CSV

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