PREVIEW / futures_daily / 2014-09-24

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-24.parquet
  size:    9 KB
  rows:    106

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-24	ES	Futures	2057.57	2081.34	2057.31	2079.77	1566690.0
2014-09-24	NQ	Futures	4672.7	4740.21	4671.83	4737.6	278357.0
2014-09-24	YM	Futures	17182.0	17398.1	17182.0	17387.9	141362.0
2014-09-24	CL	Futures	172.77	175.73	171.64	174.81	282634.0
2014-09-24	GC	Futures	1604.4	1609.0	1595.2	1599.6	131418.0
2014-09-24	ZN	Futures	116.738231	116.767518	116.44536	116.474647	1031800.0
2014-09-24	A6	Futures	0.85431	0.85946	0.85382	0.85751	114876.0
2014-09-24	AD	Futures	0.91519	0.91733	0.91164	0.91611	73097.0
2014-09-24	ALI	Futures	2958.96	2975.68	2958.96	2975.68	5.0
2014-09-24	B	Futures	101.21	101.67	99.87	101.28	216742.0
2014-09-24	B6	Futures	1.7213	1.7241	1.715	1.7162	87340.0
2014-09-24	BFX	Futures	3863.0	3870.8	3863.0	3870.8	1.0
2014-09-24	BR	Futures	0.2203	0.22257	0.21949	0.22192	142.0
2014-09-24	BZ	Futures	101.88	102.37	100.59	101.99	15460.0
2014-09-24	C	Futures	2252.0	2313.0	2252.0	2309.0	11972.0
2014-09-24	CB	Futures	160.321	161.168	158.779	161.168	17.0
2014-09-24	CC	Futures	2458.0	2495.0	2446.0	2489.0	19810.0
2014-09-24	CNH	Futures	7.0778	7.0826	7.0775	7.0793	30.0
2014-09-24	CSC	Futures	5.452	5.452	5.452	5.452	4.0
2014-09-24	CT	Futures	79.39	79.54	77.32	78.02	19957.0
2014-09-24	DC	Futures	43.01	43.95	42.91	43.82	131.0
2014-09-24	DX	Futures	80.475	80.897	80.408	80.835	30886.0
2014-09-24	E1	Futures	1.36126	1.36279	1.35269	1.35371	32593.0
2014-09-24	E6	Futures	1.51317	1.51506	1.50446	1.50517	203833.0
2014-09-24	E7	Futures	1.5035	1.5055	1.4951	1.4957	2479.0
2014-09-24	ED	Futures	95.4278	95.4278	95.423	95.423	64155.0
2014-09-24	ER	Futures	97.999	98.009	97.994	98.004	50727.0
2014-09-24	EW	Futures	1439.3	1450.7	1436.0	1447.7	21040.0
2014-09-24	FBTP	Futures	94.85	95.29	94.77	95.23	53385.0
2014-09-24	FBTS	Futures	98.694	98.703	98.668	98.694	14729.0
2014-09-24	FCE	Futures	3467.1	3524.5	3460.3	3514.5	117891.0
2014-09-24	FDAX	Futures	10505.9	10612.2	10446.7	10595.7	109737.0
2014-09-24	FESX	Futures	2310.7	2348.4	2302.8	2342.6	883636.0
2014-09-24	FEU3	Futures	98.621	98.626	98.621	98.626	13.0
2014-09-24	FGBL	Futures	131.22	131.41	131.07	131.27	580633.0
2014-09-24	FGBM	Futures	122.65	122.71	122.6	122.67	396157.0
2014-09-24	FGBS	Futures	110.898	110.918	110.893	110.913	199289.0
2014-09-24	FGBX	Futures	140.67	141.31	140.17	140.59	25470.0
2014-09-24	FMWO	Futures	5693.7	5712.5	5692.4	5712.5	64.0
2014-09-24	FOAT	Futures	121.06	121.28	120.95	121.13	46565.0
2014-09-24	FTDX	Futures	1165.3	1173.8	1158.2	1173.8	130.0
2014-09-24	FTI	Futures	361.0	364.84	360.39	364.06	27903.0
2014-09-24	FTUK	Futures	5126.7	5177.7	5122.4	5163.8	89785.0
2014-09-24	FVSA	Futures	1428.96	1441.14	1380.25	1380.25	9355.0
2014-09-24	FXXP	Futures	259.3	261.1	257.7	260.8	7981.0
2014-09-24	G	Futures	96.45	96.63	96.39	96.5	121661.0
2014-09-24	GF	Futures	357.239	358.873	356.072	358.445	2978.0
2014-09-24	GSCI	Futures	972.0	981.59	968.21	979.15	89.0
2014-09-24	HE	Futures	128.332	129.543	127.356	128.13	13532.0
2014-09-24	HG	Futures	3.8414	3.8858	3.8344	3.8731	53120.0

> showing 50 of 106 rows — these rows as CSV

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