PREVIEW / futures_daily / 2011-08-18

all futures daily files

  file:    by_date/futures_daily/2011/2011-08-18.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-08-18	ES	Futures	1181.33	1181.83	1120.5	1135.65	3809916.0
2011-08-18	NQ	Futures	2477.65	2477.65	2337.87	2370.89	444399.0
2011-08-18	YM	Futures	10756.8	10759.7	10263.3	10415.5	222033.0
2011-08-18	CL	Futures	166.77	167.07	154.81	157.17	265833.0
2011-08-18	GC	Futures	2419.7	2473.5	2412.5	2460.0	223989.0
2011-08-18	ZN	Futures	110.950165	112.094392	110.896945	111.362619	1644601.0
2011-08-18	A6	Futures	0.91291	0.91491	0.89699	0.89891	131619.0
2011-08-18	AD	Futures	1.01712	1.01762	1.00335	1.00714	100401.0
2011-08-18	B	Futures	94.56	94.74	90.9	91.52	240381.0
2011-08-18	B6	Futures	1.72	1.7217	1.7076	1.7162	96138.0
2011-08-18	BFX	Futures	2685.1	2685.1	2582.4	2591.8	333.0
2011-08-18	BR	Futures	0.27626	0.27715	0.27626	0.27715	239.0
2011-08-18	BZ	Futures	96.53	96.53	93.91	94.52	1462.0
2011-08-18	C	Futures	2047.0	2047.0	2000.0	2028.0	1463.0
2011-08-18	CB	Futures	112.326	112.326	112.326	112.326	1.0
2011-08-18	CC	Futures	2379.0	2382.0	2312.0	2341.0	10832.0
2011-08-18	CSC	Futures	4.619	4.622	4.565	4.597	9.0
2011-08-18	CT	Futures	140.14	140.14	135.85	139.57	30.0
2011-08-18	DC	Futures	31.47	31.65	30.93	31.62	737.0
2011-08-18	DX	Futures	73.162	73.826	73.098	73.598	26446.0
2011-08-18	E1	Futures	1.65901	1.66751	1.63887	1.6526	29347.0
2011-08-18	E6	Futures	1.71241	1.71585	1.69423	1.70077	325556.0
2011-08-18	E7	Futures	1.6997	1.7032	1.682	1.6883	4765.0
2011-08-18	ED	Futures	94.9311	94.9311	94.9049	94.9096	241051.0
2011-08-18	ER	Futures	97.559	97.618	97.539	97.593	111199.0
2011-08-18	EW	Futures	841.2	841.3	787.5	799.4	45172.0
2011-08-18	FBTP	Futures	64.8	65.07	64.52	64.61	6773.0
2011-08-18	FCE	Futures	2248.9	2260.8	2127.8	2159.4	111127.0
2011-08-18	FDAX	Futures	6268.9	6302.1	5912.6	5979.9	248508.0
2011-08-18	FESX	Futures	1472.0	1479.1	1393.1	1413.0	2091981.0
2011-08-18	FEU3	Futures	98.109	98.148	98.109	98.134	46.0
2011-08-18	FGBL	Futures	107.75	109.31	107.73	108.9	1017919.0
2011-08-18	FGBM	Futures	109.72	110.56	109.62	110.3	621571.0
2011-08-18	FGBS	Futures	108.88	109.198	108.845	109.094	582700.0
2011-08-18	FGBX	Futures	104.81	107.89	104.81	107.16	7795.0
2011-08-18	FTDX	Futures	634.1	634.1	602.4	606.9	857.0
2011-08-18	FTI	Futures	235.93	237.4	224.71	228.3	31591.0
2011-08-18	FTUK	Futures	3739.2	3739.2	3547.7	3584.0	177059.0
2011-08-18	FVSA	Futures	12807.03	14883.33	12768.23	14184.76	3123.0
2011-08-18	FXXP	Futures	158.8	159.2	152.5	153.2	1237.0
2011-08-18	G	Futures	90.37	91.53	90.36	91.08	149670.0
2011-08-18	GF	Futures	309.618	310.191	304.753	305.039	1494.0
2011-08-18	GSCI	Futures	1012.32	1013.42	988.35	992.66	120.0
2011-08-18	HE	Futures	107.267	107.267	105.527	106.046	16017.0
2011-08-18	HG	Futures	5.3341	5.3446	5.192	5.2429	37263.0
2011-08-18	HO	Futures	2.3977	2.4037	2.3193	2.3333	13992.0
2011-08-18	HRC	Futures	2868.4	2868.4	2868.4	2868.4	0.0
2011-08-18	J1	Futures	0.0164065	0.0164492	0.0163914	0.0164316	69936.0
2011-08-18	J7	Futures	0.016309	0.016338	0.016283	0.016322	225.0
2011-08-18	JB	Futures	123.96	124.24	123.95	124.21	2121.0

> showing 50 of 98 rows — these rows as CSV

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