PREVIEW / etf_daily / 2023-08-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-21.parquet
  size:    105 KB
  rows:    2,904

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-08-21	SPY	ETF	437.55	440.11	435.32	439.34	68719000.0
2023-08-21	QQQ	ETF	359.62	364.59	359.15	363.9	50696518.0
2023-08-21	IWM	ETF	184.7	185.28	183.07	184.38	22678100.0
2023-08-21	DIA	ETF	345.3	345.72	342.49	344.67	3176500.0
2023-08-21	GLD	ETF	175.9	175.94	174.96	175.81	4206400.0
2023-08-21	TLT	ETF	92.66	92.76	92.23	92.52	29254100.0
2023-08-21	AAA	ETF	24.83	24.83	24.74	24.79	1700.0
2023-08-21	AAAU	ETF	18.78	18.78	18.68	18.77	1108400.0
2023-08-21	AADR	ETF	49.36	50.66	49.36	50.66	2400.0
2023-08-21	AAPB	ETF	24.22	24.37	23.91	24.32	14042.0
2023-08-21	AAPD	ETF	22.3	22.47	22.19	22.22	77170.0
2023-08-21	AAPU	ETF	24.76	24.97	24.49	24.92	110490.0
2023-08-21	AAXJ	ETF	63.8	64.2	63.76	64.16	852500.0
2023-08-21	ABEQ	ETF	27.77	27.82	27.67	27.77	8700.0
2023-08-21	ACES	ETF	40.43	40.57	39.95	40.16	39600.0
2023-08-21	ACIO	ETF	30.97	31.03	30.76	30.985	57300.0
2023-08-21	ACT	ETF	28.8	28.93	28.1125	28.46	91690.0
2023-08-21	ACTV	ETF	31.51	31.51	31.25	31.394	8000.0
2023-08-21	ACVF	ETF	33.7	33.93	33.65	33.876	8400.0
2023-08-21	ACWF	ETF	34.73	34.87	34.6503	34.8689	18298.0
2023-08-21	ACWI	ETF	93.99	94.37	93.51	94.22	1641600.0
2023-08-21	ACWV	ETF	96.52	96.73	96.22	96.64	97900.0
2023-08-21	ACWX	ETF	47.65	47.83	47.51	47.79	962400.0
2023-08-21	ADFI	ETF	8.27	8.29	8.27	8.27	87900.0
2023-08-21	ADIV	ETF	13.25	13.25	13.245	13.245	600.0
2023-08-21	ADME	ETF	35.795	36.1	35.795	36.038	7900.0
2023-08-21	ADPV	ETF	24.14	24.3303	24.03	24.3303	989.0
2023-08-21	AEMB	ETF	36.75	36.75	36.54	36.54	400.0
2023-08-21	AESR	ETF	12.503	12.591	12.49	12.591	2700.0
2023-08-21	AFIF	ETF	8.9	8.91	8.86	8.89	85300.0
2023-08-21	AFK	ETF	14.35	14.47	14.25	14.44	9300.0
2023-08-21	AFLG	ETF	25.024	25.151	25.024	25.151	300.0
2023-08-21	AFTY	ETF	14.7	14.724	14.7	14.724	300.0
2023-08-21	AGG	ETF	95.26	95.3	95.04	95.14	13362300.0
2023-08-21	AGGH	ETF	22.0	22.0	21.85	21.85	11887.0
2023-08-21	AGGY	ETF	42.13	42.13	42.03	42.07	127300.0
2023-08-21	AGNG	ETF	26.92	27.11	26.92	27.03	5100.0
2023-08-21	AGOV	ETF	74.22	75.602	74.22	75.602	392.0
2023-08-21	AGOX	ETF	22.92	23.165	22.92	23.08	10600.0
2023-08-21	AGQ	ETF	27.45	27.66	26.69	27.59	925000.0
2023-08-21	AGRH	ETF	25.66	25.66	25.66	25.66	101.0
2023-08-21	AGZ	ETF	106.23	106.23	106.14	106.17	32400.0
2023-08-21	AGZD	ETF	22.19	22.19	22.11	22.16	224200.0
2023-08-21	AHYB	ETF	43.512	43.615	43.512	43.615	600.0
2023-08-21	AIA	ETF	56.2	56.39	56.0	56.38	36600.0
2023-08-21	AIEQ	ETF	30.85	30.89	30.51	30.817	13200.0
2023-08-21	AIQ	ETF	27.01	27.27	26.88	27.24	760600.0
2023-08-21	AIRR	ETF	53.41	53.45	52.68	53.19	57800.0
2023-08-21	AIVI	ETF	37.91	38.07	37.91	38.07	800.0
2023-08-21	AIVL	ETF	92.58	92.88	92.52	92.77	3000.0

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

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