PREVIEW / futures_daily / 2017-12-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-06.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-06	ES	Futures	2857.1	2865.53	2849.76	2859.82	1307666.0
2017-12-06	NQ	Futures	7363.64	7408.28	7320.77	7391.83	363675.0
2017-12-06	YM	Futures	25530.8	25587.8	25431.5	25509.7	133152.0
2017-12-06	CL	Futures	57.51	57.63	55.93	56.02	678992.0
2017-12-06	GC	Futures	1607.9	1612.4	1603.5	1605.1	253049.0
2017-12-06	ZN	Futures	122.854356	123.193265	122.808142	123.070025	40199.0
2017-12-06	A6	Futures	0.78239	0.78588	0.77765	0.77786	89284.0
2017-12-06	AD	Futures	0.80175	0.8042	0.79453	0.79499	87079.0
2017-12-06	B	Futures	44.5	44.71	43.43	43.49	314261.0
2017-12-06	B6	Futures	1.4001	1.4015	1.3931	1.3949	137307.0
2017-12-06	BR	Futures	0.23309	0.23457	0.23211	0.23211	6.0
2017-12-06	BZ	Futures	44.25	44.36	43.1	43.16	25263.0
2017-12-06	C	Futures	1341.0	1352.0	1314.0	1315.0	4238.0
2017-12-06	CB	Futures	279.826	283.316	279.826	280.598	5.0
2017-12-06	CC	Futures	1444.0	1447.0	1420.0	1422.0	25061.0
2017-12-06	CNH	Futures	6.7941	6.7985	6.7941	6.7959	54.0
2017-12-06	CSC	Futures	3.378	3.385	3.351	3.355	106.0
2017-12-06	CT	Futures	84.61	85.58	84.61	84.93	13354.0
2017-12-06	DC	Futures	26.79	26.85	26.61	26.68	78.0
2017-12-06	DX	Futures	87.26	87.55	87.096	87.514	21657.0
2017-12-06	E1	Futures	1.23922	1.24154	1.23469	1.23555	25205.0
2017-12-06	E6	Futures	1.35064	1.35281	1.34505	1.34625	197952.0
2017-12-06	E7	Futures	1.3435	1.3457	1.338	1.3393	4016.0
2017-12-06	EBM	Futures	173.97	174.51	173.43	173.97	13262.0
2017-12-06	ED	Futures	95.4333	95.4382	95.4285	95.4309	241458.0
2017-12-06	ER	Futures	98.342	98.347	98.337	98.342	88386.0
2017-12-06	EW	Futures	1996.7	1999.6	1986.6	1988.6	12842.0
2017-12-06	FBON	Futures	127.07	127.13	126.8	126.8	991.0
2017-12-06	FBTP	Futures	114.03	114.35	113.83	113.91	154326.0
2017-12-06	FBTS	Futures	103.942	103.997	103.933	103.97	71256.0
2017-12-06	FCE	Futures	4794.8	4828.4	4764.3	4817.2	88464.0
2017-12-06	FDAX	Futures	13623.9	13700.1	13516.7	13664.4	111879.0
2017-12-06	FDXM	Futures	13511.5	13584.5	13402.1	13549.1	44258.0
2017-12-06	FESX	Futures	2892.8	2910.7	2878.9	2903.4	1113565.0
2017-12-06	FGBL	Futures	151.4	151.68	151.27	151.55	1025206.0
2017-12-06	FGBM	Futures	130.28	130.45	130.28	130.4	761634.0
2017-12-06	FGBS	Futures	112.567	112.607	112.562	112.592	606136.0
2017-12-06	FGBX	Futures	172.65	173.21	172.16	172.9	109975.0
2017-12-06	FMWO	Futures	6833.6	6859.6	6830.1	6851.3	1061.0
2017-12-06	FOAT	Futures	140.11	140.32	139.94	140.17	177643.0
2017-12-06	FTDX	Futures	2478.5	2478.5	2446.6	2467.5	151.0
2017-12-06	FTI	Futures	501.66	505.0	499.71	503.98	28119.0
2017-12-06	FTUK	Futures	6350.5	6394.8	6315.8	6374.8	98145.0
2017-12-06	FVSA	Futures	319.27	322.79	313.4	314.57	20625.0
2017-12-06	FXXP	Futures	326.9	328.9	325.5	328.3	32875.0
2017-12-06	G	Futures	114.93	115.2	114.79	114.97	166582.0
2017-12-06	GF	Futures	319.004	319.004	314.517	315.707	7039.0
2017-12-06	GSCI	Futures	491.0	491.0	483.36	483.77	280.0
2017-12-06	HE	Futures	93.977	94.344	91.909	91.976	17109.0
2017-12-06	HG	Futures	3.5313	3.5774	3.5283	3.5451	106693.0

> showing 50 of 109 rows — these rows as CSV

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