PREVIEW / etf_daily / 2017-02-22

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-22.parquet
  size:    54 KB
  rows:    1,371

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-02-22	SPY	ETF	236.02	236.54	235.83	236.28	62115200.0
2017-02-22	QQQ	ETF	130.32	130.59	130.111	130.5	12110876.0
2017-02-22	IWM	ETF	140.0	140.02	139.25	139.58	14890800.0
2017-02-22	DIA	ETF	206.73	207.53	206.64	207.45	2254400.0
2017-02-22	GLD	ETF	117.86	118.02	117.24	117.91	6057200.0
2017-02-22	TLT	ETF	120.8	120.82	119.59	120.31	8101500.0
2017-02-22	AADR	ETF	45.95	46.26	45.95	46.13	18400.0
2017-02-22	AAXJ	ETF	61.2	61.32	61.12	61.32	399000.0
2017-02-22	ACSI	ETF	28.03	28.07	28.01	28.07	3861.0
2017-02-22	ACTX	ETF	126.8511	129.8012	118.0011	121.8361	4262.0
2017-02-22	ACWF	ETF	25.6191	25.6191	25.6191	25.6191	1040.0
2017-02-22	ACWI	ETF	62.61	62.75	62.55	62.71	2520100.0
2017-02-22	ACWV	ETF	75.77	76.05	75.77	76.04	363900.0
2017-02-22	ACWX	ETF	42.68	42.84	42.6233	42.82	377126.0
2017-02-22	ADRE	ETF	36.6233	36.85	36.6113	36.7101	6666.0
2017-02-22	AFK	ETF	21.59	21.63	21.53	21.63	5414.0
2017-02-22	AFTY	ETF	14.12	14.18	14.11	14.18	7400.0
2017-02-22	AGG	ETF	108.54	108.55	108.2	108.42	2655500.0
2017-02-22	AGGY	ETF	49.744	49.79	49.6	49.738	55400.0
2017-02-22	AGQ	ETF	40.49	40.86	40.31	40.85	166700.0
2017-02-22	AGZ	ETF	112.96	113.05	112.81	112.9403	9292.0
2017-02-22	AGZD	ETF	24.05	24.11	23.975	24.05	3000.0
2017-02-22	AIA	ETF	51.3	51.5382	51.3	51.52	11234.0
2017-02-22	AIQ	ETF	10.35	10.5	10.25	10.4	9936.0
2017-02-22	AIRR	ETF	24.58	24.58	24.299	24.36	44400.0
2017-02-22	AIVI	ETF	38.75	39.04	38.75	39.04	42700.0
2017-02-22	ALTY	ETF	15.512	15.539	15.5	15.51	1600.0
2017-02-22	AMJ	ETF	33.98	33.98	33.53	33.55	1428397.0
2017-02-22	AMLP	ETF	65.25	65.35	64.7	64.8	1668880.0
2017-02-22	AMUB	ETF	21.35	21.35	21.35	21.35	200.0
2017-02-22	AMZA	ETF	113.8	114.0	112.5	112.55	44270.0
2017-02-22	ANGL	ETF	29.53	29.55	29.46	29.52	151900.0
2017-02-22	AOA	ETF	49.3	49.51	49.3	49.45	127200.0
2017-02-22	AOK	ETF	33.06	33.2099	33.06	33.15	49197.0
2017-02-22	AOM	ETF	36.04	36.21	36.04	36.21	75906.0
2017-02-22	AOR	ETF	42.0	42.079	41.9101	42.05	114612.0
2017-02-22	ARGT	ETF	27.03	27.11	26.88	27.01	26700.0
2017-02-22	ARKG	ETF	19.23	19.23	19.062	19.062	2000.0
2017-02-22	ARKK	ETF	23.22	23.36	23.173	23.173	2400.0
2017-02-22	ARKQ	ETF	24.8	24.8	24.55	24.59	8200.0
2017-02-22	ARKW	ETF	28.83	28.83	28.661	28.661	5500.0
2017-02-22	ASEA	ETF	13.59	13.68	13.59	13.68	400.0
2017-02-22	ASET	ETF	26.38	26.38	26.32	26.377	6081.0
2017-02-22	ASHR	ETF	25.43	25.5	25.38	25.5	417000.0
2017-02-22	ASHS	ETF	34.29	34.35	34.26	34.3	12900.0
2017-02-22	ATMP	ETF	24.78	24.78	24.31	24.35	44400.0
2017-02-22	BAB	ETF	29.4	29.47	29.23	29.34	171465.0
2017-02-22	BAL	ETF	49.37	49.37	48.8625	48.9569	4977.0
2017-02-22	BBC	ETF	21.24	21.24	20.63	20.6641	7360.0
2017-02-22	BBH	ETF	118.6	119.3	118.29	118.33	83600.0

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

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