PREVIEW / futures_daily / 2014-07-25

all futures daily files

  file:    by_date/futures_daily/2014/2014-07-25.parquet
  size:    9 KB
  rows:    104

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-25	ES	Futures	2055.52	2057.6	2044.35	2047.99	1426906.0
2014-07-25	NQ	Futures	4572.14	4575.31	4543.0	4563.77	210231.0
2014-07-25	YM	Futures	17129.5	17157.8	16997.4	17042.8	153127.0
2014-07-25	CL	Futures	187.85	188.75	185.93	187.94	284919.0
2014-07-25	GC	Futures	1705.2	1724.6	1701.0	1717.2	131242.0
2014-07-25	ZN	Futures	116.812925	117.046347	116.652448	117.00258	942499.0
2014-07-25	A6	Futures	0.90688	0.90775	0.90465	0.90494	62565.0
2014-07-25	AD	Futures	0.94414	0.94465	0.93734	0.93795	64320.0
2014-07-25	ALI	Futures	2936.06	2936.06	2936.06	2936.06	0.0
2014-07-25	B	Futures	112.75	114.08	112.26	114.0	253169.0
2014-07-25	B6	Futures	1.7852	1.7862	1.7823	1.7839	72569.0
2014-07-25	BR	Futures	0.23516	0.23516	0.23384	0.23434	450.0
2014-07-25	BZ	Futures	113.41	114.79	112.98	114.73	12114.0
2014-07-25	C	Futures	2084.0	2089.0	2078.0	2085.0	5530.0
2014-07-25	CB	Futures	131.912	131.912	129.118	129.537	22.0
2014-07-25	CC	Futures	2349.0	2355.0	2338.0	2347.0	6628.0
2014-07-25	CNH	Futures	7.1235	7.1235	7.1157	7.1157	2.0
2014-07-25	CSC	Futures	4.466	4.466	4.439	4.444	46.0
2014-07-25	CT	Futures	83.94	84.16	81.24	82.2	50.0
2014-07-25	DC	Futures	36.4	36.41	35.79	35.89	217.0
2014-07-25	DX	Futures	76.835	77.077	76.792	77.006	24568.0
2014-07-25	E1	Futures	1.42058	1.42186	1.4166	1.41737	33707.0
2014-07-25	E6	Futures	1.58878	1.5902	1.58371	1.585	142916.0
2014-07-25	E7	Futures	1.5782	1.5797	1.5735	1.5747	1484.0
2014-07-25	ED	Futures	95.4162	95.4162	95.4115	95.4162	57159.0
2014-07-25	ER	Futures	97.876	97.886	97.876	97.881	47843.0
2014-07-25	EW	Futures	1462.3	1464.7	1454.5	1455.8	14180.0
2014-07-25	FBTP	Futures	92.29	92.54	92.29	92.41	33998.0
2014-07-25	FBTS	Futures	98.419	98.49	98.419	98.454	5022.0
2014-07-25	FCE	Futures	3497.6	3498.0	3433.2	3443.9	106012.0
2014-07-25	FDAX	Futures	10770.8	10790.6	10596.8	10615.5	99419.0
2014-07-25	FESX	Futures	2310.2	2316.7	2275.0	2281.4	874525.0
2014-07-25	FEU3	Futures	98.497	98.502	98.497	98.502	25.0
2014-07-25	FGBL	Futures	128.65	129.04	128.53	128.95	484294.0
2014-07-25	FGBM	Futures	121.61	121.79	121.59	121.76	303288.0
2014-07-25	FGBS	Futures	110.748	110.773	110.748	110.763	100204.0
2014-07-25	FGBX	Futures	135.3	136.21	135.14	136.07	12570.0
2014-07-25	FMWO	Futures	5821.7	5821.7	5797.8	5797.8	10.0
2014-07-25	FOAT	Futures	118.77	118.97	118.65	118.92	29885.0
2014-07-25	FTDX	Futures	1187.0	1187.0	1172.5	1172.5	54.0
2014-07-25	FTI	Futures	353.38	353.94	348.44	349.39	25875.0
2014-07-25	FTUK	Futures	5200.0	5219.6	5180.0	5185.4	68563.0
2014-07-25	FVSA	Futures	1392.4	1439.1	1379.67	1434.85	4234.0
2014-07-25	FXXP	Futures	258.6	259.3	256.5	256.8	5323.0
2014-07-25	G	Futures	94.54	94.92	94.48	94.85	128762.0
2014-07-25	GF	Futures	332.573	334.719	332.228	334.489	2334.0
2014-07-25	GSCI	Futures	1055.62	1061.39	1051.52	1060.55	112.0
2014-07-25	HE	Futures	129.524	130.652	128.658	129.734	10219.0
2014-07-25	HG	Futures	4.1727	4.1912	4.1388	4.142	41604.0
2014-07-25	HH	Futures	48.645	48.645	47.858	48.074	125.0

> showing 50 of 104 rows — these rows as CSV

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