PREVIEW / etf_daily / 2021-11-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-17.parquet
  size:    97 KB
  rows:    2,588

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-11-17	SPY	ETF	469.0	469.19	467.48	468.14	47858300.0
2021-11-17	QQQ	ETF	397.75	399.7196	396.64	397.63	28703263.0
2021-11-17	IWM	ETF	238.06	238.13	235.13	235.86	26527800.0
2021-11-17	DIA	ETF	361.44	361.58	359.54	359.85	2976000.0
2021-11-17	GLD	ETF	174.24	174.61	173.89	174.5	6523100.0
2021-11-17	TLT	ETF	144.57	146.29	144.46	146.26	14239900.0
2021-11-17	AAA	ETF	25.0599	25.0599	25.05	25.05	500.0
2021-11-17	AAAU	ETF	18.54	18.57	18.5	18.56	286800.0
2021-11-17	AADR	ETF	65.06	65.13	64.73	64.96	5200.0
2021-11-17	AAXJ	ETF	88.12	88.39	87.32	87.52	786200.0
2021-11-17	ABEQ	ETF	28.27	28.27	28.248	28.248	1400.0
2021-11-17	ACES	ETF	79.67	80.33	78.68	78.92	63500.0
2021-11-17	ACIO	ETF	31.95	32.03	31.95	31.975	20700.0
2021-11-17	ACSI	ETF	53.2975	53.2975	53.2975	53.2975	72.0
2021-11-17	ACT	ETF	23.06	23.1	22.35	22.95	158354.0
2021-11-17	ACTV	ETF	38.54	38.66	38.4	38.4347	5023.0
2021-11-17	ACTX	ETF	1.43	1.43	0.705	0.705	1861.0
2021-11-17	ACVF	ETF	35.37	35.37	35.18	35.184	12400.0
2021-11-17	ACWF	ETF	38.96	38.99	38.8	38.81	58403.0
2021-11-17	ACWI	ETF	107.11	107.11	106.77	106.93	3437700.0
2021-11-17	ACWV	ETF	107.15	107.37	107.09	107.31	590400.0
2021-11-17	ACWX	ETF	57.6703	57.69	57.49	57.58	1350346.0
2021-11-17	ADFI	ETF	9.63	9.63	9.63	9.63	100.0
2021-11-17	ADIV	ETF	17.99	18.0	17.93	17.964	900.0
2021-11-17	ADME	ETF	42.545	42.625	42.52	42.56	24600.0
2021-11-17	ADRE	ETF	51.04	51.04	50.13	50.39	12229.0
2021-11-17	AEMB	ETF	48.61	48.61	48.61	48.61	100.0
2021-11-17	AESR	ETF	14.84	14.86	14.81	14.83	6200.0
2021-11-17	AFIF	ETF	9.61	9.615	9.605	9.615	9236.0
2021-11-17	AFK	ETF	21.53	21.53	21.3	21.4	4989.0
2021-11-17	AFLG	ETF	27.477	27.477	27.477	27.477	100.0
2021-11-17	AFSM	ETF	28.64	28.685	28.64	28.685	300.0
2021-11-17	AFTY	ETF	21.04	21.04	21.036	21.036	1300.0
2021-11-17	AGG	ETF	113.79	114.13	113.77	114.13	7173100.0
2021-11-17	AGGY	ETF	51.55	51.707	51.55	51.69	93900.0
2021-11-17	AGNG	ETF	29.74	29.74	29.6	29.628	6500.0
2021-11-17	AGOV	ETF	98.6	98.6295	98.6	98.6295	155.0
2021-11-17	AGOX	ETF	26.65	26.65	26.22	26.3	36600.0
2021-11-17	AGQ	ETF	40.97	41.36	40.53	40.83	606900.0
2021-11-17	AGZ	ETF	117.55	117.82	117.55	117.72	89828.0
2021-11-17	AGZD	ETF	23.46	23.47	23.41	23.415	104400.0
2021-11-17	AHHX	ETF	10.37	10.51	10.37	10.465	4390.0
2021-11-17	AIA	ETF	82.31	82.31	81.44	81.65	39026.0
2021-11-17	AIEQ	ETF	44.7	44.7	44.3	44.343	7600.0
2021-11-17	AIQ	ETF	33.41	33.42	33.1	33.16	19159.0
2021-11-17	AIRR	ETF	47.67	47.733	46.93	47.36	14600.0
2021-11-17	AIVI	ETF	41.29	41.31	41.27	41.31	1800.0
2021-11-17	ALTL	ETF	44.99	44.99	44.76	44.89	44405.0
2021-11-17	ALTY	ETF	13.44	13.47	13.42	13.47	23600.0
2021-11-17	AMAX	ETF	9.82	9.95	9.82	9.84	1800.0

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

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