PREVIEW / futures_daily / 2014-06-26

all futures daily files

  file:    by_date/futures_daily/2014/2014-06-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-06-26	ES	Futures	2024.35	2028.25	2011.37	2024.35	1486643.0
2014-06-26	NQ	Futures	4399.07	4409.74	4371.67	4404.55	239390.0
2014-06-26	YM	Futures	16921.7	16950.9	16808.7	16912.6	150592.0
2014-06-26	CL	Futures	194.92	195.11	191.86	193.34	195723.0
2014-06-26	GC	Futures	1737.5	1740.0	1721.8	1735.3	134789.0
2014-06-26	ZN	Futures	116.49197	116.87128	116.433615	116.783747	1131588.0
2014-06-26	A6	Futures	0.90359	0.90533	0.90311	0.90427	47775.0
2014-06-26	AD	Futures	0.94556	0.94891	0.94505	0.94861	45107.0
2014-06-26	ALI	Futures	2788.11	2803.11	2788.11	2803.11	15.0
2014-06-26	B	Futures	119.69	119.69	118.38	118.57	116592.0
2014-06-26	B6	Futures	1.7842	1.7903	1.783	1.7886	103703.0
2014-06-26	BFX	Futures	3787.9	3790.3	3787.4	3790.3	8.0
2014-06-26	BR	Futures	0.23437	0.2359	0.23389	0.23471	1333.0
2014-06-26	BZ	Futures	120.36	120.36	119.14	119.32	10988.0
2014-06-26	C	Futures	2023.0	2027.0	2010.0	2015.0	7397.0
2014-06-26	CB	Futures	123.528	123.528	122.41	122.69	8.0
2014-06-26	CC	Futures	2256.0	2259.0	2240.0	2243.0	11156.0
2014-06-26	CNH	Futures	7.1671	7.1701	7.1671	7.1701	1.0
2014-06-26	CSC	Futures	4.678	4.689	4.672	4.689	9.0
2014-06-26	CT	Futures	94.49	94.49	92.48	93.5	50.0
2014-06-26	DC	Futures	37.47	37.68	37.37	37.59	74.0
2014-06-26	DX	Futures	76.18	76.356	76.119	76.203	19950.0
2014-06-26	E1	Futures	1.43686	1.43776	1.43212	1.43506	31544.0
2014-06-26	E6	Futures	1.6086	1.61002	1.60223	1.60601	176878.0
2014-06-26	E7	Futures	1.5981	1.5994	1.5919	1.5955	2048.0
2014-06-26	ED	Futures	95.4162	95.4162	95.4115	95.4115	50963.0
2014-06-26	ER	Futures	97.916	97.925	97.916	97.92	63845.0
2014-06-26	EW	Futures	1471.8	1473.8	1459.9	1469.7	16687.0
2014-06-26	FBTP	Futures	91.41	91.69	91.41	91.62	45825.0
2014-06-26	FBTS	Futures	98.125	98.17	98.099	98.125	11845.0
2014-06-26	FCE	Futures	3571.6	3573.6	3518.6	3544.5	107786.0
2014-06-26	FDAX	Futures	10899.6	10918.4	10744.9	10797.8	95948.0
2014-06-26	FDIV	Futures	149.87	149.87	149.87	149.87	55.0
2014-06-26	FESX	Futures	2344.0	2346.9	2305.9	2321.7	936556.0
2014-06-26	FGBL	Futures	127.63	127.98	127.59	127.94	580073.0
2014-06-26	FGBM	Futures	121.42	121.51	121.39	121.5	330864.0
2014-06-26	FGBS	Futures	110.753	110.773	110.743	110.768	152633.0
2014-06-26	FGBX	Futures	132.16	133.07	132.08	132.95	17863.0
2014-06-26	FMWO	Futures	5756.3	5762.6	5755.0	5755.0	4.0
2014-06-26	FOAT	Futures	117.47	117.79	117.43	117.75	59391.0
2014-06-26	FTDX	Futures	1226.7	1233.8	1222.5	1224.4	182.0
2014-06-26	FTI	Futures	357.01	357.23	352.95	355.2	30266.0
2014-06-26	FTUK	Futures	5150.8	5161.2	5117.3	5138.1	78775.0
2014-06-26	FVSA	Futures	1306.55	1358.13	1289.36	1336.64	8015.0
2014-06-26	FXXP	Futures	257.8	257.8	255.5	256.6	3457.0
2014-06-26	G	Futures	93.88	94.09	93.72	94.07	140992.0
2014-06-26	GF	Futures	326.711	329.7	326.136	329.7	3995.0
2014-06-26	GSCI	Futures	1109.67	1109.75	1104.83	1105.33	515.0
2014-06-26	HE	Futures	136.258	137.52	135.232	136.626	8359.0
2014-06-26	HG	Futures	4.0474	4.0602	4.027	4.0544	39862.0

> showing 50 of 105 rows — these rows as CSV

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