PREVIEW / futures_daily / 2009-09-02

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-02.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-09-02	ES	Futures	955.84	960.4	950.81	953.92	1920576.0
2009-09-02	NQ	Futures	1796.51	1805.24	1785.25	1793.98	279445.0
2009-09-02	YM	Futures	8392.7	8427.9	8353.0	8370.2	149510.0
2009-09-02	CL	Futures	170.16	171.66	167.29	169.79	269497.0
2009-09-02	GC	Futures	1324.5	1358.1	1316.8	1352.7	155929.0
2009-09-02	ZN	Futures	93.723864	94.154807	93.600738	94.080931	60784.0
2009-09-02	A6	Futures	0.6642	0.67239	0.66155	0.67119	108727.0
2009-09-02	AD	Futures	0.89487	0.89734	0.88953	0.89309	65884.0
2009-09-02	B	Futures	64.78	65.39	63.72	64.55	65267.0
2009-09-02	B6	Futures	1.6827	1.6978	1.6779	1.6954	113264.0
2009-09-02	BFX	Futures	2638.6	2638.6	2595.4	2616.3	317.0
2009-09-02	BR	Futures	0.2048	0.20989	0.2048	0.20794	24.0
2009-09-02	BZ	Futures	66.93	67.18	66.85	67.18	10.0
2009-09-02	C	Futures	1933.0	1995.0	1933.0	1995.0	905.0
2009-09-02	CB	Futures	68.045	68.045	68.045	68.045	15.0
2009-09-02	CC	Futures	2476.0	2589.0	2471.0	2579.0	7784.0
2009-09-02	CT	Futures	49.89	50.6	49.36	50.32	75.0
2009-09-02	DC	Futures	22.22	22.71	22.18	22.46	56.0
2009-09-02	DX	Futures	80.68	80.757	80.138	80.281	7229.0
2009-09-02	E1	Futures	1.24238	1.25112	1.23867	1.2486	42656.0
2009-09-02	E6	Futures	1.68829	1.69708	1.68438	1.69423	204208.0
2009-09-02	E7	Futures	1.6694	1.6794	1.6673	1.6768	1945.0
2009-09-02	ED	Futures	94.0888	94.1124	94.0746	94.1077	151227.0
2009-09-02	ER	Futures	97.144	97.164	97.144	97.154	58840.0
2009-09-02	EW	Futures	618.7	621.2	613.6	615.9	34777.0
2009-09-02	FCE	Futures	2342.7	2346.6	2309.9	2340.4	165029.0
2009-09-02	FDAX	Futures	5846.8	5859.4	5775.0	5836.9	162795.0
2009-09-02	FESX	Futures	1618.2	1621.2	1595.5	1614.6	1312600.0
2009-09-02	FEU3	Futures	97.736	97.736	97.731	97.736	331.0
2009-09-02	FGBL	Futures	93.38	93.58	93.28	93.41	944593.0
2009-09-02	FGBM	Futures	98.86	98.95	98.76	98.85	584018.0
2009-09-02	FGBS	Futures	104.456	104.489	104.407	104.446	814610.0
2009-09-02	FGBX	Futures	86.76	86.85	86.43	86.55	12186.0
2009-09-02	FTDX	Futures	605.0	605.0	592.9	600.0	1203.0
2009-09-02	FTI	Futures	239.72	239.85	236.25	238.77	49186.0
2009-09-02	FTUK	Futures	3191.3	3200.6	3167.7	3195.9	123667.0
2009-09-02	G	Futures	76.94	77.13	76.93	77.02	100589.0
2009-09-02	GF	Futures	268.501	272.855	267.671	272.578	993.0
2009-09-02	GSCI	Futures	897.52	906.99	891.6	899.86	528.0
2009-09-02	HE	Futures	73.525	74.162	72.4	73.187	10870.0
2009-09-02	HG	Futures	3.8977	3.9562	3.8183	3.9381	27401.0
2009-09-02	HO	Futures	1.761	1.7849	1.7431	1.7555	10818.0
2009-09-02	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-02	J1	Futures	0.0135497	0.0136693	0.0135283	0.0136605	106403.0
2009-09-02	J7	Futures	0.013361	0.013482	0.013344	0.013472	77.0
2009-09-02	JB	Futures	117.28	117.56	117.27	117.48	2409.0
2009-09-02	KC	Futures	316.76	322.31	316.5	319.8	6451.0
2009-09-02	KE	Futures	2368.4	2387.01	2354.44	2359.09	7019.0
2009-09-02	L	Futures	97.612	97.651	97.612	97.632	78907.0
2009-09-02	LBS	Futures	694.6	696.2	682.4	688.5	320.0

> showing 50 of 86 rows — these rows as CSV

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