PREVIEW / futures_daily / 2014-07-09

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-09.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-09	ES	Futures	2036.56	2044.61	2034.22	2043.57	1393006.0
2014-07-09	NQ	Futures	4457.62	4489.06	4449.55	4483.01	244551.0
2014-07-09	YM	Futures	17011.5	17079.1	16989.3	17065.0	115989.0
2014-07-09	CL	Futures	188.97	189.24	186.05	186.85	250987.0
2014-07-09	GC	Futures	1739.7	1756.9	1737.5	1744.9	163179.0
2014-07-09	ZN	Futures	116.49197	116.710803	116.171016	116.696214	1146552.0
2014-07-09	A6	Futures	0.90407	0.90659	0.90253	0.9063	66048.0
2014-07-09	AD	Futures	0.94963	0.95288	0.94902	0.95247	42533.0
2014-07-09	ALI	Futures	2843.42	2843.42	2843.42	2843.42	0.0
2014-07-09	B	Futures	114.6	114.78	113.92	114.09	220325.0
2014-07-09	B6	Futures	1.7998	1.8031	1.7961	1.8028	71708.0
2014-07-09	BR	Futures	0.23437	0.23542	0.23423	0.23423	35.0
2014-07-09	BZ	Futures	115.41	115.5	114.64	114.81	15046.0
2014-07-09	C	Futures	2025.0	2027.0	1992.0	2005.0	17225.0
2014-07-09	CB	Futures	119.616	119.63	118.777	118.777	16.0
2014-07-09	CC	Futures	2291.0	2291.0	2255.0	2268.0	15498.0
2014-07-09	CSC	Futures	4.359	4.379	4.285	4.305	17.0
2014-07-09	CT	Futures	88.8	89.54	88.8	89.0	63.0
2014-07-09	DC	Futures	34.82	34.82	34.21	34.32	274.0
2014-07-09	DX	Futures	76.123	76.199	75.962	75.978	18694.0
2014-07-09	E1	Futures	1.43622	1.44019	1.43494	1.43993	30236.0
2014-07-09	E6	Futures	1.6066	1.61084	1.60542	1.61061	154792.0
2014-07-09	E7	Futures	1.596	1.6003	1.595	1.6001	1636.0
2014-07-09	ED	Futures	95.4115	95.4162	95.4067	95.4115	133113.0
2014-07-09	ER	Futures	97.911	97.916	97.906	97.911	31381.0
2014-07-09	EW	Futures	1473.1	1476.8	1469.6	1475.9	13858.0
2014-07-09	FBTP	Futures	91.64	91.65	91.09	91.35	61932.0
2014-07-09	FBTS	Futures	98.312	98.312	98.188	98.25	10993.0
2014-07-09	FCE	Futures	3474.6	3488.6	3455.9	3481.4	84056.0
2014-07-09	FDAX	Futures	10786.8	10830.8	10743.8	10811.0	83034.0
2014-07-09	FESX	Futures	2293.7	2309.5	2287.9	2303.7	687940.0
2014-07-09	FEU3	Futures	98.537	98.537	98.532	98.532	58.0
2014-07-09	FGBL	Futures	128.17	128.29	128.03	128.11	436753.0
2014-07-09	FGBM	Futures	121.64	121.68	121.59	121.61	304710.0
2014-07-09	FGBS	Futures	110.788	110.793	110.768	110.783	154053.0
2014-07-09	FGBX	Futures	133.17	133.46	132.95	133.19	13174.0
2014-07-09	FMWO	Futures	5794.0	5794.0	5794.0	5794.0	0.0
2014-07-09	FOAT	Futures	118.01	118.13	117.84	117.98	64728.0
2014-07-09	FTDX	Futures	1218.3	1230.5	1209.0	1211.3	421.0
2014-07-09	FTI	Futures	354.9	355.85	353.3	354.77	23872.0
2014-07-09	FTUK	Futures	5145.8	5150.4	5111.2	5131.9	77602.0
2014-07-09	FVSA	Futures	1297.96	1310.85	1263.57	1272.17	7167.0
2014-07-09	FXXP	Futures	255.7	256.2	254.5	255.7	4873.0
2014-07-09	G	Futures	93.96	94.15	93.88	93.9	105001.0
2014-07-09	GF	Futures	332.267	335.025	326.29	327.362	7947.0
2014-07-09	GSCI	Futures	1072.9	1072.9	1064.74	1064.74	2443.0
2014-07-09	HE	Futures	136.555	138.129	134.325	136.004	33351.0
2014-07-09	HG	Futures	4.1688	4.1867	4.149	4.1516	40508.0
2014-07-09	HH	Futures	53.311	53.375	52.73	52.73	559.0
2014-07-09	HO	Futures	2.3121	2.3121	2.2949	2.3037	28079.0

> showing 50 of 103 rows — these rows as CSV

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