PREVIEW / futures_daily / 2012-02-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-02-23.parquet
  size:    9 KB
  rows:    99

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-02-23	ES	Futures	1360.84	1368.61	1355.07	1367.86	1602052.0
2012-02-23	NQ	Futures	2949.34	2975.64	2938.19	2974.21	229551.0
2012-02-23	YM	Futures	12493.6	12552.6	12435.6	12546.8	128864.0
2012-02-23	CL	Futures	196.28	201.45	195.35	199.76	325662.0
2012-02-23	GC	Futures	2381.4	2396.4	2374.7	2392.1	153929.0
2012-02-23	ZN	Futures	113.205761	113.46231	112.962714	113.381294	1306465.0
2012-02-23	A6	Futures	0.94377	0.95169	0.94057	0.94822	118436.0
2012-02-23	AD	Futures	1.00342	1.00784	1.00202	1.00422	92437.0
2012-02-23	B	Futures	109.31	110.88	108.75	110.1	208155.0
2012-02-23	B6	Futures	1.6383	1.6461	1.6358	1.6426	93920.0
2012-02-23	BFX	Futures	2774.1	2774.1	2749.6	2755.5	18.0
2012-02-23	BR	Futures	0.27379	0.27379	0.27283	0.27319	49.0
2012-02-23	BZ	Futures	117.34	118.15	115.89	117.33	884.0
2012-02-23	C	Futures	1605.0	1609.0	1523.0	1539.0	4193.0
2012-02-23	CB	Futures	84.502	84.502	84.502	84.502	19.0
2012-02-23	CC	Futures	1861.0	1877.0	1755.0	1784.0	15036.0
2012-02-23	CSC	Futures	3.708	3.731	3.692	3.692	45.0
2012-02-23	CT	Futures	114.07	114.07	111.4	111.67	13958.0
2012-02-23	DC	Futures	25.79	25.79	25.28	25.35	163.0
2012-02-23	DX	Futures	77.228	77.252	76.556	76.781	33871.0
2012-02-23	E1	Futures	1.44219	1.45728	1.44048	1.45203	52188.0
2012-02-23	E6	Futures	1.58365	1.59943	1.58162	1.59405	320659.0
2012-02-23	E7	Futures	1.5689	1.5847	1.5672	1.5795	4649.0
2012-02-23	EBM	Futures	278.78	280.42	273.87	274.85	3396.0
2012-02-23	ED	Futures	95.0748	95.0796	95.0677	95.0748	137133.0
2012-02-23	ER	Futures	97.435	97.44	97.425	97.43	72375.0
2012-02-23	EW	Futures	982.1	992.2	977.4	991.6	23631.0
2012-02-23	FBTP	Futures	65.34	65.4	64.94	65.29	10758.0
2012-02-23	FBTS	Futures	84.537	84.625	84.505	84.569	2317.0
2012-02-23	FCE	Futures	2434.3	2450.5	2418.4	2434.6	104696.0
2012-02-23	FDAX	Futures	7564.5	7628.6	7434.2	7522.6	163898.0
2012-02-23	FESX	Futures	1684.8	1694.8	1664.0	1677.4	989973.0
2012-02-23	FEU3	Futures	97.984	97.984	97.979	97.984	308.0
2012-02-23	FGBL	Futures	112.29	112.63	112.09	112.5	652777.0
2012-02-23	FGBM	Futures	113.27	113.39	113.13	113.35	320078.0
2012-02-23	FGBS	Futures	109.805	109.835	109.785	109.815	286301.0
2012-02-23	FGBX	Futures	116.97	117.72	116.59	117.7	4750.0
2012-02-23	FTDX	Futures	722.7	722.7	711.1	714.8	106.0
2012-02-23	FTI	Futures	274.46	276.02	272.36	274.29	38113.0
2012-02-23	FTUK	Futures	4244.3	4279.3	4239.7	4267.4	107076.0
2012-02-23	FVSA	Futures	10091.0	10300.04	9938.97	9938.97	3109.0
2012-02-23	FXXP	Futures	186.4	187.5	185.4	186.4	1417.0
2012-02-23	G	Futures	93.85	93.96	93.49	93.89	155095.0
2012-02-23	GF	Futures	335.497	336.398	333.694	334.331	1914.0
2012-02-23	GSCI	Futures	1113.69	1116.68	1103.84	1115.03	181.0
2012-02-23	HE	Futures	109.066	109.459	108.039	108.281	20340.0
2012-02-23	HG	Futures	5.0377	5.0462	4.9597	5.0003	19170.0
2012-02-23	HO	Futures	2.6673	2.6921	2.6551	2.6869	28197.0
2012-02-23	HRC	Futures	2731.0	2731.0	2731.0	2731.0	0.0
2012-02-23	J1	Futures	0.0156404	0.0157283	0.0156291	0.0156818	78205.0

> showing 50 of 99 rows — these rows as CSV

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