PREVIEW / futures_daily / 2017-12-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-21.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-21	ES	Futures	2914.47	2930.23	2913.65	2921.26	853748.0
2017-12-21	NQ	Futures	7597.15	7636.97	7584.56	7603.59	211561.0
2017-12-21	YM	Futures	26086.8	26217.5	26063.6	26131.0	89253.0
2017-12-21	CL	Futures	58.01	58.37	57.62	58.35	405320.0
2017-12-21	GC	Futures	1608.6	1613.3	1605.0	1610.8	196539.0
2017-12-21	ZN	Futures	121.882632	122.05232	121.820927	121.944337	845872.0
2017-12-21	A6	Futures	0.78845	0.79267	0.78711	0.79246	64794.0
2017-12-21	AD	Futures	0.79244	0.80097	0.79209	0.79889	94749.0
2017-12-21	B	Futures	45.82	46.13	45.61	46.11	155417.0
2017-12-21	B6	Futures	1.396	1.3978	1.3918	1.3973	74029.0
2017-12-21	BR	Futures	0.22767	0.22801	0.22767	0.22782	169.0
2017-12-21	BZ	Futures	45.46	45.77	45.25	45.75	17911.0
2017-12-21	C	Futures	1295.0	1295.0	1270.0	1287.0	11774.0
2017-12-21	CB	Futures	276.12	276.12	275.502	275.842	61.0
2017-12-21	CC	Futures	1432.0	1432.0	1390.0	1423.0	22348.0
2017-12-21	CNH	Futures	6.7127	6.7432	6.7127	6.7303	29.0
2017-12-21	CSC	Futures	3.233	3.244	3.223	3.229	59.0
2017-12-21	CT	Futures	88.33	91.18	88.08	91.03	24539.0
2017-12-21	DC	Futures	25.35	25.54	25.29	25.44	298.0
2017-12-21	DX	Futures	87.266	87.426	87.163	87.207	12899.0
2017-12-21	E1	Futures	1.23953	1.2405	1.23383	1.23747	19047.0
2017-12-21	E6	Futures	1.35439	1.35626	1.35184	1.35451	158705.0
2017-12-21	E7	Futures	1.3477	1.3493	1.345	1.3477	2941.0
2017-12-21	EBM	Futures	173.43	173.43	172.62	172.89	14592.0
2017-12-21	ED	Futures	95.3844	95.3844	95.3747	95.3747	186867.0
2017-12-21	ER	Futures	98.337	98.337	98.332	98.337	40761.0
2017-12-21	EW	Futures	2017.8	2028.5	2016.3	2024.1	9715.0
2017-12-21	FBON	Futures	126.48	126.75	126.48	126.63	192.0
2017-12-21	FBTP	Futures	111.63	112.17	111.6	112.01	49127.0
2017-12-21	FBTS	Futures	103.586	103.631	103.567	103.604	30675.0
2017-12-21	FCE	Futures	4778.3	4821.7	4760.0	4817.2	53625.0
2017-12-21	FDAX	Futures	13535.4	13628.8	13495.5	13589.3	70342.0
2017-12-21	FDXM	Futures	13559.9	13651.4	13518.4	13612.4	22609.0
2017-12-21	FESX	Futures	2889.5	2912.3	2877.2	2907.4	612743.0
2017-12-21	FGBL	Futures	149.94	149.98	149.68	149.87	395268.0
2017-12-21	FGBM	Futures	129.42	129.5	129.35	129.39	383046.0
2017-12-21	FGBS	Futures	112.387	112.402	112.352	112.367	299208.0
2017-12-21	FGBX	Futures	169.24	169.48	168.54	169.32	32136.0
2017-12-21	FMWO	Futures	6913.0	6957.3	6910.7	6951.5	1541.0
2017-12-21	FOAT	Futures	138.62	138.74	138.45	138.68	62013.0
2017-12-21	FTDX	Futures	2521.4	2528.4	2512.4	2527.4	53.0
2017-12-21	FTI	Futures	505.8	508.86	503.49	508.48	17099.0
2017-12-21	FTUK	Futures	6522.2	6596.5	6514.8	6589.0	82773.0
2017-12-21	FVSA	Futures	286.55	291.82	278.13	280.23	17205.0
2017-12-21	FXXP	Futures	329.5	331.8	328.3	331.5	27358.0
2017-12-21	G	Futures	114.64	114.73	114.46	114.7	111192.0
2017-12-21	GF	Futures	307.221	309.545	304.951	309.004	4008.0
2017-12-21	GSCI	Futures	495.65	497.69	494.67	497.69	8.0
2017-12-21	HE	Futures	91.509	92.443	90.909	91.476	12418.0
2017-12-21	HG	Futures	3.8258	3.8545	3.8096	3.8539	104393.0

> showing 50 of 110 rows — these rows as CSV

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