PREVIEW / etf_daily / 2022-05-31

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-31.parquet
  size:    103 KB
  rows:    2,751

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-31	SPY	ETF	413.55	416.46	410.03	412.93	95937000.0
2022-05-31	QQQ	ETF	309.07	311.33	304.33	308.28	60968330.0
2022-05-31	IWM	ETF	186.91	187.68	184.09	185.31	29794500.0
2022-05-31	DIA	ETF	330.17	332.55	327.66	330.2	4354000.0
2022-05-31	GLD	ETF	172.71	173.07	171.08	171.14	6244000.0
2022-05-31	TLT	ETF	117.18	117.23	115.93	116.56	28393700.0
2022-05-31	AAA	ETF	24.465	24.465	24.465	24.465	3.0
2022-05-31	AAAU	ETF	18.4	18.43	18.23	18.24	1727700.0
2022-05-31	AADR	ETF	57.13	57.13	56.39	56.71	900.0
2022-05-31	AAXJ	ETF	72.37	72.43	71.67	71.69	1159600.0
2022-05-31	ABEQ	ETF	29.14	29.2	29.131	29.131	8400.0
2022-05-31	ACES	ETF	54.42	54.62	52.66	53.23	412300.0
2022-05-31	ACIO	ETF	30.135	30.25	29.97	29.98	860900.0
2022-05-31	ACSI	ETF	45.63	45.63	45.493	45.493	1118.0
2022-05-31	ACT	ETF	24.4	24.52	23.9	24.32	746568.0
2022-05-31	ACTV	ETF	32.7	33.02	32.7	32.881	7660.0
2022-05-31	ACTX	ETF	0.75	0.75	0.7	0.7	6359.0
2022-05-31	ACVF	ETF	31.41	31.43	30.97	31.173	2300.0
2022-05-31	ACWF	ETF	34.91	34.9199	34.6361	34.6361	49628.0
2022-05-31	ACWI	ETF	92.55	92.93	91.82	92.14	4431600.0
2022-05-31	ACWV	ETF	99.65	99.81	98.99	99.29	388700.0
2022-05-31	ACWX	ETF	49.88	50.0215	49.62	49.65	2672407.0
2022-05-31	ADFI	ETF	8.74	8.765	8.74	8.743	4500.0
2022-05-31	ADIV	ETF	14.927	14.927	14.927	14.927	100.0
2022-05-31	ADME	ETF	37.31	37.78	37.31	37.51	58700.0
2022-05-31	ADRE	ETF	42.11	42.12	41.485	41.485	4983.0
2022-05-31	AEMB	ETF	40.634	40.634	40.634	40.634	100.0
2022-05-31	AESR	ETF	12.2	12.33	12.19	12.25	15700.0
2022-05-31	AFIF	ETF	9.0	9.03	8.99	9.01	66710.0
2022-05-31	AFK	ETF	19.05	19.21	19.0	19.0	22630.0
2022-05-31	AFLG	ETF	24.823	24.823	24.823	24.823	100.0
2022-05-31	AFMC	ETF	23.489	23.489	23.489	23.489	100.0
2022-05-31	AFSM	ETF	24.08	24.24	24.07	24.173	1600.0
2022-05-31	AFTY	ETF	17.3	17.3	17.23	17.245	3900.0
2022-05-31	AGG	ETF	103.53	103.64	103.29	103.47	10491700.0
2022-05-31	AGGH	ETF	23.84	23.91	23.84	23.849	332.0
2022-05-31	AGGY	ETF	45.83	45.86	45.72	45.82	445800.0
2022-05-31	AGNG	ETF	26.34	26.34	26.195	26.2	1200.0
2022-05-31	AGOV	ETF	81.0	81.0	80.4284	80.4284	1246.0
2022-05-31	AGOX	ETF	22.34	22.45	22.19	22.23	15200.0
2022-05-31	AGQ	ETF	29.0	29.32	28.09	28.11	830200.0
2022-05-31	AGZ	ETF	110.99	110.99	110.82	110.94	66721.0
2022-05-31	AGZD	ETF	23.065	23.065	22.98	23.02	213000.0
2022-05-31	AHHX	ETF	9.25	9.25	9.2297	9.2297	717.0
2022-05-31	AHYB	ETF	45.997	45.997	45.86	45.976	1400.0
2022-05-31	AIA	ETF	66.34	66.49	65.56	65.63	204351.0
2022-05-31	AIEQ	ETF	34.337	34.643	34.24	34.309	7200.0
2022-05-31	AIQ	ETF	22.88	22.93	22.5618	22.72	21414.0
2022-05-31	AIRR	ETF	40.37	40.37	40.0	40.32	9200.0
2022-05-31	AIVI	ETF	39.64	39.77	39.63	39.68	2400.0

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

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