PREVIEW / futures_daily / 2009-07-09

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-09.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-09	ES	Futures	838.55	848.62	838.07	843.35	1779181.0
2009-07-09	NQ	Futures	1584.51	1600.56	1583.95	1591.83	223831.0
2009-07-09	YM	Futures	7325.4	7389.4	7301.0	7338.9	116077.0
2009-07-09	CL	Futures	158.87	162.13	155.9	158.95	314800.0
2009-07-09	GC	Futures	1258.9	1272.2	1254.6	1268.4	91682.0
2009-07-09	ZN	Futures	93.342172	93.354485	92.751165	92.874292	802745.0
2009-07-09	A6	Futures	0.62378	0.62916	0.62032	0.62747	64039.0
2009-07-09	AD	Futures	0.84667	0.85556	0.84607	0.85091	50724.0
2009-07-09	B	Futures	58.06	59.43	57.18	58.38	87951.0
2009-07-09	B6	Futures	1.6724	1.7061	1.6692	1.7037	111173.0
2009-07-09	BFX	Futures	2243.9	2260.2	2238.9	2250.1	128.0
2009-07-09	BR	Futures	0.18978	0.1937	0.18978	0.1937	14.0
2009-07-09	BZ	Futures	61.76	62.3	61.76	62.3	2.0
2009-07-09	C	Futures	1738.0	1820.0	1734.0	1805.0	4215.0
2009-07-09	CB	Futures	72.189	72.758	71.905	72.189	19.0
2009-07-09	CC	Futures	2258.0	2376.0	2232.0	2354.0	12189.0
2009-07-09	CT	Futures	50.49	52.54	50.49	52.28	286.0
2009-07-09	DC	Futures	20.12	20.44	19.92	19.96	97.0
2009-07-09	DX	Futures	82.83	83.014	81.76	81.934	7361.0
2009-07-09	E1	Futures	1.21405	1.23245	1.21365	1.22914	40873.0
2009-07-09	E6	Futures	1.64698	1.67072	1.64508	1.6661	251701.0
2009-07-09	E7	Futures	1.6304	1.6535	1.6283	1.649	2510.0
2009-07-09	ED	Futures	93.9094	93.9141	93.8858	93.9047	170183.0
2009-07-09	ER	Futures	97.017	97.027	97.012	97.022	75203.0
2009-07-09	EW	Futures	526.5	532.9	524.6	528.2	26536.0
2009-07-09	FCE	Futures	1967.1	1996.4	1965.1	1973.6	123576.0
2009-07-09	FDAX	Futures	5036.6	5125.4	5034.4	5071.1	131190.0
2009-07-09	FESX	Futures	1367.0	1392.6	1367.0	1374.7	958312.0
2009-07-09	FEU3	Futures	97.594	97.603	97.594	97.599	179.0
2009-07-09	FGBL	Futures	92.92	92.97	92.52	92.71	649841.0
2009-07-09	FGBM	Futures	98.6	98.64	98.33	98.43	371789.0
2009-07-09	FGBS	Futures	104.297	104.301	104.176	104.21	423931.0
2009-07-09	FGBX	Futures	84.5	84.53	84.01	84.27	1865.0
2009-07-09	FTDX	Futures	545.2	553.2	544.3	546.1	783.0
2009-07-09	FTI	Futures	199.8	202.28	199.11	200.86	25721.0
2009-07-09	FTUK	Futures	2728.0	2756.8	2724.3	2732.0	76778.0
2009-07-09	G	Futures	76.31	76.47	75.13	75.28	125782.0
2009-07-09	GF	Futures	280.316	284.519	280.178	283.761	2771.0
2009-07-09	GSCI	Futures	851.28	853.26	833.03	841.37	3647.0
2009-07-09	HE	Futures	87.554	92.16	87.554	91.693	27131.0
2009-07-09	HG	Futures	3.0371	3.1501	3.0259	3.1417	19247.0
2009-07-09	HO	Futures	1.6117	1.6291	1.5735	1.5965	19561.0
2009-07-09	HRC	Futures	2409.0	2409.0	2409.0	2409.0	0.0
2009-07-09	J1	Futures	0.01359	0.0136366	0.0134591	0.0135422	108075.0
2009-07-09	J7	Futures	0.01339	0.013439	0.013285	0.013356	277.0
2009-07-09	JB	Futures	116.84	117.06	116.71	116.79	3214.0
2009-07-09	KC	Futures	313.13	322.35	310.55	313.81	11151.0
2009-07-09	KE	Futures	2621.21	2679.96	2621.21	2645.19	7719.0
2009-07-09	L	Futures	97.278	97.298	97.229	97.249	60863.0
2009-07-09	LBS	Futures	828.3	828.3	804.1	812.3	138.0

> showing 50 of 86 rows — these rows as CSV

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