PREVIEW / etf_daily / 2011-10-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-28.parquet
  size:    37 KB
  rows:    884

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-10-28	SPY	ETF	128.0	128.85	127.8	128.6	225906500.0
2011-10-28	QQQ	ETF	58.5	59.01	58.5	58.94	42949944.0
2011-10-28	IWM	ETF	76.3	76.92	75.76	76.03	82397500.0
2011-10-28	DIA	ETF	121.58	122.24	121.36	122.04	6666900.0
2011-10-28	GLD	ETF	169.64	169.94	168.75	169.62	9362900.0
2011-10-28	TLT	ETF	110.9	111.96	110.76	111.46	10127900.0
2011-10-28	AADR	ETF	29.62	29.76	29.62	29.76	300.0
2011-10-28	AAXJ	ETF	55.09	55.99	54.99	55.64	656000.0
2011-10-28	ACTV	ETF	14.27	14.65	13.9	14.29	77331.0
2011-10-28	ACWI	ETF	45.08	45.25	44.85	45.18	1422300.0
2011-10-28	ACWV	ETF	51.81	51.96	51.81	51.96	500.0
2011-10-28	ACWX	ETF	40.52	40.83	40.46	40.81	150963.0
2011-10-28	ADRE	ETF	41.6	42.222	41.38	42.19	58574.0
2011-10-28	AFK	ETF	29.1	29.43	29.06	29.3	6976.0
2011-10-28	AGEM	ETF	23.33	23.55	23.25	23.49	3145.0
2011-10-28	AGG	ETF	109.17	109.54	109.15	109.51	979100.0
2011-10-28	AGQ	ETF	283.4	285.36	275.52	283.2	498300.0
2011-10-28	AGZ	ETF	112.16	112.16	111.79	111.91	10618.0
2011-10-28	AIA	ETF	42.365	42.8699	42.365	42.7	21815.0
2011-10-28	AIQ	ETF	6.05	6.05	5.65	5.75	56219.0
2011-10-28	AIS	ETF	2.3	2.32	2.27	2.29	683302.0
2011-10-28	AIVI	ETF	43.54	43.75	43.3	43.67	125600.0
2011-10-28	AMJ	ETF	37.39	38.0	37.24	37.66	688591.0
2011-10-28	AMLP	ETF	80.9	81.1	80.25	80.95	195940.0
2011-10-28	AOA	ETF	34.23	34.37	34.17	34.29	257800.0
2011-10-28	AOK	ETF	29.4299	29.46	29.38	29.4438	57668.0
2011-10-28	AOM	ETF	30.3299	30.39	30.3	30.39	40594.0
2011-10-28	AOR	ETF	31.84	31.91	31.73	31.89	292768.0
2011-10-28	ARB	ETF	40.02	41.13	40.02	40.81	133936.0
2011-10-28	ARGT	ETF	23.2	23.26	23.06	23.22	1700.0
2011-10-28	ASEA	ETF	15.82	15.86	15.71	15.86	8500.0
2011-10-28	AWAY	ETF	36.41	38.11	33.055	33.71	496543.0
2011-10-28	BAB	ETF	27.4	27.82	27.38	27.76	129442.0
2011-10-28	BAL	ETF	64.67	64.74	63.52	64.64	42828.0
2011-10-28	BALT	ETF	5.95	6.2	5.95	5.97	97773.0
2011-10-28	BBH	ETF	35.95	36.5233	35.9267	36.2133	23100.0
2011-10-28	BCM	ETF	45.07	45.26	45.07	45.26	336.0
2011-10-28	BIB	ETF	8.0862	8.0954	8.0312	8.0838	5912.0
2011-10-28	BICK	ETF	27.18	27.35	27.18	27.25	3238.0
2011-10-28	BIL	ETF	91.68	91.7	91.68	91.68	404400.0
2011-10-28	BIS	ETF	5913.6	5913.6	5913.6	5913.6	1.25
2011-10-28	BITS	ETF	22.16	23.92	22.16	23.764	8223.0
2011-10-28	BIV	ETF	86.79	87.0	86.58	86.94	144400.0
2011-10-28	BJK	ETF	33.42	33.96	33.42	33.54	28900.0
2011-10-28	BKF	ETF	40.91	41.48	40.74	41.45	92967.0
2011-10-28	BKLN	ETF	24.2	24.2	23.96	24.13	56800.0
2011-10-28	BLV	ETF	88.75	89.21	88.56	88.98	76600.0
2011-10-28	BMVP	ETF	14.18	14.27	14.18	14.27	6656.0
2011-10-28	BND	ETF	83.09	83.31	83.01	83.25	654900.0
2011-10-28	BNO	ETF	37.695	38.065	37.63	37.765	79800.0

> showing 50 of 884 rows — these rows as CSV

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