PREVIEW / etf_daily / 2011-12-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-06.parquet
  size:    37 KB
  rows:    892

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-12-06	SPY	ETF	126.21	127.11	125.76	126.26	178842100.0
2011-12-06	QQQ	ETF	57.29	57.45	56.89	57.08	38669472.0
2011-12-06	IWM	ETF	74.81	75.29	74.09	74.83	43597000.0
2011-12-06	DIA	ETF	120.96	122.09	120.68	121.39	7062300.0
2011-12-06	GLD	ETF	166.31	168.57	165.53	168.18	10381900.0
2011-12-06	TLT	ETF	117.81	118.29	116.77	117.27	8506300.0
2011-12-06	AADR	ETF	28.51	28.51	28.51	28.51	100.0
2011-12-06	AAXJ	ETF	52.36	52.56	51.95	52.29	232100.0
2011-12-06	ACTV	ETF	13.33	13.4	12.93	13.29	488754.0
2011-12-06	ACWI	ETF	43.27	43.44	42.95	43.23	1197200.0
2011-12-06	ACWV	ETF	50.69	50.73	50.68	50.73	900.0
2011-12-06	ACWX	ETF	38.21	38.43	37.99	38.16	284725.0
2011-12-06	ADRE	ETF	40.39	40.601	40.15	40.4	33900.0
2011-12-06	AFK	ETF	27.24	27.47	27.24	27.43	5712.0
2011-12-06	AGEM	ETF	22.25	22.3	22.1	22.21	5528.0
2011-12-06	AGG	ETF	109.11	109.21	108.86	109.14	1105300.0
2011-12-06	AGQ	ETF	226.4	241.72	223.36	240.88	630250.0
2011-12-06	AGZ	ETF	112.25	112.6	112.25	112.52	14245.0
2011-12-06	AIA	ETF	41.1	41.3	40.92	41.22	29936.0
2011-12-06	AIQ	ETF	5.7	5.8	5.65	5.7	13081.0
2011-12-06	AIS	ETF	2.85	2.85	2.67	2.77	3112746.0
2011-12-06	AIVI	ETF	40.51	40.77	40.29	40.57	79700.0
2011-12-06	AMJ	ETF	37.6	37.6	37.27	37.55	643712.0
2011-12-06	AMLP	ETF	80.95	80.95	80.35	80.9	249500.0
2011-12-06	AOA	ETF	33.46	33.5	33.35	33.41	5500.0
2011-12-06	AOK	ETF	29.28	29.35	29.27	29.34	67965.0
2011-12-06	AOM	ETF	30.01	30.092	30.01	30.06	21356.0
2011-12-06	AOR	ETF	31.39	31.43	31.286	31.4	35014.0
2011-12-06	ARB	ETF	37.99	38.5	37.74	38.27	159302.0
2011-12-06	ARGT	ETF	23.02	23.44	23.02	23.44	350.0
2011-12-06	ASEA	ETF	14.84	14.97	14.84	14.93	3200.0
2011-12-06	AWAY	ETF	25.14	25.58	24.74	25.47	299033.0
2011-12-06	BAB	ETF	28.35	28.382	28.26	28.37	162217.0
2011-12-06	BAL	ETF	57.01	58.14	57.01	57.73	30993.0
2011-12-06	BALT	ETF	4.97	5.1899	4.9101	5.16	59763.0
2011-12-06	BBH	ETF	34.92	35.1333	34.8133	35.01	78600.0
2011-12-06	BCM	ETF	44.19	44.71	44.19	44.71	7018.0
2011-12-06	BIB	ETF	8.2438	8.2438	8.2438	8.2438	800.0
2011-12-06	BICK	ETF	24.82	25.139	24.82	25.022	14653.0
2011-12-06	BIL	ETF	91.66	91.72	91.66	91.7	211150.0
2011-12-06	BIS	ETF	5590.4	5590.4	5516.16	5516.16	1.875
2011-12-06	BITS	ETF	21.36	21.6	21.2	21.56	14784.0
2011-12-06	BIV	ETF	87.15	87.26	87.01	87.19	243700.0
2011-12-06	BJK	ETF	31.45	31.49	31.24	31.38	8100.0
2011-12-06	BKF	ETF	38.75	38.855	38.32	38.59	99668.0
2011-12-06	BKLN	ETF	23.92	23.96	23.85	23.93	42400.0
2011-12-06	BLV	ETF	90.44	90.71	89.92	90.22	95200.0
2011-12-06	BMVP	ETF	13.76	13.82	13.71	13.78	7700.0
2011-12-06	BND	ETF	83.26	83.39	83.18	83.3	858400.0
2011-12-06	BNO	ETF	38.0	38.355	37.955	38.27	15200.0

> showing 50 of 892 rows — these rows as CSV

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