PREVIEW / futures_daily / 2009-07-21

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-21.parquet
  size:    8 KB
  rows:    85

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
2009-07-21	ES	Futures	909.31	917.46	901.39	914.83	1892528.0
2009-07-21	NQ	Futures	1734.01	1751.18	1721.06	1750.06	293030.0
2009-07-21	YM	Futures	7939.8	8021.0	7905.5	8017.4	133986.0
2009-07-21	CL	Futures	168.28	171.68	166.14	168.92	279584.0
2009-07-21	GC	Futures	1315.0	1320.5	1307.4	1311.0	79090.0
2009-07-21	ZN	Futures	92.07397	93.009731	91.766153	92.812728	968889.0
2009-07-21	A6	Futures	0.65263	0.65576	0.64732	0.65158	67537.0
2009-07-21	AD	Futures	0.89269	0.90119	0.88874	0.8921	69859.0
2009-07-21	B	Futures	63.43	64.66	62.53	63.66	104331.0
2009-07-21	B6	Futures	1.723	1.7238	1.7063	1.7115	84813.0
2009-07-21	BFX	Futures	2392.4	2417.1	2392.4	2408.3	135.0
2009-07-21	BR	Futures	0.20221	0.20338	0.20217	0.20244	203.0
2009-07-21	BZ	Futures	68.73	68.88	67.92	67.92	6.0
2009-07-21	C	Futures	1902.0	1930.0	1900.0	1926.0	2881.0
2009-07-21	CC	Futures	2539.0	2566.0	2523.0	2557.0	6093.0
2009-07-21	CT	Futures	55.73	55.81	53.08	53.08	233.0
2009-07-21	DC	Futures	22.02	22.02	20.95	21.25	680.0
2009-07-21	DX	Futures	80.89	81.115	80.593	80.952	5853.0
2009-07-21	E1	Futures	1.24013	1.24767	1.23602	1.24	36954.0
2009-07-21	E6	Futures	1.68889	1.69506	1.68141	1.68509	201509.0
2009-07-21	E7	Futures	1.6711	1.6775	1.664	1.6678	2324.0
2009-07-21	ED	Futures	93.933	93.9424	93.9141	93.9283	154716.0
2009-07-21	ER	Futures	97.081	97.09	97.076	97.086	74046.0
2009-07-21	EW	Futures	576.6	582.1	568.8	578.3	25411.0
2009-07-21	FCE	Futures	2152.7	2182.5	2140.2	2164.5	106836.0
2009-07-21	FDAX	Futures	5557.2	5642.8	5518.2	5586.8	130730.0
2009-07-21	FESX	Futures	1498.8	1520.3	1488.7	1502.4	1076253.0
2009-07-21	FEU3	Futures	97.663	97.663	97.658	97.663	56.0
2009-07-21	FGBL	Futures	92.14	92.36	91.68	92.17	662125.0
2009-07-21	FGBM	Futures	98.13	98.27	97.86	98.16	320072.0
2009-07-21	FGBS	Futures	104.167	104.22	104.061	104.186	424829.0
2009-07-21	FGBX	Futures	83.46	83.9	82.73	83.5	2388.0
2009-07-21	FTDX	Futures	585.3	599.6	584.4	595.1	929.0
2009-07-21	FTI	Futures	221.36	223.53	219.79	221.27	26235.0
2009-07-21	FTUK	Futures	2927.8	2966.3	2922.8	2957.0	104437.0
2009-07-21	G	Futures	75.08	75.36	74.78	75.17	69368.0
2009-07-21	GF	Futures	287.689	287.965	284.313	284.588	1936.0
2009-07-21	GSCI	Futures	913.77	922.44	900.5	911.99	211.0
2009-07-21	HE	Futures	93.06	93.096	89.317	89.965	11189.0
2009-07-21	HG	Futures	3.4703	3.5026	3.4127	3.4415	17740.0
2009-07-21	HO	Futures	1.7417	1.7854	1.7271	1.7475	41898.0
2009-07-21	HRC	Futures	2409.0	2409.0	2409.0	2409.0	0.0
2009-07-21	J1	Futures	0.0133659	0.0135044	0.0133445	0.013454	96060.0
2009-07-21	J7	Futures	0.013235	0.01332	0.013162	0.013269	78.0
2009-07-21	JB	Futures	116.48	116.64	116.33	116.39	2719.0
2009-07-21	KC	Futures	330.09	335.11	328.59	332.39	6391.0
2009-07-21	KE	Futures	2733.92	2738.72	2685.96	2713.54	5767.0
2009-07-21	L	Futures	97.367	97.367	97.337	97.357	36629.0
2009-07-21	LBS	Futures	759.1	778.6	749.0	767.2	889.0
2009-07-21	LE	Futures	153.173	153.173	151.092	151.716	15794.0

> showing 50 of 85 rows — these rows as CSV

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