PREVIEW / futures_daily / 2012-11-02

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-02.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-11-02	ES	Futures	1448.56	1456.96	1429.99	1430.5	2089006.0
2012-11-02	NQ	Futures	3090.54	3099.75	3038.77	3038.77	287864.0
2012-11-02	YM	Futures	12855.5	12915.1	12682.7	12685.6	120034.0
2012-11-02	CL	Futures	156.64	157.23	152.58	152.94	297311.0
2012-11-02	GC	Futures	2290.6	2292.7	2236.1	2236.6	223444.0
2012-11-02	ZN	Futures	116.670216	116.807556	116.299398	116.711418	1064655.0
2012-11-02	A6	Futures	0.9418	0.94362	0.93553	0.93671	106269.0
2012-11-02	AD	Futures	1.00609	1.01061	1.00348	1.007	99506.0
2012-11-02	B	Futures	99.04	99.69	96.77	96.93	124827.0
2012-11-02	B6	Futures	1.6838	1.6848	1.6716	1.673	106367.0
2012-11-02	BFX	Futures	2872.3	2882.5	2872.3	2882.5	4.0
2012-11-02	BR	Futures	0.23864	0.23864	0.23864	0.23864	12.0
2012-11-02	BZ	Futures	102.08	102.73	99.95	99.95	380.0
2012-11-02	C	Futures	1579.0	1607.0	1579.0	1604.0	2594.0
2012-11-02	CB	Futures	91.792	92.06	91.792	92.06	3.0
2012-11-02	CC	Futures	1825.0	1848.0	1816.0	1845.0	15281.0
2012-11-02	CSC	Futures	4.13	4.183	4.13	4.173	13.0
2012-11-02	CT	Futures	90.69	91.03	89.89	90.78	12484.0
2012-11-02	DC	Futures	30.88	31.21	30.8	31.14	368.0
2012-11-02	DX	Futures	77.6	78.206	77.581	78.15	28225.0
2012-11-02	E1	Futures	1.38187	1.3829	1.35587	1.36849	40609.0
2012-11-02	E6	Futures	1.52473	1.52567	1.51037	1.51095	276549.0
2012-11-02	E7	Futures	1.5156	1.5164	1.5013	1.5019	4392.0
2012-11-02	ED	Futures	95.2349	95.2396	95.2301	95.2349	55998.0
2012-11-02	ER	Futures	97.866	97.876	97.862	97.871	65628.0
2012-11-02	EW	Futures	1019.4	1025.0	1002.5	1002.7	26951.0
2012-11-02	FBTP	Futures	72.43	72.66	72.36	72.38	10129.0
2012-11-02	FBTS	Futures	89.675	89.759	89.65	89.675	1290.0
2012-11-02	FCE	Futures	2611.4	2631.7	2596.0	2622.3	88565.0
2012-11-02	FDAX	Futures	8051.2	8098.9	8012.3	8063.8	110776.0
2012-11-02	FESX	Futures	1726.0	1738.9	1714.4	1729.4	918906.0
2012-11-02	FGBL	Futures	118.41	118.71	118.17	118.57	666280.0
2012-11-02	FGBM	Futures	116.47	116.65	116.39	116.59	339761.0
2012-11-02	FGBS	Futures	110.397	110.462	110.377	110.432	371235.0
2012-11-02	FGBX	Futures	125.53	126.21	125.17	126.06	8223.0
2012-11-02	FOAT	Futures	103.68	103.89	103.68	103.81	21265.0
2012-11-02	FTDX	Futures	758.0	760.8	751.4	759.9	26.0
2012-11-02	FTI	Futures	287.07	289.73	286.34	288.79	30410.0
2012-11-02	FTUK	Futures	4269.8	4294.7	4248.3	4272.8	74040.0
2012-11-02	FVSA	Futures	4845.12	4867.71	4754.77	4766.06	3501.0
2012-11-02	FXXP	Futures	196.9	198.4	196.9	197.7	2213.0
2012-11-02	G	Futures	98.24	98.65	98.03	98.38	141751.0
2012-11-02	GF	Futures	278.435	279.107	277.811	278.243	659.0
2012-11-02	GSCI	Futures	1030.05	1033.77	1009.76	1012.27	281.0
2012-11-02	HE	Futures	97.202	97.668	96.331	96.642	19836.0
2012-11-02	HG	Futures	4.564	4.5723	4.4625	4.474	53001.0
2012-11-02	HH	Futures	41.502	41.502	41.351	41.351	238.0
2012-11-02	HO	Futures	2.4568	2.4652	2.386	2.389	89277.0
2012-11-02	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-02	J1	Futures	0.0156264	0.0156302	0.0155237	0.0155763	106710.0

> showing 50 of 99 rows — these rows as CSV

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