PREVIEW / futures_daily / 2012-07-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-27.parquet
  size:    9 KB
  rows:    97

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-27	ES	Futures	1371.98	1402.62	1369.96	1400.09	2495356.0
2012-07-27	NQ	Futures	2952.91	3036.98	2952.62	3032.39	284847.0
2012-07-27	YM	Futures	12441.5	12671.5	12428.9	12644.3	151369.0
2012-07-27	CL	Futures	162.31	164.16	161.77	163.58	210412.0
2012-07-27	GC	Futures	2163.6	2180.7	2156.8	2166.5	118267.0
2012-07-27	ZN	Futures	117.584633	117.639109	116.644937	116.903694	1306149.0
2012-07-27	A6	Futures	0.93039	0.93875	0.9294	0.9374	153919.0
2012-07-27	AD	Futures	0.99138	0.99859	0.99108	0.99739	106829.0
2012-07-27	B	Futures	94.49	95.91	94.46	95.67	91786.0
2012-07-27	B6	Futures	1.639	1.6478	1.6372	1.6433	136577.0
2012-07-27	BR	Futures	0.23477	0.23611	0.23405	0.23482	133.0
2012-07-27	BZ	Futures	100.83	100.83	100.83	100.83	2764.0
2012-07-27	C	Futures	1614.0	1637.0	1612.0	1632.0	4357.0
2012-07-27	CB	Futures	91.499	91.499	91.364	91.364	27.0
2012-07-27	CC	Futures	1740.0	1772.0	1731.0	1756.0	13495.0
2012-07-27	CSC	Futures	3.962	3.962	3.923	3.947	53.0
2012-07-27	CT	Futures	92.71	94.83	92.67	93.17	94.0
2012-07-27	DC	Futures	29.58	29.58	28.91	29.15	414.0
2012-07-27	DX	Futures	80.493	80.624	79.979	80.333	34353.0
2012-07-27	E1	Futures	1.32176	1.33299	1.3175	1.3246	58947.0
2012-07-27	E6	Futures	1.44915	1.46236	1.44466	1.45292	348129.0
2012-07-27	E7	Futures	1.4401	1.4533	1.4359	1.4439	5838.0
2012-07-27	ED	Futures	95.1895	95.1991	95.18	95.1895	135281.0
2012-07-27	ER	Futures	97.749	97.876	97.744	97.763	102821.0
2012-07-27	EW	Futures	939.6	963.7	937.1	962.8	33934.0
2012-07-27	FBTP	Futures	65.41	66.11	64.53	65.51	35189.0
2012-07-27	FBTS	Futures	84.93	85.501	84.484	85.17	4422.0
2012-07-27	FCE	Futures	2391.6	2485.3	2376.3	2441.4	159756.0
2012-07-27	FDAX	Futures	7219.4	7443.2	7111.3	7295.8	183129.0
2012-07-27	FESX	Futures	1525.7	1582.6	1508.2	1552.1	1495644.0
2012-07-27	FEU3	Futures	98.339	98.344	98.339	98.344	100.0
2012-07-27	FGBL	Futures	118.82	119.18	117.82	118.29	777594.0
2012-07-27	FGBM	Futures	116.41	116.59	115.98	116.1	453622.0
2012-07-27	FGBS	Futures	110.507	110.662	110.452	110.462	345876.0
2012-07-27	FGBX	Futures	126.64	127.88	124.12	125.87	5346.0
2012-07-27	FOAT	Futures	101.71	102.02	101.59	101.59	24413.0
2012-07-27	FTDX	Futures	720.3	729.6	714.7	723.1	98.0
2012-07-27	FTI	Futures	272.59	277.74	269.74	274.08	40850.0
2012-07-27	FTUK	Futures	4031.8	4097.4	4008.2	4063.5	87823.0
2012-07-27	FVSA	Futures	7344.04	7510.32	7191.62	7274.76	2251.0
2012-07-27	FXXP	Futures	183.8	185.8	182.9	185.6	5911.0
2012-07-27	G	Futures	100.42	100.81	100.1	100.2	110502.0
2012-07-27	GF	Futures	267.767	274.33	265.942	271.863	3193.0
2012-07-27	GSCI	Futures	1014.7	1023.45	1014.3	1023.45	242.0
2012-07-27	HE	Futures	102.81	103.264	101.34	101.768	9421.0
2012-07-27	HG	Futures	4.3686	4.4304	4.3531	4.4137	48826.0
2012-07-27	HO	Futures	2.3461	2.367	2.3424	2.3633	50030.0
2012-07-27	HRC	Futures	2509.4	2509.4	2509.4	2509.4	50.0
2012-07-27	J1	Futures	0.0160283	0.0160597	0.0159368	0.0159544	86821.0
2012-07-27	J7	Futures	0.015967	0.015995	0.015874	0.015892	358.0

> showing 50 of 97 rows — these rows as CSV

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