PREVIEW / etf_daily / 2023-04-28

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-28.parquet
  size:    109 KB
  rows:    2,930

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-04-28	SPY	ETF	411.49	415.94	411.43	415.93	89335600.0
2023-04-28	QQQ	ETF	320.11	322.65	318.96	322.56	59712635.0
2023-04-28	IWM	ETF	173.29	175.83	173.18	175.2	31897900.0
2023-04-28	DIA	ETF	337.19	341.04	337.13	341.03	3647900.0
2023-04-28	GLD	ETF	184.79	185.38	184.17	184.8	6700400.0
2023-04-28	TLT	ETF	106.21	106.76	105.86	106.46	26949000.0
2023-04-28	AAA	ETF	24.59	24.615	24.59	24.615	144.0
2023-04-28	AAAU	ETF	19.72	19.78	19.65	19.73	922100.0
2023-04-28	AADR	ETF	47.32	48.08	47.32	48.08	700.0
2023-04-28	AAPB	ETF	23.63	23.63	23.37	23.594	2416.0
2023-04-28	AAPD	ETF	23.2	23.2701	23.0273	23.05	133962.0
2023-04-28	AAPU	ETF	23.97	24.22	23.86	24.22	109998.0
2023-04-28	AAXJ	ETF	66.4	66.78	66.36	66.71	401800.0
2023-04-28	ABEQ	ETF	28.82	28.925	28.82	28.905	2100.0
2023-04-28	ACES	ETF	42.42	42.55	41.67	42.52	57300.0
2023-04-28	ACIO	ETF	30.213	30.32	30.168	30.32	19300.0
2023-04-28	ACSI	ETF	44.2593	44.2593	44.2593	44.2593	79.0
2023-04-28	ACT	ETF	23.91	24.19	23.9	24.14	431557.0
2023-04-28	ACTV	ETF	29.52	29.747	29.52	29.6363	5990.0
2023-04-28	ACVF	ETF	31.44	31.65	31.44	31.648	1200.0
2023-04-28	ACWF	ETF	33.81	34.11	33.81	34.1017	3868.0
2023-04-28	ACWI	ETF	91.74	92.59	91.7	92.59	1619600.0
2023-04-28	ACWV	ETF	99.04	99.79	99.04	99.63	281600.0
2023-04-28	ACWX	ETF	49.32	49.7	49.32	49.68	3918986.0
2023-04-28	ADFI	ETF	8.51	8.54	8.51	8.535	53100.0
2023-04-28	ADIV	ETF	13.57	13.57	13.569	13.569	700.0
2023-04-28	ADME	ETF	34.948	35.08	34.93	35.05	19000.0
2023-04-28	AEMB	ETF	37.975	37.975	37.975	37.975	100.0
2023-04-28	AESR	ETF	12.14	12.19	12.13	12.19	35500.0
2023-04-28	AFIF	ETF	8.84	8.84	8.81	8.81	7193.0
2023-04-28	AFK	ETF	15.65	15.871	15.64	15.8228	2664.0
2023-04-28	AFLG	ETF	24.14	24.167	24.14	24.167	4000.0
2023-04-28	AFMC	ETF	23.0	23.01	23.0	23.006	500.0
2023-04-28	AFTY	ETF	16.164	16.164	16.164	16.164	100.0
2023-04-28	AGG	ETF	99.99	99.99	99.72	99.96	5469900.0
2023-04-28	AGGY	ETF	43.78	43.83	43.725	43.82	195400.0
2023-04-28	AGNG	ETF	27.99	28.32	27.99	28.19	104100.0
2023-04-28	AGOV	ETF	79.05	79.05	78.86	78.86	547.0
2023-04-28	AGOX	ETF	21.68	21.798	21.58	21.779	17500.0
2023-04-28	AGQ	ETF	33.13	33.58	32.73	33.51	457800.0
2023-04-28	AGZ	ETF	108.49	108.54	108.3	108.54	129928.0
2023-04-28	AGZD	ETF	21.695	21.79	21.64	21.765	34000.0
2023-04-28	AHOY	ETF	19.375	19.375	19.375	19.375	198.0
2023-04-28	AHYB	ETF	44.05	44.185	44.05	44.137	3300.0
2023-04-28	AIA	ETF	58.4	58.81	58.4	58.71	26626.0
2023-04-28	AIEQ	ETF	27.09	27.49	27.09	27.38	20000.0
2023-04-28	AIQ	ETF	23.62	23.8467	23.53	23.83	251388.0
2023-04-28	AIRR	ETF	45.6	46.21	45.6	46.12	13400.0
2023-04-28	AIVI	ETF	40.37	40.56	40.37	40.52	7800.0
2023-04-28	AIVL	ETF	92.14	92.57	92.14	92.55	3500.0

> showing 50 of 2,930 rows — these rows as CSV

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