PREVIEW / futures_daily / 2009-07-01

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-01.parquet
  size:    8 KB
  rows:    85

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-07-01	ES	Futures	878.61	890.6	876.45	881.97	1534550.0
2009-07-01	NQ	Futures	1663.9	1685.02	1660.24	1665.31	224432.0
2009-07-01	YM	Futures	7576.2	7693.5	7560.9	7622.2	115465.0
2009-07-01	CL	Futures	185.36	189.05	180.29	182.37	304636.0
2009-07-01	GC	Futures	1282.2	1311.1	1282.2	1303.2	97417.0
2009-07-01	ZN	Futures	91.618402	91.70459	91.150521	91.618402	701172.0
2009-07-01	A6	Futures	0.64403	0.64821	0.64129	0.64684	58379.0
2009-07-01	AD	Futures	0.85012	0.86405	0.84706	0.8602	55940.0
2009-07-01	B	Futures	67.11	68.4	65.34	66.02	66178.0
2009-07-01	B6	Futures	1.7149	1.7234	1.706	1.7159	93242.0
2009-07-01	BFX	Futures	2308.1	2362.7	2308.1	2358.2	174.0
2009-07-01	BR	Futures	0.19753	0.19847	0.19753	0.19847	3.0
2009-07-01	BZ	Futures	69.99	70.44	69.99	70.44	2.0
2009-07-01	C	Futures	1708.0	1728.0	1696.0	1696.0	925.0
2009-07-01	CB	Futures	71.337	71.337	71.052	71.052	21.0
2009-07-01	CC	Futures	2233.0	2295.0	2223.0	2227.0	5205.0
2009-07-01	CT	Futures	49.4	51.86	49.36	51.86	178.0
2009-07-01	DC	Futures	20.42	20.61	20.22	20.31	197.0
2009-07-01	DX	Futures	82.277	82.579	81.438	81.755	6758.0
2009-07-01	E1	Futures	1.21961	1.23774	1.21709	1.23311	51258.0
2009-07-01	E6	Futures	1.6661	1.68592	1.66182	1.67939	219328.0
2009-07-01	E7	Futures	1.6491	1.6684	1.6449	1.6622	2952.0
2009-07-01	ED	Futures	93.7819	93.8291	93.7819	93.815	156887.0
2009-07-01	ER	Futures	96.909	96.924	96.904	96.914	71150.0
2009-07-01	EW	Futures	558.4	568.5	557.2	563.2	24453.0
2009-07-01	FCE	Futures	2054.9	2110.3	2046.0	2098.6	137618.0
2009-07-01	FDAX	Futures	5287.8	5410.7	5274.1	5371.2	136016.0
2009-07-01	FESX	Futures	1433.2	1466.0	1427.2	1457.1	998626.0
2009-07-01	FEU3	Futures	97.485	97.49	97.485	97.49	281.0
2009-07-01	FGBL	Futures	92.05	92.08	91.79	91.91	631966.0
2009-07-01	FGBM	Futures	97.92	97.97	97.78	97.86	260860.0
2009-07-01	FGBS	Futures	103.993	104.008	103.935	103.969	362956.0
2009-07-01	FGBX	Futures	83.04	83.24	82.62	82.89	2455.0
2009-07-01	FTDX	Futures	561.2	567.5	561.2	566.6	544.0
2009-07-01	FTI	Futures	208.58	212.49	207.24	211.72	33719.0
2009-07-01	FTUK	Futures	2808.9	2871.3	2808.3	2850.4	112154.0
2009-07-01	G	Futures	75.81	75.9	75.16	75.29	116299.0
2009-07-01	GF	Futures	283.072	286.793	282.383	286.035	4241.0
2009-07-01	GSCI	Futures	953.82	960.08	928.37	936.71	738.0
2009-07-01	HE	Futures	85.791	88.202	85.647	87.374	14959.0
2009-07-01	HG	Futures	3.193	3.3264	3.1881	3.2723	16832.0
2009-07-01	HO	Futures	1.8713	1.9003	1.8149	1.835	16665.0
2009-07-01	HRC	Futures	2280.5	2280.5	2280.5	2280.5	0.0
2009-07-01	J1	Futures	0.0130801	0.0131003	0.012992	0.0130512	68262.0
2009-07-01	J7	Futures	0.012907	0.012907	0.012808	0.012871	120.0
2009-07-01	JB	Futures	116.36	116.41	116.14	116.36	2412.0
2009-07-01	KC	Futures	324.79	328.59	321.81	323.03	5273.0
2009-07-01	KE	Futures	2781.89	2815.46	2724.33	2750.71	10238.0
2009-07-01	L	Futures	97.111	97.151	97.092	97.131	32684.0
2009-07-01	LBS	Futures	882.1	883.9	860.7	861.6	346.0

> showing 50 of 85 rows — these rows as CSV

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