PREVIEW / futures_daily / 2011-09-06

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-06.parquet
  size:    9 KB
  rows:    99

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
2011-09-06	ES	Futures	1157.0	1158.74	1128.2	1156.5	3522564.0
2011-09-06	NQ	Futures	2459.15	2472.53	2400.79	2465.7	341285.0
2011-09-06	YM	Futures	10576.2	10585.7	10321.9	10520.5	159174.0
2011-09-06	CL	Futures	164.69	164.96	158.48	163.85	316166.0
2011-09-06	GC	Futures	2538.2	2597.3	2513.7	2529.2	414591.0
2011-09-06	ZN	Futures	111.775073	112.293967	111.615413	111.735158	62875.0
2011-09-06	A6	Futures	0.92065	0.923	0.90987	0.91083	200847.0
2011-09-06	AD	Futures	1.01183	1.01253	1.00105	1.00774	150235.0
2011-09-06	B	Futures	93.49	96.65	93.41	96.04	102898.0
2011-09-06	B6	Futures	1.6806	1.6858	1.6559	1.6575	178104.0
2011-09-06	BFX	Futures	2549.8	2592.0	2530.5	2539.4	159.0
2011-09-06	BR	Futures	0.26808	0.26808	0.26741	0.26799	755.0
2011-09-06	BZ	Futures	97.75	99.84	96.8	99.49	1226.0
2011-09-06	C	Futures	2073.0	2075.0	2022.0	2039.0	5609.0
2011-09-06	CB	Futures	98.628	99.176	98.628	99.176	18.0
2011-09-06	CC	Futures	2405.0	2417.0	2337.0	2343.0	11822.0
2011-09-06	CSC	Futures	4.441	4.441	4.434	4.441	17.0
2011-09-06	CT	Futures	136.64	137.87	135.82	137.87	165.0
2011-09-06	DC	Futures	30.63	30.78	30.46	30.63	103.0
2011-09-06	DX	Futures	74.643	75.381	73.95	75.323	49196.0
2011-09-06	E1	Futures	1.65901	1.673	1.51645	1.51868	79787.0
2011-09-06	E6	Futures	1.682	1.69637	1.65908	1.6611	605886.0
2011-09-06	E7	Futures	1.6709	1.684	1.6471	1.649	8459.0
2011-09-06	ED	Futures	94.9215	94.9311	94.9096	94.9239	230819.0
2011-09-06	ER	Futures	97.559	97.578	97.539	97.569	128004.0
2011-09-06	EW	Futures	821.2	821.5	792.2	818.6	39119.0
2011-09-06	FBTP	Futures	62.31	63.2	62.31	62.77	14518.0
2011-09-06	FBTS	Futures	81.51	81.55	81.213	81.317	2976.0
2011-09-06	FCE	Futures	2091.3	2137.3	2065.0	2082.9	149992.0
2011-09-06	FDAX	Futures	5558.4	5700.5	5505.0	5554.1	252652.0
2011-09-06	FESX	Futures	1336.1	1372.6	1322.6	1335.4	2005418.0
2011-09-06	FEU3	Futures	98.094	98.109	98.084	98.109	516.0
2011-09-06	FGBL	Futures	110.83	111.06	110.09	110.85	924766.0
2011-09-06	FGBM	Futures	111.1	111.16	110.67	111.03	601400.0
2011-09-06	FGBS	Futures	109.302	109.327	109.178	109.263	693598.0
2011-09-06	FGBX	Futures	110.86	110.86	108.13	109.67	35106.0
2011-09-06	FTDX	Futures	623.4	627.9	607.8	615.4	418.0
2011-09-06	FTI	Futures	222.06	226.5	220.59	223.16	58367.0
2011-09-06	FTUK	Futures	3589.3	3678.9	3556.9	3640.1	146905.0
2011-09-06	FVSA	Futures	16338.67	17367.12	16067.01	16998.43	2587.0
2011-09-06	FXXP	Futures	151.4	152.4	149.0	150.4	3653.0
2011-09-06	G	Futures	91.64	91.78	91.13	91.64	151533.0
2011-09-06	GF	Futures	303.035	306.355	302.52	306.355	640.0
2011-09-06	GSCI	Futures	1017.49	1034.4	1014.28	1031.43	179.0
2011-09-06	HE	Futures	104.306	104.428	101.466	101.802	21430.0
2011-09-06	HG	Futures	5.4652	5.4685	5.3222	5.3672	36970.0
2011-09-06	HO	Futures	2.4148	2.444	2.3763	2.4324	15415.0
2011-09-06	HRC	Futures	2910.3	2910.3	2910.3	2910.3	0.0
2011-09-06	J1	Futures	0.016355	0.0163914	0.0161689	0.0161916	200191.0
2011-09-06	J7	Futures	0.016249	0.016281	0.016058	0.016083	1049.0

> showing 50 of 99 rows — these rows as CSV

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