PREVIEW / futures_daily / 2009-08-04

all futures daily files

  file:    by_date/futures_daily/2009/2009-08-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-08-04	ES	Futures	959.68	964.24	951.76	964.0	1874293.0
2009-08-04	NQ	Futures	1830.58	1838.46	1816.22	1835.93	267943.0
2009-08-04	YM	Futures	8342.2	8381.0	8283.6	8379.2	127187.0
2009-08-04	CL	Futures	183.68	185.25	180.64	183.88	285877.0
2009-08-04	GC	Futures	1327.1	1344.7	1317.6	1340.5	94661.0
2009-08-04	ZN	Futures	91.618402	91.876967	91.138208	91.446025	766545.0
2009-08-04	A6	Futures	0.67464	0.67874	0.67183	0.67448	67871.0
2009-08-04	AD	Futures	0.92657	0.92924	0.91749	0.91946	61710.0
2009-08-04	B	Futures	69.84	71.08	68.86	70.66	49884.0
2009-08-04	B6	Futures	1.7636	1.7711	1.7588	1.7623	102748.0
2009-08-04	BFX	Futures	2484.6	2494.1	2475.1	2494.1	83.0
2009-08-04	BR	Futures	0.21175	0.21181	0.21175	0.21175	48.0
2009-08-04	BZ	Futures	72.83	74.1	72.72	73.71	7.0
2009-08-04	C	Futures	1894.0	1921.0	1893.0	1911.0	2396.0
2009-08-04	CB	Futures	73.895	73.895	73.752	73.752	27.0
2009-08-04	CC	Futures	2610.0	2626.0	2562.0	2619.0	6956.0
2009-08-04	CT	Futures	53.71	53.87	52.89	53.65	80.0
2009-08-04	DC	Futures	22.46	22.52	21.45	21.54	489.0
2009-08-04	DX	Futures	79.539	79.754	79.38	79.713	5461.0
2009-08-04	E1	Futures	1.25045	1.25217	1.24397	1.24781	33350.0
2009-08-04	E6	Futures	1.71156	1.71334	1.70563	1.70812	168745.0
2009-08-04	E7	Futures	1.6941	1.6956	1.6882	1.6906	1923.0
2009-08-04	ED	Futures	93.9613	93.9802	93.9613	93.9708	105093.0
2009-08-04	ER	Futures	97.125	97.13	97.1	97.105	117517.0
2009-08-04	EW	Futures	617.3	625.7	612.1	625.6	33946.0
2009-08-04	FCE	Futures	2279.8	2287.0	2255.3	2277.2	103154.0
2009-08-04	FDAX	Futures	5939.0	5964.8	5882.5	5945.0	109593.0
2009-08-04	FESX	Futures	1592.5	1601.5	1577.0	1592.5	893134.0
2009-08-04	FEU3	Futures	97.697	97.697	97.682	97.682	457.0
2009-08-04	FGBL	Futures	92.45	92.74	92.32	92.42	634134.0
2009-08-04	FGBM	Futures	98.07	98.29	97.87	97.96	330560.0
2009-08-04	FGBS	Futures	103.984	104.07	103.878	103.926	455565.0
2009-08-04	FGBX	Futures	85.43	85.92	85.27	85.46	1634.0
2009-08-04	FTDX	Futures	610.3	612.1	603.6	605.8	303.0
2009-08-04	FTI	Futures	235.44	235.49	232.12	234.91	28633.0
2009-08-04	FTUK	Futures	3087.1	3094.7	3048.9	3077.1	109084.0
2009-08-04	G	Futures	74.77	75.39	74.7	75.06	96800.0
2009-08-04	GF	Futures	280.798	281.143	277.422	278.249	1254.0
2009-08-04	GSCI	Futures	976.13	992.43	972.37	990.34	1305.0
2009-08-04	HE	Futures	77.347	78.809	73.937	75.136	13227.0
2009-08-04	HG	Futures	3.8578	3.9301	3.7827	3.9252	21851.0
2009-08-04	HO	Futures	1.9016	1.9421	1.8703	1.9243	39473.0
2009-08-04	HRC	Futures	2434.4	2434.4	2434.4	2434.4	0.0
2009-08-04	J1	Futures	0.0132211	0.0133495	0.0131922	0.0132211	94369.0
2009-08-04	J7	Futures	0.013029	0.013154	0.013013	0.013039	60.0
2009-08-04	JB	Futures	115.93	115.99	115.77	115.99	2743.0
2009-08-04	KC	Futures	359.8	363.87	356.27	360.88	9137.0
2009-08-04	KE	Futures	2766.3	2781.89	2719.53	2748.31	8988.0
2009-08-04	L	Futures	97.406	97.426	97.367	97.386	53166.0
2009-08-04	LBS	Futures	828.9	868.7	816.3	840.3	1570.0

> showing 50 of 86 rows — these rows as CSV

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