PREVIEW / etf_daily / 2023-02-24

all etf daily files

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

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-24	SPY	ETF	395.42	397.25	393.64	396.38	108194400.0
2023-02-24	QQQ	ETF	291.76	292.97	290.05	291.85	74331958.0
2023-02-24	IWM	ETF	186.65	187.78	185.78	187.51	24280700.0
2023-02-24	DIA	ETF	327.83	329.14	326.43	328.12	3764700.0
2023-02-24	GLD	ETF	168.42	168.84	168.19	168.35	6496500.0
2023-02-24	TLT	ETF	101.44	101.8	100.56	100.97	21403600.0
2023-02-24	AAA	ETF	24.69	24.69	24.69	24.69	37.0
2023-02-24	AAAU	ETF	17.97	18.01	17.94	17.96	614200.0
2023-02-24	AADR	ETF	47.93	47.93	47.93	47.93	100.0
2023-02-24	AAPB	ETF	18.6698	18.72	18.53	18.72	1915.0
2023-02-24	AAPD	ETF	26.68	26.88	26.65	26.71	115955.0
2023-02-24	AAPU	ETF	19.83	19.85	19.6	19.77	75908.0
2023-02-24	AAXJ	ETF	65.63	65.78	65.23	65.48	563300.0
2023-02-24	ABEQ	ETF	27.655	27.81	27.655	27.755	6600.0
2023-02-24	ACES	ETF	47.35	47.35	46.42	47.01	30000.0
2023-02-24	ACIO	ETF	29.43	29.48	29.29	29.44	35200.0
2023-02-24	ACSI	ETF	44.1761	44.1761	44.1761	44.1761	39.0
2023-02-24	ACT	ETF	24.21	24.5	23.92	24.48	93149.0
2023-02-24	ACTV	ETF	31.77	31.98	31.74	31.9282	20405.0
2023-02-24	ACVF	ETF	30.51	30.69	30.48	30.648	1800.0
2023-02-24	ACWF	ETF	32.7	32.809	32.6401	32.809	3280.0
2023-02-24	ACWI	ETF	87.96	88.29	87.66	88.16	2460100.0
2023-02-24	ACWV	ETF	93.52	93.77	93.35	93.64	119100.0
2023-02-24	ACWX	ETF	47.22	47.38	47.05	47.23	1961914.0
2023-02-24	ADFI	ETF	8.36	8.38	8.35	8.37	19100.0
2023-02-24	ADIV	ETF	13.751	13.751	13.751	13.751	100.0
2023-02-24	ADME	ETF	33.674	33.824	33.674	33.75	13200.0
2023-02-24	ADPV	ETF	24.98	25.1228	24.92	25.1228	14684.0
2023-02-24	ADRE	ETF	38.8	38.94	38.6301	38.75	36310.0
2023-02-24	AEMB	ETF	37.708	37.708	37.708	37.708	100.0
2023-02-24	AESR	ETF	11.47	11.57	11.47	11.56	43700.0
2023-02-24	AFIF	ETF	8.8	8.84	8.78	8.825	53702.0
2023-02-24	AFK	ETF	16.15	16.15	15.8701	16.0	11100.0
2023-02-24	AFLG	ETF	23.69	23.78	23.69	23.78	500.0
2023-02-24	AFMC	ETF	23.61	23.742	23.61	23.742	100.0
2023-02-24	AFSM	ETF	24.21	24.292	24.185	24.273	1300.0
2023-02-24	AFTY	ETF	16.07	16.08	15.981	15.981	2800.0
2023-02-24	AGG	ETF	97.22	97.26	96.97	97.13	4866800.0
2023-02-24	AGGY	ETF	42.69	42.73	42.62	42.68	72300.0
2023-02-24	AGNG	ETF	26.12	26.22	26.0	26.22	2600.0
2023-02-24	AGOV	ETF	75.7913	75.7913	75.7913	75.7913	1.0
2023-02-24	AGOX	ETF	21.56	21.61	21.46	21.565	66800.0
2023-02-24	AGQ	ETF	23.78	24.03	23.32	23.39	808800.0
2023-02-24	AGZ	ETF	106.55	106.59	106.428	106.54	50249.0
2023-02-24	AGZD	ETF	21.915	21.955	21.905	21.93	36000.0
2023-02-24	AHHX	ETF	8.5467	8.57	8.5417	8.5417	1650.0
2023-02-24	AHYB	ETF	43.29	43.29	43.19	43.22	1700.0
2023-02-24	AIA	ETF	58.58	58.7	58.053	58.35	137018.0
2023-02-24	AIEQ	ETF	30.03	30.18	29.8	30.03	38200.0
2023-02-24	AIQ	ETF	22.5	22.5	22.1701	22.3	35166.0

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

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