PREVIEW / etf_daily / 2017-05-18

all etf daily files

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

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-18	SPY	ETF	235.73	237.75	235.43	236.77	107047700.0
2017-05-18	QQQ	ETF	136.06	137.72	135.87	137.26	41319882.0
2017-05-18	IWM	ETF	134.57	135.9	134.23	135.38	44805100.0
2017-05-18	DIA	ETF	206.03	207.96	205.86	206.96	6653800.0
2017-05-18	GLD	ETF	119.77	119.84	118.56	118.81	10341100.0
2017-05-18	TLT	ETF	123.75	123.94	123.19	123.42	8350500.0
2017-05-18	AADR	ETF	47.8	49.2	45.99	46.33	46800.0
2017-05-18	AAXJ	ETF	64.94	65.74	64.8	65.5	946600.0
2017-05-18	ACSI	ETF	27.92	28.01	27.92	28.01	10924.0
2017-05-18	ACTX	ETF	71.6856	71.6856	59.0005	64.3106	675.0
2017-05-18	ACWF	ETF	26.395	26.395	26.37	26.37	705.0
2017-05-18	ACWI	ETF	64.41	64.79	64.17	64.58	1974600.0
2017-05-18	ACWV	ETF	78.4	78.8	78.3	78.67	247900.0
2017-05-18	ACWX	ETF	45.17	45.42	45.06	45.34	996830.0
2017-05-18	ADRE	ETF	37.0	37.4818	36.6	37.25	28955.0
2017-05-18	AFK	ETF	21.6	21.6	21.18	21.4	3093.0
2017-05-18	AFTY	ETF	13.825	13.825	13.825	13.825	200.0
2017-05-18	AGG	ETF	109.54	109.63	109.44	109.52	2107000.0
2017-05-18	AGGY	ETF	50.59	50.59	50.5	50.56	8600.0
2017-05-18	AGQ	ETF	34.65	34.73	33.35	34.05	215900.0
2017-05-18	AGZ	ETF	113.62	113.985	113.58	113.58	7865.0
2017-05-18	AGZD	ETF	24.04	24.04	24.035	24.035	2000.0
2017-05-18	AIA	ETF	55.02	55.5325	55.0	55.43	26980.0
2017-05-18	AIQ	ETF	13.2	13.2	13.15	13.2	8346.0
2017-05-18	AIRR	ETF	23.0	23.08	22.834	23.01	32000.0
2017-05-18	AIVI	ETF	40.99	41.24	40.99	41.23	9600.0
2017-05-18	ALTY	ETF	15.23	15.36	15.2	15.36	4600.0
2017-05-18	AMJ	ETF	30.78	30.98	30.52	30.88	1271018.0
2017-05-18	AMLP	ETF	60.45	60.7	60.1	60.6	1699700.0
2017-05-18	AMZA	ETF	102.7	103.2	102.0	103.1	52080.0
2017-05-18	ANGL	ETF	29.54	29.62	29.48	29.58	978800.0
2017-05-18	AOA	ETF	50.62	50.89	50.5	50.72	69400.0
2017-05-18	AOK	ETF	33.7	33.75	33.6301	33.71	71635.0
2017-05-18	AOM	ETF	36.78	36.9	36.7655	36.79	83114.0
2017-05-18	AOR	ETF	42.8	43.04	42.8	42.95	78727.0
2017-05-18	ARCM	ETF	100.05	100.05	100.05	100.05	200.0
2017-05-18	ARGT	ETF	29.52	29.64	28.87	29.51	258900.0
2017-05-18	ARKG	ETF	20.23	20.728	20.23	20.728	4200.0
2017-05-18	ARKK	ETF	26.21	26.92	26.21	26.88	37900.0
2017-05-18	ARKQ	ETF	27.57	28.02	27.252	27.97	40000.0
2017-05-18	ARKW	ETF	31.96	32.4	31.758	32.4	23900.0
2017-05-18	ASEA	ETF	14.73	14.83	14.55	14.78	4300.0
2017-05-18	ASHR	ETF	24.54	24.59	24.49	24.53	719700.0
2017-05-18	ASHS	ETF	31.33	31.37	31.28	31.37	3100.0
2017-05-18	ATMP	ETF	22.58	22.76	22.54	22.7	103700.0
2017-05-18	BAB	ETF	29.83	29.86	29.78	29.82	61814.0
2017-05-18	BAL	ETF	50.95	51.0	50.4	50.45	4970.0
2017-05-18	BBC	ETF	21.5101	22.1472	21.5101	22.1472	947.0
2017-05-18	BBH	ETF	117.28	118.77	117.28	118.36	26900.0
2017-05-18	BBP	ETF	36.84	37.053	36.564	37.053	6300.0

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

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