PREVIEW / futures_daily / 2014-08-19

all futures daily files

  file:    by_date/futures_daily/2014/2014-08-19.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-08-19	ES	Futures	2044.87	2056.56	2044.61	2053.96	868384.0
2014-08-19	NQ	Futures	4634.73	4661.84	4633.29	4654.63	151276.0
2014-08-19	YM	Futures	16954.0	17050.8	16954.0	17032.7	80509.0
2014-08-19	CL	Futures	174.81	175.78	172.52	172.97	277495.0
2014-08-19	GC	Futures	1703.3	1710.0	1698.2	1700.8	78238.0
2014-08-19	ZN	Futures	117.907089	118.198866	117.834145	117.848733	990938.0
2014-08-19	A6	Futures	0.89943	0.90146	0.89731	0.89808	64125.0
2014-08-19	AD	Futures	0.93216	0.93226	0.92687	0.92748	38411.0
2014-08-19	ALI	Futures	2942.37	2942.37	2942.37	2942.37	0.0
2014-08-19	B	Futures	106.73	107.2	106.15	106.66	177096.0
2014-08-19	B6	Futures	1.7578	1.7582	1.7458	1.7467	96849.0
2014-08-19	BFX	Futures	3830.5	3837.8	3827.1	3832.8	104.0
2014-08-19	BR	Futures	0.23305	0.23373	0.23194	0.23358	3240.0
2014-08-19	BZ	Futures	107.55	108.03	106.98	107.5	13304.0
2014-08-19	C	Futures	2183.0	2186.0	2157.0	2158.0	2644.0
2014-08-19	CB	Futures	144.405	146.585	144.405	146.585	13.0
2014-08-19	CC	Futures	2402.0	2403.0	2362.0	2365.0	16746.0
2014-08-19	CSC	Futures	4.712	4.839	4.692	4.837	11.0
2014-08-19	CT	Futures	80.02	80.11	79.89	80.07	12.0
2014-08-19	DC	Futures	38.8	39.67	38.21	39.58	499.0
2014-08-19	DX	Futures	77.504	77.794	77.495	77.777	24216.0
2014-08-19	E1	Futures	1.41417	1.41519	1.40968	1.41032	24756.0
2014-08-19	E6	Futures	1.57686	1.57698	1.57096	1.57179	159667.0
2014-08-19	E7	Futures	1.5667	1.5667	1.5608	1.5615	1564.0
2014-08-19	ED	Futures	95.4162	95.4186	95.4162	95.4186	30947.0
2014-08-19	ER	Futures	97.911	97.92	97.906	97.92	34321.0
2014-08-19	EW	Futures	1465.2	1474.7	1464.5	1473.5	10476.0
2014-08-19	FBTP	Futures	93.18	93.56	93.16	93.5	39940.0
2014-08-19	FBTS	Futures	98.659	98.739	98.65	98.712	5819.0
2014-08-19	FCE	Futures	3376.0	3391.5	3369.2	3388.3	57519.0
2014-08-19	FDAX	Futures	10210.8	10300.5	10206.9	10284.0	70974.0
2014-08-19	FESX	Futures	2216.0	2226.1	2213.8	2223.9	617270.0
2014-08-19	FGBL	Futures	130.3	130.65	130.28	130.53	490599.0
2014-08-19	FGBM	Futures	122.15	122.29	122.15	122.24	245314.0
2014-08-19	FGBS	Futures	110.828	110.843	110.823	110.838	133407.0
2014-08-19	FGBX	Futures	139.87	140.8	139.81	140.58	19349.0
2014-08-19	FMWO	Futures	5762.6	5765.1	5756.3	5763.8	159.0
2014-08-19	FOAT	Futures	120.21	120.55	120.18	120.48	48747.0
2014-08-19	FTDX	Futures	1136.4	1152.8	1135.5	1145.3	429.0
2014-08-19	FTI	Futures	344.89	347.77	344.84	347.21	19257.0
2014-08-19	FTUK	Futures	5185.0	5212.3	5183.5	5205.8	66779.0
2014-08-19	FVSA	Futures	1446.52	1463.64	1425.12	1450.8	26735.0
2014-08-19	FXXP	Futures	251.9	252.8	251.9	252.8	8640.0
2014-08-19	G	Futures	96.08	96.6	96.04	96.4	147117.0
2014-08-19	GF	Futures	335.319	337.452	331.014	332.372	2579.0
2014-08-19	GSCI	Futures	1008.81	1009.48	1003.53	1004.2	64.0
2014-08-19	HE	Futures	114.911	116.694	114.125	114.639	16146.0
2014-08-19	HG	Futures	3.9739	3.9923	3.9498	3.9562	14228.0
2014-08-19	HH	Futures	49.585	49.598	49.217	49.217	4806.0
2014-08-19	HO	Futures	2.2578	2.2632	2.2512	2.2594	17517.0

> showing 50 of 104 rows — these rows as CSV

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