PREVIEW / etf_daily / 2023-05-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-03.parquet
  size:    110 KB
  rows:    2,948

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-05-03	SPY	ETF	411.36	413.87	407.77	408.02	91531800.0
2023-05-03	QQQ	ETF	319.75	322.47	317.18	317.29	59882070.0
2023-05-03	IWM	ETF	172.22	175.7	172.19	172.33	43261400.0
2023-05-03	DIA	ETF	337.13	338.18	333.93	334.11	3924100.0
2023-05-03	GLD	ETF	187.61	189.21	186.93	189.11	11133800.0
2023-05-03	TLT	ETF	106.0	106.6	105.28	106.29	23656200.0
2023-05-03	AAA	ETF	24.52	24.57	24.52	24.53	442.0
2023-05-03	AAAU	ETF	20.02	20.19	19.94	20.18	2071200.0
2023-05-03	AADR	ETF	47.07	47.18	46.82	46.82	2800.0
2023-05-03	AAPB	ETF	23.76	23.76	23.07	23.12	1789.0
2023-05-03	AAPD	ETF	23.05	23.39	22.88	23.34	252139.0
2023-05-03	AAPU	ETF	24.21	24.45	23.7	23.74	99012.0
2023-05-03	AAXJ	ETF	65.85	66.21	65.72	65.76	341300.0
2023-05-03	ABEQ	ETF	28.83	28.88	28.68	28.703	15700.0
2023-05-03	ACES	ETF	40.81	41.77	40.81	40.94	94600.0
2023-05-03	ACIO	ETF	30.0	30.18	29.92	29.92	28200.0
2023-05-03	ACSI	ETF	43.499	43.499	43.4129	43.4129	367.0
2023-05-03	ACT	ETF	24.18	24.43	23.62	23.65	161183.0
2023-05-03	ACTV	ETF	29.165	29.285	28.84	28.89	8240.0
2023-05-03	ACVF	ETF	31.303	31.39	31.028	31.028	1900.0
2023-05-03	ACWF	ETF	33.75	33.88	33.5806	33.5806	98949.0
2023-05-03	ACWI	ETF	91.56	92.14	91.06	91.1	3964000.0
2023-05-03	ACWV	ETF	99.31	99.66	98.87	99.05	266000.0
2023-05-03	ACWX	ETF	49.23	49.5	49.12	49.13	701355.0
2023-05-03	ADFI	ETF	8.55	8.55	8.53	8.535	6500.0
2023-05-03	ADIV	ETF	13.487	13.487	13.453	13.453	600.0
2023-05-03	ADME	ETF	34.55	34.86	34.525	34.55	40600.0
2023-05-03	AEMB	ETF	37.75	37.75	37.75	37.75	100.0
2023-05-03	AESR	ETF	12.03	12.09	11.965	11.97	17600.0
2023-05-03	AFIF	ETF	8.89	8.89	8.84	8.84	456.0
2023-05-03	AFK	ETF	15.76	15.76	15.64	15.64	1876.0
2023-05-03	AFLG	ETF	23.736	23.736	23.736	23.736	100.0
2023-05-03	AFMC	ETF	23.015	23.015	22.78	22.78	400.0
2023-05-03	AFSM	ETF	22.474	22.474	22.474	22.474	100.0
2023-05-03	AFTY	ETF	15.98	15.98	15.976	15.976	300.0
2023-05-03	AGG	ETF	99.89	100.13	99.69	100.09	5637200.0
2023-05-03	AGGY	ETF	43.89	43.97	43.64	43.94	77300.0
2023-05-03	AGNG	ETF	28.24	28.4	28.2	28.21	10000.0
2023-05-03	AGOV	ETF	77.165	77.165	77.165	77.165	113.0
2023-05-03	AGOX	ETF	21.57	21.605	21.34	21.37	18500.0
2023-05-03	AGQ	ETF	34.31	35.05	33.94	34.8	680700.0
2023-05-03	AGZ	ETF	108.53	108.81	108.51	108.79	21253.0
2023-05-03	AGZD	ETF	21.73	21.82	21.605	21.7	56000.0
2023-05-03	AHYB	ETF	43.709	43.709	43.709	43.709	100.0
2023-05-03	AIA	ETF	57.71	58.06	57.55	57.59	21915.0
2023-05-03	AIEQ	ETF	27.03	27.5	26.96	26.975	12200.0
2023-05-03	AIQ	ETF	23.59	23.7701	23.4	23.47	29353.0
2023-05-03	AIRR	ETF	46.01	46.4	45.61	45.61	59100.0
2023-05-03	AIVI	ETF	40.22	40.34	40.17	40.17	2200.0
2023-05-03	AIVL	ETF	91.26	91.69	90.53	90.53	1100.0

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

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