PREVIEW / etf_daily / 2023-02-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-22.parquet
  size:    109 KB
  rows:    2,937

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-02-22	SPY	ETF	399.52	401.13	397.02	398.54	83742300.0
2023-02-22	QQQ	ETF	294.62	296.3599	292.56	294.25	51389237.0
2023-02-22	IWM	ETF	187.83	189.15	186.75	187.94	24651700.0
2023-02-22	DIA	ETF	331.75	332.43	329.45	330.52	2896400.0
2023-02-22	GLD	ETF	170.81	170.96	169.56	169.66	4105700.0
2023-02-22	TLT	ETF	100.99	101.69	100.95	101.31	15165400.0
2023-02-22	AAA	ETF	24.729	24.729	24.715	24.715	100.0
2023-02-22	AAAU	ETF	18.22	18.23	18.08	18.09	8823000.0
2023-02-22	AADR	ETF	48.33	48.51	48.33	48.51	1400.0
2023-02-22	AAPB	ETF	19.19	19.23	18.98	19.1476	6009.0
2023-02-22	AAPD	ETF	26.35	26.61	26.16	26.3	184237.0
2023-02-22	AAPU	ETF	20.17	20.3901	19.88	20.23	52882.0
2023-02-22	AAXJ	ETF	67.19	67.19	66.63	66.81	722300.0
2023-02-22	ABEQ	ETF	27.86	27.98	27.82	27.859	4000.0
2023-02-22	ACES	ETF	48.63	49.12	48.09	48.7	61000.0
2023-02-22	ACIO	ETF	29.538	29.566	29.445	29.5	18300.0
2023-02-22	ACSI	ETF	44.59	44.6532	44.59	44.6532	227.0
2023-02-22	ACT	ETF	24.06	24.38	24.05	24.25	122173.0
2023-02-22	ACTV	ETF	32.11	32.4	32.11	32.18	3672.0
2023-02-22	ACVF	ETF	30.83	30.95	30.738	30.738	1100.0
2023-02-22	ACWF	ETF	33.1	33.2	32.94	33.0209	13036.0
2023-02-22	ACWI	ETF	89.18	89.43	88.63	88.92	3636800.0
2023-02-22	ACWV	ETF	95.04	95.08	94.48	94.62	162000.0
2023-02-22	ACWX	ETF	48.08	48.11	47.735	47.84	1902004.0
2023-02-22	ADFI	ETF	8.39	8.4	8.37	8.375	11000.0
2023-02-22	ADIV	ETF	14.04	14.04	13.971	13.971	400.0
2023-02-22	ADME	ETF	33.99	34.08	33.938	33.97	30000.0
2023-02-22	ADPV	ETF	25.19	25.215	25.01	25.01	34710.0
2023-02-22	ADRE	ETF	39.76	39.76	39.3279	39.6	19829.0
2023-02-22	AEMB	ETF	37.545	37.63	37.516	37.516	700.0
2023-02-22	AESR	ETF	11.63	11.668	11.57	11.64	19100.0
2023-02-22	AFIF	ETF	8.86	8.86	8.83	8.84	17035.0
2023-02-22	AFK	ETF	16.4	16.4	16.21	16.21	6083.0
2023-02-22	AFLG	ETF	24.01	24.01	23.862	23.862	100.0
2023-02-22	AFMC	ETF	23.78	23.78	23.716	23.716	500.0
2023-02-22	AFSM	ETF	24.17	24.17	24.164	24.164	400.0
2023-02-22	AFTY	ETF	16.573	16.573	16.573	16.573	100.0
2023-02-22	AGG	ETF	97.4	97.59	97.3	97.34	5862300.0
2023-02-22	AGGY	ETF	42.81	42.895	42.777	42.81	107600.0
2023-02-22	AGNG	ETF	26.635	26.635	26.5	26.5	1300.0
2023-02-22	AGOX	ETF	21.65	21.76	21.575	21.629	17700.0
2023-02-22	AGQ	ETF	25.92	25.92	25.06	25.14	407100.0
2023-02-22	AGRH	ETF	25.65	25.65	25.59	25.59	133.0
2023-02-22	AGZ	ETF	106.74	106.82	106.66	106.66	24071.0
2023-02-22	AGZD	ETF	21.92	22.06	21.855	22.06	159400.0
2023-02-22	AHHX	ETF	8.4801	8.51	8.48	8.5056	5469.0
2023-02-22	AHYB	ETF	43.06	43.25	43.06	43.1	600.0
2023-02-22	AIA	ETF	60.21	60.29	59.65	59.86	73674.0
2023-02-22	AIEQ	ETF	30.69	31.059	30.6	30.914	72300.0
2023-02-22	AIQ	ETF	22.75	22.8499	22.51	22.55	29443.0

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

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