PREVIEW / etf_daily / 2023-04-25

all etf daily files

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

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-25	SPY	ETF	410.58	411.16	406.02	406.08	97766700.0
2023-04-25	QQQ	ETF	314.29	314.97	309.89	309.99	57121644.0
2023-04-25	IWM	ETF	175.63	175.94	173.01	173.06	28857900.0
2023-04-25	DIA	ETF	338.17	338.68	335.2	335.33	2745300.0
2023-04-25	GLD	ETF	184.84	186.22	184.3	185.75	8451900.0
2023-04-25	TLT	ETF	106.33	107.13	106.28	106.96	21899900.0
2023-04-25	AAA	ETF	24.61	24.61	24.576	24.61	2803.0
2023-04-25	AAAU	ETF	19.73	19.88	19.67	19.83	3291000.0
2023-04-25	AADR	ETF	47.42	47.42	47.3	47.3	500.0
2023-04-25	AAPB	ETF	22.6	22.85	22.25	22.25	15471.0
2023-04-25	AAPD	ETF	23.68	23.87	23.5058	23.87	170894.0
2023-04-25	AAPU	ETF	23.3	23.46	22.961	23.0	62170.0
2023-04-25	AAXJ	ETF	65.36	65.48	64.93	64.95	1844600.0
2023-04-25	ABEQ	ETF	28.53	28.55	28.44	28.487	84700.0
2023-04-25	ACES	ETF	43.66	43.67	42.98	43.06	138200.0
2023-04-25	ACIO	ETF	30.0	30.18	29.95	29.985	22400.0
2023-04-25	ACSI	ETF	43.3461	43.3461	43.3461	43.3461	28.0
2023-04-25	ACT	ETF	23.92	24.14	23.765	23.96	128044.0
2023-04-25	ACTV	ETF	28.96	29.037	28.73	28.7601	8604.0
2023-04-25	ACVF	ETF	31.42	31.42	31.02	31.02	4700.0
2023-04-25	ACWF	ETF	33.64	33.72	33.42	33.42	5270.0
2023-04-25	ACWI	ETF	91.66	91.73	90.71	90.73	3988400.0
2023-04-25	ACWV	ETF	98.95	99.22	98.68	98.72	109500.0
2023-04-25	ACWX	ETF	49.35	49.4	48.95	48.96	778649.0
2023-04-25	ADFI	ETF	8.55	8.58	8.525	8.566	26700.0
2023-04-25	ADIV	ETF	13.332	13.332	13.332	13.332	100.0
2023-04-25	ADME	ETF	34.71	34.8	34.565	34.59	49300.0
2023-04-25	ADPV	ETF	22.743	22.743	22.5999	22.5999	1262.0
2023-04-25	AEMB	ETF	37.75	37.75	37.75	37.75	100.0
2023-04-25	AESR	ETF	12.08	12.09	11.98	11.99	29900.0
2023-04-25	AFIF	ETF	8.8301	8.8499	8.83	8.84	5937.0
2023-04-25	AFK	ETF	15.85	15.85	15.53	15.5836	12773.0
2023-04-25	AFLG	ETF	23.734	23.734	23.734	23.734	100.0
2023-04-25	AFMC	ETF	22.96	22.96	22.656	22.656	1800.0
2023-04-25	AFSM	ETF	22.72	22.72	22.683	22.683	100.0
2023-04-25	AFTY	ETF	15.75	15.75	15.718	15.725	1100.0
2023-04-25	AGG	ETF	99.97	100.25	99.96	100.18	5065400.0
2023-04-25	AGGH	ETF	22.97	22.9709	22.97	22.9709	257.0
2023-04-25	AGGY	ETF	43.81	43.92	43.81	43.895	38900.0
2023-04-25	AGNG	ETF	28.28	28.28	28.11	28.11	900.0
2023-04-25	AGOV	ETF	77.0	77.865	77.0	77.83	703.0
2023-04-25	AGOX	ETF	21.51	21.51	21.27	21.296	26700.0
2023-04-25	AGQ	ETF	33.32	33.55	32.4	33.39	746800.0
2023-04-25	AGZ	ETF	108.47	108.78	108.47	108.74	80245.0
2023-04-25	AGZD	ETF	21.755	21.8	21.705	21.705	94800.0
2023-04-25	AHYB	ETF	44.072	44.072	43.994	43.994	900.0
2023-04-25	AIA	ETF	57.58	57.58	56.91	57.005	57755.0
2023-04-25	AIEQ	ETF	27.68	27.79	27.227	27.227	21500.0
2023-04-25	AIQ	ETF	23.36	23.36	22.85	22.93	75518.0
2023-04-25	AIRR	ETF	45.42	45.723	45.08	45.19	65400.0

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

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