PREVIEW / futures_daily / 2014-09-18

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-18.parquet
  size:    9 KB
  rows:    104

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
2014-09-18	ES	Futures	2084.47	2096.22	2081.86	2093.87	1402964.0
2014-09-18	NQ	Futures	4718.19	4751.51	4706.6	4747.74	225943.0
2014-09-18	YM	Futures	17337.2	17456.9	17317.9	17427.5	123091.0
2014-09-18	CL	Futures	174.85	176.31	172.94	173.26	168113.0
2014-09-18	GC	Futures	1604.3	1611.6	1595.4	1609.3	151109.0
2014-09-18	ZN	Futures	116.020698	116.167133	115.801045	115.962124	1346766.0
2014-09-18	A6	Futures	0.865	0.86898	0.86227	0.86713	125637.0
2014-09-18	AD	Futures	0.92037	0.92759	0.91946	0.92535	54197.0
2014-09-18	ALI	Futures	2975.68	2975.68	2975.68	2975.68	0.0
2014-09-18	B	Futures	103.09	103.56	101.77	102.06	193584.0
2014-09-18	B6	Futures	1.7079	1.7236	1.7063	1.7199	133473.0
2014-09-18	BFX	Futures	3861.7	3874.2	3861.7	3874.2	5.0
2014-09-18	BR	Futures	0.22449	0.22452	0.22279	0.22403	210.0
2014-09-18	BZ	Futures	103.71	104.3	102.51	102.78	15316.0
2014-09-18	C	Futures	2178.0	2204.0	2176.0	2199.0	6682.0
2014-09-18	CB	Futures	159.53	159.55	159.53	159.55	4.0
2014-09-18	CC	Futures	2331.0	2366.0	2330.0	2356.0	12760.0
2014-09-18	CNH	Futures	7.0978	7.1044	7.0925	7.0925	43.0
2014-09-18	CSC	Futures	5.421	5.51	5.421	5.476	35.0
2014-09-18	CT	Futures	87.28	87.28	84.39	84.39	44.0
2014-09-18	DC	Futures	43.3	44.28	43.2	44.13	447.0
2014-09-18	DX	Futures	80.56	80.593	80.062	80.147	32280.0
2014-09-18	E1	Futures	1.35844	1.3711	1.35665	1.36944	51851.0
2014-09-18	E6	Futures	1.51364	1.52306	1.51176	1.5213	228765.0
2014-09-18	E7	Futures	1.5045	1.5136	1.5024	1.5117	4905.0
2014-09-18	ED	Futures	95.423	95.4278	95.4183	95.423	165960.0
2014-09-18	ER	Futures	98.004	98.009	97.989	97.999	104005.0
2014-09-18	EW	Futures	1480.7	1487.6	1479.5	1483.2	13959.0
2014-09-18	FBTP	Futures	94.59	94.93	94.39	94.56	82190.0
2014-09-18	FBTS	Futures	98.73	98.757	98.668	98.686	14767.0
2014-09-18	FCE	Futures	3538.8	3554.7	3526.4	3549.2	51853.0
2014-09-18	FDAX	Futures	10623.7	10735.9	10610.0	10723.9	70705.0
2014-09-18	FESX	Futures	2341.2	2360.7	2337.5	2354.9	762295.0
2014-09-18	FGBL	Futures	130.37	130.8	130.14	130.28	850390.0
2014-09-18	FGBM	Futures	122.55	122.68	122.35	122.44	550871.0
2014-09-18	FGBS	Futures	110.933	110.943	110.898	110.903	280218.0
2014-09-18	FGBX	Futures	138.16	139.22	137.82	138.0	24880.0
2014-09-18	FMWO	Futures	5777.7	5781.4	5777.7	5781.4	6.0
2014-09-18	FOAT	Futures	120.2	120.47	119.88	119.98	105710.0
2014-09-18	FTDX	Futures	1184.2	1184.2	1174.3	1182.3	1378.0
2014-09-18	FTI	Futures	361.95	364.71	361.0	364.63	19705.0
2014-09-18	FTUK	Futures	5242.3	5256.2	5212.9	5250.8	80772.0
2014-09-18	FVSA	Futures	1388.37	1388.37	1368.07	1380.25	6736.0
2014-09-18	FXXP	Futures	261.0	263.3	261.0	262.9	35859.0
2014-09-18	G	Futures	95.96	96.06	95.48	95.57	182173.0
2014-09-18	GF	Futures	354.789	355.217	352.572	354.244	2196.0
2014-09-18	GSCI	Futures	991.19	992.11	981.76	982.6	42.0
2014-09-18	HE	Futures	125.169	128.366	122.343	126.246	22182.0
2014-09-18	HG	Futures	3.9701	3.9834	3.9194	3.9245	42079.0
2014-09-18	HH	Futures	47.951	47.951	47.889	47.902	10695.0

> showing 50 of 104 rows — these rows as CSV

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