PREVIEW / futures_daily / 2009-11-04

all futures daily files

  file:    by_date/futures_daily/2009/2009-11-04.parquet
  size:    9 KB
  rows:    89

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-11-04	ES	Futures	1004.8	1020.96	1003.84	1009.87	2360779.0
2009-11-04	NQ	Futures	1890.81	1919.03	1889.12	1904.07	350126.0
2009-11-04	YM	Futures	8820.8	8976.1	8817.2	8883.5	195523.0
2009-11-04	CL	Futures	194.73	198.63	193.87	197.01	366103.0
2009-11-04	GC	Futures	1500.8	1518.6	1493.7	1503.1	190846.0
2009-11-04	ZN	Futures	94.202064	94.264334	93.69145	93.915622	958980.0
2009-11-04	A6	Futures	0.72675	0.73629	0.72102	0.73581	100910.0
2009-11-04	AD	Futures	0.92448	0.93069	0.92261	0.92931	89684.0
2009-11-04	B	Futures	73.01	74.54	72.92	74.05	78022.0
2009-11-04	B6	Futures	1.7088	1.7272	1.706	1.7261	124133.0
2009-11-04	BFX	Futures	2682.2	2723.9	2682.2	2718.7	115.0
2009-11-04	BR	Futures	0.22897	0.22897	0.22897	0.22897	57.0
2009-11-04	BZ	Futures	79.11	79.11	78.84	78.84	2.0
2009-11-04	C	Futures	2229.0	2241.0	2214.0	2235.0	3457.0
2009-11-04	CB	Futures	77.459	77.459	77.459	77.459	1.0
2009-11-04	CC	Futures	2873.0	2887.0	2838.0	2862.0	9783.0
2009-11-04	CT	Futures	58.25	59.29	58.21	58.78	5960.0
2009-11-04	DC	Futures	25.19	25.26	25.04	25.22	67.0
2009-11-04	DX	Futures	78.124	78.149	77.291	77.414	25616.0
2009-11-04	E1	Futures	1.28761	1.3069	1.2855	1.30307	66806.0
2009-11-04	E6	Futures	1.7443	1.76681	1.74216	1.76527	290221.0
2009-11-04	E7	Futures	1.7273	1.7499	1.7257	1.7484	4192.0
2009-11-04	ED	Futures	94.2285	94.2474	94.219	94.2427	158952.0
2009-11-04	ER	Futures	97.149	97.154	97.135	97.139	89724.0
2009-11-04	EW	Futures	647.4	656.4	644.2	647.0	45411.0
2009-11-04	FBTP	Futures	62.62	62.62	62.43	62.52	4012.0
2009-11-04	FCE	Futures	2370.7	2424.2	2370.7	2415.7	127890.0
2009-11-04	FDAX	Futures	5858.9	5956.3	5849.1	5926.9	162183.0
2009-11-04	FESX	Futures	1623.5	1650.4	1621.7	1643.2	1499708.0
2009-11-04	FEU3	Futures	97.717	97.722	97.712	97.712	211.0
2009-11-04	FGBL	Futures	93.71	93.72	93.17	93.44	706565.0
2009-11-04	FGBM	Futures	99.17	99.19	98.88	99.03	382700.0
2009-11-04	FGBS	Futures	104.745	104.75	104.687	104.706	361965.0
2009-11-04	FGBX	Futures	86.68	86.68	85.95	86.18	2041.0
2009-11-04	FTDX	Futures	643.8	655.8	643.3	654.0	484.0
2009-11-04	FTI	Futures	246.5	250.63	246.46	249.61	31887.0
2009-11-04	FTUK	Futures	3343.9	3384.7	3342.2	3372.8	100728.0
2009-11-04	G	Futures	76.27	76.28	75.91	76.04	113031.0
2009-11-04	GF	Futures	261.851	263.433	260.269	262.401	839.0
2009-11-04	GSCI	Futures	1015.14	1017.11	1003.53	1011.9	870.0
2009-11-04	HE	Futures	87.958	88.644	87.158	88.111	11789.0
2009-11-04	HG	Futures	4.1499	4.2063	4.1269	4.1708	23918.0
2009-11-04	HO	Futures	2.0013	2.0339	1.9923	2.0248	45362.0
2009-11-04	HRC	Futures	2713.1	2713.1	2713.1	2713.1	0.0
2009-11-04	J1	Futures	0.0139016	0.0139468	0.0137396	0.01383	102917.0
2009-11-04	J7	Futures	0.013762	0.013762	0.013575	0.01365	66.0
2009-11-04	JB	Futures	116.72	116.76	116.39	116.4	1538.0
2009-11-04	KC	Futures	372.46	377.35	368.77	371.54	10420.0
2009-11-04	KE	Futures	2423.07	2474.26	2370.72	2450.99	7990.0
2009-11-04	L	Futures	97.779	97.779	97.75	97.75	34909.0

> showing 50 of 89 rows — these rows as CSV

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