PREVIEW / futures_daily / 2009-07-20

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-20.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-20	ES	Futures	899.0	910.75	895.88	910.51	1574716.0
2009-07-20	NQ	Futures	1720.49	1738.79	1715.71	1734.85	259734.0
2009-07-20	YM	Futures	7844.2	7948.8	7819.8	7944.3	124418.0
2009-07-20	CL	Futures	165.73	169.67	165.29	168.1	254703.0
2009-07-20	GC	Futures	1299.3	1322.7	1297.2	1313.6	102845.0
2009-07-20	ZN	Futures	91.667652	92.295597	91.273648	92.197096	591013.0
2009-07-20	A6	Futures	0.64266	0.65439	0.6421	0.65254	59871.0
2009-07-20	AD	Futures	0.88608	0.89645	0.88539	0.8924	54046.0
2009-07-20	B	Futures	61.91	63.55	61.91	63.25	101595.0
2009-07-20	B6	Futures	1.7019	1.7245	1.7004	1.7219	90639.0
2009-07-20	BFX	Futures	2390.1	2401.2	2375.7	2388.4	194.0
2009-07-20	BR	Futures	0.20044	0.20295	0.20044	0.20248	29.0
2009-07-20	BZ	Futures	66.43	67.49	66.43	67.49	3.0
2009-07-20	C	Futures	1877.0	1933.0	1873.0	1909.0	6832.0
2009-07-20	CB	Futures	75.884	76.14	75.884	76.14	14.0
2009-07-20	CC	Futures	2466.0	2570.0	2466.0	2551.0	8859.0
2009-07-20	CT	Futures	54.75	55.75	54.45	55.73	147.0
2009-07-20	DC	Futures	20.72	22.02	20.72	21.97	804.0
2009-07-20	DX	Futures	81.392	81.479	80.783	80.911	7019.0
2009-07-20	E1	Futures	1.23046	1.24317	1.22993	1.23854	28237.0
2009-07-20	E6	Futures	1.67571	1.69174	1.67488	1.68794	180361.0
2009-07-20	E7	Futures	1.6579	1.6744	1.6578	1.6706	2241.0
2009-07-20	ED	Futures	93.9141	93.9377	93.9047	93.9283	122530.0
2009-07-20	ER	Futures	97.071	97.09	97.061	97.076	61296.0
2009-07-20	EW	Futures	568.7	577.6	566.8	576.6	26786.0
2009-07-20	FCE	Futures	2131.0	2152.7	2118.3	2142.5	93254.0
2009-07-20	FDAX	Futures	5526.5	5555.0	5493.5	5524.8	109238.0
2009-07-20	FESX	Futures	1490.5	1498.2	1480.3	1489.9	782556.0
2009-07-20	FEU3	Futures	97.663	97.663	97.653	97.653	159.0
2009-07-20	FGBL	Futures	91.83	92.23	91.51	91.92	584869.0
2009-07-20	FGBM	Futures	97.98	98.21	97.65	98.03	333945.0
2009-07-20	FGBS	Futures	104.152	104.176	103.993	104.123	389666.0
2009-07-20	FGBX	Futures	83.48	83.62	82.64	83.27	2626.0
2009-07-20	FTDX	Futures	580.0	588.0	580.0	582.6	398.0
2009-07-20	FTI	Futures	220.0	221.52	218.64	220.21	22127.0
2009-07-20	FTUK	Futures	2910.5	2942.0	2893.9	2930.7	78345.0
2009-07-20	G	Futures	74.88	75.07	74.63	74.98	47050.0
2009-07-20	GF	Futures	288.447	288.929	286.035	287.965	1427.0
2009-07-20	GSCI	Futures	909.9	911.78	897.57	910.11	211.0
2009-07-20	HE	Futures	93.24	93.564	92.52	93.06	5515.0
2009-07-20	HG	Futures	3.3959	3.4956	3.3839	3.4668	17501.0
2009-07-20	HO	Futures	1.6891	1.7485	1.6891	1.7411	28491.0
2009-07-20	HRC	Futures	2409.0	2409.0	2409.0	2409.0	0.0
2009-07-20	J1	Futures	0.0133558	0.0133823	0.0132879	0.0133697	63854.0
2009-07-20	J7	Futures	0.013148	0.013195	0.013117	0.013186	210.0
2009-07-20	KC	Futures	322.9	333.21	322.35	331.85	8593.0
2009-07-20	KE	Futures	2715.94	2772.29	2682.36	2738.72	9219.0
2009-07-20	L	Futures	97.347	97.367	97.347	97.357	24171.0
2009-07-20	LBS	Futures	748.6	760.7	742.1	759.1	558.0
2009-07-20	LE	Futures	153.256	153.256	151.466	152.965	15812.0

> showing 50 of 85 rows — these rows as CSV

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