PREVIEW / futures_daily / 2011-09-22

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-22.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-22	ES	Futures	1153.22	1156.97	1104.81	1121.53	4741905.0
2011-09-22	NQ	Futures	2563.43	2567.71	2447.85	2482.1	581136.0
2011-09-22	YM	Futures	10567.3	10602.8	10098.5	10231.0	243854.0
2011-09-22	CL	Futures	159.92	160.28	150.21	151.81	459998.0
2011-09-22	GC	Futures	2406.4	2415.4	2326.6	2351.6	278040.0
2011-09-22	ZN	Futures	112.273605	113.145087	112.233383	113.051235	1253817.0
2011-09-22	A6	Futures	0.87472	0.87718	0.84341	0.84561	246294.0
2011-09-22	AD	Futures	0.99225	0.99345	0.96363	0.96914	185292.0
2011-09-22	B	Futures	93.96	93.96	89.97	90.52	299521.0
2011-09-22	B6	Futures	1.6168	1.6182	1.5985	1.6012	154346.0
2011-09-22	BFX	Futures	2434.1	2434.1	2406.8	2412.6	101.0
2011-09-22	BR	Futures	0.23109	0.23963	0.22901	0.23647	180.0
2011-09-22	BZ	Futures	96.57	96.84	93.33	93.76	1204.0
2011-09-22	C	Futures	1869.0	1889.0	1847.0	1877.0	12046.0
2011-09-22	CB	Futures	94.245	94.245	94.245	94.245	5.0
2011-09-22	CC	Futures	2123.0	2132.0	2057.0	2101.0	13728.0
2011-09-22	CSC	Futures	4.215	4.217	4.215	4.217	2.0
2011-09-22	CT	Futures	131.42	131.53	126.23	126.71	35.0
2011-09-22	DC	Futures	29.54	29.81	29.15	29.61	300.0
2011-09-22	DX	Futures	76.966	77.948	76.903	77.654	49360.0
2011-09-22	E1	Futures	1.46042	1.46488	1.43234	1.44795	34551.0
2011-09-22	E6	Futures	1.62274	1.62477	1.59919	1.60923	455837.0
2011-09-22	E7	Futures	1.609	1.6106	1.5856	1.5955	6253.0
2011-09-22	ED	Futures	94.9793	94.9936	94.9507	94.9746	381089.0
2011-09-22	ER	Futures	97.465	97.514	97.45	97.47	210564.0
2011-09-22	EW	Futures	812.2	813.8	772.5	784.0	48259.0
2011-09-22	FBTP	Futures	61.14	61.76	60.68	61.65	9637.0
2011-09-22	FBTS	Futures	81.43	81.847	81.43	81.791	2301.0
2011-09-22	FCE	Futures	2043.8	2059.9	1960.6	1988.8	161590.0
2011-09-22	FDAX	Futures	5741.8	5768.4	5545.8	5620.7	232065.0
2011-09-22	FESX	Futures	1346.3	1355.6	1301.8	1321.0	2088078.0
2011-09-22	FEU3	Futures	98.049	98.049	98.024	98.029	222.0
2011-09-22	FGBL	Futures	111.85	112.52	111.83	112.11	1025435.0
2011-09-22	FGBM	Futures	111.29	111.64	111.23	111.42	478193.0
2011-09-22	FGBS	Futures	109.268	109.372	109.233	109.273	582916.0
2011-09-22	FGBX	Futures	114.93	117.29	114.93	116.26	6426.0
2011-09-22	FTDX	Futures	618.7	618.7	598.0	599.8	273.0
2011-09-22	FTI	Futures	223.62	224.7	216.72	218.84	71576.0
2011-09-22	FTUK	Futures	3706.9	3710.4	3561.2	3599.2	180674.0
2011-09-22	FVSA	Futures	18596.23	19441.51	18596.23	19040.0	6896.0
2011-09-22	FXXP	Futures	152.8	152.9	149.2	149.5	1836.0
2011-09-22	G	Futures	92.64	93.12	92.49	92.78	181222.0
2011-09-22	GF	Futures	309.228	309.454	304.529	304.756	2675.0
2011-09-22	GSCI	Futures	967.45	973.15	958.03	960.01	481.0
2011-09-22	HE	Futures	107.137	107.555	104.856	105.402	21748.0
2011-09-22	HG	Futures	4.8948	4.9226	4.515	4.6163	80756.0
2011-09-22	HO	Futures	2.346	2.3528	2.2806	2.3006	32269.0
2011-09-22	HRC	Futures	2767.8	2767.8	2767.8	2767.8	100.0
2011-09-22	J1	Futures	0.0164542	0.0165321	0.0163172	0.016463	118784.0
2011-09-22	J7	Futures	0.016316	0.016432	0.016178	0.016363	933.0

> showing 50 of 98 rows — these rows as CSV

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