PREVIEW / futures_daily / 2011-07-28

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-28.parquet
  size:    9 KB
  rows:    96

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
2011-07-28	ES	Futures	1290.33	1303.98	1286.36	1287.85	2338767.0
2011-07-28	NQ	Futures	2687.47	2731.6	2682.63	2698.86	287066.0
2011-07-28	YM	Futures	11580.3	11659.7	11507.5	11527.3	115636.0
2011-07-28	CL	Futures	186.41	187.83	184.96	186.74	236246.0
2011-07-28	GC	Futures	2182.1	2191.0	2167.0	2182.1	163995.0
2011-07-28	ZN	Futures	105.801141	106.20029	105.761226	106.01402	1188266.0
2011-07-28	A6	Futures	0.95267	0.95728	0.94866	0.94979	87186.0
2011-07-28	AD	Futures	1.05026	1.05395	1.04666	1.04886	63989.0
2011-07-28	B	Futures	100.11	101.29	99.95	100.23	100634.0
2011-07-28	B6	Futures	1.6976	1.7031	1.694	1.6994	73544.0
2011-07-28	BFX	Futures	2948.8	2959.2	2920.4	2959.2	5.0
2011-07-28	BR	Futures	0.28196	0.28236	0.28132	0.28214	64.0
2011-07-28	BZ	Futures	103.7	103.72	103.52	103.52	1400.0
2011-07-28	C	Futures	2049.0	2060.0	2013.0	2015.0	3793.0
2011-07-28	CB	Futures	113.422	114.244	113.422	113.97	16.0
2011-07-28	CC	Futures	2404.0	2416.0	2356.0	2358.0	10778.0
2011-07-28	CSC	Futures	5.012	5.012	5.012	5.012	14.0
2011-07-28	CT	Futures	134.76	134.76	131.46	133.42	30.0
2011-07-28	DC	Futures	34.12	34.72	34.12	34.41	553.0
2011-07-28	DX	Futures	73.583	73.865	73.331	73.673	23222.0
2011-07-28	E1	Futures	1.63285	1.63769	1.62592	1.63233	31581.0
2011-07-28	E6	Futures	1.70421	1.70813	1.69055	1.69744	305232.0
2011-07-28	E7	Futures	1.6906	1.6957	1.6783	1.685	5327.0
2011-07-28	ED	Futures	94.9287	94.9382	94.9144	94.9334	181893.0
2011-07-28	ER	Futures	97.361	97.371	97.351	97.361	73903.0
2011-07-28	EW	Futures	939.3	951.0	934.9	935.2	19478.0
2011-07-28	FBTP	Futures	60.81	60.81	59.6	60.34	20919.0
2011-07-28	FCE	Futures	2607.6	2626.3	2587.9	2620.3	134428.0
2011-07-28	FDAX	Futures	7694.3	7715.7	7613.7	7705.0	164946.0
2011-07-28	FESX	Futures	1708.1	1732.4	1700.4	1729.9	1459228.0
2011-07-28	FEU3	Futures	97.905	97.905	97.9	97.9	248.0
2011-07-28	FGBL	Futures	103.77	104.18	103.59	103.83	918664.0
2011-07-28	FGBM	Futures	107.04	107.27	106.93	107.05	468720.0
2011-07-28	FGBS	Futures	107.691	107.766	107.646	107.681	497961.0
2011-07-28	FGBX	Futures	100.21	100.96	99.75	99.95	3024.0
2011-07-28	FTDX	Futures	745.7	748.4	729.2	738.6	599.0
2011-07-28	FTI	Futures	271.91	275.19	271.04	274.52	40034.0
2011-07-28	FTUK	Futures	4068.0	4124.4	4051.7	4115.2	103997.0
2011-07-28	FXXP	Futures	179.1	180.8	178.9	180.4	4395.0
2011-07-28	G	Futures	86.64	86.93	86.43	86.65	98056.0
2011-07-28	GF	Futures	313.279	317.229	312.349	315.603	2484.0
2011-07-28	GSCI	Futures	1113.75	1116.15	1107.34	1109.98	165.0
2011-07-28	HE	Futures	111.79	113.249	111.652	112.891	9019.0
2011-07-28	HG	Futures	5.8681	5.9322	5.8562	5.9085	24510.0
2011-07-28	HO	Futures	2.5058	2.5363	2.5025	2.5215	49905.0
2011-07-28	HRC	Futures	2933.1	2933.1	2933.1	2933.1	100.0
2011-07-28	J1	Futures	0.0161388	0.0161978	0.0161149	0.0161627	76909.0
2011-07-28	J7	Futures	0.01602	0.016087	0.016008	0.016055	263.0
2011-07-28	JB	Futures	123.4	123.54	123.39	123.44	2929.0
2011-07-28	KC	Futures	571.57	578.66	561.16	564.59	12484.0

> showing 50 of 96 rows — these rows as CSV

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