PREVIEW / etf_daily / 2023-11-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-21.parquet
  size:    112 KB
  rows:    3,139

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-21	SPY	ETF	453.18	454.13	451.96	453.27	49244600.0
2023-11-21	QQQ	ETF	389.01	389.23	386.7	388.47	43336989.0
2023-11-21	IWM	ETF	178.24	178.51	176.91	177.02	30457000.0
2023-11-21	DIA	ETF	351.11	351.21	350.36	350.82	1849500.0
2023-11-21	GLD	ETF	185.57	186.12	185.07	185.35	7322400.0
2023-11-21	TLT	ETF	90.5	90.8	89.89	90.55	27721000.0
2023-11-21	AAA	ETF	24.87	24.935	24.87	24.935	2000.0
2023-11-21	AAAU	ETF	19.81	19.89	19.78	19.8	1092300.0
2023-11-21	AADR	ETF	52.49	52.49	52.3	52.3	500.0
2023-11-21	AAPB	ETF	27.34	27.34	27.01	27.18	8392.0
2023-11-21	AAPD	ETF	20.43	20.5799	20.41	20.48	171055.0
2023-11-21	AAPU	ETF	27.6	27.6	27.28	27.46	87248.0
2023-11-21	AAXJ	ETF	66.06	66.25	65.76	65.87	695700.0
2023-11-21	ABEQ	ETF	27.695	27.74	27.68	27.682	21700.0
2023-11-21	ACES	ETF	31.07	31.22	30.52	30.61	71800.0
2023-11-21	ACIO	ETF	32.35	32.36	31.5	32.11	55500.0
2023-11-21	ACSI	ETF	47.32	47.32	47.32	47.32	100.0
2023-11-21	ACT	ETF	27.78	27.8	27.56	27.69	212622.0
2023-11-21	ACTV	ETF	29.69	29.69	29.55	29.59	8400.0
2023-11-21	ACVF	ETF	34.595	34.655	34.595	34.647	1400.0
2023-11-21	ACWF	ETF	36.31	36.31	36.2327	36.2559	2596.0
2023-11-21	ACWI	ETF	97.53	97.53	97.21	97.37	3352300.0
2023-11-21	ACWV	ETF	97.75	98.11	97.75	97.88	106700.0
2023-11-21	ACWX	ETF	49.24	49.27	48.98	49.04	883900.0
2023-11-21	ADFI	ETF	8.33	8.36	8.3	8.315	32300.0
2023-11-21	ADIV	ETF	13.92	13.92	13.907	13.907	600.0
2023-11-21	ADME	ETF	36.906	37.07	36.83	37.06	12400.0
2023-11-21	ADPV	ETF	23.6	23.6	23.3301	23.3941	4358.0
2023-11-21	ADVE	ETF	30.79	30.79	30.72	30.72	112.0
2023-11-21	AEMB	ETF	36.55	36.555	36.55	36.555	300.0
2023-11-21	AESR	ETF	13.02	13.03	12.99	12.99	63500.0
2023-11-21	AETH	ETF	29.98	30.34	29.45	29.9723	3207.0
2023-11-21	AFIF	ETF	8.9	8.94	8.9	8.91	37300.0
2023-11-21	AFK	ETF	14.0	14.0	13.71	13.91	5800.0
2023-11-21	AFLG	ETF	26.123	26.123	26.123	26.123	100.0
2023-11-21	AFMC	ETF	24.365	24.365	24.365	24.365	100.0
2023-11-21	AFSM	ETF	24.45	24.45	24.45	24.45	100.0
2023-11-21	AFTY	ETF	14.418	14.418	14.418	14.418	100.0
2023-11-21	AGG	ETF	95.45	95.57	95.28	95.5	7393800.0
2023-11-21	AGGH	ETF	21.56	21.6399	21.4	21.4	5429.0
2023-11-21	AGGY	ETF	42.36	42.39	42.29	42.31	58300.0
2023-11-21	AGNG	ETF	26.33	26.36	26.33	26.36	400.0
2023-11-21	AGOX	ETF	23.2	23.56	22.53	23.47	76100.0
2023-11-21	AGQ	ETF	27.92	28.23	27.56	27.68	945600.0
2023-11-21	AGQI	ETF	12.72	12.76	12.54	12.62	629400.0
2023-11-21	AGRH	ETF	25.72	25.72	25.7099	25.7099	1237.0
2023-11-21	AGZ	ETF	106.51	106.88	106.48	106.65	67500.0
2023-11-21	AGZD	ETF	22.41	22.41	22.3	22.38	114400.0
2023-11-21	AHLT	ETF	24.45	24.4553	24.36	24.4553	2100.0
2023-11-21	AHOY	ETF	20.79	20.79	20.6549	20.6549	300.0

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

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