PREVIEW / etf_daily / 2015-05-08

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-08.parquet
  size:    48 KB
  rows:    1,185

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
2015-05-08	SPY	ETF	210.88	211.86	210.78	211.62	155877300.0
2015-05-08	QQQ	ETF	108.46	108.92	108.3	108.69	33023337.0
2015-05-08	IWM	ETF	122.93	123.25	122.4	122.64	26357100.0
2015-05-08	DIA	ETF	181.14	182.02	181.08	181.85	5529600.0
2015-05-08	GLD	ETF	114.34	114.43	113.59	113.97	9964100.0
2015-05-08	TLT	ETF	123.38	123.55	122.31	122.51	11716400.0
2015-05-08	AAXJ	ETF	67.54	67.93	67.54	67.72	2263200.0
2015-05-08	ACTX	ETF	3.54	4.13	2.95	3.54	1976.0
2015-05-08	ACWF	ETF	25.23	25.23	25.23	25.23	700.0
2015-05-08	ACWI	ETF	62.3	62.59	62.21	62.47	385000.0
2015-05-08	ACWV	ETF	73.38	73.57	73.3	73.46	174300.0
2015-05-08	ACWX	ETF	47.17	47.4099	47.13	47.34	1314828.0
2015-05-08	ADRE	ETF	37.4701	37.663	37.4701	37.59	8053.0
2015-05-08	AFK	ETF	26.73	26.87	26.6301	26.8	7351.0
2015-05-08	AFTY	ETF	21.981	22.15	21.93	22.06	66600.0
2015-05-08	AGG	ETF	110.36	110.43	110.21	110.29	1933600.0
2015-05-08	AGQ	ETF	40.5	40.68	39.9	40.5	102400.0
2015-05-08	AGZ	ETF	113.43	113.5	113.2114	113.32	10717.0
2015-05-08	AGZD	ETF	24.67	24.67	24.465	24.48	5800.0
2015-05-08	AIA	ETF	53.21	53.48	53.19	53.41	42135.0
2015-05-08	AIQ	ETF	21.79	22.27	20.62	20.68	17356.0
2015-05-08	AIRR	ETF	18.25	18.25	18.14	18.2	7100.0
2015-05-08	AIVI	ETF	46.25	46.54	46.1	46.48	21800.0
2015-05-08	AMJ	ETF	44.57	44.8201	44.22	44.47	708131.0
2015-05-08	AMLP	ETF	84.95	85.35	84.55	84.95	680220.0
2015-05-08	AMZA	ETF	223.75	223.75	219.3	221.6	810.0
2015-05-08	ANGL	ETF	27.61	27.75	27.56	27.63	11700.0
2015-05-08	AOA	ETF	48.48	48.84	48.48	48.71	43400.0
2015-05-08	AOK	ETF	33.03	33.16	33.02	33.12	25439.0
2015-05-08	AOM	ETF	35.85	36.05	35.78	35.93	43747.0
2015-05-08	AOR	ETF	41.3	41.6	41.3	41.56	59016.0
2015-05-08	ARGT	ETF	21.84	21.87	21.78	21.87	2700.0
2015-05-08	ARKG	ETF	22.86	22.95	22.86	22.95	800.0
2015-05-08	ARKK	ETF	20.87	20.89	20.84	20.84	500.0
2015-05-08	ARKQ	ETF	19.65	19.65	19.65	19.65	100.0
2015-05-08	ARKW	ETF	22.585	22.59	22.585	22.59	900.0
2015-05-08	ASEA	ETF	16.04	16.11	16.04	16.1	5100.0
2015-05-08	ASHR	ETF	46.94	47.19	46.8	47.12	1571400.0
2015-05-08	ASHS	ETF	51.91	54.2	51.91	53.87	46900.0
2015-05-08	ATMP	ETF	29.95	30.3	29.95	30.15	9500.0
2015-05-08	AWAY	ETF	27.3	28.08	27.0	27.46	2708106.0
2015-05-08	BAB	ETF	29.45	29.64	29.34	29.34	70574.0
2015-05-08	BAL	ETF	44.62	44.9599	44.46	44.9599	7377.0
2015-05-08	BALT	ETF	1.41	1.44	1.38	1.42	505655.0
2015-05-08	BAR	ETF	2.646	2.665	2.62	2.62	47900.0
2015-05-08	BBC	ETF	32.56	33.1426	32.34	32.9001	14527.0
2015-05-08	BBH	ETF	129.24	131.36	129.21	130.66	77300.0
2015-05-08	BBP	ETF	31.36	31.729	31.0	31.45	23500.0
2015-05-08	BCHP	ETF	20.571	20.66	20.571	20.6529	538.0
2015-05-08	BCM	ETF	32.39	32.39	32.39	32.39	400.0

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

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