PREVIEW / futures_daily / 2009-02-06

all futures daily files

  file:    by_date/futures_daily/2009/2009-02-06.parquet
  size:    8 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-02-06	ES	Futures	794.38	820.82	790.13	819.41	2419130.0
2009-02-06	NQ	Futures	1382.39	1430.46	1375.4	1426.27	337645.0
2009-02-06	YM	Futures	7123.1	7372.4	7092.0	7349.3	205659.0
2009-02-06	CL	Futures	136.2	141.79	128.23	133.45	518382.0
2009-02-06	GC	Futures	1270.0	1279.3	1256.4	1268.8	77397.0
2009-02-06	ZN	Futures	93.542943	93.770047	93.005065	93.196311	515504.0
2009-02-06	A6	Futures	0.51512	0.53804	0.5121	0.53439	43731.0
2009-02-06	AD	Futures	0.79702	0.80704	0.78277	0.80104	47173.0
2009-02-06	B	Futures	48.83	49.08	46.04	48.12	111116.0
2009-02-06	B6	Futures	1.5178	1.5419	1.515	1.5369	82388.0
2009-02-06	BFX	Futures	2119.8	2126.2	2104.5	2115.4	341.0
2009-02-06	BR	Futures	0.16068	0.16127	0.16068	0.16068	1.0
2009-02-06	BZ	Futures	47.74	50.34	47.73	49.45	279.0
2009-02-06	C	Futures	1959.0	1997.0	1956.0	1991.0	4272.0
2009-02-06	CB	Futures	74.855	74.855	74.689	74.689	8.0
2009-02-06	CC	Futures	2451.0	2501.0	2436.0	2492.0	10609.0
2009-02-06	CT	Futures	48.64	49.11	48.15	48.53	7685.0
2009-02-06	DC	Futures	26.94	27.64	26.86	27.37	142.0
2009-02-06	DX	Futures	89.539	89.845	88.507	88.808	5310.0
2009-02-06	E1	Futures	1.1351	1.14746	1.13231	1.14374	32336.0
2009-02-06	E6	Futures	1.51279	1.53765	1.50805	1.53138	210520.0
2009-02-06	E7	Futures	1.4959	1.5199	1.4913	1.5139	2439.0
2009-02-06	EBM	Futures	228.17	232.39	228.17	230.09	3392.0
2009-02-06	ED	Futures	93.053	93.1755	93.0059	93.1566	278654.0
2009-02-06	ER	Futures	96.351	96.42	96.331	96.385	104375.0
2009-02-06	EW	Futures	496.9	519.6	495.0	519.1	36279.0
2009-02-06	FCE	Futures	1901.2	1945.7	1889.5	1928.7	146208.0
2009-02-06	FDAX	Futures	4937.7	5120.6	4924.1	5055.1	167532.0
2009-02-06	FESX	Futures	1320.3	1360.5	1314.5	1345.0	1402302.0
2009-02-06	FEU3	Futures	96.914	96.963	96.914	96.953	245.0
2009-02-06	FGBL	Futures	91.43	91.69	90.97	91.15	645768.0
2009-02-06	FGBM	Futures	97.5	97.54	97.23	97.4	355028.0
2009-02-06	FGBS	Futures	103.695	103.738	103.623	103.709	345894.0
2009-02-06	FGBX	Futures	82.9	83.68	82.86	83.24	887.0
2009-02-06	FTDX	Futures	438.5	452.8	436.7	443.9	445.0
2009-02-06	FTI	Futures	203.83	211.73	203.14	210.72	37843.0
2009-02-06	FTUK	Futures	2777.4	2827.9	2751.8	2794.1	120000.0
2009-02-06	G	Futures	73.33	73.77	73.19	73.32	66204.0
2009-02-06	GF	Futures	264.063	267.149	263.993	264.694	879.0
2009-02-06	GSCI	Futures	777.01	802.1	765.75	783.81	77.0
2009-02-06	HE	Futures	115.889	118.16	115.889	116.759	5200.0
2009-02-06	HG	Futures	2.1246	2.3005	2.1232	2.2921	22800.0
2009-02-06	HO	Futures	1.5175	1.5459	1.4457	1.5145	35259.0
2009-02-06	HRC	Futures	2953.3	2953.3	2953.3	2953.3	0.0
2009-02-06	J1	Futures	0.0138654	0.0139298	0.0137049	0.0137176	97819.0
2009-02-06	J7	Futures	0.013707	0.013759	0.013548	0.013553	114.0
2009-02-06	JB	Futures	115.75	115.97	115.68	115.76	1695.0
2009-02-06	KC	Futures	339.82	345.11	336.53	341.68	14231.0
2009-02-06	KE	Futures	2949.19	2987.91	2914.21	2930.45	8391.0
2009-02-06	L	Futures	96.669	96.709	96.63	96.645	95235.0

> showing 50 of 87 rows — these rows as CSV

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