PREVIEW / etf_daily / 2023-11-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-22.parquet
  size:    113 KB
  rows:    3,158

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-22	SPY	ETF	454.98	456.38	453.89	455.02	59394900.0
2023-11-22	QQQ	ETF	390.57	393.07	389.04	390.06	44178572.0
2023-11-22	IWM	ETF	178.18	179.39	177.42	178.13	28940900.0
2023-11-22	DIA	ETF	351.89	353.14	351.5	352.56	3486200.0
2023-11-22	GLD	ETF	185.47	185.72	184.27	184.56	4337700.0
2023-11-22	TLT	ETF	91.12	91.32	90.38	90.87	31197500.0
2023-11-22	AAA	ETF	25.01	25.01	24.88	24.916	2300.0
2023-11-22	AAAU	ETF	19.83	19.84	19.69	19.72	2351300.0
2023-11-22	AADR	ETF	52.43	52.53	52.37	52.53	400.0
2023-11-22	AAPB	ETF	27.5	27.55	27.18	27.31	18217.0
2023-11-22	AAPD	ETF	20.42	20.475	20.26	20.43	99050.0
2023-11-22	AAPU	ETF	27.61	27.9106	27.49	27.57	95187.0
2023-11-22	AAPY	ETF	26.5565	26.57	26.5565	26.56	810.0
2023-11-22	AAXJ	ETF	65.78	65.92	65.5	65.77	596900.0
2023-11-22	ABEQ	ETF	27.7	27.758	27.69	27.758	10400.0
2023-11-22	ACES	ETF	30.76	30.85	30.4	30.53	157000.0
2023-11-22	ACIO	ETF	32.31	32.31	32.16	32.25	56300.0
2023-11-22	ACSI	ETF	47.641	47.641	47.641	47.641	100.0
2023-11-22	ACT	ETF	27.87	27.95	27.66	27.8	110074.0
2023-11-22	ACTV	ETF	29.6	29.82	29.6	29.72	9600.0
2023-11-22	ACVF	ETF	34.63	34.8	34.63	34.759	6900.0
2023-11-22	ACWF	ETF	36.45	36.54	36.33	36.3916	25488.0
2023-11-22	ACWI	ETF	97.61	97.83	97.32	97.64	3275500.0
2023-11-22	ACWV	ETF	98.19	98.35	98.04	98.26	291300.0
2023-11-22	ACWX	ETF	49.09	49.13	48.86	49.09	1158400.0
2023-11-22	ADFI	ETF	8.34	8.34	8.315	8.332	21200.0
2023-11-22	ADIV	ETF	13.85	13.9	13.836	13.836	4700.0
2023-11-22	ADME	ETF	37.01	37.15	37.01	37.134	39100.0
2023-11-22	ADPV	ETF	23.53	23.569	23.53	23.569	1520.0
2023-11-22	ADVE	ETF	30.74	30.7826	30.74	30.7826	3102.0
2023-11-22	AEMB	ETF	36.686	36.686	36.686	36.686	100.0
2023-11-22	AESR	ETF	13.04	13.11	13.04	13.09	105400.0
2023-11-22	AETH	ETF	30.7	31.2737	30.7	31.2737	318.0
2023-11-22	AFIF	ETF	8.96	8.96	8.9	8.9	16300.0
2023-11-22	AFK	ETF	13.73	13.94	13.7	13.83	15700.0
2023-11-22	AFLG	ETF	26.25	26.25	26.25	26.25	100.0
2023-11-22	AFMC	ETF	24.51	24.51	24.51	24.51	100.0
2023-11-22	AFSM	ETF	24.63	24.63	24.6	24.6	1200.0
2023-11-22	AFTY	ETF	14.25	14.25	14.25	14.25	100.0
2023-11-22	AGG	ETF	95.68	95.75	95.37	95.59	6329900.0
2023-11-22	AGGH	ETF	21.4899	21.53	21.4	21.43	17329.0
2023-11-22	AGGY	ETF	42.44	42.47	42.33	42.44	343200.0
2023-11-22	AGNG	ETF	26.5	26.5	26.43	26.5	14400.0
2023-11-22	AGOX	ETF	23.644	23.72	23.59	23.6	18800.0
2023-11-22	AGQ	ETF	27.48	27.73	27.12	27.36	636500.0
2023-11-22	AGQI	ETF	12.73	12.76	12.56	12.71	2415554.0
2023-11-22	AGZ	ETF	106.61	106.77	106.48	106.62	23600.0
2023-11-22	AGZD	ETF	22.3	22.48	22.3	22.42	22400.0
2023-11-22	AHLT	ETF	24.55	24.6	24.52	24.557	1085.0
2023-11-22	AHYB	ETF	44.135	44.212	43.97	44.212	6700.0

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

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