PREVIEW / etf_daily / 2023-03-31

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-31.parquet
  size:    110 KB
  rows:    2,955

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-03-31	SPY	ETF	404.66	409.7	404.55	409.39	112062600.0
2023-03-31	QQQ	ETF	315.91	321.17	315.6	320.93	62138097.0
2023-03-31	IWM	ETF	176.4	178.64	176.37	178.4	39602900.0
2023-03-31	DIA	ETF	329.59	332.81	329.51	332.62	2837300.0
2023-03-31	GLD	ETF	184.11	184.42	182.8	183.22	8003300.0
2023-03-31	TLT	ETF	105.35	106.56	105.08	106.37	25396700.0
2023-03-31	AAA	ETF	24.465	24.465	24.465	24.465	0.0
2023-03-31	AAAU	ETF	19.65	19.67	19.51	19.55	1035200.0
2023-03-31	AADR	ETF	47.69	48.19	47.69	47.77	1200.0
2023-03-31	AAPB	ETF	22.1493	22.7	22.1493	22.6827	5602.0
2023-03-31	AAPD	ETF	24.0015	24.0015	23.6377	23.66	169985.0
2023-03-31	AAPU	ETF	22.78	23.32	22.75	23.31	176272.0
2023-03-31	AAXJ	ETF	67.82	68.16	67.72	67.87	303600.0
2023-03-31	ABEQ	ETF	27.89	27.95	27.86	27.94	5700.0
2023-03-31	ACES	ETF	45.42	46.68	45.42	46.49	94700.0
2023-03-31	ACIO	ETF	29.81	30.19	29.81	30.19	47000.0
2023-03-31	ACSI	ETF	44.1	44.4044	44.1	44.4044	208.0
2023-03-31	ACT	ETF	22.77	22.92	20.8401	22.86	123340.0
2023-03-31	ACTV	ETF	29.34	29.87	29.34	29.87	22987.0
2023-03-31	ACTX	ETF	0.073	0.3	0.073	0.3	803.0
2023-03-31	ACVF	ETF	31.19	31.51	31.19	31.51	1400.0
2023-03-31	ACWF	ETF	33.33	33.6312	33.33	33.6312	15795.0
2023-03-31	ACWI	ETF	90.56	91.2	90.45	91.16	3182400.0
2023-03-31	ACWV	ETF	96.11	96.82	96.11	96.75	89200.0
2023-03-31	ACWX	ETF	48.74	48.86	48.66	48.77	1805311.0
2023-03-31	ADFI	ETF	8.51	8.535	8.5	8.535	6500.0
2023-03-31	ADIV	ETF	13.685	13.685	13.685	13.685	100.0
2023-03-31	ADME	ETF	34.42	34.62	34.34	34.6	23100.0
2023-03-31	ADPV	ETF	23.15	23.46	23.15	23.46	6035.0
2023-03-31	AEMB	ETF	37.92	37.92	37.92	37.92	100.0
2023-03-31	AESR	ETF	11.881	12.02	11.881	12.02	30600.0
2023-03-31	AFIF	ETF	8.73	8.7802	8.73	8.7802	19717.0
2023-03-31	AFK	ETF	16.15	16.27	15.84	15.9689	35787.0
2023-03-31	AFLG	ETF	23.91	24.035	23.9	24.035	1100.0
2023-03-31	AFMC	ETF	23.149	23.149	23.149	23.149	100.0
2023-03-31	AFSM	ETF	23.158	23.22	23.07	23.22	106300.0
2023-03-31	AFTY	ETF	16.31	16.34	16.269	16.269	200.0
2023-03-31	AGG	ETF	99.39	99.69	99.16	99.64	8521600.0
2023-03-31	AGGH	ETF	22.84	22.84	22.8141	22.8141	323.0
2023-03-31	AGGY	ETF	43.57	43.7	43.48	43.69	194200.0
2023-03-31	AGNG	ETF	26.64	26.787	26.64	26.787	2200.0
2023-03-31	AGOV	ETF	82.0	82.0	76.07	77.77	925.0
2023-03-31	AGOX	ETF	21.69	21.792	21.62	21.792	18300.0
2023-03-31	AGQ	ETF	31.05	31.48	30.9	31.23	689800.0
2023-03-31	AGZ	ETF	107.99	108.23	107.95	108.23	139429.0
2023-03-31	AGZD	ETF	21.8	21.8	21.75	21.765	110200.0
2023-03-31	AHYB	ETF	44.11	44.35	44.11	44.35	1800.0
2023-03-31	AIA	ETF	62.05	62.12	61.7	61.89	36666.0
2023-03-31	AIEQ	ETF	28.47	29.135	28.47	29.135	12800.0
2023-03-31	AIQ	ETF	24.51	24.64	24.24	24.59	58762.0

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

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