PREVIEW / etf_daily / 2023-07-31

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-31.parquet
  size:    108 KB
  rows:    3,019

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
2023-07-31	SPY	ETF	457.41	458.16	456.05	457.79	62040400.0
2023-07-31	QQQ	ETF	383.79	384.88	382.34	383.68	44019905.0
2023-07-31	IWM	ETF	196.93	198.75	196.92	198.71	24203900.0
2023-07-31	DIA	ETF	354.57	355.6	354.19	355.57	2201400.0
2023-07-31	GLD	ETF	182.43	183.09	182.31	182.35	5494800.0
2023-07-31	TLT	ETF	99.65	100.33	99.62	100.05	28663800.0
2023-07-31	AAA	ETF	24.75	25.09	24.75	24.78	7800.0
2023-07-31	AAAU	ETF	19.47	19.55	19.46	19.47	1125800.0
2023-07-31	AADR	ETF	52.64	53.11	52.64	53.11	900.0
2023-07-31	AAPB	ETF	29.5701	29.7	29.5	29.7	10052.0
2023-07-31	AAPD	ETF	19.92	20.0	19.89	19.9	64393.0
2023-07-31	AAPU	ETF	29.48	29.55	29.27	29.55	104587.0
2023-07-31	AAXJ	ETF	70.13	70.63	70.13	70.53	1555100.0
2023-07-31	ABEQ	ETF	28.7	28.72	28.66	28.678	6600.0
2023-07-31	ACES	ETF	47.69	48.29	47.69	48.23	66800.0
2023-07-31	ACIO	ETF	31.828	31.85	31.746	31.85	85900.0
2023-07-31	ACSI	ETF	48.237	48.237	48.237	48.237	100.0
2023-07-31	ACT	ETF	27.39	27.45	27.025	27.2	166437.0
2023-07-31	ACTV	ETF	33.39	33.62	33.32	33.498	22900.0
2023-07-31	ACVF	ETF	34.86	34.86	34.75	34.814	18200.0
2023-07-31	ACWF	ETF	36.6299	36.63	36.5601	36.63	3962.0
2023-07-31	ACWI	ETF	99.3	99.51	99.15	99.39	2951900.0
2023-07-31	ACWV	ETF	99.89	99.89	99.42	99.6	118200.0
2023-07-31	ACWX	ETF	51.16	51.3	51.1	51.15	1452200.0
2023-07-31	ADFI	ETF	8.45	8.48	8.45	8.465	16400.0
2023-07-31	ADIV	ETF	14.393	14.43	14.383	14.383	2600.0
2023-07-31	ADME	ETF	37.31	37.36	37.23	37.36	55500.0
2023-07-31	ADPV	ETF	25.82	25.875	25.8	25.875	1299.0
2023-07-31	AEMB	ETF	38.001	38.001	38.001	38.001	100.0
2023-07-31	AESR	ETF	13.14	13.14	13.091	13.131	30300.0
2023-07-31	AFIF	ETF	8.89	8.9	8.87	8.87	16600.0
2023-07-31	AFK	ETF	15.8	15.95	15.8	15.88	7500.0
2023-07-31	AFLG	ETF	26.111	26.111	26.111	26.111	100.0
2023-07-31	AFMC	ETF	25.79	25.8	25.776	25.776	1000.0
2023-07-31	AFSM	ETF	26.085	26.17	26.085	26.152	3800.0
2023-07-31	AFTY	ETF	16.13	16.13	16.07	16.11	1100.0
2023-07-31	AGG	ETF	97.53	97.8	97.52	97.68	11079100.0
2023-07-31	AGGH	ETF	22.36	22.39	22.27	22.27	5078.0
2023-07-31	AGGY	ETF	42.91	43.009	42.91	42.98	63600.0
2023-07-31	AGNG	ETF	28.07	28.07	27.82	27.892	4000.0
2023-07-31	AGOV	ETF	75.91	76.1432	75.91	76.1432	224.0
2023-07-31	AGOX	ETF	24.084	24.14	24.02	24.07	15400.0
2023-07-31	AGQ	ETF	30.95	31.74	30.93	31.48	588700.0
2023-07-31	AGZ	ETF	106.77	106.93	106.77	106.85	7700.0
2023-07-31	AGZD	ETF	22.19	22.27	22.135	22.18	44600.0
2023-07-31	AHYB	ETF	44.39	44.39	44.39	44.39	100.0
2023-07-31	AIA	ETF	62.93	63.5	62.93	63.33	45700.0
2023-07-31	AIEQ	ETF	33.49	33.786	33.38	33.62	18200.0
2023-07-31	AIQ	ETF	29.51	29.659	29.45	29.63	466500.0
2023-07-31	AIRR	ETF	54.24	54.564	54.04	54.46	62000.0

> showing 50 of 3,019 rows — these rows as CSV

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