PREVIEW / futures_daily / 2011-09-26

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-26.parquet
  size:    9 KB
  rows:    98

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-26	ES	Futures	1120.03	1156.97	1113.05	1156.47	3089036.0
2011-09-26	NQ	Futures	2500.36	2548.3	2468.11	2540.88	390098.0
2011-09-26	YM	Futures	10221.4	10548.0	10135.9	10540.4	151762.0
2011-09-26	CL	Futures	150.17	153.79	145.4	151.3	325671.0
2011-09-26	GC	Futures	2241.3	2249.8	2072.5	2153.2	373462.0
2011-09-26	ZN	Futures	112.085902	112.501531	111.790939	111.844569	1039457.0
2011-09-26	A6	Futures	0.85185	0.85651	0.8376	0.84939	166099.0
2011-09-26	AD	Futures	0.97074	0.97414	0.96143	0.96704	131869.0
2011-09-26	B	Futures	89.21	90.75	87.53	89.61	138947.0
2011-09-26	B6	Futures	1.6139	1.6238	1.6095	1.6189	116272.0
2011-09-26	BFX	Futures	2437.3	2486.6	2437.3	2483.5	59.0
2011-09-26	BR	Futures	0.24143	0.2418	0.24044	0.2418	160.0
2011-09-26	BZ	Futures	92.41	95.79	92.41	94.71	1029.0
2011-09-26	C	Futures	1826.0	1860.0	1822.0	1849.0	7689.0
2011-09-26	CB	Futures	94.245	94.245	93.697	94.245	24.0
2011-09-26	CC	Futures	2059.0	2114.0	2047.0	2100.0	9973.0
2011-09-26	CSC	Futures	4.215	4.215	4.142	4.154	92.0
2011-09-26	CT	Futures	129.76	131.89	128.3	128.46	9215.0
2011-09-26	DC	Futures	29.24	29.24	28.48	28.73	299.0
2011-09-26	DX	Futures	77.551	78.189	77.251	77.617	27912.0
2011-09-26	E1	Futures	1.45438	1.46015	1.43785	1.45136	22554.0
2011-09-26	E6	Futures	1.61366	1.61891	1.59644	1.60864	399493.0
2011-09-26	E7	Futures	1.5987	1.6051	1.5829	1.5949	5576.0
2011-09-26	ED	Futures	94.9984	95.0175	94.9698	95.008	179226.0
2011-09-26	ER	Futures	97.524	97.554	97.485	97.494	196840.0
2011-09-26	EW	Futures	789.1	810.7	781.0	809.3	33008.0
2011-09-26	FBTP	Futures	62.14	62.14	61.37	61.69	5348.0
2011-09-26	FBTS	Futures	81.799	81.952	81.631	81.679	1238.0
2011-09-26	FCE	Futures	1989.9	2085.6	1953.8	2043.5	168956.0
2011-09-26	FDAX	Futures	5600.6	5891.1	5521.4	5812.4	242973.0
2011-09-26	FESX	Futures	1325.7	1400.8	1306.4	1378.9	2036853.0
2011-09-26	FEU3	Futures	98.054	98.054	98.054	98.054	8.0
2011-09-26	FGBL	Futures	111.61	111.97	110.72	111.06	943981.0
2011-09-26	FGBM	Futures	111.42	111.55	110.82	111.05	490463.0
2011-09-26	FGBS	Futures	109.377	109.392	109.133	109.213	613652.0
2011-09-26	FGBX	Futures	116.89	117.02	114.76	115.13	8483.0
2011-09-26	FTDX	Futures	588.8	612.7	583.3	604.9	367.0
2011-09-26	FTI	Futures	217.68	226.98	215.19	224.03	64617.0
2011-09-26	FTUK	Futures	3651.2	3687.8	3533.2	3631.9	152945.0
2011-09-26	FVSA	Futures	19441.51	19441.51	18258.12	19040.0	11509.0
2011-09-26	FXXP	Futures	148.5	154.7	148.5	152.9	3014.0
2011-09-26	G	Futures	92.72	92.72	92.03	92.15	138784.0
2011-09-26	GF	Futures	308.831	312.058	308.831	312.058	1042.0
2011-09-26	GSCI	Futures	947.57	958.34	938.62	948.92	519.0
2011-09-26	HE	Futures	107.619	108.166	106.623	106.687	14684.0
2011-09-26	HG	Futures	4.3907	4.4436	4.0645	4.3443	76474.0
2011-09-26	HO	Futures	2.2614	2.2901	2.2238	2.2573	28165.0
2011-09-26	HRC	Futures	2747.5	2767.8	2747.5	2767.8	10.0
2011-09-26	J1	Futures	0.0164228	0.0165132	0.0163851	0.0164466	104105.0
2011-09-26	J7	Futures	0.016314	0.016411	0.016286	0.016347	669.0

> showing 50 of 98 rows — these rows as CSV

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