PREVIEW / futures_daily / 2009-01-29

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-29.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-01-29	ES	Futures	822.95	823.18	793.44	795.8	2044480.0
2009-01-29	NQ	Futures	1375.12	1376.52	1337.11	1348.29	268951.0
2009-01-29	YM	Futures	7407.2	7409.8	7194.4	7222.9	163671.0
2009-01-29	CL	Futures	140.26	140.59	133.48	137.67	245854.0
2009-01-29	GC	Futures	1235.1	1264.6	1215.2	1258.0	126384.0
2009-01-29	ZN	Futures	94.702369	94.893614	93.590755	93.961293	587778.0
2009-01-29	A6	Futures	0.52622	0.52789	0.51496	0.5167	25455.0
2009-01-29	AD	Futures	0.81077	0.81077	0.80085	0.8035	26410.0
2009-01-29	B	Futures	46.88	48.13	46.17	47.49	82189.0
2009-01-29	B6	Futures	1.4796	1.4966	1.4608	1.4868	79297.0
2009-01-29	BFX	Futures	2117.0	2118.0	2078.1	2088.7	316.0
2009-01-29	BR	Futures	0.1598	0.1598	0.15853	0.15853	2.0
2009-01-29	BZ	Futures	48.66	48.83	48.66	48.81	268.0
2009-01-29	C	Futures	2015.0	2035.0	1999.0	2013.0	7084.0
2009-01-29	CC	Futures	2477.0	2503.0	2422.0	2471.0	6242.0
2009-01-29	CT	Futures	49.74	49.84	48.45	48.74	6049.0
2009-01-29	DC	Futures	27.21	28.44	27.18	28.12	171.0
2009-01-29	DX	Futures	88.466	89.124	87.89	88.922	4166.0
2009-01-29	E1	Futures	1.15398	1.16607	1.14813	1.15437	32793.0
2009-01-29	E6	Futures	1.55565	1.5592	1.52972	1.53351	188272.0
2009-01-29	E7	Futures	1.5396	1.5418	1.5116	1.516	2728.0
2009-01-29	EBM	Futures	231.62	231.62	227.79	229.32	3264.0
2009-01-29	ED	Futures	93.1943	93.2273	93.1472	93.1708	189411.0
2009-01-29	ER	Futures	96.228	96.277	96.204	96.263	123820.0
2009-01-29	EW	Futures	518.4	518.4	497.2	501.5	26526.0
2009-01-29	FCE	Futures	1901.5	1903.4	1834.1	1862.3	137866.0
2009-01-29	FDAX	Futures	4945.9	4953.0	4777.2	4845.5	144965.0
2009-01-29	FESX	Futures	1339.2	1339.2	1285.2	1304.8	1291348.0
2009-01-29	FEU3	Futures	96.79	96.83	96.79	96.83	124.0
2009-01-29	FGBL	Futures	91.47	92.06	91.31	91.79	737366.0
2009-01-29	FGBM	Futures	96.57	97.11	96.53	96.98	408657.0
2009-01-29	FGBS	Futures	103.133	103.397	103.129	103.383	456815.0
2009-01-29	FGBX	Futures	82.56	84.82	82.4	84.66	3008.0
2009-01-29	FTDX	Futures	434.9	443.0	427.8	431.4	469.0
2009-01-29	FTI	Futures	207.74	207.74	200.64	202.82	27352.0
2009-01-29	FTUK	Futures	2768.5	2777.1	2687.2	2713.1	128404.0
2009-01-29	G	Futures	73.47	73.74	73.07	73.56	93672.0
2009-01-29	GF	Futures	253.613	254.875	250.106	254.244	701.0
2009-01-29	GSCI	Futures	774.66	791.55	773.02	789.2	138.0
2009-01-29	HE	Futures	118.595	118.789	117.919	118.402	5715.0
2009-01-29	HG	Futures	2.1021	2.114	2.0	2.0514	11381.0
2009-01-29	HO	Futures	1.5722	1.6124	1.5366	1.5791	35998.0
2009-01-29	HRC	Futures	3041.9	3041.9	3041.9	3041.9	0.0
2009-01-29	J1	Futures	0.0139778	0.0141306	0.0139437	0.0140738	71459.0
2009-01-29	J7	Futures	0.013817	0.013954	0.01378	0.013905	76.0
2009-01-29	JB	Futures	116.42	116.43	115.93	116.42	5.0
2009-01-29	KC	Futures	349.54	350.11	344.82	347.25	5765.0
2009-01-29	KE	Futures	3126.56	3126.56	3019.14	3037.87	6176.0
2009-01-29	L	Futures	96.881	96.905	96.851	96.896	37430.0
2009-01-29	LBS	Futures	785.3	799.3	773.5	774.6	106.0

> showing 50 of 86 rows — these rows as CSV

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