PREVIEW / futures_daily / 2009-01-28

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-28.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-28	ES	Futures	793.44	827.2	791.08	822.95	2305731.0
2009-01-28	NQ	Futures	1327.89	1391.61	1324.81	1376.52	320654.0
2009-01-28	YM	Futures	7212.2	7442.8	7193.5	7409.8	175478.0
2009-01-28	CL	Futures	139.49	144.84	134.88	140.06	291416.0
2009-01-28	GC	Futures	1251.6	1256.2	1226.5	1235.1	74373.0
2009-01-28	ZN	Futures	95.228294	95.574926	94.535029	94.738227	575605.0
2009-01-28	A6	Futures	0.52384	0.53201	0.52091	0.52662	28430.0
2009-01-28	AD	Futures	0.80153	0.81676	0.7981	0.80763	33184.0
2009-01-28	B	Futures	46.78	48.55	46.08	47.27	75043.0
2009-01-28	B6	Futures	1.4697	1.4927	1.4666	1.4796	81304.0
2009-01-28	BFX	Futures	2092.7	2119.9	2072.8	2117.8	111.0
2009-01-28	BZ	Futures	48.29	49.4	47.5	48.58	76.0
2009-01-28	C	Futures	1995.0	2014.0	1986.0	2012.0	4793.0
2009-01-28	CB	Futures	76.507	76.837	76.507	76.672	13.0
2009-01-28	CC	Futures	2448.0	2478.0	2426.0	2463.0	4881.0
2009-01-28	CT	Futures	50.03	50.32	49.1	49.71	7590.0
2009-01-28	DC	Futures	26.7	27.64	26.62	27.45	138.0
2009-01-28	DX	Futures	88.139	88.538	87.123	88.357	5991.0
2009-01-28	E1	Futures	1.16567	1.17391	1.14985	1.15291	31611.0
2009-01-28	E6	Futures	1.55908	1.57708	1.54961	1.55399	195197.0
2009-01-28	E7	Futures	1.5417	1.5588	1.5322	1.5362	2509.0
2009-01-28	EBM	Futures	232.77	233.92	230.47	232.39	3101.0
2009-01-28	ED	Futures	93.1802	93.2414	93.1614	93.2226	198203.0
2009-01-28	ER	Futures	96.209	96.272	96.204	96.243	165951.0
2009-01-28	EW	Futures	495.3	519.0	495.3	518.3	24224.0
2009-01-28	FCE	Futures	1849.6	1917.3	1848.4	1901.5	127022.0
2009-01-28	FDAX	Futures	4784.9	4989.6	4782.1	4938.3	166754.0
2009-01-28	FESX	Futures	1292.7	1348.4	1291.5	1336.9	1474462.0
2009-01-28	FEU3	Futures	96.805	96.83	96.8	96.81	276.0
2009-01-28	FGBL	Futures	91.79	92.17	91.53	91.92	670090.0
2009-01-28	FGBM	Futures	96.78	96.99	96.63	96.93	404488.0
2009-01-28	FGBS	Futures	103.191	103.311	103.138	103.292	384420.0
2009-01-28	FGBX	Futures	82.5	83.76	81.89	83.2	1950.0
2009-01-28	FTDX	Futures	431.4	444.8	422.4	443.0	538.0
2009-01-28	FTI	Futures	202.5	209.39	201.85	206.77	29930.0
2009-01-28	FTUK	Futures	2751.2	2816.7	2748.5	2793.5	121991.0
2009-01-28	G	Futures	73.64	74.19	73.61	73.76	63588.0
2009-01-28	GF	Futures	253.543	255.576	251.368	254.104	599.0
2009-01-28	GSCI	Futures	782.05	802.57	776.54	792.72	94.0
2009-01-28	HE	Futures	117.532	119.417	116.759	118.595	8488.0
2009-01-28	HG	Futures	2.1028	2.1865	2.0718	2.1056	14165.0
2009-01-28	HO	Futures	1.5345	1.6144	1.5244	1.5722	36261.0
2009-01-28	HRC	Futures	3189.6	3189.6	3189.6	3189.6	0.0
2009-01-28	J1	Futures	0.0141849	0.0142203	0.0139184	0.0139651	82539.0
2009-01-28	J7	Futures	0.013992	0.014047	0.01376	0.013797	98.0
2009-01-28	JB	Futures	116.34	116.59	116.2	116.2	17.0
2009-01-28	KC	Futures	348.68	350.82	345.54	350.11	5139.0
2009-01-28	KE	Futures	3064.11	3142.8	3052.86	3127.81	5829.0
2009-01-28	L	Futures	96.886	96.92	96.841	96.905	53410.0
2009-01-28	LBS	Futures	835.8	838.6	783.1	794.3	116.0

> showing 50 of 86 rows — these rows as CSV

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