PREVIEW / futures_daily / 2011-08-23

all futures daily files

  file:    by_date/futures_daily/2011/2011-08-23.parquet
  size:    9 KB
  rows:    97

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-08-23	ES	Futures	1115.79	1152.78	1110.82	1150.55	3338118.0
2011-08-23	NQ	Futures	2330.75	2424.7	2319.65	2418.72	273713.0
2011-08-23	YM	Futures	10255.8	10541.3	10217.9	10532.8	144469.0
2011-08-23	CL	Futures	160.86	164.56	158.86	162.75	353947.0
2011-08-23	GC	Futures	2565.6	2589.5	2465.4	2513.0	366699.0
2011-08-23	ZN	Futures	111.176349	111.429144	110.763895	110.976775	1130571.0
2011-08-23	A6	Futures	0.90117	0.91317	0.9003	0.91065	93788.0
2011-08-23	AD	Futures	1.00684	1.01263	1.00644	1.00864	79958.0
2011-08-23	B	Futures	92.47	94.27	91.7	93.5	226467.0
2011-08-23	B6	Futures	1.7121	1.7237	1.7111	1.7161	75111.0
2011-08-23	BFX	Futures	2610.1	2645.7	2561.9	2563.2	2197.0
2011-08-23	BR	Futures	0.27782	0.27782	0.27726	0.27726	313.0
2011-08-23	BZ	Futures	96.17	97.29	94.75	96.57	1025.0
2011-08-23	C	Futures	2074.0	2107.0	2066.0	2104.0	3707.0
2011-08-23	CB	Futures	101.368	101.368	101.368	101.368	3.0
2011-08-23	CC	Futures	2394.0	2466.0	2394.0	2463.0	17993.0
2011-08-23	CT	Futures	137.59	139.26	136.44	136.44	19.0
2011-08-23	DC	Futures	30.93	31.1	29.82	29.85	835.0
2011-08-23	DX	Futures	73.529	73.543	72.924	73.247	21714.0
2011-08-23	E1	Futures	1.6577	1.66764	1.65129	1.656	16841.0
2011-08-23	E6	Futures	1.70445	1.72179	1.70421	1.71264	277467.0
2011-08-23	E7	Futures	1.6922	1.7091	1.6916	1.7001	3748.0
2011-08-23	ED	Futures	94.9001	94.912	94.8906	94.9001	233646.0
2011-08-23	ER	Futures	97.544	97.544	97.489	97.519	124443.0
2011-08-23	EW	Futures	780.0	813.0	776.8	811.3	30106.0
2011-08-23	FBTP	Futures	64.59	64.69	64.41	64.45	6587.0
2011-08-23	FCE	Futures	2155.1	2199.4	2137.3	2162.5	95566.0
2011-08-23	FDAX	Futures	5900.8	6025.3	5826.6	5902.4	170652.0
2011-08-23	FESX	Futures	1409.2	1436.8	1393.1	1409.2	1326555.0
2011-08-23	FEU3	Futures	98.074	98.074	98.049	98.059	108.0
2011-08-23	FGBL	Futures	108.4	108.67	108.0	108.52	746450.0
2011-08-23	FGBM	Futures	109.9	110.1	109.66	109.98	367285.0
2011-08-23	FGBS	Futures	108.944	109.049	108.835	108.939	500732.0
2011-08-23	FGBX	Futures	107.53	107.75	106.78	107.56	4247.0
2011-08-23	FTDX	Futures	626.5	635.0	618.0	624.3	260.0
2011-08-23	FTI	Futures	227.36	230.62	225.12	227.2	36573.0
2011-08-23	FTUK	Futures	3571.7	3674.0	3571.7	3614.7	119685.0
2011-08-23	FVSA	Futures	14863.92	15407.25	14611.66	15310.23	829.0
2011-08-23	FXXP	Futures	154.1	155.3	152.3	153.1	516.0
2011-08-23	G	Futures	90.29	90.61	89.99	90.41	134843.0
2011-08-23	GF	Futures	307.271	307.729	305.898	305.955	939.0
2011-08-23	GSCI	Futures	1019.45	1027.12	1008.17	1021.25	51.0
2011-08-23	HE	Futures	108.092	108.397	107.054	107.756	12359.0
2011-08-23	HG	Futures	5.2528	5.3699	5.2323	5.3123	10639.0
2011-08-23	HO	Futures	2.3582	2.3924	2.3358	2.379	18034.0
2011-08-23	HRC	Futures	2868.4	2868.4	2868.4	2868.4	0.0
2011-08-23	J1	Futures	0.0163663	0.0164417	0.0163399	0.0163851	82199.0
2011-08-23	J7	Futures	0.016243	0.016331	0.016231	0.016276	364.0
2011-08-23	JB	Futures	124.2	124.29	124.03	124.07	1816.0
2011-08-23	KC	Futures	630.0	644.49	630.0	640.01	10534.0

> showing 50 of 97 rows — these rows as CSV

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