PREVIEW / futures_daily / 2012-07-31

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-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-07-31	ES	Futures	1397.55	1404.14	1388.44	1391.98	1774241.0
2012-07-31	NQ	Futures	3026.65	3044.44	3019.76	3026.08	215377.0
2012-07-31	YM	Futures	12611.3	12666.6	12547.3	12562.8	104423.0
2012-07-31	CL	Futures	162.75	163.89	158.46	159.82	282851.0
2012-07-31	GC	Futures	2170.4	2178.4	2155.2	2155.7	124765.0
2012-07-31	ZN	Futures	117.271401	117.557396	117.148832	117.366733	997842.0
2012-07-31	A6	Futures	0.93929	0.94343	0.93893	0.94127	119017.0
2012-07-31	AD	Futures	0.9996	1.0013	0.99729	0.9988	92295.0
2012-07-31	B	Futures	95.47	95.78	93.49	94.28	109908.0
2012-07-31	B6	Futures	1.6414	1.6439	1.633	1.6389	109533.0
2012-07-31	BFX	Futures	2747.1	2747.1	2727.9	2728.4	48.0
2012-07-31	BR	Futures	0.23334	0.23334	0.23088	0.23191	150.0
2012-07-31	BZ	Futures	99.03	99.36	99.03	99.36	1362.0
2012-07-31	C	Futures	1637.0	1663.0	1627.0	1658.0	5666.0
2012-07-31	CB	Futures	89.884	89.884	89.615	89.615	6.0
2012-07-31	CC	Futures	1756.0	1799.0	1742.0	1790.0	18702.0
2012-07-31	CSC	Futures	3.99	4.012	3.951	3.951	29.0
2012-07-31	CT	Futures	93.82	94.06	92.5	92.97	54.0
2012-07-31	DC	Futures	29.57	29.77	29.03	29.11	402.0
2012-07-31	DX	Futures	80.43	80.498	80.134	80.28	14729.0
2012-07-31	E1	Futures	1.31866	1.32692	1.31814	1.32434	37258.0
2012-07-31	E6	Futures	1.44679	1.4554	1.44572	1.45245	221689.0
2012-07-31	E7	Futures	1.4373	1.4462	1.4367	1.4434	3960.0
2012-07-31	ED	Futures	95.2086	95.2134	95.1943	95.1991	160334.0
2012-07-31	ER	Futures	97.827	97.842	97.798	97.827	158039.0
2012-07-31	EW	Futures	956.2	961.0	948.0	951.3	27153.0
2012-07-31	FBTP	Futures	65.34	65.6	64.75	64.99	25205.0
2012-07-31	FBTS	Futures	85.129	85.319	84.682	84.798	3425.0
2012-07-31	FCE	Futures	2481.2	2483.8	2443.7	2450.4	123797.0
2012-07-31	FDAX	Futures	7435.6	7465.6	7375.0	7406.6	137657.0
2012-07-31	FESX	Futures	1587.3	1592.0	1566.3	1574.4	1285570.0
2012-07-31	FEU3	Futures	98.409	98.409	98.409	98.409	115.0
2012-07-31	FGBL	Futures	118.39	119.45	118.35	119.41	727454.0
2012-07-31	FGBM	Futures	116.31	116.77	116.29	116.68	380728.0
2012-07-31	FGBS	Futures	110.557	110.612	110.547	110.582	268942.0
2012-07-31	FGBX	Futures	125.87	128.97	125.83	128.8	11770.0
2012-07-31	FOAT	Futures	101.95	102.84	101.95	102.79	29309.0
2012-07-31	FTDX	Futures	727.7	729.6	721.7	722.1	240.0
2012-07-31	FTI	Futures	279.66	279.79	276.34	276.85	33111.0
2012-07-31	FTUK	Futures	4106.1	4125.8	4060.6	4081.4	99526.0
2012-07-31	FVSA	Futures	7136.19	7510.32	7136.19	7454.89	1225.0
2012-07-31	FXXP	Futures	188.2	188.7	186.5	186.9	4351.0
2012-07-31	G	Futures	100.17	100.86	100.07	100.78	141621.0
2012-07-31	GF	Futures	272.849	276.155	271.863	273.59	2682.0
2012-07-31	GSCI	Futures	1026.88	1026.88	1007.22	1010.72	226.0
2012-07-31	HE	Futures	100.939	101.554	98.855	99.362	8790.0
2012-07-31	HG	Futures	4.4085	4.4536	4.3943	4.4027	49768.0
2012-07-31	HO	Futures	2.3506	2.3567	2.3099	2.3285	63882.0
2012-07-31	HRC	Futures	2509.4	2509.4	2509.4	2509.4	0.0
2012-07-31	J1	Futures	0.0160371	0.0160659	0.016012	0.0160496	57514.0

> showing 50 of 99 rows — these rows as CSV

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