PREVIEW / etf_daily / 2013-08-30

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-30.parquet
  size:    41 KB
  rows:    1,009

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-08-30	SPY	ETF	164.51	164.53	163.17	163.65	134928900.0
2013-08-30	QQQ	ETF	76.04	76.04	75.2	75.47	26228459.0
2013-08-30	IWM	ETF	101.99	102.05	100.24	100.38	43334600.0
2013-08-30	DIA	ETF	148.42	148.42	147.43	147.85	6326800.0
2013-08-30	GLD	ETF	134.65	135.71	134.44	134.62	7680000.0
2013-08-30	TLT	ETF	106.02	106.68	105.74	105.99	8987600.0
2013-08-30	AADR	ETF	33.24	33.24	33.05	33.12	8300.0
2013-08-30	AAXJ	ETF	54.92	54.92	54.4	54.65	521600.0
2013-08-30	ACTV	ETF	10.03	10.03	9.65	9.8	479404.0
2013-08-30	ACWI	ETF	51.4	51.41	51.01	51.09	661600.0
2013-08-30	ACWV	ETF	60.09	60.09	59.69	59.84	13600.0
2013-08-30	ACWX	ETF	42.2	42.2	41.81	41.88	430205.0
2013-08-30	ADRE	ETF	34.88	34.88	34.57	34.64	23921.0
2013-08-30	AFK	ETF	28.6	28.87	28.52	28.61	45693.0
2013-08-30	AGEM	ETF	20.65	20.7495	20.56	20.716	715.0
2013-08-30	AGG	ETF	106.4	106.52	106.21	106.21	1670400.0
2013-08-30	AGQ	ETF	95.64	97.6	94.76	95.4	505275.0
2013-08-30	AGZ	ETF	110.82	110.82	110.55	110.676	67606.0
2013-08-30	AIA	ETF	44.31	44.36	44.11	44.26	25292.0
2013-08-30	AIQ	ETF	24.6	25.0	23.591	24.3	54180.0
2013-08-30	AIVI	ETF	42.34	42.35	42.08	42.14	17700.0
2013-08-30	AMJ	ETF	45.33	45.5395	44.6	44.74	331401.0
2013-08-30	AMLP	ETF	87.4	87.65	86.4	86.6	903760.0
2013-08-30	ANGL	ETF	26.39	26.41	26.39	26.41	800.0
2013-08-30	AOA	ETF	40.91	40.91	40.25	40.25	7100.0
2013-08-30	AOK	ETF	30.9	30.9	30.74	30.75	17524.0
2013-08-30	AOM	ETF	32.65	32.65	32.4601	32.48	11715.0
2013-08-30	AOR	ETF	36.03	36.03	35.65	35.65	34115.0
2013-08-30	ARB	ETF	46.87	47.15	46.7101	47.06	384661.0
2013-08-30	ARGT	ETF	18.44	18.46	18.24	18.24	3800.0
2013-08-30	ASEA	ETF	15.28	15.29	15.14	15.18	51900.0
2013-08-30	ATMP	ETF	25.95	25.95	25.7	25.79	39200.0
2013-08-30	AVIV	ETF	23.13	23.24	22.64	22.72	85631.0
2013-08-30	AWAY	ETF	31.26	31.85	31.18	31.54	761972.0
2013-08-30	BAB	ETF	27.2	27.339	27.19	27.26	96673.0
2013-08-30	BAL	ETF	53.19	53.97	52.79	53.56	17302.0
2013-08-30	BALT	ETF	4.55	4.59	4.4	4.44	151939.0
2013-08-30	BBH	ETF	78.34	78.38	77.35	77.54	22300.0
2013-08-30	BCM	ETF	41.6	41.6	41.6	41.6	400.0
2013-08-30	BFOR	ETF	6.5175	6.525	6.4525	6.465	62800.0
2013-08-30	BIB	ETF	28.7925	28.7925	27.8287	28.0825	51764.0
2013-08-30	BICK	ETF	21.39	21.39	21.322	21.322	1000.0
2013-08-30	BIL	ETF	91.58	91.6	91.58	91.6	500900.0
2013-08-30	BIS	ETF	1187.604	1208.8	1187.604	1196.404	187.0
2013-08-30	BIV	ETF	82.5	82.64	82.43	82.52	312800.0
2013-08-30	BIZD	ETF	20.02	20.02	19.79	19.79	9900.0
2013-08-30	BJK	ETF	43.23	43.23	42.97	42.98	4800.0
2013-08-30	BKF	ETF	34.23	34.23	33.88	34.17	35325.0
2013-08-30	BKLN	ETF	24.74	24.74	24.7	24.72	2173100.0
2013-08-30	BLNG	ETF	40.44	40.44	40.44	40.44	100.0

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

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