PREVIEW / etf_daily / 2023-09-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-07.parquet
  size:    107 KB
  rows:    3,018

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-07	SPY	ETF	443.11	445.55	442.75	444.85	70355400.0
2023-09-07	QQQ	ETF	370.21	372.85	369.15	372.06	52060716.0
2023-09-07	IWM	ETF	185.14	185.38	183.59	184.33	23894800.0
2023-09-07	DIA	ETF	344.46	346.24	344.35	345.69	2378600.0
2023-09-07	GLD	ETF	178.31	178.37	177.9	178.02	3257200.0
2023-09-07	TLT	ETF	94.0	94.07	93.68	94.01	18091500.0
2023-09-07	AAA	ETF	24.77	24.77	24.77	24.77	100.0
2023-09-07	AAAU	ETF	19.05	19.05	19.0	19.02	711000.0
2023-09-07	AADR	ETF	50.74	51.06	50.74	50.86	500.0
2023-09-07	AAPB	ETF	24.0	24.69	23.6505	24.56	61780.0
2023-09-07	AAPD	ETF	22.28	22.4718	21.9355	22.0	543275.0
2023-09-07	AAPU	ETF	24.68	25.29	24.3	25.17	515412.0
2023-09-07	AAXJ	ETF	65.0	65.01	64.68	64.9	588900.0
2023-09-07	ABEQ	ETF	27.69	27.91	27.69	27.848	3300.0
2023-09-07	ACES	ETF	39.98	40.349	39.39	40.32	54400.0
2023-09-07	ACIO	ETF	31.09	31.32	31.09	31.26	34100.0
2023-09-07	ACSI	ETF	45.67	45.67	45.67	45.67	100.0
2023-09-07	ACT	ETF	28.01	29.37	27.81	28.16	156820.0
2023-09-07	ACTV	ETF	31.26	31.26	31.18	31.238	4100.0
2023-09-07	ACVF	ETF	34.26	34.45	34.26	34.392	7400.0
2023-09-07	ACWF	ETF	35.32	35.38	35.3	35.32	3336.0
2023-09-07	ACWI	ETF	95.07	95.41	94.9	95.29	1748700.0
2023-09-07	ACWV	ETF	96.92	97.46	96.53	97.25	106000.0
2023-09-07	ACWX	ETF	48.07	48.15	47.92	48.06	1068100.0
2023-09-07	ADFI	ETF	8.35	8.38	8.35	8.375	9900.0
2023-09-07	ADIV	ETF	13.484	13.484	13.484	13.484	100.0
2023-09-07	ADME	ETF	36.29	36.484	36.29	36.45	8800.0
2023-09-07	ADPV	ETF	25.0537	25.21	25.0537	25.195	843.0
2023-09-07	AEMB	ETF	36.62	36.83	36.62	36.76	1200.0
2023-09-07	AESR	ETF	12.7	12.708	12.64	12.697	18000.0
2023-09-07	AFIF	ETF	8.89	8.95	8.64	8.9	42400.0
2023-09-07	AFK	ETF	14.61	14.63	14.47	14.59	3700.0
2023-09-07	AFLG	ETF	25.383	25.409	25.383	25.409	300.0
2023-09-07	AFMC	ETF	24.525	24.57	24.518	24.518	700.0
2023-09-07	AFSM	ETF	24.585	24.585	24.548	24.548	100.0
2023-09-07	AFTY	ETF	14.8	14.8	14.77	14.77	200.0
2023-09-07	AGG	ETF	95.59	95.74	95.49	95.73	5077800.0
2023-09-07	AGGH	ETF	21.915	22.03	21.915	22.03	2048.0
2023-09-07	AGGY	ETF	42.2	42.3	42.19	42.28	106000.0
2023-09-07	AGNG	ETF	27.0	27.03	26.99	27.02	27800.0
2023-09-07	AGOV	ETF	72.795	74.4999	72.655	73.616	5931.0
2023-09-07	AGOX	ETF	24.98	24.98	23.386	23.42	25100.0
2023-09-07	AGQ	ETF	26.63	26.86	26.43	26.55	577700.0
2023-09-07	AGZ	ETF	106.26	106.37	106.24	106.35	24200.0
2023-09-07	AGZD	ETF	22.21	22.22	22.13	22.22	61900.0
2023-09-07	AHLT	ETF	25.74	25.74	25.7075	25.7075	394.0
2023-09-07	AHOY	ETF	20.41	20.41	20.3542	20.3542	551.0
2023-09-07	AHYB	ETF	43.914	43.914	43.914	43.914	300.0
2023-09-07	AIA	ETF	57.33	57.33	56.93	57.12	22700.0
2023-09-07	AIEQ	ETF	31.0	31.145	30.97	31.062	6900.0

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

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