PREVIEW / etf_daily / 2013-11-06

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-06.parquet
  size:    43 KB
  rows:    1,049

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-11-06	SPY	ETF	177.03	177.5	176.54	177.17	87348000.0
2013-11-06	QQQ	ETF	83.35	83.4	82.73	83.0	25576806.0
2013-11-06	IWM	ETF	110.35	110.37	108.91	109.12	31773400.0
2013-11-06	DIA	ETF	156.49	157.29	156.37	157.22	7548400.0
2013-11-06	GLD	ETF	127.11	127.36	126.92	127.2	3544900.0
2013-11-06	TLT	ETF	104.94	105.14	104.69	105.07	5643000.0
2013-11-06	AADR	ETF	36.4	36.66	36.28	36.66	7900.0
2013-11-06	AAXJ	ETF	60.13	60.15	59.86	59.9	196900.0
2013-11-06	ACTV	ETF	14.47	14.48	14.46	14.47	2140028.0
2013-11-06	ACWI	ETF	56.2	56.4	56.15	56.25	572000.0
2013-11-06	ACWV	ETF	64.46	64.47	64.17	64.46	26500.0
2013-11-06	ACWX	ETF	46.29	46.39	46.23	46.3	115737.0
2013-11-06	ADRE	ETF	38.03	38.1001	37.97	38.04	9639.0
2013-11-06	AFK	ETF	31.619	31.619	31.46	31.5	4134.0
2013-11-06	AGG	ETF	107.39	107.46	107.35	107.41	557300.0
2013-11-06	AGQ	ETF	80.56	81.04	79.76	80.12	184400.0
2013-11-06	AGZ	ETF	111.71	113.562	111.29	111.74	13480.0
2013-11-06	AIA	ETF	47.79	47.958	47.7714	47.85	29055.0
2013-11-06	AIQ	ETF	25.56	25.56	23.8	24.06	18628.0
2013-11-06	AIVI	ETF	47.34	47.58	47.34	47.48	16200.0
2013-11-06	ALTL	ETF	31.63	31.63	31.62	31.62	800.0
2013-11-06	AMJ	ETF	45.91	46.12	45.852	46.086	493610.0
2013-11-06	AMLP	ETF	89.5	89.75	89.05	89.55	620180.0
2013-11-06	ANGL	ETF	27.04	27.04	27.04	27.04	200.0
2013-11-06	AOA	ETF	43.5	43.55	43.36	43.43	12900.0
2013-11-06	AOK	ETF	31.76	31.82	31.76	31.8	24843.0
2013-11-06	AOM	ETF	33.951	34.01	33.9301	33.98	29055.0
2013-11-06	AOR	ETF	37.9	37.9	37.79	37.84	11388.0
2013-11-06	ARGT	ETF	20.43	20.5	20.21	20.27	6700.0
2013-11-06	ASEA	ETF	17.0	17.0	16.96	16.99	1500.0
2013-11-06	ASHR	ETF	24.77	24.81	24.74	24.8	58501.0
2013-11-06	ATMP	ETF	26.83	26.88	26.83	26.88	5300.0
2013-11-06	AVIV	ETF	25.18	25.52	25.012	25.12	187652.0
2013-11-06	AWAY	ETF	29.74	29.76	28.12	29.09	1950255.0
2013-11-06	BAB	ETF	27.66	27.7	27.61	27.68	157504.0
2013-11-06	BAL	ETF	49.25	50.53	48.97	49.11	20650.0
2013-11-06	BALT	ETF	5.26	5.28	4.81	4.95	1144788.0
2013-11-06	BBH	ETF	82.66	82.66	79.58	79.61	122100.0
2013-11-06	BFOR	ETF	7.13	7.15	7.06	7.085	351600.0
2013-11-06	BIB	ETF	32.0375	32.0375	29.7505	29.8025	265620.0
2013-11-06	BICK	ETF	24.5	24.5299	24.5	24.5299	312.0
2013-11-06	BIL	ETF	91.58	91.58	91.56	91.58	502800.0
2013-11-06	BIS	ETF	1014.0	1078.76	1008.8	1078.76	728.5
2013-11-06	BIV	ETF	83.84	83.92	83.77	83.86	182700.0
2013-11-06	BIZD	ETF	20.58	20.66	20.57	20.62	9900.0
2013-11-06	BJK	ETF	50.15	50.22	49.93	50.05	8500.0
2013-11-06	BKF	ETF	38.14	38.315	38.09	38.14	79370.0
2013-11-06	BKLN	ETF	24.87	24.88	24.83	24.87	3360300.0
2013-11-06	BLV	ETF	82.87	82.9	82.68	82.8	82800.0
2013-11-06	BMVP	ETF	21.7	21.7433	21.4915	21.55	3315.0

> showing 50 of 1,049 rows — these rows as CSV

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