PREVIEW / futures_daily / 2014-11-17

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-17.parquet
  size:    9 KB
  rows:    103

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-11-17	ES	Futures	2129.39	2131.48	2115.55	2130.69	1061143.0
2014-11-17	NQ	Futures	4894.65	4896.09	4857.85	4881.9	230967.0
2014-11-17	YM	Futures	17862.7	17897.2	17765.3	17872.9	98261.0
2014-11-17	CL	Futures	146.31	146.82	144.1	145.85	142710.0
2014-11-17	GC	Futures	1555.0	1565.6	1548.8	1552.3	199521.0
2014-11-17	ZN	Futures	118.656534	119.022622	118.480811	118.524742	993852.0
2014-11-17	A6	Futures	0.84925	0.85304	0.84332	0.84469	82561.0
2014-11-17	AD	Futures	0.89914	0.90097	0.89609	0.89772	46606.0
2014-11-17	ALI	Futures	3066.06	3066.06	3066.06	3066.06	0.0
2014-11-17	B	Futures	82.2	82.3	80.58	82.0	189076.0
2014-11-17	B6	Futures	1.6463	1.6537	1.6415	1.6438	77257.0
2014-11-17	BR	Futures	0.20627	0.20837	0.20546	0.20667	842.0
2014-11-17	BZ	Futures	82.73	82.97	81.41	82.83	12896.0
2014-11-17	C	Futures	2007.0	2024.0	1998.0	2020.0	3995.0
2014-11-17	CB	Futures	135.656	137.197	134.307	137.197	12.0
2014-11-17	CC	Futures	2061.0	2091.0	2059.0	2087.0	8056.0
2014-11-17	CNH	Futures	7.0369	7.0369	7.0346	7.0346	1.0
2014-11-17	CSC	Futures	4.88	4.888	4.728	4.736	34.0
2014-11-17	CT	Futures	75.47	75.6	74.33	74.52	8998.0
2014-11-17	DC	Futures	39.3	39.66	38.24	38.24	789.0
2014-11-17	DX	Futures	83.204	83.588	82.805	83.545	28651.0
2014-11-17	E1	Futures	1.333	1.33888	1.32469	1.32571	36594.0
2014-11-17	E6	Futures	1.47386	1.48092	1.46515	1.46597	188393.0
2014-11-17	E7	Futures	1.4648	1.4715	1.4561	1.4568	2765.0
2014-11-17	ED	Futures	95.4398	95.4422	95.4398	95.4398	69541.0
2014-11-17	ER	Futures	97.994	98.004	97.994	97.999	14779.0
2014-11-17	EW	Futures	1489.5	1491.2	1480.8	1489.4	11671.0
2014-11-17	FBTP	Futures	95.48	95.95	95.39	95.87	47900.0
2014-11-17	FBTS	Futures	98.499	98.561	98.472	98.552	12422.0
2014-11-17	FCE	Futures	3377.7	3427.6	3366.4	3415.0	70252.0
2014-11-17	FDAX	Futures	10048.6	10223.8	9996.0	10193.7	108261.0
2014-11-17	FESX	Futures	2194.8	2236.9	2184.7	2228.9	900995.0
2014-11-17	FGBL	Futures	133.92	133.98	133.47	133.61	545481.0
2014-11-17	FGBM	Futures	123.33	123.35	123.19	123.22	222590.0
2014-11-17	FGBS	Futures	110.908	110.913	110.888	110.898	145939.0
2014-11-17	FGBX	Futures	147.2	147.47	146.2	146.64	20806.0
2014-11-17	FMWO	Futures	5693.7	5710.0	5692.4	5702.4	237.0
2014-11-17	FOAT	Futures	123.27	123.46	122.88	123.1	60083.0
2014-11-17	FTDX	Futures	1188.5	1213.1	1185.2	1212.1	327.0
2014-11-17	FTI	Futures	355.94	360.55	355.25	359.94	2734.0
2014-11-17	FTUK	Futures	5113.9	5168.0	5113.1	5153.7	67237.0
2014-11-17	FVSA	Futures	1591.15	1617.52	1551.59	1560.38	8433.0
2014-11-17	FXXP	Futures	252.2	256.1	251.6	255.6	4484.0
2014-11-17	G	Futures	99.89	100.17	99.7	99.83	150351.0
2014-11-17	GF	Futures	378.9	382.43	378.86	381.026	3584.0
2014-11-17	GSCI	Futures	874.62	882.05	874.2	880.19	171.0
2014-11-17	HE	Futures	124.732	124.866	123.189	124.262	12383.0
2014-11-17	HG	Futures	3.8699	3.8826	3.8344	3.8553	38616.0
2014-11-17	HH	Futures	49.759	51.738	49.759	51.738	1972.0
2014-11-17	HO	Futures	1.9235	1.9235	1.888	1.9136	12942.0

> showing 50 of 103 rows — these rows as CSV

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