PREVIEW / futures_daily / 2014-07-14

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-14.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-07-14	ES	Futures	2038.9	2050.58	2038.64	2047.47	1003831.0
2014-07-14	NQ	Futures	4497.43	4535.22	4497.14	4521.95	163878.0
2014-07-14	YM	Futures	17029.6	17169.9	17028.6	17130.5	92371.0
2014-07-14	CL	Futures	184.18	185.53	183.58	184.98	151215.0
2014-07-14	GC	Futures	1764.9	1766.8	1715.8	1721.7	208856.0
2014-07-14	ZN	Futures	116.915047	116.944225	116.681625	116.681625	558109.0
2014-07-14	A6	Futures	0.90291	0.90485	0.90262	0.90369	34465.0
2014-07-14	AD	Futures	0.94485	0.94698	0.94353	0.94648	44031.0
2014-07-14	ALI	Futures	2859.67	2859.67	2859.67	2859.67	0.0
2014-07-14	B	Futures	112.77	113.72	112.46	113.29	299036.0
2014-07-14	B6	Futures	1.7987	1.8015	1.7936	1.7947	76426.0
2014-07-14	BFX	Futures	3768.6	3785.6	3768.6	3777.5	17.0
2014-07-14	BR	Futures	0.23355	0.23521	0.23342	0.235	759.0
2014-07-14	BZ	Futures	113.62	114.42	113.18	114.01	13571.0
2014-07-14	C	Futures	2022.0	2028.0	2011.0	2021.0	8115.0
2014-07-14	CB	Futures	120.314	121.348	120.314	121.348	7.0
2014-07-14	CC	Futures	2269.0	2273.0	2259.0	2265.0	7140.0
2014-07-14	CSC	Futures	4.265	4.325	4.265	4.316	15.0
2014-07-14	CT	Futures	87.06	87.66	86.29	86.54	24.0
2014-07-14	DC	Futures	34.49	34.99	34.4	34.91	198.0
2014-07-14	DX	Futures	76.147	76.209	76.052	76.157	8429.0
2014-07-14	E1	Futures	1.43737	1.44147	1.43583	1.43788	30865.0
2014-07-14	E6	Futures	1.60601	1.6099	1.60483	1.60731	106672.0
2014-07-14	E7	Futures	1.5955	1.5994	1.5944	1.5968	1148.0
2014-07-14	ED	Futures	95.4162	95.4162	95.4115	95.4162	48876.0
2014-07-14	ER	Futures	97.901	97.906	97.896	97.901	17340.0
2014-07-14	EW	Futures	1465.1	1474.0	1463.7	1467.4	10446.0
2014-07-14	FBTP	Futures	91.28	91.5	91.09	91.35	27813.0
2014-07-14	FBTS	Futures	98.223	98.276	98.205	98.223	6225.0
2014-07-14	FCE	Futures	3447.5	3465.4	3439.5	3460.2	31652.0
2014-07-14	FDAX	Futures	10692.6	10791.7	10676.1	10782.9	68175.0
2014-07-14	FESX	Futures	2279.3	2293.7	2275.0	2290.8	563812.0
2014-07-14	FGBL	Futures	128.26	128.4	128.23	128.33	232401.0
2014-07-14	FGBM	Futures	121.66	121.7	121.63	121.68	159441.0
2014-07-14	FGBS	Futures	110.783	110.788	110.768	110.778	73218.0
2014-07-14	FGBX	Futures	133.82	134.21	133.74	134.06	7127.0
2014-07-14	FMWO	Futures	5806.6	5811.6	5806.6	5809.1	26.0
2014-07-14	FOAT	Futures	118.04	118.13	117.97	118.05	28057.0
2014-07-14	FTDX	Futures	1190.7	1204.8	1190.7	1200.1	266.0
2014-07-14	FTI	Futures	349.39	351.39	348.66	350.91	4080.0
2014-07-14	FTUK	Futures	5114.2	5163.5	5112.3	5154.2	65027.0
2014-07-14	FVSA	Futures	1383.91	1388.16	1349.95	1354.2	7285.0
2014-07-14	FXXP	Futures	254.0	255.7	253.9	255.6	5409.0
2014-07-14	G	Futures	94.44	94.52	94.32	94.41	75526.0
2014-07-14	GF	Futures	323.722	325.485	320.619	322.879	5522.0
2014-07-14	GSCI	Futures	1055.54	1059.05	1053.78	1058.88	1246.0
2014-07-14	HE	Futures	135.899	137.709	135.611	136.791	22231.0
2014-07-14	HG	Futures	4.1804	4.211	4.1458	4.1529	35265.0
2014-07-14	HH	Futures	51.883	52.603	51.819	52.439	774.0
2014-07-14	HO	Futures	2.2996	2.3135	2.2922	2.3041	27728.0

> showing 50 of 103 rows — these rows as CSV

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