PREVIEW / etf_daily / 2023-10-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-12.parquet
  size:    109 KB
  rows:    3,071

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-10-12	SPY	ETF	436.95	437.34	431.23	433.66	81154200.0
2023-10-12	QQQ	ETF	371.73	373.74	367.5	369.93	49587942.0
2023-10-12	IWM	ETF	175.88	175.88	170.79	171.7	38693800.0
2023-10-12	DIA	ETF	338.77	338.77	334.57	336.27	3315000.0
2023-10-12	GLD	ETF	174.06	174.23	173.24	173.26	5912700.0
2023-10-12	TLT	ETF	88.05	88.19	85.93	86.07	66986700.0
2023-10-12	AAA	ETF	24.779	24.819	24.779	24.815	2200.0
2023-10-12	AAAU	ETF	18.6	18.61	18.51	18.51	1782000.0
2023-10-12	AADR	ETF	48.87	49.89	48.87	49.68	2400.0
2023-10-12	AAPB	ETF	24.98	25.4057	24.77	25.08	13392.0
2023-10-12	AAPD	ETF	21.66	21.7293	21.34	21.54	444321.0
2023-10-12	AAPU	ETF	25.42	25.8151	25.1501	25.5	170201.0
2023-10-12	AAXJ	ETF	64.83	64.83	63.92	64.03	527800.0
2023-10-12	ABEQ	ETF	27.27	27.305	27.2	27.21	6400.0
2023-10-12	ACES	ETF	35.2	35.2	33.81	34.08	70800.0
2023-10-12	ACIO	ETF	30.85	30.93	30.61	30.74	52800.0
2023-10-12	ACSI	ETF	44.776	44.776	44.776	44.776	100.0
2023-10-12	ACT	ETF	28.07	28.25	27.91	28.23	132934.0
2023-10-12	ACTV	ETF	29.73	29.73	28.79	28.896	14200.0
2023-10-12	ACVF	ETF	33.56	33.56	33.361	33.361	900.0
2023-10-12	ACWF	ETF	35.0	35.0	34.6401	34.71	4381.0
2023-10-12	ACWI	ETF	94.12	94.12	92.84	93.3	2831800.0
2023-10-12	ACWV	ETF	96.33	96.33	95.12	95.43	174800.0
2023-10-12	ACWX	ETF	47.6	47.62	46.92	47.08	830200.0
2023-10-12	ADFI	ETF	8.19	8.21	8.17	8.19	35200.0
2023-10-12	ADIV	ETF	13.33	13.33	13.33	13.33	100.0
2023-10-12	ADME	ETF	35.66	35.74	35.48	35.516	17000.0
2023-10-12	ADPV	ETF	24.51	24.51	24.14	24.1914	1815.0
2023-10-12	AEMB	ETF	35.3	35.41	35.2	35.2	4300.0
2023-10-12	AESR	ETF	12.556	12.58	12.395	12.48	38800.0
2023-10-12	AETH	ETF	23.0519	23.0519	22.715	22.8123	2000.0
2023-10-12	AFIF	ETF	8.93	8.93	8.9	8.9	9600.0
2023-10-12	AFK	ETF	14.1	14.1	13.63	13.75	11700.0
2023-10-12	AFLG	ETF	25.039	25.039	25.039	25.039	100.0
2023-10-12	AFMC	ETF	23.578	23.578	23.539	23.539	300.0
2023-10-12	AFTY	ETF	14.48	14.48	14.47	14.47	300.0
2023-10-12	AGG	ETF	93.87	93.91	93.17	93.24	11189800.0
2023-10-12	AGGH	ETF	21.32	21.32	21.12	21.12	273715.0
2023-10-12	AGGY	ETF	41.51	41.555	41.2	41.28	158500.0
2023-10-12	AGNG	ETF	26.05	26.05	25.65	25.68	1700.0
2023-10-12	AGOV	ETF	72.66	72.66	72.66	72.66	144.0
2023-10-12	AGOX	ETF	22.89	22.903	22.64	22.68	24900.0
2023-10-12	AGQ	ETF	24.2	24.38	23.45	23.56	903000.0
2023-10-12	AGZ	ETF	105.62	105.71	105.39	105.49	15500.0
2023-10-12	AGZD	ETF	22.19	22.22	22.12	22.16	39400.0
2023-10-12	AHYB	ETF	43.02	43.069	42.921	42.921	600.0
2023-10-12	AIA	ETF	57.26	57.26	56.28	56.4	31700.0
2023-10-12	AIEQ	ETF	30.08	30.08	29.602	29.774	5300.0
2023-10-12	AIQ	ETF	27.85	27.92	27.382	27.56	254800.0
2023-10-12	AIRR	ETF	51.89	51.89	50.52	50.78	101000.0

> showing 50 of 3,071 rows — these rows as CSV

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