PREVIEW / etf_daily / 2023-04-20

all etf daily files

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

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-04-20	SPY	ETF	411.21	413.7	410.27	411.88	75840400.0
2023-04-20	QQQ	ETF	315.69	319.27	314.97	316.28	62462142.0
2023-04-20	IWM	ETF	177.15	178.43	176.52	177.33	20336300.0
2023-04-20	DIA	ETF	337.43	338.85	336.85	337.95	2179300.0
2023-04-20	GLD	ETF	186.14	187.03	185.78	186.09	5789900.0
2023-04-20	TLT	ETF	104.83	105.28	104.75	104.99	16450100.0
2023-04-20	AAA	ETF	24.545	24.545	24.545	24.545	90.0
2023-04-20	AAAU	ETF	19.86	19.95	19.83	19.87	2509100.0
2023-04-20	AADR	ETF	48.56	48.56	48.56	48.56	100.0
2023-04-20	AAPB	ETF	22.989	23.16	22.72	22.921	3790.0
2023-04-20	AAPD	ETF	23.53	23.57	23.27	23.43	249505.0
2023-04-20	AAPU	ETF	23.51	23.85	23.4	23.58	57445.0
2023-04-20	AAXJ	ETF	67.41	67.85	67.19	67.37	696700.0
2023-04-20	ABEQ	ETF	28.53	28.554	28.48	28.525	4700.0
2023-04-20	ACES	ETF	43.62	44.08	43.51	43.66	23100.0
2023-04-20	ACIO	ETF	30.214	30.29	30.18	30.24	15100.0
2023-04-20	ACSI	ETF	44.1701	44.1701	44.0646	44.0646	754.0
2023-04-20	ACT	ETF	24.57	24.665	24.22	24.25	112905.0
2023-04-20	ACTV	ETF	29.04	29.18	28.95	29.02	11977.0
2023-04-20	ACTX	ETF	0.32	0.32	0.32	0.32	380.0
2023-04-20	ACVF	ETF	31.52	31.52	31.32	31.387	2400.0
2023-04-20	ACWF	ETF	34.025	34.04	33.84	33.9223	2748.0
2023-04-20	ACWI	ETF	91.94	92.46	91.81	92.11	1860500.0
2023-04-20	ACWV	ETF	98.41	98.81	98.41	98.67	68300.0
2023-04-20	ACWX	ETF	49.55	49.82	49.53	49.67	1250536.0
2023-04-20	ADFI	ETF	8.49	8.54	8.49	8.52	29200.0
2023-04-20	ADIV	ETF	13.77	13.77	13.77	13.77	100.0
2023-04-20	ADME	ETF	34.88	35.05	34.845	34.9	11300.0
2023-04-20	AEMB	ETF	37.479	37.479	37.479	37.479	100.0
2023-04-20	AESR	ETF	12.06	12.13	12.03	12.09	30700.0
2023-04-20	AFIF	ETF	8.825	8.83	8.8	8.808	7700.0
2023-04-20	AFK	ETF	16.07	16.13	15.96	16.0	7271.0
2023-04-20	AFLG	ETF	24.084	24.084	24.084	24.084	100.0
2023-04-20	AFMC	ETF	23.15	23.15	23.099	23.099	100.0
2023-04-20	AFSM	ETF	23.309	23.309	23.309	23.309	100.0
2023-04-20	AFTY	ETF	16.224	16.224	16.224	16.224	100.0
2023-04-20	AGG	ETF	99.21	99.36	99.19	99.34	5092400.0
2023-04-20	AGGY	ETF	43.63	43.69	43.62	43.69	108100.0
2023-04-20	AGNG	ETF	28.09	28.09	28.0	28.0	500.0
2023-04-20	AGOV	ETF	79.4	79.4	77.4	77.725	504.0
2023-04-20	AGOX	ETF	21.82	21.86	21.71	21.783	27800.0
2023-04-20	AGQ	ETF	34.26	34.83	33.7	34.09	522400.0
2023-04-20	AGZ	ETF	107.85	108.19	107.85	108.19	48566.0
2023-04-20	AGZD	ETF	21.81	21.885	21.805	21.83	13600.0
2023-04-20	AHYB	ETF	43.859	43.862	43.805	43.805	2200.0
2023-04-20	AIA	ETF	60.02	60.38	59.68	59.83	41102.0
2023-04-20	AIEQ	ETF	28.0	28.03	27.77	27.84	13700.0
2023-04-20	AIQ	ETF	23.81	23.9129	23.56	23.61	17456.0
2023-04-20	AIRR	ETF	45.52	45.873	45.47	45.75	23400.0
2023-04-20	AIVI	ETF	39.97	40.07	39.92	39.99	12500.0

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

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