PREVIEW / etf_daily / 2018-11-08

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-08.parquet
  size:    64 KB
  rows:    1,667

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-11-08	SPY	ETF	280.11	281.22	279.22	280.5	65584900.0
2018-11-08	QQQ	ETF	174.76	175.302	173.63	174.46	40296538.0
2018-11-08	IWM	ETF	156.61	157.9	156.34	156.99	14987700.0
2018-11-08	DIA	ETF	261.53	262.97	260.97	262.1	4023400.0
2018-11-08	GLD	ETF	115.77	116.15	115.5	115.78	7638800.0
2018-11-08	TLT	ETF	112.96	112.97	112.41	112.51	6905100.0
2018-11-08	AAAU	ETF	12.24	12.25	12.22	12.22	3600.0
2018-11-08	AADR	ETF	47.97	47.97	47.16	47.26	22200.0
2018-11-08	AAXJ	ETF	65.9	66.14	65.12	65.35	829700.0
2018-11-08	ACES	ETF	24.96	24.96	24.9	24.9	9300.0
2018-11-08	ACSI	ETF	33.5	33.5519	33.4887	33.4887	3815.0
2018-11-08	ACTX	ETF	90.2708	91.4508	81.4207	85.5508	1125.0
2018-11-08	ACWF	ETF	29.2943	29.3864	29.1201	29.265	12762.0
2018-11-08	ACWI	ETF	71.05	71.18	70.58	70.78	1668200.0
2018-11-08	ACWV	ETF	86.0	86.18	85.69	85.92	130800.0
2018-11-08	ACWX	ETF	45.33	45.42	44.86	44.96	1461903.0
2018-11-08	ADRE	ETF	38.7	38.8082	38.05	38.2	4513.0
2018-11-08	AFIF	ETF	10.05	10.08	10.02	10.04	33241.0
2018-11-08	AFK	ETF	21.21	21.35	20.785	20.99	15995.0
2018-11-08	AFTY	ETF	14.49	14.6	14.4	14.43	4600.0
2018-11-08	AGG	ETF	104.19	104.22	104.0	104.01	3489200.0
2018-11-08	AGGY	ETF	47.53	47.53	47.401	47.41	14500.0
2018-11-08	AGNG	ETF	20.691	20.691	20.691	20.691	2200.0
2018-11-08	AGQ	ETF	23.24	23.44	23.1	23.24	77000.0
2018-11-08	AGZ	ETF	110.07	110.07	109.9788	109.99	29674.0
2018-11-08	AGZD	ETF	23.865	23.91	23.825	23.91	3000.0
2018-11-08	AIA	ETF	57.68	57.79	57.05	57.15	88556.0
2018-11-08	AIEQ	ETF	27.56	27.56	27.279	27.34	31500.0
2018-11-08	AIQ	ETF	14.51	14.51	14.3	14.318	8777.0
2018-11-08	AIRR	ETF	26.04	26.25	25.99	26.07	29200.0
2018-11-08	AIVI	ETF	40.72	40.76	40.38	40.42	6400.0
2018-11-08	ALTY	ETF	14.72	14.72	14.7	14.7	1200.0
2018-11-08	AMJ	ETF	26.17	26.7	26.11	26.21	1453277.0
2018-11-08	AMLP	ETF	50.05	51.05	49.7	50.1	3531440.0
2018-11-08	AMZA	ETF	66.4	67.6	65.8	65.8	112160.0
2018-11-08	ANGL	ETF	28.19	28.3	28.19	28.21	510300.0
2018-11-08	AOA	ETF	52.5	52.61	52.21	52.35	56000.0
2018-11-08	AOK	ETF	33.45	33.51	33.3701	33.38	48401.0
2018-11-08	AOM	ETF	36.88	36.93	36.7428	36.77	106079.0
2018-11-08	AOR	ETF	43.65	43.6799	43.43	43.51	117253.0
2018-11-08	ARGT	ETF	26.46	26.52	26.02	26.14	46900.0
2018-11-08	ARKG	ETF	31.0	31.15	30.36	30.52	361100.0
2018-11-08	ARKK	ETF	45.89	46.22	44.93	45.24	322200.0
2018-11-08	ARKQ	ETF	34.47	34.85	34.47	34.72	116700.0
2018-11-08	ARKW	ETF	55.93	56.069	54.6	54.86	136400.0
2018-11-08	ARVR	ETF	19.25	19.25	19.25	19.25	103.0
2018-11-08	ASEA	ETF	15.79	15.79	15.79	15.79	500.0
2018-11-08	ASET	ETF	27.2042	27.21	27.0939	27.1281	1908.0
2018-11-08	ASHR	ETF	23.61	23.63	23.3	23.35	2360100.0
2018-11-08	ASHS	ETF	23.39	23.39	23.05	23.05	9000.0

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

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