PREVIEW / futures_daily / 2011-11-23

all futures daily files

  file:    by_date/futures_daily/2011/2011-11-23.parquet
  size:    9 KB
  rows:    97

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
2011-11-23	ES	Futures	1180.68	1182.92	1156.47	1157.97	2325948.0
2011-11-23	NQ	Futures	2527.18	2530.32	2466.69	2466.69	252323.0
2011-11-23	YM	Futures	10999.6	11015.9	10773.8	10792.0	126739.0
2011-11-23	CL	Futures	183.33	183.48	178.75	180.29	283449.0
2011-11-23	GC	Futures	2295.1	2309.8	2264.3	2289.7	173328.0
2011-11-23	ZN	Futures	112.273605	112.66242	112.005457	112.595383	1436712.0
2011-11-23	A6	Futures	0.86293	0.86416	0.84719	0.84886	134357.0
2011-11-23	AD	Futures	0.96323	0.96383	0.95253	0.95403	74636.0
2011-11-23	B	Futures	96.14	96.35	94.55	94.73	182087.0
2011-11-23	B6	Futures	1.6322	1.6336	1.6168	1.6182	91311.0
2011-11-23	BFX	Futures	2309.2	2332.5	2293.3	2293.3	197.0
2011-11-23	BR	Futures	0.2422	0.24317	0.2422	0.24317	103.0
2011-11-23	BZ	Futures	100.78	101.04	99.88	100.03	669.0
2011-11-23	C	Futures	1597.0	1618.0	1596.0	1605.0	1885.0
2011-11-23	CB	Futures	90.423	90.423	90.153	90.423	53.0
2011-11-23	CC	Futures	1865.0	1891.0	1859.0	1864.0	6928.0
2011-11-23	CSC	Futures	3.971	3.983	3.971	3.978	31.0
2011-11-23	CT	Futures	116.35	118.22	115.02	116.95	188.0
2011-11-23	DC	Futures	28.23	28.33	28.12	28.23	106.0
2011-11-23	DX	Futures	76.898	77.948	76.898	77.9	30312.0
2011-11-23	E1	Futures	1.43549	1.43798	1.42328	1.42564	21348.0
2011-11-23	E6	Futures	1.61533	1.61724	1.5919	1.59298	304645.0
2011-11-23	E7	Futures	1.6015	1.6034	1.5783	1.5794	5211.0
2011-11-23	ED	Futures	94.8624	94.8671	94.8433	94.8552	176771.0
2011-11-23	ER	Futures	97.204	97.218	97.169	97.184	117735.0
2011-11-23	EW	Futures	839.0	839.6	816.1	817.9	25018.0
2011-11-23	FBTP	Futures	56.76	56.76	56.03	56.33	6017.0
2011-11-23	FBTS	Futures	77.762	77.882	76.975	77.256	1227.0
2011-11-23	FCE	Futures	2027.4	2057.1	2008.8	2013.1	112299.0
2011-11-23	FDAX	Futures	5954.1	6072.4	5921.0	5949.7	189102.0
2011-11-23	FESX	Futures	1407.5	1427.4	1386.9	1398.2	1285591.0
2011-11-23	FGBL	Futures	111.25	111.48	109.44	109.88	1045742.0
2011-11-23	FGBM	Futures	111.83	112.01	111.09	111.28	531871.0
2011-11-23	FGBS	Futures	109.447	109.471	109.268	109.327	503017.0
2011-11-23	FGBX	Futures	114.18	114.36	110.64	111.45	9362.0
2011-11-23	FTDX	Futures	587.4	589.7	581.4	583.3	283.0
2011-11-23	FTI	Futures	230.35	234.0	228.84	229.17	42991.0
2011-11-23	FTUK	Futures	3744.2	3750.6	3670.6	3695.7	108948.0
2011-11-23	FVSA	Futures	16773.21	17073.11	16773.21	17073.11	2040.0
2011-11-23	FXXP	Futures	154.5	156.1	153.0	154.0	5384.0
2011-11-23	G	Futures	92.96	93.14	92.37	92.81	254189.0
2011-11-23	GF	Futures	316.757	316.918	313.687	314.064	2593.0
2011-11-23	GSCI	Futures	992.93	993.86	985.72	989.21	113.0
2011-11-23	HE	Futures	112.277	113.016	111.629	112.739	11715.0
2011-11-23	HG	Futures	4.387	4.4595	4.2841	4.3428	17328.0
2011-11-23	HO	Futures	2.4379	2.4407	2.4018	2.4046	10378.0
2011-11-23	HRC	Futures	2664.5	2664.5	2664.5	2664.5	0.0
2011-11-23	J1	Futures	0.0163336	0.0163398	0.0162004	0.0162519	56663.0
2011-11-23	J7	Futures	0.016233	0.016233	0.016103	0.016153	145.0
2011-11-23	JB	Futures	124.81	124.85	124.65	124.84	840.0

> showing 50 of 97 rows — these rows as CSV

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