PREVIEW / futures_daily / 2012-08-31

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-31.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-08-31	ES	Futures	1414.77	1430.21	1413.25	1422.87	2046718.0
2012-08-31	NQ	Futures	3162.09	3196.81	3150.9	3180.45	293090.0
2012-08-31	YM	Futures	12596.8	12752.0	12584.1	12688.9	158861.0
2012-08-31	CL	Futures	171.41	175.34	170.98	174.52	249063.0
2012-08-31	GC	Futures	2213.4	2263.7	2199.1	2253.2	195805.0
2012-08-31	ZN	Futures	116.917313	117.557396	116.713031	117.448445	279292.0
2012-08-31	A6	Futures	0.92427	0.92985	0.92283	0.92715	139214.0
2012-08-31	AD	Futures	1.01002	1.01744	1.00922	1.01704	112064.0
2012-08-31	B	Futures	102.19	104.27	102.1	103.99	110635.0
2012-08-31	B6	Futures	1.6495	1.6613	1.649	1.6599	106877.0
2012-08-31	BR	Futures	0.23636	0.23636	0.23624	0.23624	15.0
2012-08-31	BZ	Futures	108.47	108.99	108.47	108.99	2073.0
2012-08-31	C	Futures	1728.0	1733.0	1713.0	1716.0	1654.0
2012-08-31	CB	Futures	99.018	100.891	99.004	100.088	17.0
2012-08-31	CC	Futures	1971.0	1996.0	1952.0	1968.0	17454.0
2012-08-31	CSC	Futures	4.12	4.12	4.072	4.072	34.0
2012-08-31	CT	Futures	100.25	100.75	100.14	100.75	24.0
2012-08-31	DC	Futures	30.74	30.74	30.24	30.34	136.0
2012-08-31	DX	Futures	79.299	79.338	78.581	78.83	24483.0
2012-08-31	E1	Futures	1.34448	1.3592	1.34358	1.35313	49251.0
2012-08-31	E6	Futures	1.47557	1.49102	1.47403	1.48418	312652.0
2012-08-31	E7	Futures	1.4662	1.4818	1.4648	1.475	6153.0
2012-08-31	ED	Futures	95.1871	95.2015	95.1847	95.1943	189198.0
2012-08-31	ER	Futures	97.862	97.871	97.857	97.862	63321.0
2012-08-31	EW	Futures	978.7	990.4	974.1	983.9	23628.0
2012-08-31	FBTP	Futures	66.66	66.82	66.28	66.38	25089.0
2012-08-31	FBTS	Futures	87.378	87.783	87.32	87.593	4388.0
2012-08-31	FCE	Futures	2516.2	2556.0	2508.7	2537.8	108296.0
2012-08-31	FDAX	Futures	7540.9	7657.8	7522.4	7609.2	136812.0
2012-08-31	FESX	Futures	1625.2	1654.2	1621.1	1647.5	1016763.0
2012-08-31	FGBL	Futures	119.11	119.2	118.25	118.96	809951.0
2012-08-31	FGBM	Futures	116.69	116.7	116.24	116.56	512960.0
2012-08-31	FGBS	Futures	110.517	110.532	110.452	110.502	516285.0
2012-08-31	FGBX	Futures	128.61	128.95	127.05	128.42	13670.0
2012-08-31	FOAT	Futures	102.76	102.87	102.4	102.68	26129.0
2012-08-31	FTDX	Futures	736.6	745.4	736.6	743.1	60.0
2012-08-31	FTI	Futures	278.52	282.18	278.3	280.35	33323.0
2012-08-31	FTUK	Futures	4154.5	4192.4	4140.0	4148.7	111023.0
2012-08-31	FVSA	Futures	7122.01	7122.01	6724.92	6814.58	1945.0
2012-08-31	FXXP	Futures	189.8	191.5	189.5	190.5	1180.0
2012-08-31	G	Futures	100.12	100.19	99.56	99.88	117632.0
2012-08-31	GF	Futures	282.703	286.397	282.703	284.87	850.0
2012-08-31	GSCI	Futures	1081.4	1089.12	1075.6	1089.12	227.0
2012-08-31	HE	Futures	91.731	91.885	89.97	91.669	23441.0
2012-08-31	HG	Futures	4.4233	4.4567	4.3789	4.4425	47161.0
2012-08-31	HH	Futures	37.522	37.522	37.522	37.522	320.0
2012-08-31	HO	Futures	2.5392	2.5793	2.5392	2.5742	19013.0
2012-08-31	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0
2012-08-31	J1	Futures	0.0159406	0.0160321	0.0159368	0.0159995	91303.0
2012-08-31	J7	Futures	0.015886	0.015968	0.015881	0.015937	474.0

> showing 50 of 99 rows — these rows as CSV

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