PREVIEW / etf_daily / 2017-04-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-24.parquet
  size:    55 KB
  rows:    1,396

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
2017-04-24	SPY	ETF	237.18	237.41	234.56	237.17	119209900.0
2017-04-24	QQQ	ETF	134.02	134.285	133.8042	134.16	22469948.0
2017-04-24	IWM	ETF	139.08	139.34	138.49	138.92	33836900.0
2017-04-24	DIA	ETF	207.33	207.63	207.03	207.38	3220200.0
2017-04-24	GLD	ETF	120.77	121.51	120.66	121.48	11053600.0
2017-04-24	TLT	ETF	122.55	123.16	122.46	122.93	8066400.0
2017-04-24	AADR	ETF	47.62	47.85	46.6	47.31	17900.0
2017-04-24	AAXJ	ETF	63.43	63.52	63.34	63.41	1335600.0
2017-04-24	ACSI	ETF	28.2514	28.33	28.2514	28.33	1781.0
2017-04-24	ACTX	ETF	94.4008	97.3509	87.1438	88.5008	681.0
2017-04-24	ACWF	ETF	26.13	26.1607	26.1299	26.1525	4352.0
2017-04-24	ACWI	ETF	63.94	64.07	63.9	63.98	1944400.0
2017-04-24	ACWV	ETF	78.16	78.23	77.96	78.18	183700.0
2017-04-24	ACWX	ETF	44.4	44.46	44.34	44.44	838549.0
2017-04-24	ADRE	ETF	36.5	36.9254	36.5	36.9	6108.0
2017-04-24	AFK	ETF	21.54	21.54	21.1101	21.22	14836.0
2017-04-24	AFTY	ETF	13.62	13.62	13.62	13.62	100.0
2017-04-24	AGG	ETF	109.05	109.22	109.0	109.18	2745400.0
2017-04-24	AGGY	ETF	50.138	50.19	50.1	50.152	13700.0
2017-04-24	AGQ	ETF	39.2	39.86	38.93	39.81	149400.0
2017-04-24	AGZ	ETF	113.31	113.5165	113.2598	113.48	27597.0
2017-04-24	AGZD	ETF	23.975	23.98	23.93	23.965	9400.0
2017-04-24	AIA	ETF	52.62	52.67	52.5	52.58	32100.0
2017-04-24	AIQ	ETF	13.1	13.3	13.0	13.2	57169.0
2017-04-24	AIRR	ETF	23.94	24.409	23.93	24.31	40400.0
2017-04-24	AIVI	ETF	39.78	39.96	39.78	39.91	11500.0
2017-04-24	ALTY	ETF	15.95	15.95	15.58	15.58	11800.0
2017-04-24	AMJ	ETF	31.9	32.0777	31.77	31.98	1147981.0
2017-04-24	AMLP	ETF	63.15	63.25	62.8	63.15	996420.0
2017-04-24	AMZA	ETF	105.2	105.62	104.61	105.5	45560.0
2017-04-24	ANGL	ETF	29.65	29.68	29.57	29.65	361300.0
2017-04-24	AOA	ETF	50.33	50.41	50.27	50.35	38700.0
2017-04-24	AOK	ETF	33.7	33.7	33.49	33.55	44495.0
2017-04-24	AOM	ETF	36.5	36.64	36.5	36.64	62712.0
2017-04-24	AOR	ETF	42.65	42.7	42.58	42.7	83235.0
2017-04-24	ARCM	ETF	100.0	100.0	100.0	100.0	3440.0
2017-04-24	ARGT	ETF	29.0	29.0	28.88	28.94	134800.0
2017-04-24	ARKG	ETF	20.1	20.226	20.08	20.226	1600.0
2017-04-24	ARKK	ETF	25.0	25.0	24.53	24.68	10000.0
2017-04-24	ARKQ	ETF	25.81	25.81	25.57	25.64	20500.0
2017-04-24	ARKW	ETF	30.03	30.11	29.83	29.93	8300.0
2017-04-24	ASEA	ETF	14.32	14.42	14.31	14.42	900.0
2017-04-24	ASET	ETF	26.92	26.92	26.9	26.9032	540.0
2017-04-24	ASHR	ETF	24.96	24.96	24.73	24.78	1749900.0
2017-04-24	ASHS	ETF	32.87	32.87	32.12	32.12	14500.0
2017-04-24	ATMP	ETF	23.53	23.57	23.5	23.5	6500.0
2017-04-24	BAB	ETF	29.51	29.54	29.44	29.53	106928.0
2017-04-24	BAL	ETF	50.45	50.5005	49.62	49.62	2288.0
2017-04-24	BBC	ETF	22.14	22.14	21.7001	22.0681	4737.0
2017-04-24	BBH	ETF	118.89	119.63	118.89	119.37	42800.0

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

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