PREVIEW / etf_daily / 2023-03-20

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-20.parquet
  size:    109 KB
  rows:    2,956

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-03-20	SPY	ETF	390.8	394.17	390.07	393.74	93055800.0
2023-03-20	QQQ	ETF	304.26	306.3	302.01	305.97	56359491.0
2023-03-20	IWM	ETF	173.05	175.37	172.53	173.45	46103200.0
2023-03-20	DIA	ETF	319.33	322.75	319.33	322.3	4695000.0
2023-03-20	GLD	ETF	184.19	184.54	182.74	183.84	11845700.0
2023-03-20	TLT	ETF	106.88	106.96	105.72	105.91	24242800.0
2023-03-20	AAA	ETF	24.41	24.455	24.375	24.455	834.0
2023-03-20	AAAU	ETF	19.66	19.68	19.5	19.61	1755700.0
2023-03-20	AADR	ETF	45.69	45.69	45.45	45.45	300.0
2023-03-20	AAPB	ETF	20.5581	20.9799	20.5581	20.9799	1751.0
2023-03-20	AAPD	ETF	25.27	25.42	24.863	24.9	83634.0
2023-03-20	AAPU	ETF	21.45	21.95	21.22	21.87	126487.0
2023-03-20	AAXJ	ETF	64.42	65.03	64.39	64.9	445000.0
2023-03-20	ABEQ	ETF	27.31	27.38	27.31	27.353	5700.0
2023-03-20	ACES	ETF	42.9	43.7	42.9	43.088	26200.0
2023-03-20	ACIO	ETF	29.489	29.64	29.489	29.53	32200.0
2023-03-20	ACSI	ETF	42.7	42.8419	42.7	42.8419	527.0
2023-03-20	ACT	ETF	21.97	22.21	21.695	21.93	98019.0
2023-03-20	ACTV	ETF	28.33	28.59	28.33	28.4561	8258.0
2023-03-20	ACTX	ETF	0.35	0.43	0.1261	0.1395	6780.0
2023-03-20	ACVF	ETF	30.0	30.393	30.0	30.361	5800.0
2023-03-20	ACWF	ETF	32.26	32.425	32.26	32.425	14749.0
2023-03-20	ACWI	ETF	86.77	87.58	86.73	87.41	2152700.0
2023-03-20	ACWV	ETF	93.85	94.4	93.76	94.28	200700.0
2023-03-20	ACWX	ETF	46.32	46.67	46.27	46.58	2698408.0
2023-03-20	ADFI	ETF	8.431	8.45	8.42	8.44	8100.0
2023-03-20	ADIV	ETF	13.49	13.53	13.49	13.53	1400.0
2023-03-20	ADME	ETF	33.66	34.02	33.66	33.96	55900.0
2023-03-20	ADPV	ETF	22.85	22.99	22.85	22.8895	24624.0
2023-03-20	ADRE	ETF	38.1	38.21	35.89	38.2	50964.0
2023-03-20	AEMB	ETF	37.29	37.294	37.29	37.294	100.0
2023-03-20	AESR	ETF	11.52	11.54	11.5	11.53	18800.0
2023-03-20	AFIF	ETF	8.78	8.8	8.72	8.732	18276.0
2023-03-20	AFK	ETF	15.54	15.54	15.0301	15.13	18834.0
2023-03-20	AFLG	ETF	23.285	23.285	23.285	23.285	100.0
2023-03-20	AFMC	ETF	22.32	22.44	22.32	22.376	5900.0
2023-03-20	AFSM	ETF	22.65	22.704	22.65	22.657	400.0
2023-03-20	AFTY	ETF	15.89	15.91	15.89	15.91	600.0
2023-03-20	AGG	ETF	99.73	99.73	99.02	99.1	6346400.0
2023-03-20	AGGY	ETF	43.81	43.81	43.54	43.565	132800.0
2023-03-20	AGNG	ETF	25.86	26.085	25.86	26.085	1800.0
2023-03-20	AGOV	ETF	77.0655	77.0655	77.0655	77.0655	1.0
2023-03-20	AGOX	ETF	20.83	20.93	20.72	20.871	14800.0
2023-03-20	AGQ	ETF	27.01	27.52	26.7	27.3	887200.0
2023-03-20	AGZ	ETF	108.52	108.52	108.02	108.19	51981.0
2023-03-20	AGZD	ETF	21.665	21.785	21.595	21.695	201200.0
2023-03-20	AHHX	ETF	8.42	8.42	8.35	8.42	4101.0
2023-03-20	AHYB	ETF	43.049	43.05	42.885	42.898	1300.0
2023-03-20	AIA	ETF	57.36	57.97	57.36	57.77	23759.0
2023-03-20	AIEQ	ETF	28.26	28.555	28.2	28.45	13600.0

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

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