PREVIEW / futures_daily / 2011-09-23

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-23.parquet
  size:    9 KB
  rows:    96

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-23	ES	Futures	1122.28	1136.5	1100.07	1127.77	3365634.0
2011-09-23	NQ	Futures	2485.81	2522.9	2435.87	2513.49	398446.0
2011-09-23	YM	Futures	10231.0	10351.1	10057.1	10276.2	167285.0
2011-09-23	CL	Futures	151.6	154.26	146.23	150.57	427569.0
2011-09-23	GC	Futures	2347.9	2373.4	2203.0	2214.0	359497.0
2011-09-23	ZN	Futures	112.957383	113.212124	112.193161	112.380865	1342588.0
2011-09-23	A6	Futures	0.84825	0.85898	0.84165	0.84737	220173.0
2011-09-23	AD	Futures	0.97044	0.97694	0.96503	0.96744	149525.0
2011-09-23	B	Futures	90.4	91.81	88.75	89.21	237761.0
2011-09-23	B6	Futures	1.6	1.6157	1.5998	1.6085	128635.0
2011-09-23	BFX	Futures	2418.4	2436.5	2361.7	2433.7	45.0
2011-09-23	BR	Futures	0.23217	0.24324	0.23217	0.24044	777.0
2011-09-23	BZ	Futures	93.96	95.0	91.98	92.41	1277.0
2011-09-23	C	Futures	1881.0	1883.0	1830.0	1835.0	7883.0
2011-09-23	CC	Futures	2117.0	2124.0	2049.0	2065.0	12485.0
2011-09-23	CT	Futures	127.18	129.76	127.18	129.76	67.0
2011-09-23	DC	Futures	29.69	29.71	29.27	29.32	55.0
2011-09-23	DX	Futures	77.457	77.87	77.153	77.779	36314.0
2011-09-23	E1	Futures	1.44874	1.46212	1.44808	1.44953	26920.0
2011-09-23	E6	Futures	1.60852	1.62107	1.60326	1.60816	359907.0
2011-09-23	E7	Futures	1.5961	1.6071	1.5896	1.5944	4718.0
2011-09-23	ED	Futures	94.9793	95.0032	94.965	94.9936	216670.0
2011-09-23	ER	Futures	97.47	97.544	97.47	97.499	230947.0
2011-09-23	EW	Futures	784.6	795.6	768.1	792.9	37857.0
2011-09-23	FBTP	Futures	61.43	62.03	61.36	61.71	6744.0
2011-09-23	FBTS	Futures	81.807	81.936	81.655	81.831	2030.0
2011-09-23	FCE	Futures	2000.6	2022.1	1923.8	2007.8	185874.0
2011-09-23	FDAX	Futures	5638.6	5691.9	5407.4	5639.7	229338.0
2011-09-23	FESX	Futures	1327.0	1349.0	1279.2	1338.3	1968973.0
2011-09-23	FEU3	Futures	98.094	98.094	98.059	98.059	2.0
2011-09-23	FGBL	Futures	112.28	112.62	111.23	111.75	898129.0
2011-09-23	FGBM	Futures	111.58	111.83	111.23	111.34	480007.0
2011-09-23	FGBS	Futures	109.342	109.456	109.253	109.307	572521.0
2011-09-23	FGBX	Futures	116.54	117.51	115.97	116.45	6230.0
2011-09-23	FTDX	Futures	607.2	607.2	578.2	599.4	431.0
2011-09-23	FTI	Futures	220.17	222.08	212.9	220.05	74145.0
2011-09-23	FTUK	Futures	3620.7	3645.1	3515.6	3609.3	161050.0
2011-09-23	FVSA	Futures	18807.55	19969.82	18807.55	19018.87	3452.0
2011-09-23	FXXP	Futures	149.7	150.7	145.5	150.1	2718.0
2011-09-23	G	Futures	92.66	93.09	92.42	92.51	138574.0
2011-09-23	GF	Futures	303.228	307.133	302.888	305.265	1967.0
2011-09-23	GSCI	Futures	960.01	961.43	941.63	948.13	370.0
2011-09-23	HE	Futures	105.852	107.941	105.659	107.619	16616.0
2011-09-23	HG	Futures	4.5653	4.6249	4.2544	4.3404	78916.0
2011-09-23	HO	Futures	2.3009	2.3226	2.2569	2.259	24604.0
2011-09-23	HRC	Futures	2767.8	2767.8	2767.8	2767.8	0.0
2011-09-23	J1	Futures	0.0164856	0.0165208	0.0163574	0.0163951	73208.0
2011-09-23	J7	Futures	0.016372	0.016419	0.016262	0.016296	521.0
2011-09-23	JB	Futures	124.71	124.73	124.57	124.66	364.0
2011-09-23	KC	Futures	565.31	570.14	543.87	545.4	18571.0

> showing 50 of 96 rows — these rows as CSV

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