PREVIEW / futures_daily / 2008-07-31

all futures daily files

  file:    by_date/futures_daily/2008/2008-07-31.parquet
  size:    8 KB
  rows:    83

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
2008-07-31	ES	Futures	1188.11	1193.2	1170.07	1171.92	2330165.0
2008-07-31	NQ	Futures	2066.11	2090.03	2038.57	2062.21	448365.0
2008-07-31	YM	Futures	10284.3	10303.0	10072.1	10088.1	213191.0
2008-07-31	CL	Futures	550.83	555.12	532.64	538.58	280832.0
2008-07-31	GC	Futures	1282.4	1306.9	1280.0	1290.4	130539.0
2008-07-31	ZN	Futures	84.043714	84.791638	83.928648	84.561508	1146131.0
2008-07-31	A6	Futures	0.72519	0.72782	0.72171	0.72372	53223.0
2008-07-31	AD	Futures	0.95911	0.96097	0.95469	0.95911	36528.0
2008-07-31	B	Futures	151.67	152.44	147.04	148.3	49267.0
2008-07-31	B6	Futures	2.033	2.0453	2.03	2.0348	119344.0
2008-07-31	BFX	Futures	3408.8	3408.8	3378.7	3395.7	678.0
2008-07-31	BR	Futures	0.23115	0.23115	0.23094	0.23094	27.0
2008-07-31	BZ	Futures	146.8	148.93	144.79	145.01	1176.0
2008-07-31	C	Futures	1331.0	1353.0	1326.0	1346.0	3124.0
2008-07-31	CB	Futures	96.848	96.848	96.235	96.848	18.0
2008-07-31	CC	Futures	2518.0	2565.0	2517.0	2563.0	6332.0
2008-07-31	CT	Futures	74.55	75.26	74.47	74.9	183.0
2008-07-31	DC	Futures	48.09	48.22	47.56	48.09	297.0
2008-07-31	DX	Futures	77.802	77.802	77.278	77.707	7312.0
2008-07-31	E1	Futures	1.27219	1.28139	1.26992	1.27219	71119.0
2008-07-31	E6	Futures	1.81958	1.83398	1.81864	1.82134	250907.0
2008-07-31	E7	Futures	1.8016	1.8161	1.801	1.8037	3324.0
2008-07-31	ED	Futures	91.7493	91.7729	91.7115	91.7493	199040.0
2008-07-31	ER	Futures	93.63	93.63	93.6	93.61	113935.0
2008-07-31	EW	Futures	807.7	809.5	791.5	795.3	30208.0
2008-07-31	FCE	Futures	2881.5	2908.8	2846.9	2867.5	117681.0
2008-07-31	FDAX	Futures	7305.3	7371.3	7239.7	7308.1	172705.0
2008-07-31	FESX	Futures	1997.3	2005.5	1969.1	1983.2	1418754.0
2008-07-31	FEU3	Futures	94.162	94.166	94.152	94.157	711.0
2008-07-31	FGBL	Futures	84.41	84.8	84.12	84.8	1034251.0
2008-07-31	FGBM	Futures	90.46	90.79	90.25	90.79	658108.0
2008-07-31	FGBS	Futures	99.497	99.671	99.395	99.671	709749.0
2008-07-31	FGBX	Futures	75.93	76.51	75.37	76.51	2348.0
2008-07-31	FTDX	Futures	694.1	710.4	693.2	698.6	1325.0
2008-07-31	FTI	Futures	311.9	312.17	305.46	306.81	31861.0
2008-07-31	FTUK	Futures	3527.0	3533.8	3475.2	3501.8	98331.0
2008-07-31	G	Futures	68.01	68.3	67.85	68.23	109124.0
2008-07-31	GF	Futures	306.189	309.782	305.647	308.63	168.0
2008-07-31	GSCI	Futures	1968.92	1990.05	1933.97	1949.21	1055.0
2008-07-31	HE	Futures	158.022	161.069	157.822	159.121	3254.0
2008-07-31	HG	Futures	5.0856	5.1616	5.0717	5.103	8496.0
2008-07-31	HO	Futures	4.134	4.1453	3.9845	4.0186	39735.0
2008-07-31	J1	Futures	0.0118032	0.011854	0.0117637	0.0118197	119391.0
2008-07-31	J7	Futures	0.011595	0.011648	0.01156	0.011616	110.0
2008-07-31	JB	Futures	113.96	114.07	113.85	113.93	2304.0
2008-07-31	KC	Futures	417.36	423.58	415.69	422.82	12896.0
2008-07-31	KE	Futures	4343.19	4398.89	4317.99	4321.97	8758.0
2008-07-31	L	Futures	93.433	93.443	93.413	93.423	42962.0
2008-07-31	LE	Futures	196.53	197.595	195.882	196.9	6602.0
2008-07-31	MP	Futures	0.04777	0.04783	0.0476	0.04772	11716.0

> showing 50 of 83 rows — these rows as CSV

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