PREVIEW / etf_daily / 2017-05-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-16.parquet
  size:    55 KB
  rows:    1,401

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-05-16	SPY	ETF	240.64	240.67	239.63	240.08	51241800.0
2017-05-16	QQQ	ETF	139.36	139.64	138.99	139.62	21785994.0
2017-05-16	IWM	ETF	138.97	139.04	137.62	138.63	18520900.0
2017-05-16	DIA	ETF	210.32	210.46	209.46	209.95	1746600.0
2017-05-16	GLD	ETF	117.45	117.91	117.4	117.65	4942800.0
2017-05-16	TLT	ETF	121.11	121.89	121.11	121.51	6722700.0
2017-05-16	AADR	ETF	49.61	49.83	49.42	49.8	68300.0
2017-05-16	AAXJ	ETF	66.33	66.41	66.2	66.37	848500.0
2017-05-16	ACSI	ETF	28.3999	28.408	28.34	28.37	1294.0
2017-05-16	ACTX	ETF	71.6856	74.3407	70.8006	73.7507	405.0
2017-05-16	ACWF	ETF	26.83	26.83	26.781	26.781	1218.0
2017-05-16	ACWI	ETF	65.58	65.61	65.41	65.49	676400.0
2017-05-16	ACWV	ETF	78.88	78.89	78.61	78.61	346600.0
2017-05-16	ACWX	ETF	46.01	46.0499	45.96	46.02	349557.0
2017-05-16	ADRE	ETF	38.9	39.09	38.9	39.034	9352.0
2017-05-16	AFK	ETF	21.49	21.54	21.43	21.43	10891.0
2017-05-16	AFTY	ETF	13.95	14.0	13.95	13.96	1500.0
2017-05-16	AGG	ETF	108.88	109.1	108.88	109.02	2051800.0
2017-05-16	AGGY	ETF	50.28	50.39	50.225	50.32	56500.0
2017-05-16	AGQ	ETF	34.5	35.14	34.4	34.94	340700.0
2017-05-16	AGZ	ETF	113.31	113.43	113.2201	113.36	19209.0
2017-05-16	AGZD	ETF	24.07	24.07	24.02	24.045	2400.0
2017-05-16	AIA	ETF	55.95	55.96	55.74	55.96	24969.0
2017-05-16	AIQ	ETF	13.0	13.15	13.0	13.1	21908.0
2017-05-16	AIRR	ETF	23.88	23.88	23.521	23.74	50100.0
2017-05-16	AIVI	ETF	41.47	41.57	41.47	41.56	17200.0
2017-05-16	ALTY	ETF	15.42	15.42	15.42	15.42	200.0
2017-05-16	AMJ	ETF	31.7	31.75	31.45	31.45	813066.0
2017-05-16	AMLP	ETF	61.75	61.8	61.35	61.35	960180.0
2017-05-16	AMZA	ETF	105.6	105.6	104.4	104.6	92700.0
2017-05-16	ANGL	ETF	29.71	29.72	29.65	29.71	793200.0
2017-05-16	AOA	ETF	51.37	51.37	51.27	51.35	204500.0
2017-05-16	AOK	ETF	33.75	33.8	33.74	33.79	57214.0
2017-05-16	AOM	ETF	36.98	37.009	36.9228	37.0	352984.0
2017-05-16	AOR	ETF	43.3	43.32	43.24	43.32	83762.0
2017-05-16	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-05-16	ARGT	ETF	30.95	31.96	30.86	31.13	255600.0
2017-05-16	ARKG	ETF	20.699	20.75	20.57	20.74	7700.0
2017-05-16	ARKK	ETF	26.99	27.075	26.76	27.075	27200.0
2017-05-16	ARKQ	ETF	28.39	28.73	28.12	28.72	59300.0
2017-05-16	ARKW	ETF	32.57	32.57	32.32	32.47	19600.0
2017-05-16	ASEA	ETF	14.89	14.95	14.89	14.92	3200.0
2017-05-16	ASET	ETF	27.0498	27.0498	27.0398	27.0398	536.0
2017-05-16	ASHR	ETF	24.8	24.89	24.77	24.84	1203200.0
2017-05-16	ASHS	ETF	31.5	31.67	31.5	31.65	6300.0
2017-05-16	ASHX	ETF	19.235	19.235	19.235	19.235	313.0
2017-05-16	ATMP	ETF	23.21	23.33	23.1	23.1	47500.0
2017-05-16	BAB	ETF	29.43	29.62	29.43	29.56	112616.0
2017-05-16	BAL	ETF	53.75	53.75	51.85	51.92	19786.0
2017-05-16	BBC	ETF	22.5	22.5	22.1408	22.4	3356.0

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

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