PREVIEW / futures_daily / 2009-01-07

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-07.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-07	ES	Futures	878.42	879.84	848.68	854.82	1961214.0
2009-01-07	NQ	Futures	1419.84	1423.48	1372.33	1385.74	277243.0
2009-01-07	YM	Futures	7964.5	7977.0	7721.5	7785.6	161150.0
2009-01-07	CL	Futures	192.19	194.89	168.37	169.25	306262.0
2009-01-07	GC	Futures	1204.9	1209.9	1165.6	1173.5	119843.0
2009-01-07	ZN	Futures	95.455398	95.527115	94.869709	95.228294	372027.0
2009-01-07	A6	Futures	0.5681	0.57301	0.5589	0.56128	27029.0
2009-01-07	AD	Futures	0.82983	0.83415	0.81794	0.8203	27898.0
2009-01-07	B	Futures	54.72	55.67	50.04	50.22	97366.0
2009-01-07	B6	Futures	1.5469	1.5868	1.5363	1.5702	72651.0
2009-01-07	BFX	Futures	2192.4	2192.6	2178.4	2191.3	78.0
2009-01-07	BZ	Futures	54.2	54.2	50.42	50.42	123.0
2009-01-07	C	Futures	1790.0	1811.0	1771.0	1777.0	7519.0
2009-01-07	CB	Futures	77.664	77.994	77.664	77.664	23.0
2009-01-07	CC	Futures	2293.0	2329.0	2254.0	2290.0	9073.0
2009-01-07	CT	Futures	48.82	48.89	47.79	48.29	12435.0
2009-01-07	DC	Futures	27.64	27.67	26.03	26.03	345.0
2009-01-07	DX	Futures	86.967	87.201	85.516	86.184	4080.0
2009-01-07	E1	Futures	1.19239	1.22415	1.18707	1.20648	43217.0
2009-01-07	E6	Futures	1.59519	1.62396	1.58655	1.60809	179512.0
2009-01-07	E7	Futures	1.5778	1.6053	1.5687	1.5897	3262.0
2009-01-07	EBM	Futures	233.92	234.31	221.65	225.87	3253.0
2009-01-07	ED	Futures	93.1614	93.2226	93.1284	93.199	172044.0
2009-01-07	ER	Futures	95.861	95.973	95.851	95.934	133956.0
2009-01-07	EW	Futures	542.4	543.0	523.1	530.2	26262.0
2009-01-07	FCE	Futures	2086.8	2097.9	2036.9	2059.7	94216.0
2009-01-07	FDAX	Futures	5486.4	5496.7	5368.4	5409.9	121242.0
2009-01-07	FESX	Futures	1480.6	1481.1	1445.5	1458.2	1002357.0
2009-01-07	FEU3	Futures	96.45	96.519	96.445	96.489	1038.0
2009-01-07	FGBL	Futures	92.2	92.39	91.65	91.77	766733.0
2009-01-07	FGBM	Futures	97.15	97.33	96.94	97.13	398081.0
2009-01-07	FGBS	Futures	103.167	103.344	103.119	103.268	417877.0
2009-01-07	FGBX	Futures	84.24	84.92	83.25	83.41	2235.0
2009-01-07	FTDX	Futures	476.1	477.9	460.9	462.7	432.0
2009-01-07	FTI	Futures	214.62	215.62	210.22	211.66	29591.0
2009-01-07	FTUK	Futures	3016.1	3016.1	2905.2	2931.1	117408.0
2009-01-07	G	Futures	75.88	76.14	75.56	75.66	84446.0
2009-01-07	GF	Futures	266.217	267.046	260.55	261.241	432.0
2009-01-07	GSCI	Futures	896.77	898.2	833.5	833.74	274.0
2009-01-07	HE	Futures	124.684	126.231	122.461	122.848	7805.0
2009-01-07	HG	Futures	2.2336	2.2836	2.1112	2.1274	13718.0
2009-01-07	HO	Futures	1.8223	1.8433	1.7213	1.7287	21255.0
2009-01-07	HRC	Futures	3101.0	3101.0	3101.0	3101.0	0.0
2009-01-07	J1	Futures	0.0135294	0.013691	0.0134207	0.0136317	75601.0
2009-01-07	J7	Futures	0.013312	0.013524	0.013274	0.013468	110.0
2009-01-07	JB	Futures	116.45	116.49	116.13	116.45	5.0
2009-01-07	KC	Futures	331.53	334.96	325.1	326.39	11618.0
2009-01-07	KE	Futures	3327.67	3337.67	3175.28	3182.77	9085.0
2009-01-07	L	Futures	96.743	96.782	96.733	96.773	24065.0
2009-01-07	LBS	Futures	1033.2	1037.1	1009.7	1014.2	43.0

> showing 50 of 86 rows — these rows as CSV

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