PREVIEW / futures_daily / 2009-04-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-04-23.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-04-23	ES	Futures	796.79	810.13	792.26	808.94	2489552.0
2009-04-23	NQ	Futures	1492.3	1513.65	1481.91	1507.75	363322.0
2009-04-23	YM	Futures	6999.2	7166.9	6953.4	7099.7	196049.0
2009-04-23	CL	Futures	130.6	134.45	130.28	133.65	227296.0
2009-04-23	GC	Futures	1234.1	1260.6	1233.0	1255.3	90672.0
2009-04-23	ZN	Futures	94.791385	94.912756	94.402995	94.827796	671530.0
2009-04-23	A6	Futures	0.56097	0.56887	0.55866	0.56655	40018.0
2009-04-23	AD	Futures	0.79464	0.80547	0.79316	0.80389	51109.0
2009-04-23	B	Futures	47.71	48.86	47.64	48.47	84599.0
2009-04-23	B6	Futures	1.507	1.534	1.5028	1.5289	74500.0
2009-04-23	BFX	Futures	2053.9	2074.3	2052.8	2073.1	102.0
2009-04-23	BZ	Futures	50.95	51.24	50.39	51.16	120.0
2009-04-23	C	Futures	1834.0	1896.0	1834.0	1883.0	3059.0
2009-04-23	CB	Futures	76.436	76.737	76.436	76.436	59.0
2009-04-23	CC	Futures	2125.0	2184.0	2112.0	2170.0	5135.0
2009-04-23	CT	Futures	46.19	49.05	46.03	48.11	1511.0
2009-04-23	DC	Futures	27.91	27.96	26.97	27.02	323.0
2009-04-23	DX	Futures	89.084	89.239	88.06	88.307	5508.0
2009-04-23	E1	Futures	1.14004	1.15383	1.13646	1.15091	30150.0
2009-04-23	E6	Futures	1.54044	1.55976	1.53806	1.55407	137146.0
2009-04-23	E7	Futures	1.5227	1.5414	1.5203	1.536	1552.0
2009-04-23	EBM	Futures	221.37	228.72	221.37	225.62	6172.0
2009-04-23	ED	Futures	93.2377	93.2896	93.233	93.2755	186811.0
2009-04-23	ER	Futures	96.606	96.655	96.606	96.635	102974.0
2009-04-23	EW	Futures	515.6	522.7	506.6	518.3	36544.0
2009-04-23	FCE	Futures	1876.8	1914.2	1867.2	1884.4	129342.0
2009-04-23	FDAX	Futures	4976.1	5027.9	4932.0	4947.3	159565.0
2009-04-23	FESX	Futures	1320.1	1341.7	1311.1	1317.1	1148526.0
2009-04-23	FEU3	Futures	97.19	97.214	97.19	97.214	137.0
2009-04-23	FGBL	Futures	92.3	92.42	92.03	92.2	686610.0
2009-04-23	FGBM	Futures	97.44	97.58	97.29	97.41	457331.0
2009-04-23	FGBS	Futures	103.536	103.589	103.469	103.546	392888.0
2009-04-23	FGBX	Futures	83.11	83.51	82.77	83.28	2179.0
2009-04-23	FTDX	Futures	500.0	511.7	496.4	501.8	457.0
2009-04-23	FTI	Futures	191.81	196.54	191.6	192.22	39311.0
2009-04-23	FTUK	Futures	2643.4	2693.0	2631.8	2646.8	110988.0
2009-04-23	G	Futures	76.86	76.86	76.17	76.39	93459.0
2009-04-23	GF	Futures	277.212	278.958	276.305	277.003	539.0
2009-04-23	GSCI	Futures	766.61	769.37	759.17	764.48	201.0
2009-04-23	HE	Futures	115.026	115.356	113.994	114.778	595.0
2009-04-23	HG	Futures	2.8722	2.9552	2.7646	2.8012	12381.0
2009-04-23	HO	Futures	1.4539	1.4851	1.441	1.4568	25699.0
2009-04-23	HRC	Futures	2595.1	2595.1	2595.1	2595.1	0.0
2009-04-23	J1	Futures	0.0128736	0.0129177	0.0128106	0.0128875	69161.0
2009-04-23	J7	Futures	0.012726	0.012735	0.012642	0.012712	30.0
2009-04-23	JB	Futures	114.99	115.12	114.85	114.87	1854.0
2009-04-23	KC	Futures	326.13	328.21	325.02	327.65	6609.0
2009-04-23	KE	Futures	2810.12	2882.84	2789.17	2879.14	3158.0
2009-04-23	L	Futures	96.915	96.954	96.895	96.934	49238.0
2009-04-23	LBS	Futures	903.8	917.2	896.0	917.2	103.0

> showing 50 of 86 rows — these rows as CSV

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