PREVIEW / futures_daily / 2014-07-31

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-31.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-07-31	ES	Futures	2041.24	2041.75	1998.13	1999.42	2772401.0
2014-07-31	NQ	Futures	4579.06	4580.79	4478.68	4482.14	423444.0
2014-07-31	YM	Futures	16973.1	16973.1	16636.1	16642.2	259862.0
2014-07-31	CL	Futures	183.12	183.82	179.67	180.72	335785.0
2014-07-31	GC	Futures	1701.2	1703.6	1680.6	1682.6	143363.0
2014-07-31	ZN	Futures	116.419026	116.49197	115.995949	116.346082	1885354.0
2014-07-31	A6	Futures	0.89866	0.89914	0.89412	0.89547	94497.0
2014-07-31	AD	Futures	0.93033	0.93277	0.9283	0.93073	61510.0
2014-07-31	ALI	Futures	2916.81	2916.81	2916.81	2916.81	31.0
2014-07-31	B	Futures	111.88	112.42	111.23	111.88	139493.0
2014-07-31	B6	Futures	1.7773	1.7787	1.7713	1.7741	106986.0
2014-07-31	BFX	Futures	3760.8	3767.1	3749.1	3752.8	15.0
2014-07-31	BR	Futures	0.23199	0.23199	0.22989	0.23054	1715.0
2014-07-31	BZ	Futures	112.67	113.29	112.11	112.76	14332.0
2014-07-31	C	Futures	2106.0	2125.0	2106.0	2123.0	8062.0
2014-07-31	CB	Futures	128.0	128.279	127.762	128.0	19.0
2014-07-31	CC	Futures	2359.0	2369.0	2342.0	2365.0	13200.0
2014-07-31	CSC	Futures	4.58	4.596	4.544	4.544	13.0
2014-07-31	CT	Futures	79.85	79.85	78.09	78.33	28.0
2014-07-31	DC	Futures	36.98	37.4	36.97	37.0	416.0
2014-07-31	DX	Futures	77.362	77.514	77.329	77.384	24110.0
2014-07-31	E1	Futures	1.41084	1.41276	1.4084	1.41096	46555.0
2014-07-31	E6	Futures	1.58064	1.58146	1.57792	1.58017	167085.0
2014-07-31	E7	Futures	1.5707	1.5712	1.5678	1.5699	1231.0
2014-07-31	ED	Futures	95.4067	95.4115	95.4019	95.4115	124960.0
2014-07-31	ER	Futures	97.886	97.891	97.881	97.886	27472.0
2014-07-31	EW	Futures	1450.9	1451.2	1417.3	1420.6	27434.0
2014-07-31	FBTP	Futures	92.61	92.86	92.42	92.65	66927.0
2014-07-31	FBTS	Futures	98.41	98.481	98.365	98.436	12544.0
2014-07-31	FCE	Futures	3438.4	3450.3	3361.2	3375.9	167476.0
2014-07-31	FDAX	Futures	10571.5	10580.8	10316.5	10372.7	162472.0
2014-07-31	FDIV	Futures	144.29	144.29	142.82	142.82	112.0
2014-07-31	FESX	Futures	2283.6	2287.2	2231.1	2242.6	1591757.0
2014-07-31	FGBL	Futures	128.64	128.93	128.39	128.69	921218.0
2014-07-31	FGBM	Futures	121.59	121.77	121.55	121.69	466245.0
2014-07-31	FGBS	Futures	110.748	110.773	110.743	110.758	259725.0
2014-07-31	FGBX	Futures	135.82	136.45	135.26	135.8	34342.0
2014-07-31	FMWO	Futures	5746.2	5746.2	5709.7	5709.7	82.0
2014-07-31	FOAT	Futures	118.89	119.1	118.66	118.9	100910.0
2014-07-31	FTDX	Futures	1167.3	1167.3	1127.6	1139.3	623.0
2014-07-31	FTI	Futures	352.51	353.47	347.62	349.09	43347.0
2014-07-31	FTUK	Futures	5181.9	5192.7	5114.6	5140.0	127233.0
2014-07-31	FVSA	Futures	1439.1	1524.0	1426.36	1511.27	18029.0
2014-07-31	FXXP	Futures	256.3	256.6	251.9	252.8	10556.0
2014-07-31	G	Futures	94.63	94.72	94.17	94.43	184714.0
2014-07-31	GF	Futures	342.19	342.612	337.631	338.205	3740.0
2014-07-31	GSCI	Futures	1043.83	1046.92	1038.81	1039.64	666.0
2014-07-31	HE	Futures	124.46	126.454	123.254	123.857	11153.0
2014-07-31	HG	Futures	4.1452	4.1637	4.1222	4.1299	43065.0
2014-07-31	HH	Futures	48.163	49.267	47.808	48.76	1178.0

> showing 50 of 104 rows — these rows as CSV

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