PREVIEW / etf_daily / 2023-09-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-13.parquet
  size:    107 KB
  rows:    2,988

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-13	SPY	ETF	446.22	447.71	445.08	446.51	60199300.0
2023-09-13	QQQ	ETF	373.03	375.84	371.88	374.21	46300677.0
2023-09-13	IWM	ETF	184.5	184.88	182.39	182.97	24415700.0
2023-09-13	DIA	ETF	347.56	348.51	345.82	346.55	2025200.0
2023-09-13	GLD	ETF	177.53	177.75	177.04	177.08	3874800.0
2023-09-13	TLT	ETF	93.92	94.53	93.82	94.21	23332300.0
2023-09-13	AAA	ETF	24.77	24.83	24.77	24.77	2200.0
2023-09-13	AAAU	ETF	18.96	18.98	18.91	18.91	1558900.0
2023-09-13	AADR	ETF	50.28	50.41	50.28	50.41	200.0
2023-09-13	AAPB	ETF	24.39	24.42	23.7	23.71	39433.0
2023-09-13	AAPD	ETF	22.07	22.47	22.06	22.45	287876.0
2023-09-13	AAPU	ETF	25.01	25.05	24.37	24.42	252241.0
2023-09-13	AAXJ	ETF	65.41	65.52	65.21	65.32	396000.0
2023-09-13	ABEQ	ETF	28.12	28.173	28.045	28.08	4300.0
2023-09-13	ACES	ETF	41.0	41.04	40.35	40.37	20400.0
2023-09-13	ACIO	ETF	31.38	31.444	31.31	31.39	41800.0
2023-09-13	ACSI	ETF	46.0	46.0	45.922	45.922	100.0
2023-09-13	ACT	ETF	28.14	28.16	27.69	27.83	144219.0
2023-09-13	ACTV	ETF	31.13	31.216	31.047	31.047	1900.0
2023-09-13	ACVF	ETF	34.51	34.55	34.41	34.492	9500.0
2023-09-13	ACWF	ETF	35.35	35.45	35.35	35.368	3916.0
2023-09-13	ACWI	ETF	95.7	95.96	95.47	95.72	2860200.0
2023-09-13	ACWV	ETF	97.53	97.83	97.53	97.67	96600.0
2023-09-13	ACWX	ETF	48.31	48.42	48.18	48.27	601800.0
2023-09-13	ADFI	ETF	8.35	8.41	8.35	8.41	14900.0
2023-09-13	ADME	ETF	36.605	36.65	36.51	36.586	13600.0
2023-09-13	ADPV	ETF	24.66	24.66	24.59	24.6221	725.0
2023-09-13	AEMB	ETF	36.74	36.825	36.74	36.825	200.0
2023-09-13	AESR	ETF	12.74	12.78	12.68	12.73	25100.0
2023-09-13	AFIF	ETF	8.95	8.97	8.92	8.94	107900.0
2023-09-13	AFK	ETF	14.55	14.65	14.5	14.65	1900.0
2023-09-13	AFMC	ETF	24.34	24.34	24.302	24.302	1600.0
2023-09-13	AFSM	ETF	24.318	24.318	24.318	24.318	200.0
2023-09-13	AFTY	ETF	14.911	14.924	14.911	14.924	200.0
2023-09-13	AGG	ETF	95.61	95.95	95.59	95.84	5953600.0
2023-09-13	AGGH	ETF	22.01	22.04	21.98	22.03	20314.0
2023-09-13	AGGY	ETF	42.23	42.36	42.23	42.315	43600.0
2023-09-13	AGNG	ETF	27.15	27.15	26.96	27.01	1400.0
2023-09-13	AGOV	ETF	74.2302	74.2302	74.2302	74.2302	35.0
2023-09-13	AGOX	ETF	23.28	23.455	23.28	23.31	8800.0
2023-09-13	AGQ	ETF	26.52	26.76	26.24	26.32	717200.0
2023-09-13	AGZ	ETF	106.25	106.43	106.25	106.42	17600.0
2023-09-13	AGZD	ETF	22.27	22.37	22.19	22.23	27400.0
2023-09-13	AHOY	ETF	20.32	20.34	20.2961	20.2961	254.0
2023-09-13	AHYB	ETF	43.942	44.04	43.942	44.01	500.0
2023-09-13	AIA	ETF	57.48	57.89	57.48	57.54	40200.0
2023-09-13	AIEQ	ETF	30.9	30.99	30.68	30.703	4000.0
2023-09-13	AIQ	ETF	28.28	28.38	28.12	28.26	394400.0
2023-09-13	AIRR	ETF	53.43	53.505	52.58	52.83	64200.0
2023-09-13	AIVI	ETF	38.73	38.81	38.69	38.72	1200.0

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

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