PREVIEW / futures_daily / 2009-07-07

all futures daily files

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

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-07	ES	Futures	859.42	861.82	839.75	843.59	1930545.0
2009-07-07	NQ	Futures	1622.8	1629.28	1578.03	1585.64	286819.0
2009-07-07	YM	Futures	7468.8	7485.1	7295.6	7336.2	144379.0
2009-07-07	CL	Futures	168.89	170.79	163.68	165.58	262358.0
2009-07-07	GC	Futures	1280.1	1290.9	1275.1	1286.3	78415.0
2009-07-07	ZN	Futures	92.012406	92.504912	91.840029	92.418724	691052.0
2009-07-07	A6	Futures	0.63647	0.64282	0.63036	0.6331	65914.0
2009-07-07	AD	Futures	0.8524	0.85615	0.84617	0.84864	46030.0
2009-07-07	B	Futures	61.62	62.06	59.84	60.45	86605.0
2009-07-07	B6	Futures	1.6949	1.6972	1.6784	1.682	87007.0
2009-07-07	BFX	Futures	2283.2	2308.1	2267.0	2267.0	380.0
2009-07-07	BR	Futures	0.19383	0.19383	0.19383	0.19383	41.0
2009-07-07	BZ	Futures	64.91	64.91	64.5	64.5	2.0
2009-07-07	C	Futures	1705.0	1742.0	1704.0	1707.0	913.0
2009-07-07	CB	Futures	70.512	71.337	70.512	71.067	22.0
2009-07-07	CC	Futures	2196.0	2256.0	2176.0	2195.0	6029.0
2009-07-07	CT	Futures	51.7	51.75	49.99	51.04	203.0
2009-07-07	DC	Futures	19.76	20.6	19.74	20.24	127.0
2009-07-07	DX	Futures	82.441	82.983	82.211	82.768	4809.0
2009-07-07	E1	Futures	1.2208	1.22676	1.21365	1.21736	38130.0
2009-07-07	E6	Futures	1.65885	1.66799	1.65031	1.65327	206072.0
2009-07-07	E7	Futures	1.6417	1.6506	1.6334	1.6363	2727.0
2009-07-07	ED	Futures	93.8669	93.8811	93.8575	93.8763	128389.0
2009-07-07	ER	Futures	97.007	97.022	96.983	97.012	108239.0
2009-07-07	EW	Futures	543.0	544.5	528.4	531.9	28231.0
2009-07-07	FCE	Futures	2019.9	2031.7	1973.9	1988.0	114529.0
2009-07-07	FDAX	Futures	5123.2	5162.7	5017.4	5042.6	140892.0
2009-07-07	FESX	Futures	1402.8	1411.7	1370.0	1379.5	980567.0
2009-07-07	FEU3	Futures	97.564	97.589	97.564	97.589	49.0
2009-07-07	FGBL	Futures	92.64	92.77	92.37	92.54	534269.0
2009-07-07	FGBM	Futures	98.44	98.48	98.3	98.38	318078.0
2009-07-07	FGBS	Futures	104.229	104.258	104.167	104.22	327687.0
2009-07-07	FGBX	Futures	84.36	84.36	83.83	84.13	5325.0
2009-07-07	FTDX	Futures	546.1	553.2	537.1	541.6	604.0
2009-07-07	FTI	Futures	204.07	205.37	201.47	202.2	28540.0
2009-07-07	FTUK	Futures	2774.8	2794.3	2735.6	2751.9	89034.0
2009-07-07	G	Futures	75.82	75.95	75.62	75.8	73024.0
2009-07-07	GF	Futures	286.104	286.38	282.521	282.934	2390.0
2009-07-07	GSCI	Futures	883.51	886.12	861.4	862.23	660.0
2009-07-07	HE	Futures	89.102	89.893	88.382	89.533	11178.0
2009-07-07	HG	Futures	3.1761	3.2253	3.0898	3.1249	15450.0
2009-07-07	HO	Futures	1.7004	1.7098	1.6492	1.6666	15431.0
2009-07-07	HRC	Futures	2382.2	2382.2	2382.2	2382.2	0.0
2009-07-07	J1	Futures	0.0132161	0.0133042	0.0131972	0.0132954	77704.0
2009-07-07	J7	Futures	0.013037	0.013118	0.013024	0.013112	32.0
2009-07-07	JB	Futures	116.71	116.76	116.57	116.63	1204.0
2009-07-07	KC	Futures	322.35	323.71	316.11	316.65	7175.0
2009-07-07	KE	Futures	2642.79	2678.76	2609.22	2609.22	10073.0
2009-07-07	L	Futures	97.219	97.249	97.209	97.229	36742.0
2009-07-07	LBS	Futures	848.8	855.2	834.7	851.1	236.0

> showing 50 of 86 rows — these rows as CSV

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