PREVIEW / futures_daily / 2014-07-29

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-29.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-07-29	ES	Futures	2049.03	2056.3	2038.12	2039.16	1509091.0
2014-07-29	NQ	Futures	4567.23	4589.15	4555.7	4560.02	219908.0
2014-07-29	YM	Futures	17066.0	17145.7	16991.3	16996.4	152804.0
2014-07-29	CL	Futures	187.04	187.46	184.77	185.88	258060.0
2014-07-29	GC	Futures	1713.9	1724.3	1702.5	1705.8	150849.0
2014-07-29	ZN	Futures	116.856692	117.119291	116.739981	117.060936	1129557.0
2014-07-29	A6	Futures	0.9061	0.90717	0.90301	0.90417	67594.0
2014-07-29	AD	Futures	0.93937	0.93947	0.93368	0.93459	51749.0
2014-07-29	ALI	Futures	2908.12	2908.12	2908.12	2908.12	9.0
2014-07-29	B	Futures	113.14	113.75	112.9	113.48	92054.0
2014-07-29	B6	Futures	1.7845	1.786	1.7794	1.7806	75837.0
2014-07-29	BFX	Futures	3847.6	3852.6	3817.7	3817.7	4.0
2014-07-29	BR	Futures	0.23463	0.23479	0.2341	0.23429	2853.0
2014-07-29	BZ	Futures	114.19	114.63	113.79	114.37	15650.0
2014-07-29	C	Futures	2066.0	2084.0	2060.0	2082.0	8606.0
2014-07-29	CB	Futures	129.537	129.677	129.453	129.453	1.0
2014-07-29	CC	Futures	2330.0	2342.0	2325.0	2334.0	10183.0
2014-07-29	CNH	Futures	7.1032	7.1074	7.1032	7.1074	5.0
2014-07-29	CSC	Futures	4.533	4.564	4.533	4.562	7.0
2014-07-29	CT	Futures	82.38	82.38	80.7	81.29	17.0
2014-07-29	DC	Futures	36.64	37.07	36.64	37.04	252.0
2014-07-29	DX	Futures	76.973	77.21	76.968	77.186	15266.0
2014-07-29	E1	Futures	1.41827	1.41904	1.41314	1.41391	36605.0
2014-07-29	E6	Futures	1.58595	1.58654	1.5817	1.58241	133238.0
2014-07-29	E7	Futures	1.5755	1.5761	1.5715	1.5721	1336.0
2014-07-29	ED	Futures	95.4115	95.4162	95.4067	95.4162	267304.0
2014-07-29	ER	Futures	97.881	97.886	97.881	97.886	24381.0
2014-07-29	EW	Futures	1453.9	1462.1	1445.5	1447.5	13633.0
2014-07-29	FBTP	Futures	92.73	93.04	92.7	92.94	47110.0
2014-07-29	FBTS	Futures	98.516	98.596	98.508	98.552	10135.0
2014-07-29	FCE	Futures	3465.4	3492.8	3445.5	3472.1	101711.0
2014-07-29	FDAX	Futures	10596.8	10679.4	10545.6	10634.8	95783.0
2014-07-29	FESX	Futures	2287.9	2306.6	2275.0	2292.9	866757.0
2014-07-29	FEU3	Futures	98.507	98.507	98.507	98.507	5.0
2014-07-29	FGBL	Futures	128.9	129.37	128.85	129.29	626941.0
2014-07-29	FGBM	Futures	121.67	121.83	121.66	121.79	342057.0
2014-07-29	FGBS	Futures	110.743	110.768	110.738	110.763	159836.0
2014-07-29	FGBX	Futures	136.37	137.71	136.29	137.52	21463.0
2014-07-29	FMWO	Futures	5814.1	5819.2	5801.6	5801.6	104.0
2014-07-29	FOAT	Futures	118.94	119.38	118.94	119.34	40140.0
2014-07-29	FTDX	Futures	1171.5	1173.9	1162.6	1171.1	387.0
2014-07-29	FTI	Futures	350.65	352.99	349.0	351.78	32413.0
2014-07-29	FTUK	Futures	5195.4	5222.7	5181.5	5201.9	76276.0
2014-07-29	FVSA	Futures	1422.12	1426.36	1383.91	1405.14	4059.0
2014-07-29	FXXP	Futures	257.4	258.3	256.3	257.4	3410.0
2014-07-29	G	Futures	94.88	95.18	94.72	95.1	208315.0
2014-07-29	GF	Futures	338.704	339.93	337.171	339.355	2864.0
2014-07-29	GSCI	Futures	1053.03	1054.36	1049.93	1053.03	83.0
2014-07-29	HE	Futures	129.025	129.025	126.9	127.451	14099.0
2014-07-29	HG	Futures	4.1471	4.1599	4.1088	4.1145	34474.0

> showing 50 of 105 rows — these rows as CSV

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