PREVIEW / futures_daily / 2009-06-04

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-04.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-06-04	ES	Futures	887.33	897.81	884.47	896.38	1786027.0
2009-06-04	NQ	Futures	1658.02	1678.24	1655.77	1677.4	204494.0
2009-06-04	YM	Futures	7768.8	7844.1	7737.4	7830.7	110604.0
2009-06-04	CL	Futures	175.94	185.29	175.49	183.19	304674.0
2009-06-04	GC	Futures	1334.6	1361.5	1331.9	1360.0	115369.0
2009-06-04	ZN	Futures	91.526483	91.526483	90.482685	90.652606	31296.0
2009-06-04	A6	Futures	0.63745	0.64503	0.62804	0.63945	97906.0
2009-06-04	AD	Futures	0.88443	0.90097	0.88168	0.89763	89184.0
2009-06-04	B	Futures	63.85	67.14	63.77	66.43	65589.0
2009-06-04	B6	Futures	1.6959	1.71	1.6736	1.6848	147902.0
2009-06-04	BFX	Futures	2346.8	2349.1	2329.7	2349.1	889.0
2009-06-04	BR	Futures	0.19457	0.19718	0.19457	0.19718	1.0
2009-06-04	BZ	Futures	71.76	72.85	71.76	72.49	8.0
2009-06-04	C	Futures	1862.0	1900.0	1838.0	1892.0	5008.0
2009-06-04	CB	Futures	75.6	75.6	74.463	74.747	14.0
2009-06-04	CC	Futures	2412.0	2446.0	2369.0	2430.0	5225.0
2009-06-04	CT	Futures	51.77	52.64	51.06	52.63	14507.0
2009-06-04	DC	Futures	23.62	23.62	23.35	23.48	204.0
2009-06-04	DX	Futures	81.866	82.381	81.428	81.814	11461.0
2009-06-04	E1	Futures	1.23802	1.24624	1.23153	1.23975	45876.0
2009-06-04	E6	Futures	1.67712	1.68827	1.66788	1.6808	275312.0
2009-06-04	E7	Futures	1.658	1.6688	1.6486	1.6613	2976.0
2009-06-04	ED	Futures	93.6926	93.6926	93.6572	93.6667	184862.0
2009-06-04	ER	Futures	96.753	96.762	96.679	96.694	238274.0
2009-06-04	EW	Futures	570.6	577.5	565.8	576.8	28129.0
2009-06-04	FCE	Futures	2150.8	2180.1	2147.3	2154.8	111542.0
2009-06-04	FDAX	Futures	5505.5	5580.1	5494.6	5527.8	127981.0
2009-06-04	FESX	Futures	1487.5	1505.5	1485.1	1494.7	997790.0
2009-06-04	FEU3	Futures	97.337	97.337	97.273	97.273	1044.0
2009-06-04	FGBL	Futures	90.36	90.54	89.84	89.99	1241057.0
2009-06-04	FGBM	Futures	97.16	97.33	96.65	96.79	742119.0
2009-06-04	FGBS	Futures	103.882	103.939	103.603	103.661	936553.0
2009-06-04	FGBX	Futures	80.37	80.37	79.51	79.68	19515.0
2009-06-04	FTDX	Futures	581.0	590.8	581.0	586.4	302.0
2009-06-04	FTI	Futures	216.76	219.31	215.98	217.25	26462.0
2009-06-04	FTUK	Futures	2925.4	2954.7	2900.5	2923.8	95027.0
2009-06-04	G	Futures	74.94	75.22	74.57	74.66	57829.0
2009-06-04	GF	Futures	266.121	267.844	263.571	266.259	1482.0
2009-06-04	GSCI	Futures	953.15	980.24	952.72	974.06	422.0
2009-06-04	HE	Futures	87.692	89.592	87.509	88.569	6490.0
2009-06-04	HG	Futures	3.1234	3.2612	3.1065	3.2373	18767.0
2009-06-04	HO	Futures	1.8318	1.8971	1.8318	1.8759	8916.0
2009-06-04	HRC	Futures	2279.4	2279.4	2279.4	2279.4	0.0
2009-06-04	J1	Futures	0.0131408	0.0131446	0.0129946	0.013011	77523.0
2009-06-04	J7	Futures	0.012929	0.012955	0.012821	0.012834	39.0
2009-06-04	JB	Futures	114.25	114.75	114.24	114.59	1813.0
2009-06-04	KC	Futures	383.35	386.53	376.97	385.7	8268.0
2009-06-04	KE	Futures	3281.39	3398.41	3261.89	3364.28	8738.0
2009-06-04	L	Futures	97.111	97.111	97.023	97.043	87490.0
2009-06-04	LBS	Futures	917.7	962.9	912.7	962.9	638.0

> showing 50 of 86 rows — these rows as CSV

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