PREVIEW / futures_daily / 2012-11-09

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-09.parquet
  size:    9 KB
  rows:    99

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
2012-11-09	ES	Futures	1400.22	1412.68	1387.75	1400.22	2549324.0
2012-11-09	NQ	Futures	2961.1	2999.93	2941.25	2969.15	366575.0
2012-11-09	YM	Futures	12476.6	12540.1	12372.1	12463.9	168559.0
2012-11-09	CL	Futures	153.19	156.38	151.62	155.12	322403.0
2012-11-09	GC	Futures	2311.8	2322.3	2305.6	2311.0	148670.0
2012-11-09	ZN	Futures	117.727733	117.961211	117.507989	117.700265	1156330.0
2012-11-09	A6	Futures	0.94253	0.94553	0.93853	0.94162	129416.0
2012-11-09	AD	Futures	1.00258	1.00469	0.99957	1.00258	92021.0
2012-11-09	B	Futures	98.19	100.48	97.38	100.12	159378.0
2012-11-09	B6	Futures	1.6691	1.6729	1.659	1.6607	119099.0
2012-11-09	BFX	Futures	2823.8	2827.7	2811.3	2827.7	6.0
2012-11-09	BR	Futures	0.23643	0.2368	0.23435	0.2368	163.0
2012-11-09	BZ	Futures	101.17	103.33	100.49	103.24	394.0
2012-11-09	C	Futures	1540.0	1565.0	1539.0	1561.0	2790.0
2012-11-09	CB	Futures	92.06	92.06	92.06	92.06	4.0
2012-11-09	CC	Futures	1769.0	1788.0	1752.0	1780.0	15064.0
2012-11-09	CSC	Futures	4.019	4.019	3.973	3.973	19.0
2012-11-09	CT	Futures	89.65	90.35	89.18	89.79	29689.0
2012-11-09	DC	Futures	30.44	30.45	29.67	29.75	574.0
2012-11-09	DX	Futures	78.409	78.627	78.152	78.552	23737.0
2012-11-09	E1	Futures	1.36128	1.36566	1.35536	1.35742	26830.0
2012-11-09	E6	Futures	1.50142	1.5066	1.4947	1.49741	286917.0
2012-11-09	E7	Futures	1.4927	1.4976	1.4859	1.4885	3510.0
2012-11-09	ED	Futures	95.2396	95.2444	95.2301	95.2396	120067.0
2012-11-09	ER	Futures	97.891	97.896	97.886	97.891	52411.0
2012-11-09	EW	Futures	984.7	994.1	976.1	987.4	21935.0
2012-11-09	FBTP	Futures	72.13	72.41	71.7	72.31	20754.0
2012-11-09	FBTS	Futures	89.709	89.835	89.625	89.826	2858.0
2012-11-09	FCE	Futures	2566.7	2579.8	2533.6	2573.8	114878.0
2012-11-09	FDAX	Futures	7924.1	7929.6	7738.4	7855.1	181511.0
2012-11-09	FESX	Futures	1690.6	1692.0	1660.0	1688.6	1219244.0
2012-11-09	FGBL	Futures	119.56	119.91	119.46	119.63	655460.0
2012-11-09	FGBM	Futures	117.09	117.22	117.02	117.08	378290.0
2012-11-09	FGBS	Futures	110.527	110.542	110.502	110.512	259461.0
2012-11-09	FGBX	Futures	127.09	127.84	127.09	127.43	10244.0
2012-11-09	FOAT	Futures	104.38	104.68	104.25	104.61	21919.0
2012-11-09	FTDX	Futures	758.9	758.9	750.0	755.6	104.0
2012-11-09	FTI	Futures	285.27	285.35	281.41	284.32	37504.0
2012-11-09	FTUK	Futures	4205.5	4222.7	4168.1	4215.0	98892.0
2012-11-09	FVSA	Futures	5082.29	5387.23	5059.7	5082.29	4717.0
2012-11-09	FXXP	Futures	195.1	195.2	193.0	194.8	1215.0
2012-11-09	G	Futures	99.17	99.97	99.17	99.49	216534.0
2012-11-09	GF	Futures	277.475	278.243	276.515	276.899	1330.0
2012-11-09	GSCI	Futures	1010.65	1030.62	1010.57	1026.17	1727.0
2012-11-09	HE	Futures	99.594	100.62	99.315	100.371	24503.0
2012-11-09	HG	Futures	4.4541	4.4875	4.3732	4.4278	62261.0
2012-11-09	HH	Futures	40.757	40.757	40.757	40.757	330.0
2012-11-09	HO	Futures	2.3954	2.4454	2.3847	2.436	46986.0
2012-11-09	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-09	J1	Futures	0.0157579	0.015838	0.0157316	0.0157666	114109.0

> showing 50 of 99 rows — these rows as CSV

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