PREVIEW / futures_daily / 2011-07-20

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-20.parquet
  size:    9 KB
  rows:    95

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-07-20	ES	Futures	1312.18	1320.62	1310.19	1312.18	1637321.0
2011-07-20	NQ	Futures	2721.35	2748.39	2711.38	2712.24	253753.0
2011-07-20	YM	Futures	11824.2	11891.3	11812.8	11824.2	89020.0
2011-07-20	CL	Futures	188.73	190.44	185.76	188.58	295669.0
2011-07-20	GC	Futures	2148.8	2169.0	2139.9	2161.3	153916.0
2011-07-20	ZN	Futures	106.413169	106.413169	106.01402	106.09385	956902.0
2011-07-20	A6	Futures	0.9257	0.92883	0.92457	0.92727	84868.0
2011-07-20	AD	Futures	1.04886	1.05375	1.04756	1.05195	71629.0
2011-07-20	B	Futures	100.13	101.34	99.8	100.73	155468.0
2011-07-20	B6	Futures	1.676	1.6807	1.6704	1.68	96828.0
2011-07-20	BFX	Futures	2929.8	2960.0	2929.8	2955.9	18.0
2011-07-20	BR	Futures	0.28325	0.28325	0.28183	0.28305	35.0
2011-07-20	BZ	Futures	104.79	104.98	103.68	104.61	725.0
2011-07-20	C	Futures	2166.0	2180.0	2149.0	2154.0	7742.0
2011-07-20	CB	Futures	112.326	113.696	112.326	113.696	10.0
2011-07-20	CC	Futures	2508.0	2553.0	2501.0	2523.0	7070.0
2011-07-20	CT	Futures	131.33	132.89	128.05	131.45	57.0
2011-07-20	DC	Futures	33.29	33.33	33.13	33.19	424.0
2011-07-20	DX	Futures	74.668	74.791	74.291	74.369	26891.0
2011-07-20	E1	Futures	1.5876	1.59976	1.58499	1.59741	35387.0
2011-07-20	E6	Futures	1.67796	1.68841	1.67559	1.68663	304958.0
2011-07-20	E7	Futures	1.6656	1.6764	1.6632	1.6743	5111.0
2011-07-20	ED	Futures	94.9049	94.9334	94.9001	94.9239	244482.0
2011-07-20	ER	Futures	97.366	97.371	97.326	97.336	103639.0
2011-07-20	EW	Futures	968.4	974.7	964.7	969.7	13267.0
2011-07-20	FBTP	Futures	60.67	61.55	60.67	61.35	12455.0
2011-07-20	FCE	Futures	2619.6	2653.5	2616.8	2647.1	151354.0
2011-07-20	FDAX	Futures	7752.0	7780.9	7674.6	7732.3	148021.0
2011-07-20	FESX	Futures	1715.8	1738.9	1710.6	1735.0	1464938.0
2011-07-20	FEU3	Futures	97.9	97.9	97.87	97.87	29.0
2011-07-20	FGBL	Futures	103.52	103.54	102.75	102.79	923862.0
2011-07-20	FGBM	Futures	106.93	106.95	106.46	106.49	565538.0
2011-07-20	FGBS	Futures	107.721	107.741	107.552	107.572	627814.0
2011-07-20	FGBX	Futures	99.72	99.95	98.15	98.2	7558.0
2011-07-20	FTDX	Futures	754.7	757.8	746.2	749.3	1.0
2011-07-20	FTI	Futures	270.79	272.78	270.21	272.58	37195.0
2011-07-20	FTUK	Futures	4071.1	4105.7	4068.3	4096.5	109658.0
2011-07-20	FXXP	Futures	179.7	180.8	179.4	180.7	359.0
2011-07-20	G	Futures	86.04	86.24	85.75	85.97	108272.0
2011-07-20	GF	Futures	316.532	317.113	312.814	313.569	2077.0
2011-07-20	GSCI	Futures	1115.27	1121.6	1106.86	1115.59	58.0
2011-07-20	HE	Futures	109.393	109.779	107.438	107.796	11588.0
2011-07-20	HG	Futures	5.9091	5.9223	5.8523	5.8642	23666.0
2011-07-20	HO	Futures	2.5256	2.5477	2.5103	2.5357	37528.0
2011-07-20	HRC	Futures	2989.2	2989.2	2989.2	2989.2	50.0
2011-07-20	J1	Futures	0.0158849	0.0159766	0.0158535	0.0159628	79101.0
2011-07-20	J7	Futures	0.015781	0.015874	0.015749	0.015856	448.0
2011-07-20	JB	Futures	123.33	123.52	123.29	123.38	1396.0
2011-07-20	KC	Futures	578.43	583.04	568.02	575.82	11382.0
2011-07-20	KE	Futures	2982.54	3059.36	2979.66	3049.76	11113.0

> showing 50 of 95 rows — these rows as CSV

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