PREVIEW / futures_daily / 2009-09-30

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-30.parquet
  size:    9 KB
  rows:    87

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-30	ES	Futures	1017.34	1025.54	1004.56	1015.65	2852909.0
2009-09-30	NQ	Futures	1935.96	1952.9	1906.33	1938.78	427976.0
2009-09-30	YM	Futures	8781.8	8838.1	8664.7	8763.6	221193.0
2009-09-30	CL	Futures	165.2	175.14	163.99	174.86	386690.0
2009-09-30	GC	Futures	1374.1	1397.4	1372.3	1395.3	142136.0
2009-09-30	ZN	Futures	94.31415	94.463598	94.102432	94.31415	939177.0
2009-09-30	A6	Futures	0.6996	0.71067	0.69944	0.70906	100493.0
2009-09-30	AD	Futures	0.909	0.92409	0.9087	0.9233	101566.0
2009-09-30	B	Futures	61.93	65.36	61.32	65.11	81510.0
2009-09-30	B6	Futures	1.6601	1.6777	1.6586	1.665	167643.0
2009-09-30	BFX	Futures	2835.5	2836.9	2805.8	2822.9	484.0
2009-09-30	BR	Futures	0.21955	0.22241	0.21955	0.22241	27.0
2009-09-30	C	Futures	2118.0	2172.0	2112.0	2167.0	6645.0
2009-09-30	CB	Futures	69.659	71.542	69.659	71.542	4.0
2009-09-30	CC	Futures	2698.0	2771.0	2690.0	2755.0	8761.0
2009-09-30	CT	Futures	52.95	54.44	52.34	54.23	11149.0
2009-09-30	DC	Futures	23.84	24.22	23.79	23.86	160.0
2009-09-30	DX	Futures	78.899	78.91	78.287	78.471	12105.0
2009-09-30	E1	Futures	1.2752	1.2855	1.2645	1.27599	105195.0
2009-09-30	E6	Futures	1.72853	1.73908	1.72723	1.73564	294482.0
2009-09-30	E7	Futures	1.7114	1.7225	1.7106	1.719	3462.0
2009-09-30	ED	Futures	94.1718	94.1954	94.1623	94.1812	160272.0
2009-09-30	ER	Futures	97.184	97.184	97.135	97.159	214584.0
2009-09-30	EW	Futures	670.9	676.4	658.8	668.3	60523.0
2009-09-30	FCE	Futures	2522.0	2536.5	2481.8	2505.9	146564.0
2009-09-30	FDAX	Futures	6222.8	6252.2	6113.5	6173.9	179827.0
2009-09-30	FESX	Futures	1721.4	1730.4	1691.6	1706.5	1350411.0
2009-09-30	FEU3	Futures	97.751	97.751	97.727	97.732	847.0
2009-09-30	FGBL	Futures	93.79	94.01	93.69	93.92	888267.0
2009-09-30	FGBM	Futures	99.07	99.22	98.91	99.14	516575.0
2009-09-30	FGBS	Futures	104.721	104.726	104.576	104.706	787965.0
2009-09-30	FGBX	Futures	87.67	88.29	87.67	88.15	3423.0
2009-09-30	FTDX	Futures	672.7	676.7	665.2	671.0	567.0
2009-09-30	FTI	Futures	256.67	258.85	254.16	256.79	36018.0
2009-09-30	FTUK	Futures	3405.6	3422.8	3356.2	3376.7	157265.0
2009-09-30	G	Futures	76.79	77.03	76.69	76.95	106058.0
2009-09-30	GF	Futures	263.781	266.259	261.715	265.708	856.0
2009-09-30	GSCI	Futures	896.54	928.96	883.73	926.56	732.0
2009-09-30	HE	Futures	75.915	76.22	74.01	75.611	15928.0
2009-09-30	HG	Futures	3.7869	3.9416	3.7813	3.9283	30056.0
2009-09-30	HO	Futures	1.6952	1.8042	1.6847	1.8008	25210.0
2009-09-30	HRC	Futures	2763.8	2763.8	2763.8	2763.8	0.0
2009-09-30	J1	Futures	0.013938	0.0140598	0.013894	0.0140158	99598.0
2009-09-30	J7	Futures	0.01375	0.013874	0.013716	0.013833	44.0
2009-09-30	JB	Futures	117.63	117.63	117.47	117.56	1379.0
2009-09-30	KC	Futures	331.68	337.88	331.41	337.35	6464.0
2009-09-30	KE	Futures	2172.97	2231.13	2140.4	2217.17	10535.0
2009-09-30	L	Futures	97.789	97.838	97.75	97.809	131097.0
2009-09-30	LBS	Futures	687.2	696.5	683.9	687.6	1611.0
2009-09-30	LE	Futures	143.34	144.47	142.0	144.177	20759.0

> showing 50 of 87 rows — these rows as CSV

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