PREVIEW / futures_daily / 2013-07-29

all futures daily files

  file:    by_date/futures_daily/2013/2013-07-29.parquet
  size:    9 KB
  rows:    102

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-29	ES	Futures	1737.03	1738.58	1726.73	1732.91	1100568.0
2013-07-29	NQ	Futures	3551.22	3561.05	3535.89	3546.01	189954.0
2013-07-29	YM	Futures	15356.0	15367.9	15285.6	15346.1	94946.0
2013-07-29	CL	Futures	182.7	184.03	181.41	182.6	206326.0
2013-07-29	GC	Futures	1763.6	1770.2	1749.9	1758.5	102050.0
2013-07-29	ZN	Futures	113.756076	113.92452	113.531484	113.671854	677973.0
2013-07-29	A6	Futures	0.86573	0.86845	0.85916	0.86047	71546.0
2013-07-29	AD	Futures	0.97862	0.98154	0.97862	0.98124	42959.0
2013-07-29	B	Futures	104.25	104.89	103.71	104.5	96082.0
2013-07-29	B6	Futures	1.6124	1.6156	1.6066	1.6096	66472.0
2013-07-29	BR	Futures	0.21747	0.21762	0.21663	0.21677	1621.0
2013-07-29	BZ	Futures	105.06	105.64	104.48	105.27	8559.0
2013-07-29	C	Futures	1659.0	1671.0	1635.0	1637.0	7147.0
2013-07-29	CB	Futures	74.628	74.628	73.91	74.269	24.0
2013-07-29	CC	Futures	1736.0	1738.0	1695.0	1704.0	15341.0
2013-07-29	CSC	Futures	3.471	3.482	3.459	3.471	34.0
2013-07-29	CT	Futures	101.9	101.9	101.05	101.05	4.0
2013-07-29	DC	Futures	26.46	26.93	26.41	26.61	198.0
2013-07-29	DX	Futures	78.152	78.305	77.994	78.141	27235.0
2013-07-29	E1	Futures	1.38468	1.38712	1.37928	1.38224	19230.0
2013-07-29	E6	Futures	1.56766	1.56931	1.56259	1.56577	155080.0
2013-07-29	E7	Futures	1.5573	1.559	1.5524	1.5556	2166.0
2013-07-29	ED	Futures	95.2964	95.2964	95.2869	95.2916	51460.0
2013-07-29	ER	Futures	97.822	97.827	97.817	97.817	34803.0
2013-07-29	EW	Futures	1249.0	1252.8	1240.1	1245.5	15280.0
2013-07-29	FBTP	Futures	77.67	77.8	77.3	77.37	18757.0
2013-07-29	FBTS	Futures	93.023	93.04	92.902	92.928	3697.0
2013-07-29	FCE	Futures	3078.3	3094.9	3064.4	3069.4	62354.0
2013-07-29	FDAX	Futures	9175.3	9244.6	9149.7	9161.9	70822.0
2013-07-29	FESX	Futures	1931.6	1939.4	1919.7	1921.8	511883.0
2013-07-29	FEU3	Futures	98.433	98.433	98.428	98.428	2.0
2013-07-29	FGBL	Futures	119.38	119.51	119.09	119.28	415953.0
2013-07-29	FGBM	Futures	117.19	117.25	117.01	117.14	284876.0
2013-07-29	FGBS	Futures	110.318	110.318	110.258	110.288	176341.0
2013-07-29	FGBX	Futures	123.29	123.61	122.64	123.4	10780.0
2013-07-29	FMWO	Futures	4938.3	4938.3	4938.3	4938.3	0.0
2013-07-29	FOAT	Futures	106.4	106.47	106.19	106.35	28014.0
2013-07-29	FTDX	Futures	936.2	938.5	930.5	931.0	231.0
2013-07-29	FTI	Futures	322.12	323.65	320.68	321.16	18225.0
2013-07-29	FTUK	Futures	4907.3	4921.2	4871.7	4880.7	58714.0
2013-07-29	FVSA	Futures	2752.17	2809.07	2745.06	2780.62	2619.0
2013-07-29	FXXP	Futures	221.1	221.2	219.5	219.6	4537.0
2013-07-29	G	Futures	95.15	95.51	95.03	95.18	91851.0
2013-07-29	GF	Futures	257.746	259.136	257.577	258.251	2612.0
2013-07-29	GSCI	Futures	1044.39	1046.27	1038.34	1040.38	274.0
2013-07-29	HE	Futures	101.317	101.627	100.62	101.136	8837.0
2013-07-29	HG	Futures	3.9397	3.9556	3.9156	3.9429	47436.0
2013-07-29	HH	Futures	38.008	38.25	37.766	38.25	1159.0
2013-07-29	HO	Futures	2.4193	2.441	2.412	2.4245	42843.0
2013-07-29	HRC	Futures	2249.0	2249.0	2249.0	2249.0	0.0

> showing 50 of 102 rows — these rows as CSV

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