PREVIEW / etf_daily / 2021-09-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-15.parquet
  size:    93 KB
  rows:    2,464

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
2021-09-15	SPY	ETF	444.62	448.41	443.44	447.88	78792200.0
2021-09-15	QQQ	ETF	375.73	378.41	373.37	378.05	34097865.0
2021-09-15	IWM	ETF	220.02	222.74	219.46	222.03	27572000.0
2021-09-15	DIA	ETF	346.41	349.46	345.78	348.82	3267300.0
2021-09-15	GLD	ETF	168.13	168.36	167.45	167.83	5624900.0
2021-09-15	TLT	ETF	151.21	151.25	149.93	150.58	11940300.0
2021-09-15	AAA	ETF	25.005	25.005	25.005	25.005	1.0
2021-09-15	AAAU	ETF	17.89	17.9	17.82	17.85	160700.0
2021-09-15	AADR	ETF	67.24	67.24	67.24	67.24	400.0
2021-09-15	AAXJ	ETF	87.84	88.07	87.46	88.01	900300.0
2021-09-15	ABEQ	ETF	27.38	27.38	27.34	27.34	500.0
2021-09-15	ACES	ETF	68.75	68.84	67.97	68.58	86100.0
2021-09-15	ACIO	ETF	30.63	30.89	30.63	30.819	65000.0
2021-09-15	ACSI	ETF	50.7893	50.7893	50.7893	50.7893	151.0
2021-09-15	ACTV	ETF	37.29	37.99	37.13	37.91	6561.0
2021-09-15	ACTX	ETF	1.2	1.2	1.01	1.01	5804.0
2021-09-15	ACVF	ETF	33.02	33.205	32.88	33.13	15900.0
2021-09-15	ACWF	ETF	38.74	39.0589	38.7101	39.0	10981.0
2021-09-15	ACWI	ETF	103.47	104.17	103.25	104.06	3472100.0
2021-09-15	ACWV	ETF	106.38	106.78	106.17	106.51	274300.0
2021-09-15	ACWX	ETF	57.57	57.8	57.42	57.8	3345486.0
2021-09-15	ADFI	ETF	9.77	9.78	9.77	9.78	800.0
2021-09-15	ADIV	ETF	17.785	17.785	17.785	17.785	100.0
2021-09-15	ADME	ETF	40.781	41.1	40.781	41.04	36200.0
2021-09-15	ADRE	ETF	51.19	51.36	50.73	51.185	10752.0
2021-09-15	AEMB	ETF	50.27	50.27	50.27	50.27	100.0
2021-09-15	AESR	ETF	14.07	14.16	14.0	14.16	11000.0
2021-09-15	AFIF	ETF	9.68	9.71	9.67	9.67	30222.0
2021-09-15	AFK	ETF	21.74	21.74	21.15	21.5	18055.0
2021-09-15	AFLG	ETF	26.288	26.451	26.278	26.451	400.0
2021-09-15	AFMC	ETF	25.7	25.7	25.7	25.7	100.0
2021-09-15	AFSM	ETF	26.224	26.224	26.224	26.224	600.0
2021-09-15	AFTY	ETF	20.23	20.328	20.22	20.32	1900.0
2021-09-15	AGG	ETF	116.29	116.29	116.09	116.17	3448500.0
2021-09-15	AGGY	ETF	52.81	52.845	52.73	52.76	55300.0
2021-09-15	AGNG	ETF	30.07	30.4	30.07	30.32	3900.0
2021-09-15	AGOV	ETF	100.91	100.91	100.91	100.91	61.0
2021-09-15	AGOX	ETF	26.16	26.473	26.16	26.44	22200.0
2021-09-15	AGQ	ETF	37.37	37.63	36.97	37.38	425900.0
2021-09-15	AGZ	ETF	119.29	119.29	119.16	119.2	19064.0
2021-09-15	AGZD	ETF	23.425	23.455	23.42	23.435	12400.0
2021-09-15	AIA	ETF	81.05	81.37	80.6101	81.37	72085.0
2021-09-15	AIEQ	ETF	42.572	42.96	42.405	42.885	8800.0
2021-09-15	AIQ	ETF	31.34	31.66	31.15	31.66	7548.0
2021-09-15	AIRR	ETF	40.75	41.305	40.74	41.256	21500.0
2021-09-15	AIVI	ETF	43.51	43.63	43.51	43.63	4900.0
2021-09-15	ALTL	ETF	42.99	43.25	42.6	42.96	41987.0
2021-09-15	ALTY	ETF	13.58	13.672	13.58	13.63	9600.0
2021-09-15	AMJ	ETF	17.91	18.03	17.78	17.93	752911.0
2021-09-15	AMLP	ETF	32.85	33.14	32.65	32.87	1779500.0

> showing 50 of 2,464 rows — these rows as CSV

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