PREVIEW / futures_daily / 2017-12-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-01.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-01	ES	Futures	2872.33	2883.2	2833.44	2875.86	2520826.0
2017-12-01	NQ	Futures	7463.19	7481.1	7336.62	7454.38	608005.0
2017-12-01	YM	Futures	25592.0	25687.1	25263.6	25595.2	346046.0
2017-12-01	CL	Futures	57.48	58.94	57.35	58.42	685215.0
2017-12-01	GC	Futures	1620.1	1638.6	1615.4	1625.7	438931.0
2017-12-01	ZN	Futures	122.592472	123.331909	122.438423	122.915976	178443.0
2017-12-01	A6	Futures	0.77745	0.78599	0.77734	0.783	148394.0
2017-12-01	AD	Futures	0.78898	0.80247	0.78893	0.80155	159130.0
2017-12-01	B	Futures	44.57	45.69	44.47	45.28	308154.0
2017-12-01	B6	Futures	1.4101	1.4134	1.4023	1.4047	160476.0
2017-12-01	BR	Futures	0.2323	0.2323	0.23116	0.23116	1.0
2017-12-01	BZ	Futures	44.16	45.34	44.13	44.93	28073.0
2017-12-01	C	Futures	1413.0	1418.0	1392.0	1407.0	9895.0
2017-12-01	CB	Futures	281.679	281.679	280.475	281.648	15.0
2017-12-01	CC	Futures	1526.0	1529.0	1502.0	1523.0	24810.0
2017-12-01	CNH	Futures	6.7887	6.7889	6.7734	6.7734	35.0
2017-12-01	CSC	Futures	3.415	3.419	3.387	3.387	31.0
2017-12-01	CT	Futures	85.04	85.74	84.86	85.59	18181.0
2017-12-01	DC	Futures	27.27	27.42	27.07	27.07	53.0
2017-12-01	DX	Futures	86.881	87.166	86.549	86.821	31151.0
2017-12-01	E1	Futures	1.2435	1.25707	1.23971	1.25414	48325.0
2017-12-01	E6	Futures	1.35789	1.36354	1.35327	1.35817	289430.0
2017-12-01	E7	Futures	1.3511	1.3563	1.3463	1.3511	6959.0
2017-12-01	EBM	Futures	171.27	172.35	170.46	172.08	7717.0
2017-12-01	ED	Futures	95.4552	95.4624	95.4503	95.4552	419851.0
2017-12-01	ER	Futures	98.332	98.342	98.328	98.342	174943.0
2017-12-01	EW	Futures	2014.5	2021.9	1970.8	2014.5	26674.0
2017-12-01	FBON	Futures	126.44	127.23	126.44	127.09	819.0
2017-12-01	FBTP	Futures	113.57	114.12	113.34	113.95	201253.0
2017-12-01	FBTS	Futures	103.878	103.933	103.86	103.906	81996.0
2017-12-01	FCE	Futures	4814.1	4818.1	4742.8	4761.6	170491.0
2017-12-01	FDAX	Futures	13721.7	13740.0	13459.4	13519.3	158966.0
2017-12-01	FDXM	Futures	13606.4	13622.0	13347.9	13405.2	85836.0
2017-12-01	FESX	Futures	2914.8	2914.8	2864.2	2874.0	1843790.0
2017-12-01	FEU3	Futures	99.011	99.011	99.006	99.006	10.0
2017-12-01	FGBL	Futures	150.47	151.57	150.34	151.45	1412604.0
2017-12-01	FGBM	Futures	129.83	130.2	129.77	130.16	1095003.0
2017-12-01	FGBS	Futures	112.452	112.547	112.452	112.522	970752.0
2017-12-01	FGBX	Futures	170.87	173.54	170.54	173.14	96584.0
2017-12-01	FMWO	Futures	6899.8	6910.4	6827.7	6846.6	1297.0
2017-12-01	FOAT	Futures	139.18	140.29	139.01	140.16	233350.0
2017-12-01	FTDX	Futures	2521.9	2522.4	2481.0	2492.0	665.0
2017-12-01	FTI	Futures	502.73	503.24	495.49	497.3	59642.0
2017-12-01	FTUK	Futures	6334.9	6381.4	6314.5	6337.1	161267.0
2017-12-01	FVSA	Futures	315.75	356.83	314.57	346.27	48086.0
2017-12-01	FXXP	Futures	328.7	329.2	324.9	326.0	57315.0
2017-12-01	G	Futures	114.01	115.14	113.96	114.94	283917.0
2017-12-01	GF	Futures	333.381	333.381	323.976	325.003	7380.0
2017-12-01	GSCI	Futures	501.09	503.54	500.28	500.86	78.0
2017-12-01	HE	Futures	93.343	94.711	92.543	94.344	18763.0

> showing 50 of 110 rows — these rows as CSV

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