PREVIEW / etf_daily / 2023-09-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-01.parquet
  size:    107 KB
  rows:    2,989

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-09-01	SPY	ETF	453.17	453.67	449.68	451.19	58875700.0
2023-09-01	QQQ	ETF	380.4	380.83	376.0801	377.59	39801177.0
2023-09-01	IWM	ETF	190.07	191.86	189.85	190.85	25081400.0
2023-09-01	DIA	ETF	349.93	350.36	347.75	348.98	2531700.0
2023-09-01	GLD	ETF	180.8	181.12	179.51	180.11	4969300.0
2023-09-01	TLT	ETF	95.8	95.82	94.62	94.85	32466900.0
2023-09-01	AAA	ETF	24.71	24.758	24.71	24.71	800.0
2023-09-01	AAAU	ETF	19.31	19.34	19.17	19.23	1200300.0
2023-09-01	AADR	ETF	51.98	52.54	51.98	52.16	2700.0
2023-09-01	AAPB	ETF	27.57	27.5801	27.3	27.54	23384.0
2023-09-01	AAPD	ETF	20.65	20.7685	20.63	20.65	151695.0
2023-09-01	AAPU	ETF	27.8	27.83	27.52	27.78	100535.0
2023-09-01	AAXJ	ETF	66.46	66.8	66.28	66.43	403600.0
2023-09-01	ABEQ	ETF	28.295	28.295	28.22	28.22	21200.0
2023-09-01	ACES	ETF	42.02	42.22	41.64	41.71	57000.0
2023-09-01	ACIO	ETF	31.636	31.657	31.49	31.6	30200.0
2023-09-01	ACSI	ETF	46.522	46.522	46.522	46.522	100.0
2023-09-01	ACT	ETF	28.8	29.11	28.67	28.76	332292.0
2023-09-01	ACTV	ETF	32.27	32.41	32.2	32.378	10200.0
2023-09-01	ACVF	ETF	34.98	34.98	34.62	34.713	14800.0
2023-09-01	ACWF	ETF	35.98	35.98	35.77	35.8438	10552.0
2023-09-01	ACWI	ETF	97.24	97.39	96.5	96.77	2337800.0
2023-09-01	ACWV	ETF	98.13	98.24	97.53	97.65	104600.0
2023-09-01	ACWX	ETF	49.22	49.29	48.81	48.93	465700.0
2023-09-01	ADFI	ETF	8.415	8.415	8.39	8.4	1700.0
2023-09-01	ADIV	ETF	13.726	13.726	13.7	13.7	300.0
2023-09-01	ADME	ETF	36.97	36.97	36.812	36.906	11800.0
2023-09-01	ADPV	ETF	25.688	25.688	25.64	25.6447	2183.0
2023-09-01	AEMB	ETF	36.92	36.92	36.92	36.92	100.0
2023-09-01	AESR	ETF	13.0	13.02	12.893	12.93	4800.0
2023-09-01	AFIF	ETF	8.94	8.94	8.93	8.93	500.0
2023-09-01	AFK	ETF	14.8	14.8	14.5	14.61	5600.0
2023-09-01	AFLG	ETF	25.813	25.813	25.813	25.813	100.0
2023-09-01	AFMC	ETF	25.255	25.346	25.255	25.346	600.0
2023-09-01	AFSM	ETF	25.33	25.446	25.33	25.446	400.0
2023-09-01	AFTY	ETF	15.2	15.2	15.187	15.187	1900.0
2023-09-01	AGG	ETF	96.54	96.57	95.98	96.04	8132400.0
2023-09-01	AGGH	ETF	22.09	22.1	22.0	22.0407	12004.0
2023-09-01	AGGY	ETF	42.68	42.68	42.435	42.48	126100.0
2023-09-01	AGNG	ETF	27.377	27.45	27.305	27.305	500.0
2023-09-01	AGOV	ETF	75.1	75.1	75.1	75.1	126.0
2023-09-01	AGOX	ETF	23.842	23.94	23.78	23.819	14000.0
2023-09-01	AGQ	ETF	30.87	31.09	29.58	29.61	1125200.0
2023-09-01	AGZ	ETF	106.55	106.75	106.51	106.53	18100.0
2023-09-01	AGZD	ETF	22.17	22.24	22.12	22.23	39400.0
2023-09-01	AHLT	ETF	25.1	25.4885	25.1	25.4885	1711.0
2023-09-01	AHOY	ETF	20.83	20.83	20.7265	20.7265	836.0
2023-09-01	AHYB	ETF	44.09	44.09	44.09	44.09	100.0
2023-09-01	AIA	ETF	59.0	59.48	58.93	58.97	26200.0
2023-09-01	AIEQ	ETF	31.66	31.66	31.52	31.58	9600.0

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

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