PREVIEW / futures_daily / 2014-08-21

all futures daily files

  file:    by_date/futures_daily/2014/2014-08-21.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-08-21	ES	Futures	2059.67	2069.28	2057.6	2066.69	841545.0
2014-08-21	NQ	Futures	4660.98	4671.65	4652.9	4669.92	145148.0
2014-08-21	YM	Futures	17100.3	17203.2	17091.2	17168.9	84581.0
2014-08-21	CL	Futures	174.14	175.93	172.3	175.02	226343.0
2014-08-21	GC	Futures	1694.5	1694.7	1670.3	1672.9	145351.0
2014-08-21	ZN	Futures	117.571545	117.7612	117.440246	117.659078	1138277.0
2014-08-21	A6	Futures	0.89586	0.89847	0.89122	0.89769	78379.0
2014-08-21	AD	Futures	0.92525	0.92779	0.92383	0.92728	34921.0
2014-08-21	ALI	Futures	2971.62	2971.62	2971.62	2971.62	0.0
2014-08-21	B	Futures	107.27	107.95	106.29	107.79	179611.0
2014-08-21	B6	Futures	1.7444	1.7449	1.7411	1.7433	63504.0
2014-08-21	BFX	Futures	3822.7	3842.2	3822.3	3839.1	14.0
2014-08-21	BR	Futures	0.23265	0.23334	0.23168	0.23234	853.0
2014-08-21	BZ	Futures	108.23	108.79	107.14	108.63	8468.0
2014-08-21	C	Futures	2173.0	2181.0	2157.0	2158.0	2938.0
2014-08-21	CB	Futures	151.616	152.035	151.616	152.035	7.0
2014-08-21	CC	Futures	2376.0	2386.0	2356.0	2362.0	9540.0
2014-08-21	CNH	Futures	7.0665	7.0681	7.0622	7.0622	5.0
2014-08-21	CSC	Futures	4.935	5.027	4.935	5.024	16.0
2014-08-21	CT	Futures	82.81	85.33	82.81	83.89	110.0
2014-08-21	DC	Futures	40.19	41.26	40.19	40.93	401.0
2014-08-21	DX	Futures	78.112	78.112	78.034	78.034	29354.0
2014-08-21	E1	Futures	1.40327	1.40712	1.40186	1.40673	28077.0
2014-08-21	E6	Futures	1.56436	1.56813	1.56259	1.56719	131932.0
2014-08-21	E7	Futures	1.5545	1.5579	1.5525	1.557	2746.0
2014-08-21	ED	Futures	95.4162	95.4186	95.4139	95.4162	98052.0
2014-08-21	ER	Futures	97.92	97.92	97.911	97.916	24847.0
2014-08-21	EW	Futures	1476.7	1482.0	1472.0	1481.0	9765.0
2014-08-21	FBTP	Futures	93.47	93.73	93.3	93.62	55071.0
2014-08-21	FBTS	Futures	98.694	98.774	98.676	98.756	8900.0
2014-08-21	FCE	Futures	3387.9	3420.2	3368.4	3417.8	73276.0
2014-08-21	FDAX	Futures	10290.1	10360.6	10216.3	10345.7	85534.0
2014-08-21	FESX	Futures	2220.3	2246.9	2210.2	2245.5	707811.0
2014-08-21	FGBL	Futures	130.55	130.78	130.39	130.62	590666.0
2014-08-21	FGBM	Futures	122.22	122.29	122.16	122.23	275419.0
2014-08-21	FGBS	Futures	110.828	110.843	110.823	110.838	146318.0
2014-08-21	FGBX	Futures	141.02	141.67	140.82	141.27	23857.0
2014-08-21	FMWO	Futures	5782.7	5791.5	5777.7	5791.5	469.0
2014-08-21	FOAT	Futures	120.56	120.69	120.32	120.57	70978.0
2014-08-21	FTDX	Futures	1143.0	1148.6	1142.1	1148.6	71.0
2014-08-21	FTI	Futures	347.6	350.06	346.83	349.5	23046.0
2014-08-21	FTUK	Futures	5201.2	5212.7	5189.2	5206.2	57539.0
2014-08-21	FVSA	Futures	1455.08	1472.2	1425.12	1437.96	7113.0
2014-08-21	FXXP	Futures	252.8	254.3	252.2	254.1	3789.0
2014-08-21	G	Futures	96.12	96.43	95.82	96.34	220080.0
2014-08-21	GF	Futures	327.291	328.106	323.064	324.887	2723.0
2014-08-21	GSCI	Futures	1004.87	1013.34	1004.87	1013.17	31.0
2014-08-21	HE	Futures	111.586	114.911	109.35	113.188	29479.0
2014-08-21	HG	Futures	4.0545	4.0646	4.0228	4.0526	16462.0
2014-08-21	HH	Futures	49.128	49.369	48.239	49.369	6532.0

> showing 50 of 104 rows — these rows as CSV

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