PREVIEW / etf_daily / 2023-11-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-03.parquet
  size:    111 KB
  rows:    3,105

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-11-03	SPY	ETF	433.14	436.29	433.01	434.69	100110800.0
2023-11-03	QQQ	ETF	364.75	369.02	364.52	367.71	53280457.0
2023-11-03	IWM	ETF	172.8	175.65	172.78	174.49	57041300.0
2023-11-03	DIA	ETF	340.12	341.62	339.39	340.61	4043800.0
2023-11-03	GLD	ETF	184.48	185.47	184.35	184.79	8529000.0
2023-11-03	TLT	ETF	88.81	89.05	87.58	87.63	77668500.0
2023-11-03	AAA	ETF	24.94	24.94	24.875	24.875	2600.0
2023-11-03	AAAU	ETF	19.7	19.81	19.69	19.74	1283100.0
2023-11-03	AADR	ETF	49.59	49.87	49.59	49.87	400.0
2023-11-03	AAPB	ETF	23.28	23.86	23.15	23.86	35930.0
2023-11-03	AAPD	ETF	22.37	22.5	22.07	22.08	510697.0
2023-11-03	AAPU	ETF	24.01	24.54	23.8252	24.49	410603.0
2023-11-03	AAPY	ETF	25.85	26.0259	25.85	26.0259	628.0
2023-11-03	AAXJ	ETF	63.78	64.31	63.7	64.24	1722700.0
2023-11-03	ABEQ	ETF	27.46	27.66	27.45	27.56	9000.0
2023-11-03	ACES	ETF	32.11	32.58	32.017	32.1	30700.0
2023-11-03	ACIO	ETF	31.0	31.121	30.99	31.07	166600.0
2023-11-03	ACSI	ETF	45.699	45.699	45.699	45.699	100.0
2023-11-03	ACT	ETF	28.22	28.45	28.17	28.23	328990.0
2023-11-03	ACTV	ETF	29.15	29.398	29.15	29.27	5700.0
2023-11-03	ACVF	ETF	33.4	33.55	33.291	33.48	4500.0
2023-11-03	ACWF	ETF	34.57	34.93	34.57	34.831	6345.0
2023-11-03	ACWI	ETF	93.4	94.07	93.4	93.79	3144100.0
2023-11-03	ACWV	ETF	96.66	96.85	96.38	96.58	285100.0
2023-11-03	ACWX	ETF	47.39	47.73	47.39	47.6	3332100.0
2023-11-03	ADFI	ETF	8.24	8.25	8.21	8.247	23400.0
2023-11-03	ADIV	ETF	13.44	13.513	13.44	13.513	1100.0
2023-11-03	ADME	ETF	35.58	35.7	35.53	35.57	74300.0
2023-11-03	ADPV	ETF	22.395	22.42	22.395	22.4	1616.0
2023-11-03	AEMB	ETF	35.89	36.19	35.89	36.08	1000.0
2023-11-03	AESR	ETF	12.36	12.365	12.323	12.34	22300.0
2023-11-03	AETH	ETF	27.03	27.3908	27.03	27.3908	741.0
2023-11-03	AFIF	ETF	8.94	8.94	8.9	8.9	12200.0
2023-11-03	AFK	ETF	13.8	14.1	13.74	14.04	6500.0
2023-11-03	AFLG	ETF	25.199	25.199	25.199	25.199	100.0
2023-11-03	AFMC	ETF	23.86	23.86	23.761	23.761	400.0
2023-11-03	AFSM	ETF	23.952	23.952	23.952	23.952	100.0
2023-11-03	AFTY	ETF	14.33	14.401	14.33	14.401	300.0
2023-11-03	AGG	ETF	94.54	94.69	94.14	94.18	11890300.0
2023-11-03	AGGH	ETF	21.39	21.4	21.2	21.2	106815.0
2023-11-03	AGGY	ETF	41.77	41.86	41.67	41.71	152100.0
2023-11-03	AGNG	ETF	25.751	25.864	25.751	25.819	900.0
2023-11-03	AGOV	ETF	71.54	72.7616	71.54	72.7616	190.0
2023-11-03	AGOX	ETF	22.96	22.96	22.775	22.82	12600.0
2023-11-03	AGQ	ETF	25.95	26.77	25.83	26.47	1265400.0
2023-11-03	AGZ	ETF	106.13	106.35	105.92	106.12	41800.0
2023-11-03	AGZD	ETF	22.3	22.4	22.03	22.15	174200.0
2023-11-03	AHLT	ETF	25.2	25.25	25.08	25.1077	2973.0
2023-11-03	AHYB	ETF	43.69	43.866	43.69	43.866	900.0
2023-11-03	AIA	ETF	56.71	57.16	56.64	57.02	42200.0

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

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