PREVIEW / etf_daily / 2023-03-21

all etf daily files

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

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-21	SPY	ETF	397.24	399.41	395.58	398.91	91524200.0
2023-03-21	QQQ	ETF	307.94	310.8	306.395	310.34	49757048.0
2023-03-21	IWM	ETF	176.55	178.18	175.96	176.65	34465900.0
2023-03-21	DIA	ETF	325.42	325.84	323.34	325.62	3527300.0
2023-03-21	GLD	ETF	182.65	182.73	179.9	180.37	10734500.0
2023-03-21	TLT	ETF	105.08	105.42	104.54	105.0	18934900.0
2023-03-21	AAA	ETF	24.44	24.44	24.44	24.44	32.0
2023-03-21	AAAU	ETF	19.49	19.49	19.19	19.24	2145400.0
2023-03-21	AADR	ETF	46.62	46.66	46.62	46.66	600.0
2023-03-21	AAPB	ETF	21.162	21.42	20.94	21.4	4735.0
2023-03-21	AAPD	ETF	24.74	24.87	24.435	24.4638	189845.0
2023-03-21	AAPU	ETF	21.77	22.19	21.63	22.18	167982.0
2023-03-21	AAXJ	ETF	65.33	65.68	65.15	65.51	280900.0
2023-03-21	ABEQ	ETF	27.47	27.5	27.37	27.489	5300.0
2023-03-21	ACES	ETF	43.69	45.14	43.69	44.85	25200.0
2023-03-21	ACIO	ETF	29.778	29.89	29.66	29.865	32100.0
2023-03-21	ACSI	ETF	43.51	43.7105	43.51	43.7105	129.0
2023-03-21	ACT	ETF	22.3	22.5	22.24	22.34	92029.0
2023-03-21	ACTV	ETF	28.81	29.08	28.81	29.0299	9686.0
2023-03-21	ACTX	ETF	0.2708	0.337	0.2708	0.337	612.0
2023-03-21	ACVF	ETF	30.522	30.73	30.522	30.711	3400.0
2023-03-21	ACWF	ETF	32.731	32.8415	32.6221	32.8415	5909.0
2023-03-21	ACWI	ETF	88.36	88.68	87.97	88.57	2800100.0
2023-03-21	ACWV	ETF	94.62	94.63	93.8	94.27	88600.0
2023-03-21	ACWX	ETF	47.14	47.26	46.94	47.17	2173082.0
2023-03-21	ADFI	ETF	8.44	8.47	8.44	8.461	18200.0
2023-03-21	ADIV	ETF	13.56	13.635	13.56	13.635	300.0
2023-03-21	ADME	ETF	34.12	34.2	33.99	34.2	9800.0
2023-03-21	ADPV	ETF	22.86	22.8999	22.82	22.8939	19894.0
2023-03-21	ADRE	ETF	38.21	38.28	38.12	38.15	11175.0
2023-03-21	AEMB	ETF	37.46	37.46	37.388	37.388	900.0
2023-03-21	AESR	ETF	11.63	11.652	11.575	11.652	16400.0
2023-03-21	AFIF	ETF	8.74	8.78	8.73	8.78	8954.0
2023-03-21	AFK	ETF	15.13	15.2	15.08	15.1	88855.0
2023-03-21	AFLG	ETF	23.554	23.554	23.554	23.554	100.0
2023-03-21	AFMC	ETF	22.83	22.83	22.6	22.71	5300.0
2023-03-21	AFSM	ETF	23.02	23.08	23.02	23.063	700.0
2023-03-21	AFTY	ETF	16.064	16.064	16.064	16.064	100.0
2023-03-21	AGG	ETF	98.88	99.03	98.7	98.8	5499100.0
2023-03-21	AGGH	ETF	22.8	22.8	22.72	22.73	1671.0
2023-03-21	AGGY	ETF	43.54	43.58	43.38	43.5	368600.0
2023-03-21	AGNG	ETF	26.195	26.296	26.15	26.296	2200.0
2023-03-21	AGOV	ETF	75.92	75.92	75.92	75.92	1.0
2023-03-21	AGOX	ETF	21.16	21.29	21.031	21.207	22400.0
2023-03-21	AGQ	ETF	27.41	27.42	26.53	26.97	630600.0
2023-03-21	AGZ	ETF	107.66	107.84	107.22	107.65	33819.0
2023-03-21	AGZD	ETF	21.65	21.85	21.65	21.77	78400.0
2023-03-21	AHHX	ETF	8.42	8.49	8.35	8.42	7569.0
2023-03-21	AHYB	ETF	43.24	43.357	43.18	43.357	1400.0
2023-03-21	AIA	ETF	58.39	58.64	58.19	58.52	38847.0

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

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