PREVIEW / futures_daily / 2014-09-26

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-26.parquet
  size:    9 KB
  rows:    105

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
2014-09-26	ES	Futures	2048.43	2067.5	2043.73	2064.1	1680945.0
2014-09-26	NQ	Futures	4641.7	4694.43	4637.93	4688.93	309995.0
2014-09-26	YM	Futures	17147.5	17316.9	17125.2	17277.3	151568.0
2014-09-26	CL	Futures	174.19	176.8	173.73	176.2	258890.0
2014-09-26	GC	Futures	1603.0	1616.9	1590.8	1594.2	149452.0
2014-09-26	ZN	Futures	116.94324	117.075032	116.533222	116.621083	1683560.0
2014-09-26	A6	Futures	0.84935	0.85168	0.84527	0.84643	120373.0
2014-09-26	AD	Futures	0.91225	0.91408	0.90778	0.90889	61952.0
2014-09-26	ALI	Futures	2945.39	2945.39	2945.39	2945.39	0.0
2014-09-26	B	Futures	101.36	101.85	100.81	101.34	115928.0
2014-09-26	B6	Futures	1.7142	1.7158	1.7057	1.7072	87488.0
2014-09-26	BR	Futures	0.21825	0.22012	0.21715	0.21963	2362.0
2014-09-26	BZ	Futures	102.04	102.6	101.57	102.09	12939.0
2014-09-26	C	Futures	2286.0	2298.0	2249.0	2262.0	5308.0
2014-09-26	CB	Futures	162.247	162.247	158.394	158.394	20.0
2014-09-26	CC	Futures	2475.0	2486.0	2432.0	2444.0	14292.0
2014-09-26	CNH	Futures	7.0782	7.083	7.0782	7.083	8.0
2014-09-26	CSC	Futures	5.4	5.457	5.334	5.342	56.0
2014-09-26	CT	Futures	77.54	80.15	77.54	78.42	16069.0
2014-09-26	DC	Futures	43.36	43.84	42.74	42.91	249.0
2014-09-26	DX	Futures	80.949	81.471	80.911	81.416	24321.0
2014-09-26	E1	Futures	1.35115	1.35243	1.34399	1.34502	30899.0
2014-09-26	E6	Futures	1.50164	1.50293	1.49293	1.49363	215880.0
2014-09-26	E7	Futures	1.4922	1.4934	1.4834	1.4842	2703.0
2014-09-26	ED	Futures	95.4326	95.4374	95.4278	95.4326	156032.0
2014-09-26	ER	Futures	98.009	98.009	98.004	98.009	23531.0
2014-09-26	EW	Futures	1431.3	1440.9	1426.6	1438.9	18594.0
2014-09-26	FBTP	Futures	95.26	95.44	94.69	95.1	63857.0
2014-09-26	FBTS	Futures	98.686	98.721	98.623	98.677	10548.0
2014-09-26	FCE	Futures	3470.7	3521.3	3454.7	3497.8	108116.0
2014-09-26	FDAX	Futures	10409.0	10463.2	10358.6	10399.1	116640.0
2014-09-26	FDIV	Futures	135.71	136.08	135.71	135.85	24.0
2014-09-26	FESX	Futures	2312.9	2340.4	2301.3	2323.8	910120.0
2014-09-26	FGBL	Futures	131.71	131.9	131.49	131.65	724533.0
2014-09-26	FGBM	Futures	122.83	122.91	122.81	122.86	318287.0
2014-09-26	FGBS	Futures	110.943	110.948	110.933	110.943	150088.0
2014-09-26	FGBX	Futures	141.35	141.99	141.17	141.65	28793.0
2014-09-26	FMWO	Futures	5638.5	5658.6	5638.5	5651.1	69.0
2014-09-26	FOAT	Futures	121.47	121.65	121.31	121.45	60401.0
2014-09-26	FTDX	Futures	1174.8	1174.8	1163.0	1171.9	127.0
2014-09-26	FTI	Futures	360.87	363.42	358.71	361.56	32671.0
2014-09-26	FTUK	Futures	5111.6	5149.5	5094.2	5123.2	89517.0
2014-09-26	FVSA	Futures	1445.2	1453.32	1416.78	1445.2	9255.0
2014-09-26	FXXP	Futures	258.2	260.3	257.1	259.1	5129.0
2014-09-26	G	Futures	96.88	97.01	96.55	96.68	173426.0
2014-09-26	GF	Futures	358.523	362.645	357.278	362.645	4156.0
2014-09-26	GSCI	Futures	981.34	981.84	975.87	980.16	98.0
2014-09-26	HE	Futures	125.539	127.289	124.967	127.154	13987.0
2014-09-26	HG	Futures	3.8471	3.8724	3.8407	3.8503	30289.0
2014-09-26	HH	Futures	48.503	48.733	48.056	48.709	267.0

> showing 50 of 105 rows — these rows as CSV

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