PREVIEW / futures_daily / 2012-07-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-23.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
2012-07-23	ES	Futures	1372.74	1374.01	1348.94	1360.84	2078031.0
2012-07-23	NQ	Futures	2994.51	2999.1	2919.05	2960.37	276430.0
2012-07-23	YM	Futures	12375.6	12375.6	12147.6	12267.9	145126.0
2012-07-23	CL	Futures	166.27	166.32	159.55	159.97	290355.0
2012-07-23	GC	Futures	2114.3	2115.3	2088.1	2108.7	141477.0
2012-07-23	ZN	Futures	117.639109	117.993197	117.611871	117.720821	871633.0
2012-07-23	A6	Futures	0.92688	0.92724	0.91636	0.91834	153627.0
2012-07-23	AD	Futures	0.98777	0.98857	0.98125	0.98416	113072.0
2012-07-23	B	Futures	96.03	96.07	92.01	92.76	224905.0
2012-07-23	B6	Futures	1.6311	1.6317	1.6181	1.6219	119465.0
2012-07-23	BR	Futures	0.2321	0.23269	0.23164	0.23229	96.0
2012-07-23	BZ	Futures	100.79	100.79	98.61	99.39	360.0
2012-07-23	C	Futures	1564.0	1594.0	1562.0	1582.0	3734.0
2012-07-23	CB	Futures	89.75	89.75	89.75	89.75	10.0
2012-07-23	CC	Futures	1680.0	1710.0	1649.0	1686.0	10858.0
2012-07-23	CSC	Futures	4.116	4.116	4.116	4.116	6.0
2012-07-23	CT	Futures	94.5	94.65	93.03	93.99	50.0
2012-07-23	DC	Futures	30.49	30.58	30.2	30.38	221.0
2012-07-23	DX	Futures	81.289	81.668	81.26	81.352	22948.0
2012-07-23	E1	Futures	1.30433	1.3073	1.29916	1.30523	55404.0
2012-07-23	E6	Futures	1.4311	1.43369	1.42449	1.43145	284732.0
2012-07-23	E7	Futures	1.4217	1.4249	1.4156	1.4226	3297.0
2012-07-23	ED	Futures	95.1895	95.1895	95.1704	95.18	122313.0
2012-07-23	ER	Futures	97.754	97.759	97.724	97.734	161010.0
2012-07-23	EW	Futures	946.2	949.5	927.2	937.8	25317.0
2012-07-23	FBTP	Futures	64.01	64.13	63.21	63.65	21203.0
2012-07-23	FBTS	Futures	84.029	84.029	83.475	83.773	6790.0
2012-07-23	FCE	Futures	2346.9	2356.9	2297.0	2308.9	156293.0
2012-07-23	FDAX	Futures	7146.8	7179.0	6955.7	7016.9	176960.0
2012-07-23	FESX	Futures	1489.2	1495.3	1460.8	1475.0	1520973.0
2012-07-23	FEU3	Futures	98.325	98.325	98.31	98.315	220.0
2012-07-23	FGBL	Futures	120.67	120.81	120.2	120.22	567173.0
2012-07-23	FGBM	Futures	117.18	117.22	116.84	116.87	355351.0
2012-07-23	FGBS	Futures	110.582	110.587	110.537	110.552	205105.0
2012-07-23	FGBX	Futures	130.92	131.19	129.7	129.8	4644.0
2012-07-23	FOAT	Futures	102.9	102.9	102.0	102.08	22778.0
2012-07-23	FTDX	Futures	706.3	706.3	690.5	694.7	58.0
2012-07-23	FTI	Futures	269.18	269.18	263.65	265.09	44970.0
2012-07-23	FTUK	Futures	4062.8	4066.1	3979.4	3995.1	104059.0
2012-07-23	FVSA	Futures	7427.18	8508.0	7427.18	8203.15	14730.0
2012-07-23	FXXP	Futures	182.9	182.9	179.3	180.1	2616.0
2012-07-23	G	Futures	100.84	101.25	100.62	100.72	116039.0
2012-07-23	GF	Futures	269.05	273.442	266.287	267.718	3048.0
2012-07-23	GSCI	Futures	1005.07	1018.92	1005.07	1006.74	309.0
2012-07-23	HE	Futures	99.79	100.458	99.523	99.763	6369.0
2012-07-23	HG	Futures	4.4285	4.4375	4.3054	4.3544	61343.0
2012-07-23	HO	Futures	2.3905	2.3913	2.3036	2.3061	56161.0
2012-07-23	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-23	J1	Futures	0.0159845	0.0160897	0.0159682	0.0159932	80422.0
2012-07-23	J7	Futures	0.015918	0.016025	0.015914	0.015931	424.0

> showing 50 of 98 rows — these rows as CSV

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