PREVIEW / futures_daily / 2011-09-29

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-29.parquet
  size:    9 KB
  rows:    98

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
2011-09-29	ES	Futures	1146.24	1168.7	1131.51	1154.22	2975702.0
2011-09-29	NQ	Futures	2530.89	2579.41	2456.98	2499.22	405111.0
2011-09-29	YM	Futures	10538.4	10758.4	10461.6	10662.4	155434.0
2011-09-29	CL	Futures	152.11	158.35	150.17	154.88	351345.0
2011-09-29	GC	Futures	2172.8	2211.4	2140.0	2183.6	193524.0
2011-09-29	ZN	Futures	111.455754	111.563013	111.053532	111.536198	1159893.0
2011-09-29	A6	Futures	0.84983	0.86073	0.84526	0.84719	143464.0
2011-09-29	AD	Futures	0.96593	0.97374	0.96003	0.96143	118036.0
2011-09-29	B	Futures	89.18	91.32	88.49	89.6	154538.0
2011-09-29	B6	Futures	1.6242	1.6392	1.6211	1.626	114825.0
2011-09-29	BFX	Futures	2608.2	2608.2	2606.2	2606.2	15.0
2011-09-29	BR	Futures	0.24383	0.24392	0.24098	0.24098	96.0
2011-09-29	BZ	Futures	95.69	96.46	94.69	94.69	819.0
2011-09-29	C	Futures	1826.0	1849.0	1814.0	1847.0	5288.0
2011-09-29	CB	Futures	93.149	93.162	93.149	93.162	4.0
2011-09-29	CC	Futures	2074.0	2123.0	2054.0	2112.0	7669.0
2011-09-29	CSC	Futures	4.105	4.139	4.105	4.117	41.0
2011-09-29	CT	Futures	128.06	133.01	126.61	131.78	11846.0
2011-09-29	DC	Futures	27.97	28.55	27.92	28.41	276.0
2011-09-29	DX	Futures	77.295	77.305	76.598	77.166	26043.0
2011-09-29	E1	Futures	1.45924	1.47419	1.45687	1.46199	18259.0
2011-09-29	E6	Futures	1.61628	1.63445	1.61509	1.62023	279130.0
2011-09-29	E7	Futures	1.6021	1.6205	1.6013	1.6064	5278.0
2011-09-29	ED	Futures	94.9793	94.9889	94.9698	94.9746	129117.0
2011-09-29	ER	Futures	97.332	97.347	97.292	97.312	151187.0
2011-09-29	EW	Futures	798.8	814.8	784.7	803.8	34640.0
2011-09-29	FBTP	Futures	61.7	62.29	61.54	62.14	14718.0
2011-09-29	FBTS	Futures	81.727	81.968	81.655	81.879	4672.0
2011-09-29	FCE	Futures	2129.9	2188.5	2125.3	2163.8	119089.0
2011-09-29	FDAX	Futures	6038.2	6206.0	6016.0	6132.1	172817.0
2011-09-29	FESX	Futures	1433.4	1477.9	1428.7	1463.3	1439555.0
2011-09-29	FEU3	Futures	97.88	97.88	97.871	97.871	2.0
2011-09-29	FGBL	Futures	109.68	110.07	109.36	109.43	784527.0
2011-09-29	FGBM	Futures	110.3	110.53	110.1	110.18	452226.0
2011-09-29	FGBS	Futures	108.945	109.029	108.85	108.875	481279.0
2011-09-29	FGBX	Futures	111.76	112.45	111.15	111.3	3468.0
2011-09-29	FTDX	Futures	662.4	662.4	615.0	624.2	186.0
2011-09-29	FTI	Futures	230.26	236.99	229.72	235.91	45137.0
2011-09-29	FTUK	Futures	3676.4	3751.4	3656.3	3705.8	115185.0
2011-09-29	FVSA	Futures	18427.17	18553.97	17772.08	18004.53	6570.0
2011-09-29	FXXP	Futures	157.0	160.5	157.0	159.0	2880.0
2011-09-29	G	Futures	91.2	91.74	91.12	91.19	130329.0
2011-09-29	GF	Futures	315.228	318.397	314.775	315.624	2300.0
2011-09-29	GSCI	Futures	963.97	971.57	957.87	960.01	166.0
2011-09-29	HE	Futures	105.82	111.154	105.723	110.511	34050.0
2011-09-29	HG	Futures	4.216	4.3529	4.0757	4.2954	71706.0
2011-09-29	HO	Futures	2.2667	2.3134	2.2535	2.2702	21991.0
2011-09-29	HRC	Futures	2747.5	2747.5	2747.5	2747.5	0.0
2011-09-29	J1	Futures	0.016429	0.0164617	0.0163273	0.0163951	88094.0
2011-09-29	J7	Futures	0.016327	0.016359	0.016228	0.016296	462.0

> showing 50 of 98 rows — these rows as CSV

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