PREVIEW / futures_daily / 2009-10-07

all futures daily files

  file:    by_date/futures_daily/2009/2009-10-07.parquet
  size:    9 KB
  rows:    88

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-10-07	ES	Futures	1011.07	1017.34	1008.18	1016.14	1692060.0
2009-10-07	NQ	Futures	1919.88	1930.32	1914.51	1928.06	235732.0
2009-10-07	YM	Futures	8760.9	8808.1	8734.6	8781.8	117436.0
2009-10-07	CL	Futures	176.22	177.71	170.58	172.29	346922.0
2009-10-07	GC	Futures	1441.5	1451.1	1434.7	1443.8	103249.0
2009-10-07	ZN	Futures	94.862126	95.459918	94.849672	95.422556	807060.0
2009-10-07	A6	Futures	0.7156	0.71908	0.71221	0.71399	66576.0
2009-10-07	AD	Futures	0.93079	0.93671	0.92586	0.92714	59314.0
2009-10-07	B	Futures	65.23	65.52	62.97	63.47	125145.0
2009-10-07	B6	Futures	1.6554	1.6614	1.6495	1.6577	98310.0
2009-10-07	BFX	Futures	2852.5	2881.0	2834.3	2839.5	192.0
2009-10-07	BR	Futures	0.2246	0.2246	0.22261	0.2238	14.0
2009-10-07	BZ	Futures	68.33	68.39	66.57	66.57	6.0
2009-10-07	C	Futures	2211.0	2231.0	2203.0	2217.0	3981.0
2009-10-07	CB	Futures	71.004	71.138	71.004	71.138	6.0
2009-10-07	CC	Futures	2813.0	2858.0	2813.0	2845.0	4744.0
2009-10-07	CT	Futures	54.46	54.75	53.76	53.94	4842.0
2009-10-07	DC	Futures	25.16	25.29	24.93	25.19	382.0
2009-10-07	DX	Futures	78.083	78.409	77.899	78.272	3867.0
2009-10-07	E1	Futures	1.28709	1.28814	1.27559	1.27771	48648.0
2009-10-07	E6	Futures	1.74477	1.74643	1.73564	1.73837	221072.0
2009-10-07	E7	Futures	1.7277	1.7296	1.7189	1.7217	4901.0
2009-10-07	ED	Futures	94.1812	94.1907	94.1718	94.1765	122638.0
2009-10-07	ER	Futures	97.159	97.169	97.105	97.115	207577.0
2009-10-07	EW	Futures	662.9	667.3	660.4	663.7	34770.0
2009-10-07	FCE	Futures	2481.8	2503.5	2473.8	2480.4	120812.0
2009-10-07	FDAX	Futures	6136.3	6196.2	6123.3	6151.0	126842.0
2009-10-07	FESX	Futures	1696.9	1711.3	1691.0	1699.9	920388.0
2009-10-07	FEU3	Futures	97.736	97.736	97.687	97.687	322.0
2009-10-07	FGBL	Futures	94.33	94.72	94.25	94.62	732808.0
2009-10-07	FGBM	Futures	99.44	99.63	99.38	99.55	370216.0
2009-10-07	FGBS	Futures	104.798	104.842	104.769	104.784	453285.0
2009-10-07	FGBX	Futures	88.74	89.36	88.63	89.17	3439.0
2009-10-07	FTDX	Futures	672.3	675.0	664.3	665.6	475.0
2009-10-07	FTI	Futures	253.62	257.0	253.62	254.49	29031.0
2009-10-07	FTUK	Futures	3376.4	3400.0	3359.2	3375.1	89612.0
2009-10-07	G	Futures	78.08	78.28	78.04	78.2	94099.0
2009-10-07	GF	Futures	256.277	257.654	256.071	257.035	798.0
2009-10-07	GSCI	Futures	929.66	934.96	909.75	917.55	2395.0
2009-10-07	HE	Futures	74.81	79.345	74.62	78.888	19287.0
2009-10-07	HG	Futures	3.8545	3.9074	3.8336	3.8733	16426.0
2009-10-07	HO	Futures	1.8004	1.8091	1.7394	1.7537	20664.0
2009-10-07	HRC	Futures	2713.5	2713.5	2713.5	2713.5	0.0
2009-10-07	J1	Futures	0.0141489	0.0142745	0.0140497	0.0141741	124865.0
2009-10-07	J7	Futures	0.013942	0.014088	0.013878	0.013989	138.0
2009-10-07	JB	Futures	117.81	117.82	117.54	117.63	2197.0
2009-10-07	KC	Futures	352.66	357.28	351.21	354.38	6473.0
2009-10-07	KE	Futures	2205.54	2238.11	2186.93	2234.62	6943.0
2009-10-07	L	Futures	97.799	97.809	97.779	97.809	50939.0
2009-10-07	LBS	Futures	698.2	701.8	665.2	684.3	1345.0

> showing 50 of 88 rows — these rows as CSV

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