PREVIEW / etf_daily / 2023-09-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-08.parquet
  size:    108 KB
  rows:    3,001

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-09-08	SPY	ETF	444.9	447.11	444.53	445.52	61659700.0
2023-09-08	QQQ	ETF	372.01	374.85	371.6	372.58	35847359.0
2023-09-08	IWM	ETF	184.56	184.83	183.45	183.92	19399100.0
2023-09-08	DIA	ETF	345.77	347.04	345.48	346.51	1665900.0
2023-09-08	GLD	ETF	178.36	179.05	177.9	178.08	3292700.0
2023-09-08	TLT	ETF	94.38	94.9	94.17	94.37	17052100.0
2023-09-08	AAA	ETF	24.75	24.75	24.75	24.75	400.0
2023-09-08	AAAU	ETF	19.05	19.12	19.0	19.02	610500.0
2023-09-08	AADR	ETF	50.89	50.89	50.31	50.38	2600.0
2023-09-08	AAPB	ETF	24.67	25.17	24.6399	24.69	28475.0
2023-09-08	AAPD	ETF	21.93	21.9865	21.7	21.95	274419.0
2023-09-08	AAPU	ETF	25.33	25.69	25.19	25.26	268909.0
2023-09-08	AAXJ	ETF	64.96	65.09	64.81	64.92	286300.0
2023-09-08	ABEQ	ETF	27.96	27.96	27.901	27.904	2100.0
2023-09-08	ACES	ETF	40.3	40.4	39.83	40.1	406400.0
2023-09-08	ACIO	ETF	31.315	31.39	31.24	31.32	47000.0
2023-09-08	ACSI	ETF	45.688	45.688	45.688	45.688	100.0
2023-09-08	ACT	ETF	28.12	28.385	28.12	28.29	126594.0
2023-09-08	ACTV	ETF	31.22	31.35	31.19	31.235	11100.0
2023-09-08	ACVF	ETF	34.3	34.43	34.3	34.417	4000.0
2023-09-08	ACWF	ETF	35.33	35.44	35.33	35.3697	5844.0
2023-09-08	ACWI	ETF	95.32	95.65	95.19	95.33	1110400.0
2023-09-08	ACWV	ETF	97.3	97.49	97.18	97.32	53600.0
2023-09-08	ACWX	ETF	48.06	48.17	47.97	48.02	629200.0
2023-09-08	ADFI	ETF	8.385	8.4	8.38	8.4	20000.0
2023-09-08	ADIV	ETF	13.48	13.48	13.48	13.48	100.0
2023-09-08	ADME	ETF	36.48	36.52	36.38	36.452	11900.0
2023-09-08	ADPV	ETF	25.31	25.31	25.2282	25.2282	327.0
2023-09-08	AEMB	ETF	36.815	36.815	36.815	36.815	100.0
2023-09-08	AESR	ETF	12.725	12.75	12.67	12.72	24500.0
2023-09-08	AFIF	ETF	8.94	8.95	8.91	8.91	6000.0
2023-09-08	AFK	ETF	14.75	14.91	14.5	14.51	14500.0
2023-09-08	AFLG	ETF	25.469	25.469	25.469	25.469	100.0
2023-09-08	AFMC	ETF	24.595	24.595	24.545	24.545	400.0
2023-09-08	AFTY	ETF	14.69	14.69	14.67	14.686	1500.0
2023-09-08	AGG	ETF	95.93	96.02	95.76	95.78	4774200.0
2023-09-08	AGGH	ETF	22.0179	22.05	22.0	22.0058	9387.0
2023-09-08	AGGY	ETF	42.35	42.41	42.3	42.32	46400.0
2023-09-08	AGNG	ETF	27.025	27.04	26.95	27.01	2500.0
2023-09-08	AGOV	ETF	73.85	73.85	73.85	73.85	54.0
2023-09-08	AGOX	ETF	23.32	23.56	23.32	23.4	135700.0
2023-09-08	AGQ	ETF	26.61	26.99	26.3	26.45	560600.0
2023-09-08	AGZ	ETF	106.38	106.5	106.24	106.35	10700.0
2023-09-08	AGZD	ETF	22.2	22.32	22.12	22.23	15400.0
2023-09-08	AHLT	ETF	25.52	25.685	25.52	25.685	1795.0
2023-09-08	AHYB	ETF	44.02	44.02	43.883	43.883	400.0
2023-09-08	AIA	ETF	57.12	57.24	56.96	57.12	62400.0
2023-09-08	AIEQ	ETF	31.08	31.17	30.96	30.999	7600.0
2023-09-08	AIQ	ETF	28.32	28.51	28.28	28.34	234000.0
2023-09-08	AIRR	ETF	53.52	53.52	53.17	53.35	39500.0

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

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