PREVIEW / etf_daily / 2018-04-16

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-16.parquet
  size:    60 KB
  rows:    1,542

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
2018-04-16	SPY	ETF	267.0	268.2	266.07	267.33	63405300.0
2018-04-16	QQQ	ETF	162.45	163.19	161.48	162.6	28180780.0
2018-04-16	IWM	ETF	154.84	155.82	154.11	155.37	18846900.0
2018-04-16	DIA	ETF	245.12	246.67	244.72	245.62	4018400.0
2018-04-16	GLD	ETF	127.74	128.05	127.57	127.63	4600000.0
2018-04-16	TLT	ETF	120.23	120.97	120.18	120.94	4491300.0
2018-04-16	AADR	ETF	59.56	59.56	58.78	58.88	19800.0
2018-04-16	AAXJ	ETF	76.76	77.06	76.56	77.01	257000.0
2018-04-16	ACSI	ETF	30.87	31.0798	30.87	31.0798	493.0
2018-04-16	ACTX	ETF	59.0005	73.7507	54.8705	67.2606	2139.0
2018-04-16	ACWF	ETF	31.0371	31.139	31.0348	31.13	3812.0
2018-04-16	ACWI	ETF	72.46	72.7	72.32	72.57	1998600.0
2018-04-16	ACWV	ETF	84.14	84.57	84.09	84.4	87400.0
2018-04-16	ACWX	ETF	50.28	50.28	50.06	50.21	1231415.0
2018-04-16	ADRE	ETF	43.73	43.73	43.46	43.719	4384.0
2018-04-16	AFK	ETF	25.4	25.6	25.33	25.54	4474.0
2018-04-16	AFTY	ETF	17.11	17.12	17.0	17.12	1900.0
2018-04-16	AGG	ETF	106.64	106.84	106.61	106.82	3860800.0
2018-04-16	AGGY	ETF	49.13	49.24	49.13	49.235	29000.0
2018-04-16	AGQ	ETF	32.5	32.68	32.21	32.26	119500.0
2018-04-16	AGZ	ETF	111.29	111.42	111.28	111.3748	8257.0
2018-04-16	AGZD	ETF	24.095	24.095	24.005	24.01	7600.0
2018-04-16	AIA	ETF	67.44	67.69	67.21	67.69	105199.0
2018-04-16	AIEQ	ETF	26.17	26.405	26.15	26.3	61500.0
2018-04-16	AIRR	ETF	25.79	26.157	25.79	26.104	34500.0
2018-04-16	AIVI	ETF	44.24	44.24	44.13	44.17	5400.0
2018-04-16	ALTY	ETF	14.68	14.68	14.53	14.53	2100.0
2018-04-16	AMJ	ETF	24.92	25.88	24.8	25.81	2036413.0
2018-04-16	AMLP	ETF	48.5	50.6	48.3	50.5	4866860.0
2018-04-16	AMZA	ETF	70.7	74.27	70.5	74.2	125120.0
2018-04-16	ANGL	ETF	29.39	29.5	29.31	29.34	341500.0
2018-04-16	AOA	ETF	53.88	53.97	53.75	53.9	41900.0
2018-04-16	AOK	ETF	34.21	34.27	34.11	34.27	51521.0
2018-04-16	AOM	ETF	37.71	37.7799	37.6	37.69	456269.0
2018-04-16	AOR	ETF	44.68	44.7697	44.55	44.73	56457.0
2018-04-16	ARGT	ETF	35.68	35.68	35.12	35.17	28700.0
2018-04-16	ARKG	ETF	26.75	26.767	26.28	26.37	29500.0
2018-04-16	ARKK	ETF	40.54	40.55	40.023	40.22	188200.0
2018-04-16	ARKQ	ETF	34.1	34.1	33.43	33.69	8100.0
2018-04-16	ARKW	ETF	50.37	50.37	49.61	50.04	134100.0
2018-04-16	ASEA	ETF	17.97	17.97	17.82	17.95	5100.0
2018-04-16	ASET	ETF	27.84	27.8599	27.835	27.835	1800.0
2018-04-16	ASHR	ETF	30.3	30.4	30.21	30.32	679200.0
2018-04-16	ASHS	ETF	34.72	34.85	34.71	34.84	2400.0
2018-04-16	ASHX	ETF	20.7699	20.77	20.76	20.76	421.0
2018-04-16	ATMP	ETF	18.77	19.62	18.77	19.54	42300.0
2018-04-16	BAB	ETF	29.95	30.01	29.931	29.99	87917.0
2018-04-16	BAL	ETF	50.54	50.55	50.39	50.4	1360.0
2018-04-16	BAR	ETF	13.455	13.4553	13.455	13.4553	4060.0
2018-04-16	BBC	ETF	32.44	32.44	31.7001	31.97	9611.0

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

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