PREVIEW / etf_daily / 2022-05-16

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-16.parquet
  size:    102 KB
  rows:    2,727

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
2022-05-16	SPY	ETF	399.98	403.97	397.6	400.09	78622400.0
2022-05-16	QQQ	ETF	300.15	302.26	297.13	298.44	59190432.0
2022-05-16	IWM	ETF	177.5	179.44	176.14	177.22	28225500.0
2022-05-16	DIA	ETF	321.71	325.57	319.7	322.78	3692600.0
2022-05-16	GLD	ETF	168.43	170.43	168.34	170.4	7319300.0
2022-05-16	TLT	ETF	116.21	116.94	115.85	115.86	11050600.0
2022-05-16	AAA	ETF	24.62	24.62	24.55	24.55	19171.0
2022-05-16	AAAU	ETF	17.93	18.15	17.93	18.14	1563200.0
2022-05-16	AADR	ETF	53.1	53.54	53.1	53.37	1600.0
2022-05-16	AAXJ	ETF	67.64	68.07	67.48	67.72	1200100.0
2022-05-16	ABEQ	ETF	28.285	28.54	28.28	28.415	31900.0
2022-05-16	ACES	ETF	47.33	48.24	46.72	46.8	79600.0
2022-05-16	ACIO	ETF	29.52	29.561	29.24	29.49	53700.0
2022-05-16	ACSI	ETF	44.36	44.36	43.9477	43.9477	255.0
2022-05-16	ACT	ETF	23.51	23.575	22.85	22.98	223069.0
2022-05-16	ACTV	ETF	32.316	32.338	32.0	32.0543	24449.0
2022-05-16	ACTX	ETF	1.0	1.0	1.0	1.0	500.0
2022-05-16	ACVF	ETF	30.12	30.436	30.01	30.178	5100.0
2022-05-16	ACWF	ETF	33.53	33.65	33.43	33.5817	5760.0
2022-05-16	ACWI	ETF	88.77	89.54	88.3	88.85	2073300.0
2022-05-16	ACWV	ETF	97.39	98.09	97.11	97.48	311000.0
2022-05-16	ACWX	ETF	47.11	47.545	46.94	47.33	3061190.0
2022-05-16	ADFI	ETF	8.65	8.67	8.63	8.645	3700.0
2022-05-16	ADIV	ETF	14.296	14.313	14.296	14.313	100.0
2022-05-16	ADME	ETF	36.885	36.93	36.617	36.705	57000.0
2022-05-16	ADRE	ETF	38.27	38.7	38.27	38.48	6134.0
2022-05-16	AESR	ETF	11.78	11.85	11.76	11.793	9400.0
2022-05-16	AFIF	ETF	9.01	9.02	9.0	9.01	18338.0
2022-05-16	AFK	ETF	18.75	18.75	18.62	18.7	3396.0
2022-05-16	AFLG	ETF	24.22	24.22	24.219	24.219	100.0
2022-05-16	AFMC	ETF	22.77	22.77	22.77	22.77	100.0
2022-05-16	AFSM	ETF	23.275	23.275	23.275	23.275	100.0
2022-05-16	AFTY	ETF	16.485	16.485	16.485	16.485	100.0
2022-05-16	AGG	ETF	102.71	102.97	102.69	102.74	7239200.0
2022-05-16	AGGY	ETF	45.42	45.639	45.417	45.5	823600.0
2022-05-16	AGNG	ETF	25.51	25.59	25.45	25.45	2500.0
2022-05-16	AGOV	ETF	79.3881	79.3881	79.3881	79.3881	8.0
2022-05-16	AGOX	ETF	21.64	21.64	21.3	21.399	51600.0
2022-05-16	AGQ	ETF	27.55	28.69	27.51	28.49	1118600.0
2022-05-16	AGZ	ETF	110.75	110.7924	110.44	110.62	65807.0
2022-05-16	AGZD	ETF	22.965	23.055	22.91	22.975	103200.0
2022-05-16	AHHX	ETF	9.085	9.0905	9.05	9.0743	8495.0
2022-05-16	AHYB	ETF	44.49	44.509	44.42	44.42	600.0
2022-05-16	AIA	ETF	61.4	61.86	61.28	61.47	29959.0
2022-05-16	AIEQ	ETF	32.9	32.989	32.65	32.65	8900.0
2022-05-16	AIQ	ETF	22.14	22.18	21.88	21.9	45071.0
2022-05-16	AIRR	ETF	37.7	37.996	37.2	37.764	12700.0
2022-05-16	AIVI	ETF	38.13	38.47	38.1	38.33	3800.0
2022-05-16	AIVL	ETF	93.59	94.81	93.59	94.18	7100.0
2022-05-16	ALTL	ETF	42.61	42.9693	42.5	42.78	124717.0

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

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