PREVIEW / futures_daily / 2014-01-27

all futures daily files

  file:    by_date/futures_daily/2014/2014-01-27.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-27	ES	Futures	1836.73	1847.29	1821.52	1830.54	2776036.0
2014-01-27	NQ	Futures	4060.13	4075.36	3986.84	4027.07	444255.0
2014-01-27	YM	Futures	15776.1	15861.9	15697.2	15762.1	257321.0
2014-01-27	CL	Futures	171.12	171.62	168.14	169.04	235110.0
2014-01-27	GC	Futures	1674.0	1687.4	1650.4	1665.5	64820.0
2014-01-27	ZN	Futures	114.648765	114.734612	114.291069	114.291069	1257348.0
2014-01-27	A6	Futures	0.82585	0.83224	0.82423	0.83128	82732.0
2014-01-27	AD	Futures	0.9138	0.91683	0.90964	0.91137	53233.0
2014-01-27	B	Futures	110.19	110.26	108.66	108.87	107543.0
2014-01-27	B6	Futures	1.7308	1.742	1.7297	1.7405	83589.0
2014-01-27	BFX	Futures	3474.1	3484.9	3474.1	3484.2	5.0
2014-01-27	BR	Futures	0.21386	0.21456	0.21166	0.21215	642.0
2014-01-27	BZ	Futures	111.89	112.16	110.88	111.08	6560.0
2014-01-27	C	Futures	1870.0	1936.0	1854.0	1932.0	17894.0
2014-01-27	CB	Futures	92.443	92.443	90.775	90.775	4.0
2014-01-27	CC	Futures	2075.0	2155.0	2061.0	2144.0	32753.0
2014-01-27	CNH	Futures	6.9642	6.9654	6.9609	6.9634	48.0
2014-01-27	CSC	Futures	4.164	4.176	4.164	4.176	4.0
2014-01-27	CT	Futures	99.2	99.38	95.39	96.06	27486.0
2014-01-27	DC	Futures	32.03	32.5	31.82	32.5	272.0
2014-01-27	DX	Futures	76.581	76.695	76.447	76.659	14359.0
2014-01-27	E1	Futures	1.43583	1.43776	1.42941	1.43134	30249.0
2014-01-27	E6	Futures	1.61498	1.61923	1.61156	1.61321	161699.0
2014-01-27	E7	Futures	1.6047	1.6086	1.601	1.6027	4432.0
2014-01-27	EBM	Futures	268.34	272.17	268.34	270.43	9647.0
2014-01-27	ED	Futures	95.3566	95.371	95.3519	95.3662	147560.0
2014-01-27	ER	Futures	97.842	97.867	97.832	97.842	52437.0
2014-01-27	EW	Futures	1336.4	1345.5	1319.6	1328.5	27577.0
2014-01-27	FBTP	Futures	83.22	83.33	83.0	83.26	44593.0
2014-01-27	FBTS	Futures	96.012	96.047	95.951	96.012	9444.0
2014-01-27	FCE	Futures	3222.7	3246.0	3206.4	3223.5	179194.0
2014-01-27	FDAX	Futures	10362.6	10439.6	10303.8	10395.3	160553.0
2014-01-27	FESX	Futures	2116.2	2138.0	2102.8	2121.1	1349144.0
2014-01-27	FGBL	Futures	121.37	121.42	121.18	121.3	555182.0
2014-01-27	FGBM	Futures	118.67	118.73	118.58	118.65	360413.0
2014-01-27	FGBS	Futures	110.553	110.563	110.523	110.548	279007.0
2014-01-27	FGBX	Futures	123.1	123.3	122.93	123.1	11960.0
2014-01-27	FMWO	Futures	5277.4	5277.4	5268.5	5268.5	6.0
2014-01-27	FOAT	Futures	109.57	109.76	109.52	109.67	50124.0
2014-01-27	FTDX	Futures	1136.2	1140.8	1117.4	1123.9	801.0
2014-01-27	FTI	Futures	335.15	336.74	331.9	334.08	42468.0
2014-01-27	FTUK	Futures	4960.2	4980.6	4887.5	4924.6	155007.0
2014-01-27	FVSA	Futures	1989.35	2030.16	1933.24	2014.85	18878.0
2014-01-27	FXXP	Futures	237.4	237.4	234.6	236.2	20955.0
2014-01-27	G	Futures	92.61	92.78	92.47	92.69	113929.0
2014-01-27	GF	Futures	271.587	272.675	270.055	272.151	2520.0
2014-01-27	GSCI	Futures	1027.36	1027.36	1012.61	1013.51	788.0
2014-01-27	HE	Futures	113.435	114.129	112.62	113.888	16415.0
2014-01-27	HG	Futures	4.1187	4.1522	4.1092	4.1162	44401.0
2014-01-27	HH	Futures	51.912	52.539	49.5	49.66	849.0

> showing 50 of 104 rows — these rows as CSV

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