PREVIEW / etf_daily / 2022-05-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-19.parquet
  size:    101 KB
  rows:    2,723

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-19	SPY	ETF	388.62	394.14	387.11	389.46	98510700.0
2022-05-19	QQQ	ETF	289.29	294.39	287.58	289.58	79920709.0
2022-05-19	IWM	ETF	174.89	178.81	174.89	176.53	33627700.0
2022-05-19	DIA	ETF	312.12	316.35	310.83	313.18	3836700.0
2022-05-19	GLD	ETF	171.55	172.52	170.89	171.91	10580300.0
2022-05-19	TLT	ETF	118.64	118.72	116.85	117.18	21937500.0
2022-05-19	AAA	ETF	24.44	24.48	24.44	24.48	11637.0
2022-05-19	AAAU	ETF	18.27	18.37	18.2	18.31	528700.0
2022-05-19	AADR	ETF	53.46	53.95	53.2	53.53	7900.0
2022-05-19	AAXJ	ETF	68.21	69.29	68.21	69.06	2126500.0
2022-05-19	ABEQ	ETF	28.17	28.37	28.059	28.259	11700.0
2022-05-19	ACES	ETF	48.39	50.64	48.39	50.07	171600.0
2022-05-19	ACIO	ETF	28.53	28.99	28.53	28.7	36800.0
2022-05-19	ACSI	ETF	42.59	42.663	42.59	42.663	119.0
2022-05-19	ACT	ETF	23.15	23.78	23.11	23.31	216205.0
2022-05-19	ACTV	ETF	31.56	31.988	31.56	31.8586	2597.0
2022-05-19	ACTX	ETF	0.85	0.85	0.85	0.85	270.0
2022-05-19	ACVF	ETF	29.24	29.7	29.24	29.44	4700.0
2022-05-19	ACWF	ETF	32.85	33.3101	32.83	33.06	17428.0
2022-05-19	ACWI	ETF	87.17	88.49	86.96	87.7	5937500.0
2022-05-19	ACWV	ETF	95.71	96.47	95.12	95.94	335700.0
2022-05-19	ACWX	ETF	47.14	47.94	47.06	47.68	6036296.0
2022-05-19	ADFI	ETF	8.64	8.66	8.63	8.641	3500.0
2022-05-19	ADIV	ETF	14.37	14.42	14.37	14.42	200.0
2022-05-19	ADME	ETF	35.59	36.12	35.59	35.73	29900.0
2022-05-19	ADRE	ETF	38.7987	39.2356	38.4958	38.86	5239.0
2022-05-19	AEMB	ETF	39.965	39.965	39.965	39.965	100.0
2022-05-19	AESR	ETF	11.5	11.64	11.43	11.516	30100.0
2022-05-19	AFIF	ETF	9.02	9.02	8.97	9.0	106504.0
2022-05-19	AFK	ETF	18.53	18.88	18.53	18.8	5899.0
2022-05-19	AFLG	ETF	23.536	23.536	23.474	23.474	300.0
2022-05-19	AFMC	ETF	22.28	22.349	22.28	22.349	100.0
2022-05-19	AFTY	ETF	16.7	16.762	16.7	16.762	600.0
2022-05-19	AGG	ETF	103.2	103.22	102.75	102.85	10504300.0
2022-05-19	AGGH	ETF	23.8899	23.8899	23.7876	23.7876	165.0
2022-05-19	AGGY	ETF	45.59	45.65	45.45	45.45	315900.0
2022-05-19	AGNG	ETF	25.23	25.47	25.23	25.423	1000.0
2022-05-19	AGOV	ETF	79.0	80.0439	79.0	80.0439	663.0
2022-05-19	AGOX	ETF	21.09	21.441	21.09	21.265	40300.0
2022-05-19	AGQ	ETF	28.92	29.44	28.87	29.37	938400.0
2022-05-19	AGZ	ETF	110.83	110.92	110.63	110.77	38729.0
2022-05-19	AGZD	ETF	22.92	22.985	22.86	22.925	287600.0
2022-05-19	AHHX	ETF	9.0604	9.077	9.0599	9.065	923.0
2022-05-19	AHYB	ETF	44.21	44.39	44.21	44.39	600.0
2022-05-19	AIA	ETF	61.8	62.8619	61.78	62.6	146853.0
2022-05-19	AIEQ	ETF	32.35	33.11	32.33	32.68	15900.0
2022-05-19	AIQ	ETF	21.35	21.8372	21.3	21.56	12958.0
2022-05-19	AIRR	ETF	37.88	38.778	37.84	38.5	17300.0
2022-05-19	AIVI	ETF	38.57	38.82	38.57	38.7	1000.0
2022-05-19	AIVL	ETF	92.13	93.54	92.13	92.77	6000.0

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

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