PREVIEW / futures_daily / 2013-07-31

all futures daily files

  file:    by_date/futures_daily/2013/2013-07-31.parquet
  size:    9 KB
  rows:    102

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
2013-07-31	ES	Futures	1734.46	1744.76	1730.6	1730.85	1981532.0
2013-07-31	NQ	Futures	3565.68	3591.71	3561.92	3566.26	254202.0
2013-07-31	YM	Futures	15346.1	15442.2	15294.6	15296.5	168437.0
2013-07-31	CL	Futures	180.15	184.13	179.77	183.43	299127.0
2013-07-31	GC	Futures	1754.2	1771.8	1726.3	1736.5	218787.0
2013-07-31	ZN	Futures	113.559558	113.756076	112.773484	113.587632	1660001.0
2013-07-31	A6	Futures	0.84828	0.84893	0.83514	0.84237	159267.0
2013-07-31	AD	Futures	0.97661	0.98225	0.97369	0.98185	96363.0
2013-07-31	B	Futures	103.98	105.06	102.96	104.83	123850.0
2013-07-31	B6	Futures	1.5975	1.5989	1.5853	1.5981	158665.0
2013-07-31	BFX	Futures	3172.2	3204.3	3172.2	3201.2	109.0
2013-07-31	BR	Futures	0.21529	0.21611	0.21373	0.21598	750.0
2013-07-31	BZ	Futures	104.67	105.69	103.74	105.6	8100.0
2013-07-31	C	Futures	1651.0	1671.0	1641.0	1668.0	9614.0
2013-07-31	CB	Futures	74.066	74.066	73.551	73.551	3.0
2013-07-31	CC	Futures	1709.0	1721.0	1695.0	1717.0	19266.0
2013-07-31	CSC	Futures	3.509	3.509	3.499	3.503	13.0
2013-07-31	CT	Futures	101.88	101.98	101.44	101.98	17.0
2013-07-31	DC	Futures	26.9	27.05	26.79	26.93	256.0
2013-07-31	DX	Futures	78.3	78.649	77.87	77.927	62799.0
2013-07-31	E1	Futures	1.38275	1.39329	1.3771	1.39226	43240.0
2013-07-31	E6	Futures	1.56542	1.5751	1.55881	1.57415	335681.0
2013-07-31	E7	Futures	1.5552	1.5648	1.5482	1.5639	6287.0
2013-07-31	ED	Futures	95.2916	95.2964	95.2869	95.2964	94526.0
2013-07-31	ER	Futures	97.822	97.827	97.817	97.822	48621.0
2013-07-31	EW	Futures	1250.7	1262.2	1249.5	1252.5	28127.0
2013-07-31	FBTP	Futures	77.69	77.77	77.59	77.61	17664.0
2013-07-31	FBTS	Futures	92.988	92.997	92.954	92.963	3832.0
2013-07-31	FCE	Futures	3083.7	3099.2	3065.5	3085.6	93451.0
2013-07-31	FDAX	Futures	9178.6	9219.6	9116.4	9156.4	99016.0
2013-07-31	FESX	Futures	1936.6	1948.5	1928.8	1933.7	887315.0
2013-07-31	FGBL	Futures	119.29	119.7	118.75	119.21	1056712.0
2013-07-31	FGBM	Futures	117.18	117.33	116.9	117.14	649304.0
2013-07-31	FGBS	Futures	110.298	110.323	110.263	110.308	347720.0
2013-07-31	FGBX	Futures	123.38	124.21	122.62	123.63	19831.0
2013-07-31	FMWO	Futures	4957.3	4957.3	4957.3	4957.3	0.0
2013-07-31	FOAT	Futures	106.37	106.73	106.16	106.63	44358.0
2013-07-31	FTDX	Futures	935.7	944.7	932.9	936.7	74.0
2013-07-31	FTI	Futures	321.55	324.09	319.93	322.47	27115.0
2013-07-31	FTUK	Futures	4895.7	4961.7	4881.8	4923.0	123599.0
2013-07-31	FVSA	Futures	2780.62	2816.18	2730.84	2730.84	2493.0
2013-07-31	FXXP	Futures	220.2	221.0	219.1	220.0	1996.0
2013-07-31	G	Futures	95.24	95.51	94.67	94.97	181389.0
2013-07-31	GF	Futures	258.041	259.01	257.577	258.504	1377.0
2013-07-31	GSCI	Futures	1032.2	1047.01	1029.5	1046.11	442.0
2013-07-31	HE	Futures	100.568	101.188	100.232	100.8	7964.0
2013-07-31	HG	Futures	3.8585	3.9702	3.8541	3.9569	66010.0
2013-07-31	HH	Futures	38.052	38.14	37.71	37.964	1287.0
2013-07-31	HO	Futures	2.4133	2.457	2.391	2.4534	63811.0
2013-07-31	HRC	Futures	2238.5	2238.5	2238.5	2238.5	0.0

> showing 50 of 102 rows — these rows as CSV

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