PREVIEW / etf_daily / 2012-09-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-11.parquet
  size:    39 KB
  rows:    943

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-09-11	SPY	ETF	143.6	144.37	143.56	143.91	88760000.0
2012-09-11	QQQ	ETF	68.54	68.82	68.32	68.43	29810086.0
2012-09-11	IWM	ETF	83.89	84.56	83.83	84.06	33164100.0
2012-09-11	DIA	ETF	132.6	133.45	132.59	133.09	2824400.0
2012-09-11	GLD	ETF	168.22	168.53	167.79	167.9	7522900.0
2012-09-11	TLT	ETF	124.02	124.1	123.29	123.55	3523300.0
2012-09-11	AADR	ETF	29.66	29.7	29.66	29.7	400.0
2012-09-11	AAXJ	ETF	54.18	54.5	54.12	54.42	86700.0
2012-09-11	ACTV	ETF	12.2	12.45	12.15	12.39	355423.0
2012-09-11	ACWI	ETF	46.45	46.86	46.45	46.73	451500.0
2012-09-11	ACWV	ETF	56.21	56.3	56.1	56.19	3900.0
2012-09-11	ACWX	ETF	39.11	39.48	39.1	39.42	92722.0
2012-09-11	ADRE	ETF	38.63	38.99	38.63	38.93	16123.0
2012-09-11	AFK	ETF	30.91	31.02	30.8401	30.9324	10473.0
2012-09-11	AGEM	ETF	21.86	22.131	21.86	22.0	18517.0
2012-09-11	AGG	ETF	111.77	111.88	111.75	111.78	3037100.0
2012-09-11	AGQ	ETF	224.28	225.44	219.8	220.88	338650.0
2012-09-11	AGZ	ETF	113.92	113.94	113.55	113.89	8721.0
2012-09-11	AIA	ETF	42.7	43.08	42.7	43.01	47959.0
2012-09-11	AIQ	ETF	6.8	7.15	6.7	7.15	8860.0
2012-09-11	AIVI	ETF	40.66	41.08	40.59	41.03	24000.0
2012-09-11	ALTL	ETF	25.77	25.77	25.714	25.743	3629.0
2012-09-11	AMJ	ETF	39.52	39.59	39.4095	39.51	649481.0
2012-09-11	AMLP	ETF	81.65	81.7	81.4	81.55	300700.0
2012-09-11	AOA	ETF	36.78	36.83	36.76	36.77	5200.0
2012-09-11	AOK	ETF	30.48	30.48	30.44	30.4562	8516.0
2012-09-11	AOM	ETF	31.58	31.6392	31.58	31.6	69662.0
2012-09-11	AOR	ETF	33.66	33.8	33.66	33.7659	15746.0
2012-09-11	ARB	ETF	38.18	38.63	37.96	38.06	103143.0
2012-09-11	ARGT	ETF	17.2	17.2	17.2	17.2	4000.0
2012-09-11	ASEA	ETF	16.39	16.51	16.39	16.44	3300.0
2012-09-11	AWAY	ETF	22.88	23.295	22.88	22.99	223352.0
2012-09-11	BAB	ETF	30.09	30.12	29.94	30.05	297800.0
2012-09-11	BAL	ETF	49.89	49.89	49.42	49.59	5526.0
2012-09-11	BALT	ETF	3.41	3.47	3.29	3.29	81166.0
2012-09-11	BBH	ETF	52.57	52.57	52.4	52.42	14200.0
2012-09-11	BIB	ETF	15.2338	15.2338	15.015	15.138	30120.0
2012-09-11	BICK	ETF	22.99	23.069	22.926	23.059	15201.0
2012-09-11	BIL	ETF	91.64	91.64	91.62	91.62	49900.0
2012-09-11	BIS	ETF	2652.8	2694.4	2652.8	2694.4	3.43
2012-09-11	BIV	ETF	89.65	89.68	89.51	89.57	162500.0
2012-09-11	BJK	ETF	33.24	33.32	33.24	33.3	3100.0
2012-09-11	BKF	ETF	36.77	37.07	36.77	37.01	84074.0
2012-09-11	BKLN	ETF	24.94	24.95	24.93	24.94	913600.0
2012-09-11	BLV	ETF	95.87	95.9	95.45	95.55	69800.0
2012-09-11	BMVP	ETF	16.11	16.1875	16.11	16.1472	2390.0
2012-09-11	BND	ETF	84.76	84.76	84.65	84.65	912300.0
2012-09-11	BNO	ETF	41.3	41.43	41.25	41.43	20400.0
2012-09-11	BOIL	ETF	872000.0	905000.0	856200.0	901800.0	36.6
2012-09-11	BOND	ETF	107.73	107.74	107.66	107.69	401899.0

> showing 50 of 943 rows — these rows as CSV

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