PREVIEW / futures_daily / 2014-01-31

all futures daily files

  file:    by_date/futures_daily/2014/2014-01-31.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-01-31	ES	Futures	1838.53	1843.43	1815.59	1831.32	2389820.0
2014-01-31	NQ	Futures	4046.62	4061.28	3999.77	4039.72	326853.0
2014-01-31	YM	Futures	15716.2	15728.1	15525.5	15605.3	220501.0
2014-01-31	CL	Futures	173.01	173.75	171.47	172.16	253457.0
2014-01-31	GC	Futures	1639.8	1654.1	1632.2	1634.3	116151.0
2014-01-31	ZN	Futures	114.863383	115.292618	114.777536	115.14954	1387281.0
2014-01-31	A6	Futures	0.8349	0.83843	0.82623	0.83109	91671.0
2014-01-31	AD	Futures	0.906	0.91238	0.90114	0.90914	82648.0
2014-01-31	B	Futures	110.12	110.16	108.54	108.65	139455.0
2014-01-31	B6	Futures	1.7321	1.7326	1.7252	1.7258	101561.0
2014-01-31	BFX	Futures	3499.1	3499.1	3496.8	3496.8	9.0
2014-01-31	BR	Futures	0.21246	0.21347	0.21103	0.21287	270.0
2014-01-31	BZ	Futures	112.02	112.31	110.77	110.84	9260.0
2014-01-31	C	Futures	1953.0	1968.0	1944.0	1946.0	6890.0
2014-01-31	CB	Futures	88.567	89.793	88.567	89.793	11.0
2014-01-31	CC	Futures	2162.0	2171.0	2145.0	2161.0	14424.0
2014-01-31	CSC	Futures	4.35	4.381	4.334	4.352	133.0
2014-01-31	CT	Futures	98.09	98.69	97.72	97.86	12382.0
2014-01-31	DC	Futures	33.66	33.94	33.33	33.61	550.0
2014-01-31	DX	Futures	77.194	77.446	77.104	77.411	23497.0
2014-01-31	E1	Futures	1.42274	1.42556	1.41414	1.41516	35045.0
2014-01-31	E6	Futures	1.60034	1.60235	1.59114	1.59173	321695.0
2014-01-31	E7	Futures	1.5897	1.5918	1.5808	1.5813	8874.0
2014-01-31	EBM	Futures	265.21	268.34	264.51	267.99	17894.0
2014-01-31	ED	Futures	95.3758	95.3758	95.3614	95.371	155111.0
2014-01-31	ER	Futures	97.867	97.906	97.862	97.891	156910.0
2014-01-31	EW	Futures	1339.2	1347.7	1321.3	1338.4	26117.0
2014-01-31	FBTP	Futures	83.78	84.22	83.72	84.15	65461.0
2014-01-31	FBTS	Futures	96.187	96.398	96.17	96.31	9838.0
2014-01-31	FCE	Futures	3264.7	3264.7	3186.9	3241.0	188477.0
2014-01-31	FDAX	Futures	10402.5	10408.0	10166.3	10339.8	152418.0
2014-01-31	FESX	Futures	2132.4	2133.1	2083.8	2123.2	1548136.0
2014-01-31	FGBL	Futures	122.05	122.59	121.99	122.44	1081661.0
2014-01-31	FGBM	Futures	119.08	119.39	119.03	119.3	721380.0
2014-01-31	FGBS	Futures	110.643	110.698	110.628	110.683	413480.0
2014-01-31	FGBX	Futures	124.35	125.25	124.23	125.07	26091.0
2014-01-31	FMWO	Futures	5214.5	5249.7	5214.5	5249.7	25.0
2014-01-31	FOAT	Futures	110.35	111.02	110.35	110.97	71814.0
2014-01-31	FTDX	Futures	1137.1	1147.9	1132.9	1146.5	119.0
2014-01-31	FTI	Futures	332.84	332.84	326.16	330.7	48124.0
2014-01-31	FTUK	Futures	4914.7	4916.6	4817.9	4888.6	141235.0
2014-01-31	FVSA	Futures	2065.86	2229.09	2060.76	2127.07	20660.0
2014-01-31	FXXP	Futures	236.5	237.0	232.8	236.2	8881.0
2014-01-31	G	Futures	93.15	93.57	93.1	93.38	194335.0
2014-01-31	GF	Futures	272.03	273.844	270.942	273.159	3762.0
2014-01-31	GSCI	Futures	1022.28	1024.57	1017.69	1017.69	494.0
2014-01-31	HE	Futures	113.405	114.673	113.073	114.492	24750.0
2014-01-31	HG	Futures	4.0713	4.0802	4.0296	4.0379	43091.0
2014-01-31	HH	Futures	52.858	52.9	50.18	52.518	467.0
2014-01-31	HO	Futures	2.4284	2.4456	2.3912	2.3961	78471.0

> showing 50 of 103 rows — these rows as CSV

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