PREVIEW / futures_daily / 2012-09-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-27.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-09-27	ES	Futures	1452.89	1470.19	1452.89	1466.63	1754826.0
2012-09-27	NQ	Futures	3192.66	3246.16	3192.66	3238.4	219259.0
2012-09-27	YM	Futures	13033.2	13136.7	13029.3	13098.7	123345.0
2012-09-27	CL	Futures	162.58	166.75	162.22	165.77	237289.0
2012-09-27	GC	Futures	2344.9	2380.4	2340.8	2377.2	181476.0
2012-09-27	ZN	Futures	117.453053	117.453053	117.192108	117.343181	953865.0
2012-09-27	A6	Futures	0.93607	0.94416	0.93562	0.94289	117549.0
2012-09-27	AD	Futures	1.01734	1.02316	1.01673	1.02155	81208.0
2012-09-27	B	Futures	100.18	102.36	99.8	101.9	183321.0
2012-09-27	B6	Futures	1.6884	1.6961	1.688	1.6953	114217.0
2012-09-27	BFX	Futures	2882.5	2882.6	2878.9	2882.6	6.0
2012-09-27	BR	Futures	0.23672	0.23774	0.2367	0.2368	106.0
2012-09-27	BZ	Futures	105.34	106.01	105.28	105.74	3247.0
2012-09-27	C	Futures	1613.0	1627.0	1608.0	1623.0	6972.0
2012-09-27	CC	Futures	1866.0	1885.0	1852.0	1872.0	9249.0
2012-09-27	CSC	Futures	4.025	4.046	4.011	4.011	76.0
2012-09-27	CT	Futures	92.25	92.38	90.92	92.3	14039.0
2012-09-27	DC	Futures	30.74	30.86	30.13	30.21	402.0
2012-09-27	DX	Futures	77.358	77.499	77.053	77.094	18215.0
2012-09-27	E1	Futures	1.37209	1.37673	1.36849	1.37544	33317.0
2012-09-27	E6	Futures	1.5172	1.52379	1.5119	1.52226	288116.0
2012-09-27	E7	Futures	1.5079	1.5146	1.5029	1.5132	5324.0
2012-09-27	ED	Futures	95.1919	95.211	95.1823	95.2062	224225.0
2012-09-27	ER	Futures	97.852	97.871	97.842	97.871	143974.0
2012-09-27	EW	Futures	997.0	1011.3	997.0	1008.5	20426.0
2012-09-27	FBTP	Futures	70.39	70.87	70.05	70.71	37817.0
2012-09-27	FBTS	Futures	88.93	89.098	88.704	89.022	4155.0
2012-09-27	FCE	Futures	2574.1	2595.4	2558.7	2573.0	98299.0
2012-09-27	FDAX	Futures	8031.5	8053.4	7966.3	7988.2	112040.0
2012-09-27	FESX	Futures	1709.7	1718.5	1694.7	1701.5	977682.0
2012-09-27	FEU3	Futures	98.478	98.492	98.478	98.492	150.0
2012-09-27	FGBL	Futures	118.26	118.44	118.08	118.32	610158.0
2012-09-27	FGBM	Futures	116.19	116.28	116.08	116.17	342171.0
2012-09-27	FGBS	Futures	110.338	110.363	110.318	110.338	296480.0
2012-09-27	FGBX	Futures	125.21	126.23	125.15	125.87	6402.0
2012-09-27	FOAT	Futures	102.76	103.03	102.7	102.82	17072.0
2012-09-27	FTDX	Futures	757.1	763.2	755.6	761.8	61.0
2012-09-27	FTI	Futures	281.4	282.38	279.9	280.76	23083.0
2012-09-27	FTUK	Futures	4201.8	4234.0	4196.7	4210.9	69503.0
2012-09-27	FVSA	Futures	5706.8	5804.57	5547.94	5731.25	4474.0
2012-09-27	FXXP	Futures	195.8	196.0	194.8	195.4	2010.0
2012-09-27	G	Futures	99.71	99.79	99.38	99.5	147589.0
2012-09-27	GF	Futures	285.106	285.982	283.062	284.668	1961.0
2012-09-27	GSCI	Futures	1062.84	1067.76	1059.78	1064.53	113.0
2012-09-27	HE	Futures	92.602	93.006	91.359	91.484	18220.0
2012-09-27	HG	Futures	4.776	4.8172	4.7548	4.8114	48429.0
2012-09-27	HH	Futures	41.76	42.041	41.76	42.041	1408.0
2012-09-27	HO	Futures	2.4968	2.5488	2.4908	2.5404	28398.0
2012-09-27	HRC	Futures	2443.1	2443.1	2443.1	2443.1	0.0
2012-09-27	J1	Futures	0.0161159	0.0161498	0.0161122	0.0161435	66291.0

> showing 50 of 98 rows — these rows as CSV

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