PREVIEW / futures_daily / 2011-06-20

all futures daily files

  file:    by_date/futures_daily/2011/2011-06-20.parquet
  size:    9 KB
  rows:    94

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-06-20	ES	Futures	1256.31	1266.49	1247.62	1265.0	1675608.0
2011-06-20	NQ	Futures	2493.31	2513.24	2475.66	2505.27	215125.0
2011-06-20	YM	Futures	11273.0	11375.1	11204.0	11357.2	99165.0
2011-06-20	CL	Futures	178.77	180.12	175.59	179.66	277378.0
2011-06-20	GC	Futures	2086.0	2095.4	2075.6	2087.0	95171.0
2011-06-20	ZN	Futures	105.468516	105.88097	105.295552	105.428601	1041792.0
2011-06-20	A6	Futures	0.91187	0.913	0.90265	0.90935	90593.0
2011-06-20	AD	Futures	1.01562	1.01812	1.01103	1.01672	54192.0
2011-06-20	B	Futures	96.65	97.0	95.17	95.56	173716.0
2011-06-20	B6	Futures	1.68	1.687	1.6738	1.6814	81753.0
2011-06-20	BFX	Futures	3022.6	3026.5	3008.8	3013.6	194.0
2011-06-20	BR	Futures	0.27415	0.27546	0.27386	0.27492	30.0
2011-06-20	BZ	Futures	99.99	100.41	99.3	99.65	667.0
2011-06-20	C	Futures	1977.0	2012.0	1957.0	2010.0	2318.0
2011-06-20	CB	Futures	115.614	116.162	115.614	116.162	6.0
2011-06-20	CC	Futures	2312.0	2363.0	2284.0	2353.0	6849.0
2011-06-20	CT	Futures	143.91	149.06	142.63	147.21	3995.0
2011-06-20	DC	Futures	30.49	30.83	30.49	30.59	70.0
2011-06-20	DX	Futures	74.885	75.217	74.638	74.772	24589.0
2011-06-20	E1	Futures	1.54143	1.55687	1.53646	1.54614	36517.0
2011-06-20	E6	Futures	1.69091	1.69732	1.68105	1.69447	241768.0
2011-06-20	E7	Futures	1.6786	1.6848	1.6689	1.6821	5378.0
2011-06-20	ED	Futures	94.9144	94.9382	94.9001	94.9049	321971.0
2011-06-20	ER	Futures	97.281	97.296	97.272	97.291	95463.0
2011-06-20	EW	Futures	920.8	932.3	914.1	931.1	17840.0
2011-06-20	FBTP	Futures	65.01	65.01	64.75	64.9	6296.0
2011-06-20	FCE	Futures	2631.2	2646.5	2602.0	2641.6	110226.0
2011-06-20	FDAX	Futures	7627.0	7687.9	7571.5	7671.4	135046.0
2011-06-20	FESX	Futures	1761.3	1769.6	1742.7	1764.5	1277313.0
2011-06-20	FGBL	Futures	101.32	101.55	101.06	101.2	836458.0
2011-06-20	FGBM	Futures	105.5	105.72	105.32	105.43	512123.0
2011-06-20	FGBS	Futures	107.199	107.298	107.134	107.179	517898.0
2011-06-20	FGBX	Futures	96.41	96.83	95.61	95.81	5813.0
2011-06-20	FTDX	Futures	772.1	775.7	769.9	773.0	218.0
2011-06-20	FTI	Futures	272.0	273.32	269.83	272.58	30256.0
2011-06-20	FTUK	Futures	3992.8	4003.1	3957.6	3992.5	86271.0
2011-06-20	FXXP	Futures	178.7	179.5	178.3	179.5	3111.0
2011-06-20	G	Futures	85.08	85.2	84.78	84.87	81922.0
2011-06-20	GF	Futures	311.419	315.254	310.722	314.905	3383.0
2011-06-20	GSCI	Futures	1045.99	1053.33	1045.99	1051.83	92.0
2011-06-20	HE	Futures	102.638	104.346	102.585	104.079	11721.0
2011-06-20	HG	Futures	5.4497	5.457	5.3195	5.4101	11517.0
2011-06-20	HO	Futures	2.4405	2.4406	2.3961	2.4009	9398.0
2011-06-20	HRC	Futures	3077.0	3077.0	3077.0	3077.0	0.0
2011-06-20	J1	Futures	0.0156926	0.0157164	0.0156486	0.0156624	78293.0
2011-06-20	J7	Futures	0.015596	0.015609	0.015543	0.015558	202.0
2011-06-20	JB	Futures	122.81	123.01	122.81	122.99	1466.0
2011-06-20	KC	Futures	598.42	598.54	582.33	582.68	18356.0
2011-06-20	KE	Futures	3182.45	3191.33	3130.11	3163.68	16577.0
2011-06-20	L	Futures	98.433	98.443	98.423	98.443	42530.0

> showing 50 of 94 rows — these rows as CSV

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