PREVIEW / etf_daily / 2013-02-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-28.parquet
  size:    40 KB
  rows:    985

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
2013-02-28	SPY	ETF	151.9	152.87	151.41	151.61	126866000.0
2013-02-28	QQQ	ETF	67.24	67.74	67.09	67.1	28557148.0
2013-02-28	IWM	ETF	90.3	91.05	90.18	90.48	31208800.0
2013-02-28	DIA	ETF	140.45	141.31	140.18	140.28	11383200.0
2013-02-28	GLD	ETF	154.09	154.16	152.39	153.0	14864400.0
2013-02-28	TLT	ETF	118.43	118.66	117.98	118.51	6023400.0
2013-02-28	AADR	ETF	32.74	32.74	32.74	32.74	200.0
2013-02-28	AAXJ	ETF	60.36	60.49	60.1	60.12	405800.0
2013-02-28	ACTV	ETF	4.81	5.0	4.66	4.69	469111.0
2013-02-28	ACWI	ETF	49.88	50.17	49.81	49.84	357600.0
2013-02-28	ACWV	ETF	59.45	59.59	59.29	59.29	60600.0
2013-02-28	ACWX	ETF	42.6	42.82	42.54	42.55	178929.0
2013-02-28	ADRE	ETF	39.301	39.47	39.2	39.2	23413.0
2013-02-28	AFK	ETF	30.57	30.63	30.45	30.45	38081.0
2013-02-28	AGEM	ETF	22.91	22.91	22.89	22.89	1895.0
2013-02-28	AGG	ETF	110.69	110.83	110.69	110.83	1211900.0
2013-02-28	AGQ	ETF	158.0	158.28	152.28	153.16	352950.0
2013-02-28	AGZ	ETF	113.355	113.409	113.17	113.327	23802.0
2013-02-28	AIA	ETF	47.55	47.635	47.41	47.43	13667.0
2013-02-28	AIQ	ETF	6.69	7.08	6.69	7.04	10105.0
2013-02-28	AIVI	ETF	41.86	42.2	41.86	41.88	30100.0
2013-02-28	ALTL	ETF	28.15	28.15	28.15	28.15	100.0
2013-02-28	AMJ	ETF	43.18	43.34	43.0	43.0	3004357.0
2013-02-28	AMLP	ETF	85.3	85.55	85.2	85.4	491160.0
2013-02-28	ANGL	ETF	27.16	27.16	27.02	27.02	1900.0
2013-02-28	AOA	ETF	38.83	39.03	38.81	38.81	94800.0
2013-02-28	AOK	ETF	30.92	31.0	30.92	30.95	33124.0
2013-02-28	AOM	ETF	32.28	32.4512	32.28	32.37	24656.0
2013-02-28	AOR	ETF	34.94	35.17	34.94	35.06	64675.0
2013-02-28	ARB	ETF	46.88	46.97	46.82	46.84	397779.0
2013-02-28	ARGT	ETF	17.38	17.38	16.88	16.88	2000.0
2013-02-28	ASEA	ETF	17.3	17.41	17.3	17.33	171200.0
2013-02-28	AWAY	ETF	29.41	30.31	29.16	29.5	1603280.0
2013-02-28	BAB	ETF	30.45	30.55	30.431	30.54	158743.0
2013-02-28	BAL	ETF	54.17	55.5399	54.102	55.04	62865.0
2013-02-28	BALT	ETF	3.54	3.83	3.54	3.68	154458.0
2013-02-28	BBH	ETF	58.96	59.76	58.96	59.39	78500.0
2013-02-28	BCM	ETF	43.2199	43.2199	42.9028	42.9028	17522.0
2013-02-28	BIB	ETF	16.8573	16.9215	16.675	16.7362	66736.0
2013-02-28	BICK	ETF	25.12	25.13	24.95	24.95	900.0
2013-02-28	BIL	ETF	91.62	91.62	91.6	91.62	328500.0
2013-02-28	BIS	ETF	2290.4	2290.4	2233.996	2234.0	40.0
2013-02-28	BIV	ETF	87.93	87.98	87.83	87.92	142800.0
2013-02-28	BIZD	ETF	20.32	20.38	20.28	20.36	6200.0
2013-02-28	BJK	ETF	38.4	38.53	38.33	38.34	5700.0
2013-02-28	BKF	ETF	40.02	40.154	39.86	39.88	58128.0
2013-02-28	BKLN	ETF	24.99	25.01	24.98	25.0	3563400.0
2013-02-28	BLNG	ETF	46.7785	46.7785	46.58	46.58	209.0
2013-02-28	BLV	ETF	92.44	92.57	92.21	92.46	45700.0
2013-02-28	BMVP	ETF	17.7333	17.8761	17.7333	17.75	2745.0

> showing 50 of 985 rows — these rows as CSV

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