PREVIEW / futures_daily / 2011-07-18

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-18.parquet
  size:    9 KB
  rows:    95

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-18	ES	Futures	1305.47	1305.72	1282.38	1291.57	2168734.0
2011-07-18	NQ	Futures	2681.21	2682.06	2640.49	2664.69	249078.0
2011-07-18	YM	Futures	11773.1	11773.1	11570.8	11655.0	128610.0
2011-07-18	CL	Futures	187.49	187.91	182.16	184.46	182989.0
2011-07-18	GC	Futures	2157.8	2176.2	2153.8	2168.7	139693.0
2011-07-18	ZN	Futures	106.333339	106.586134	106.20029	106.373254	1024055.0
2011-07-18	A6	Futures	0.91848	0.91952	0.91135	0.91474	94787.0
2011-07-18	AD	Futures	1.04437	1.04497	1.03409	1.03848	63079.0
2011-07-18	B	Futures	100.22	100.43	97.76	98.94	149229.0
2011-07-18	B6	Futures	1.6767	1.6774	1.6637	1.668	109428.0
2011-07-18	BFX	Futures	2915.1	2915.1	2870.5	2875.8	146.0
2011-07-18	BR	Futures	0.27891	0.27996	0.27889	0.2796	73.0
2011-07-18	BZ	Futures	103.15	103.55	101.61	102.76	416.0
2011-07-18	C	Futures	2138.0	2186.0	2132.0	2166.0	3571.0
2011-07-18	CC	Futures	2504.0	2534.0	2471.0	2504.0	6841.0
2011-07-18	CSC	Futures	4.867	4.892	4.867	4.892	1.0
2011-07-18	CT	Futures	131.53	131.53	125.18	127.11	182.0
2011-07-18	DC	Futures	32.73	33.64	32.66	33.43	623.0
2011-07-18	DX	Futures	74.791	75.381	74.752	75.062	30471.0
2011-07-18	E1	Futures	1.61546	1.61585	1.59702	1.59833	39070.0
2011-07-18	E6	Futures	1.67464	1.67559	1.66133	1.66953	277153.0
2011-07-18	E7	Futures	1.663	1.6635	1.6493	1.6573	5017.0
2011-07-18	ED	Futures	94.8858	94.8906	94.8667	94.8906	264228.0
2011-07-18	ER	Futures	97.371	97.405	97.361	97.371	79039.0
2011-07-18	EW	Futures	967.5	967.8	946.6	953.1	21558.0
2011-07-18	FBTP	Futures	60.51	60.51	59.09	59.51	9048.0
2011-07-18	FCE	Futures	2616.8	2621.4	2563.2	2573.8	151407.0
2011-07-18	FDAX	Futures	7701.3	7706.6	7593.4	7632.9	154474.0
2011-07-18	FESX	Futures	1707.4	1710.0	1676.0	1686.9	1475330.0
2011-07-18	FEU3	Futures	97.91	97.91	97.905	97.91	102.0
2011-07-18	FGBL	Futures	103.5	104.08	103.49	103.84	694296.0
2011-07-18	FGBM	Futures	107.03	107.3	107.02	107.11	391198.0
2011-07-18	FGBS	Futures	107.855	107.91	107.776	107.825	408977.0
2011-07-18	FGBX	Futures	99.7	101.18	99.7	100.85	3888.0
2011-07-18	FTDX	Futures	739.5	746.6	726.1	731.9	724.0
2011-07-18	FTI	Futures	270.59	270.84	266.03	266.53	39553.0
2011-07-18	FTUK	Futures	4091.6	4091.6	4018.9	4037.6	101623.0
2011-07-18	FXXP	Futures	179.4	179.6	176.9	177.4	1501.0
2011-07-18	G	Futures	86.28	86.48	86.21	86.32	78319.0
2011-07-18	GF	Futures	315.544	317.288	311.652	312.756	2544.0
2011-07-18	GSCI	Futures	1104.62	1106.22	1092.05	1101.5	418.0
2011-07-18	HE	Futures	109.641	110.165	106.364	108.457	14033.0
2011-07-18	HG	Futures	5.8364	5.8807	5.7796	5.8205	33650.0
2011-07-18	HO	Futures	2.5376	2.5467	2.4751	2.5021	20454.0
2011-07-18	HRC	Futures	2989.2	2989.2	2989.2	2989.2	0.0
2011-07-18	J1	Futures	0.0159	0.0159276	0.0158798	0.0159037	56237.0
2011-07-18	J7	Futures	0.015786	0.015822	0.015777	0.015797	171.0
2011-07-18	JB	Futures	123.37	123.52	123.35	123.45	365.0
2011-07-18	KC	Futures	597.0	599.13	585.05	587.18	9457.0
2011-07-18	KE	Futures	2938.37	2946.05	2874.99	2923.01	6561.0

> showing 50 of 95 rows — these rows as CSV

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