PREVIEW / futures_daily / 2013-07-23

all futures daily files

  file:    by_date/futures_daily/2013/2013-07-23.parquet
  size:    9 KB
  rows:    101

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
2013-07-23	ES	Futures	1741.15	1746.3	1736.52	1738.84	979783.0
2013-07-23	NQ	Futures	3527.22	3539.65	3497.43	3500.32	161677.0
2013-07-23	YM	Futures	15358.0	15409.5	15349.1	15375.8	80289.0
2013-07-23	CL	Futures	186.87	187.84	184.19	187.28	241640.0
2013-07-23	GC	Futures	1771.3	1790.4	1759.8	1771.8	159441.0
2013-07-23	ZN	Futures	114.275446	114.289483	113.896446	114.050854	778470.0
2013-07-23	A6	Futures	0.86413	0.86939	0.86197	0.86882	82920.0
2013-07-23	AD	Futures	0.97318	0.97903	0.97217	0.97872	68019.0
2013-07-23	B	Futures	105.33	105.65	104.61	105.45	190199.0
2013-07-23	B6	Futures	1.6093	1.6133	1.6063	1.6132	95095.0
2013-07-23	BFX	Futures	3172.2	3179.4	3156.0	3156.0	70.0
2013-07-23	BR	Futures	0.21928	0.22197	0.21928	0.22126	306.0
2013-07-23	BZ	Futures	105.88	106.34	105.34	106.16	9570.0
2013-07-23	C	Futures	1690.0	1705.0	1688.0	1695.0	6384.0
2013-07-23	CB	Futures	75.381	76.063	75.381	75.943	9.0
2013-07-23	CC	Futures	1754.0	1774.0	1748.0	1763.0	12074.0
2013-07-23	CT	Futures	102.72	102.72	101.35	102.43	5.0
2013-07-23	DC	Futures	27.06	27.08	26.72	26.89	283.0
2013-07-23	DX	Futures	78.625	78.816	78.377	78.405	25188.0
2013-07-23	E1	Futures	1.37362	1.37645	1.36694	1.3762	20449.0
2013-07-23	E6	Futures	1.5561	1.56282	1.55374	1.56211	170473.0
2013-07-23	E7	Futures	1.5461	1.5525	1.5437	1.5519	2753.0
2013-07-23	ED	Futures	95.2869	95.2964	95.2821	95.2869	65085.0
2013-07-23	ER	Futures	97.813	97.832	97.798	97.803	84746.0
2013-07-23	EW	Futures	1261.8	1265.5	1257.3	1261.5	12654.0
2013-07-23	FBTP	Futures	78.02	78.25	77.73	77.85	25409.0
2013-07-23	FBTS	Futures	93.143	93.178	93.023	93.04	5522.0
2013-07-23	FCE	Futures	3055.1	3062.0	3033.4	3035.0	60263.0
2013-07-23	FDAX	Futures	9273.5	9289.6	9220.2	9233.5	69835.0
2013-07-23	FESX	Futures	1919.0	1925.3	1909.9	1911.3	650892.0
2013-07-23	FGBL	Futures	120.78	120.83	120.2	120.42	659868.0
2013-07-23	FGBM	Futures	117.83	117.85	117.45	117.57	425451.0
2013-07-23	FGBS	Futures	110.392	110.397	110.303	110.333	346213.0
2013-07-23	FGBX	Futures	126.14	126.26	125.15	125.49	11576.0
2013-07-23	FMWO	Futures	4994.0	4994.0	4985.1	4985.1	24.0
2013-07-23	FOAT	Futures	107.04	107.19	106.72	106.9	45198.0
2013-07-23	FTDX	Futures	945.1	950.3	930.5	932.4	168.0
2013-07-23	FTI	Futures	323.87	324.49	321.38	321.55	16901.0
2013-07-23	FTUK	Futures	4932.0	4959.4	4909.5	4924.2	79768.0
2013-07-23	FVSA	Futures	2723.73	2745.06	2695.28	2730.84	4530.0
2013-07-23	FXXP	Futures	221.8	221.8	219.9	220.0	3519.0
2013-07-23	G	Futures	95.72	95.72	95.1	95.34	141111.0
2013-07-23	GF	Futures	257.577	259.978	257.325	258.799	2112.0
2013-07-23	GSCI	Futures	1060.18	1063.04	1055.51	1060.01	502.0
2013-07-23	HE	Futures	100.955	102.479	100.775	102.453	16637.0
2013-07-23	HG	Futures	4.0298	4.0831	4.014	4.0577	43366.0
2013-07-23	HH	Futures	41.738	41.86	40.88	41.693	6293.0
2013-07-23	HO	Futures	2.4681	2.4744	2.4456	2.4675	41915.0
2013-07-23	HRC	Futures	2221.1	2221.1	2221.1	2221.1	0.0
2013-07-23	J1	Futures	0.0126332	0.0126961	0.0125627	0.0126571	108548.0

> showing 50 of 101 rows — these rows as CSV

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