PREVIEW / etf_daily / 2023-11-27

all etf daily files

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

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-27	SPY	ETF	454.65	455.49	454.08	454.48	50506000.0
2023-11-27	QQQ	ETF	389.01	391.1499	388.28	389.17	34139656.0
2023-11-27	IWM	ETF	178.5	179.11	177.23	178.73	30665800.0
2023-11-27	DIA	ETF	353.63	354.14	352.78	353.32	2532400.0
2023-11-27	GLD	ETF	186.56	186.8	185.93	186.77	6320400.0
2023-11-27	TLT	ETF	90.3	91.34	90.21	91.3	39804400.0
2023-11-27	AAA	ETF	24.99	24.99	24.911	24.975	1600.0
2023-11-27	AAAU	ETF	19.93	19.96	19.86	19.95	2909500.0
2023-11-27	AADR	ETF	53.75	54.18	53.74	54.18	1400.0
2023-11-27	AAPB	ETF	26.82	27.021	26.74	26.88	9916.0
2023-11-27	AAPD	ETF	20.61	20.71	20.515	20.6	107570.0
2023-11-27	AAPU	ETF	27.26	27.408	27.06	27.21	62902.0
2023-11-27	AAXJ	ETF	65.27	65.45	65.19	65.38	392500.0
2023-11-27	ABEQ	ETF	27.8	27.82	27.76	27.81	4700.0
2023-11-27	ACES	ETF	30.49	30.49	29.98	30.13	965100.0
2023-11-27	ACIO	ETF	32.15	32.28	32.15	32.234	128500.0
2023-11-27	ACSI	ETF	47.604	47.604	47.604	47.604	100.0
2023-11-27	ACT	ETF	27.72	27.81	27.65	27.79	273956.0
2023-11-27	ACTV	ETF	29.82	29.82	29.66	29.718	4200.0
2023-11-27	ACVF	ETF	34.78	34.81	34.72	34.76	4600.0
2023-11-27	ACWF	ETF	36.45	36.45	36.354	36.4013	8663.0
2023-11-27	ACWI	ETF	97.71	97.78	97.53	97.62	8016600.0
2023-11-27	ACWV	ETF	98.38	98.38	98.13	98.18	66600.0
2023-11-27	ACWX	ETF	49.19	49.24	49.07	49.2	1716000.0
2023-11-27	ADFI	ETF	8.32	8.35	8.32	8.345	6300.0
2023-11-27	ADIV	ETF	13.89	13.89	13.804	13.804	700.0
2023-11-27	ADME	ETF	37.072	37.1	37.04	37.055	43500.0
2023-11-27	ADPV	ETF	23.63	23.65	23.52	23.6221	16335.0
2023-11-27	AEMB	ETF	36.644	36.795	36.644	36.795	300.0
2023-11-27	AESR	ETF	13.06	13.08	13.035	13.07	16600.0
2023-11-27	AETH	ETF	30.21	30.24	29.79	29.8433	5115.0
2023-11-27	AFIF	ETF	8.96	8.96	8.93	8.94	8600.0
2023-11-27	AFK	ETF	14.01	14.03	13.85	14.03	3700.0
2023-11-27	AFLG	ETF	26.23	26.23	26.226	26.226	200.0
2023-11-27	AFMC	ETF	24.612	24.631	24.612	24.631	200.0
2023-11-27	AFSM	ETF	24.729	24.729	24.729	24.729	100.0
2023-11-27	AFTY	ETF	14.13	14.13	14.11	14.11	600.0
2023-11-27	AGG	ETF	95.36	95.72	95.33	95.69	8854500.0
2023-11-27	AGGH	ETF	21.235	21.34	21.235	21.292	16229.0
2023-11-27	AGGY	ETF	42.24	42.349	42.19	42.34	152200.0
2023-11-27	AGNG	ETF	26.57	26.64	26.56	26.61	29000.0
2023-11-27	AGOX	ETF	23.77	23.77	23.63	23.72	15600.0
2023-11-27	AGQ	ETF	29.95	30.04	29.5	29.69	983700.0
2023-11-27	AGQI	ETF	12.79	12.79	12.76	12.77	2327249.0
2023-11-27	AGZ	ETF	106.47	106.69	106.47	106.68	20900.0
2023-11-27	AGZD	ETF	22.36	22.59	22.34	22.46	133400.0
2023-11-27	AHLT	ETF	24.358	24.4	24.3543	24.3543	567.0
2023-11-27	AHOY	ETF	20.8361	20.8361	20.815	20.815	212.0
2023-11-27	AHYB	ETF	44.169	44.241	44.169	44.241	1100.0
2023-11-27	AIA	ETF	57.88	58.11	57.82	58.05	32000.0

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

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