PREVIEW / futures_daily / 2014-01-23

all futures daily files

  file:    by_date/futures_daily/2014/2014-01-23.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-01-23	ES	Futures	1895.74	1900.9	1869.71	1880.54	1815516.0
2014-01-23	NQ	Futures	4167.9	4179.11	4117.32	4154.39	286469.0
2014-01-23	YM	Futures	16290.3	16328.2	16052.6	16125.5	174732.0
2014-01-23	CL	Futures	170.75	172.78	170.26	171.86	274078.0
2014-01-23	GC	Futures	1636.2	1677.6	1629.6	1671.3	209347.0
2014-01-23	ZN	Futures	113.461214	114.376916	113.403983	114.262453	1653026.0
2014-01-23	A6	Futures	0.84005	0.84053	0.82928	0.83205	125339.0
2014-01-23	AD	Futures	0.91187	0.91187	0.90499	0.90995	120858.0
2014-01-23	B	Futures	110.25	110.36	109.53	109.79	188871.0
2014-01-23	B6	Futures	1.7403	1.7478	1.7386	1.7464	134922.0
2014-01-23	BR	Futures	0.21575	0.2164	0.2135	0.21427	923.0
2014-01-23	BZ	Futures	112.45	112.55	111.75	112.01	11238.0
2014-01-23	C	Futures	1820.0	1872.0	1820.0	1871.0	16618.0
2014-01-23	CB	Futures	91.756	92.001	90.296	90.296	56.0
2014-01-23	CC	Futures	2005.0	2077.0	2005.0	2071.0	24917.0
2014-01-23	CNH	Futures	6.9573	6.9573	6.9542	6.9542	6.0
2014-01-23	CSC	Futures	4.097	4.112	4.087	4.112	7.0
2014-01-23	CT	Futures	100.24	100.51	99.14	99.58	12568.0
2014-01-23	DC	Futures	32.12	32.37	31.62	32.01	487.0
2014-01-23	DX	Futures	77.389	77.408	76.543	76.576	34880.0
2014-01-23	E1	Futures	1.40887	1.43275	1.40592	1.43108	56055.0
2014-01-23	E6	Futures	1.59893	1.61711	1.59704	1.61675	316076.0
2014-01-23	E7	Futures	1.5887	1.6066	1.5867	1.6062	9259.0
2014-01-23	EBM	Futures	269.04	272.87	269.04	269.74	15863.0
2014-01-23	ED	Futures	95.3758	95.3758	95.3614	95.3662	187781.0
2014-01-23	ER	Futures	97.847	97.867	97.842	97.862	103974.0
2014-01-23	EW	Futures	1387.4	1389.3	1368.1	1376.2	20995.0
2014-01-23	FBTP	Futures	83.73	83.76	83.48	83.53	40309.0
2014-01-23	FBTS	Futures	96.126	96.152	96.091	96.091	7143.0
2014-01-23	FCE	Futures	3360.4	3375.9	3319.2	3330.8	123303.0
2014-01-23	FDAX	Futures	10769.6	10799.0	10649.8	10698.0	115782.0
2014-01-23	FDIV	Futures	147.27	147.27	146.93	146.93	5.0
2014-01-23	FESX	Futures	2214.0	2222.4	2184.4	2192.9	993943.0
2014-01-23	FGBL	Futures	120.44	121.22	120.3	120.87	861865.0
2014-01-23	FGBM	Futures	118.26	118.65	118.21	118.44	499239.0
2014-01-23	FGBS	Futures	110.478	110.543	110.458	110.493	292832.0
2014-01-23	FGBX	Futures	121.21	122.77	121.09	122.13	20245.0
2014-01-23	FMWO	Futures	5410.7	5410.7	5410.7	5410.7	0.0
2014-01-23	FOAT	Futures	108.95	109.19	108.78	109.1	62946.0
2014-01-23	FTDX	Futures	1191.5	1191.5	1170.9	1172.8	227.0
2014-01-23	FTI	Futures	348.05	348.95	344.32	345.35	26277.0
2014-01-23	FTUK	Futures	5146.4	5147.5	5078.6	5090.3	92163.0
2014-01-23	FVSA	Futures	1790.41	1861.83	1759.81	1841.42	9871.0
2014-01-23	FXXP	Futures	245.6	246.6	243.2	243.8	9224.0
2014-01-23	G	Futures	91.76	92.54	91.72	92.4	223033.0
2014-01-23	GF	Futures	275.013	275.295	272.554	273.884	3765.0
2014-01-23	GSCI	Futures	1024.98	1026.05	1021.62	1022.44	319.0
2014-01-23	HE	Futures	112.257	113.073	111.291	112.257	16858.0
2014-01-23	HG	Futures	4.2008	4.2166	4.1383	4.1496	66314.0
2014-01-23	HH	Futures	48.977	49.388	46.683	47.384	6868.0

> showing 50 of 104 rows — these rows as CSV

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