PREVIEW / etf_daily / 2023-08-04

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-04.parquet
  size:    108 KB
  rows:    2,987

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-08-04	SPY	ETF	450.72	452.9	446.27	446.81	100052300.0
2023-08-04	QQQ	ETF	375.75	378.1	371.53	372.04	61702759.0
2023-08-04	IWM	ETF	194.82	196.31	193.71	194.17	24937100.0
2023-08-04	DIA	ETF	353.12	354.96	350.2	350.65	4268300.0
2023-08-04	GLD	ETF	180.25	180.77	179.85	180.19	5325700.0
2023-08-04	TLT	ETF	95.15	96.68	95.13	96.53	42053300.0
2023-08-04	AAA	ETF	24.698	24.7	24.67	24.67	700.0
2023-08-04	AAAU	ETF	19.24	19.3	19.2	19.24	1024200.0
2023-08-04	AADR	ETF	51.7	52.05	51.49	51.49	800.0
2023-08-04	AAPB	ETF	26.91	27.159	25.91	25.95	60100.0
2023-08-04	AAPD	ETF	21.1	21.46	20.88	21.46	544523.0
2023-08-04	AAPU	ETF	27.08	27.4697	26.27	26.27	480940.0
2023-08-04	AAXJ	ETF	68.54	68.82	68.13	68.17	679300.0
2023-08-04	ABEQ	ETF	28.34	28.45	28.19	28.19	29200.0
2023-08-04	ACES	ETF	45.92	45.92	44.73	44.78	35100.0
2023-08-04	ACIO	ETF	31.61	31.61	31.253	31.282	80700.0
2023-08-04	ACSI	ETF	47.127	47.127	47.127	47.127	100.0
2023-08-04	ACT	ETF	28.65	29.44	28.25	28.99	1768687.0
2023-08-04	ACTV	ETF	32.94	33.05	32.66	32.661	8900.0
2023-08-04	ACVF	ETF	34.49	34.52	34.12	34.167	8800.0
2023-08-04	ACWF	ETF	35.91	36.0401	35.64	35.64	3312.0
2023-08-04	ACWI	ETF	97.21	97.79	96.53	96.64	2931100.0
2023-08-04	ACWV	ETF	98.19	98.57	97.69	97.78	71400.0
2023-08-04	ACWX	ETF	49.67	50.02	49.49	49.53	958600.0
2023-08-04	ADFI	ETF	8.395	8.41	8.391	8.391	14400.0
2023-08-04	ADIV	ETF	14.061	14.083	14.059	14.059	400.0
2023-08-04	ADME	ETF	36.78	37.0	36.45	36.555	75500.0
2023-08-04	ADPV	ETF	25.77	25.8204	25.59	25.6171	3863.0
2023-08-04	AEMB	ETF	37.402	37.465	37.402	37.465	600.0
2023-08-04	AESR	ETF	12.93	13.01	12.822	12.85	33400.0
2023-08-04	AFIF	ETF	8.88	8.92	8.88	8.88	10700.0
2023-08-04	AFK	ETF	15.19	15.46	15.19	15.36	4200.0
2023-08-04	AFLG	ETF	25.761	25.761	25.615	25.615	200.0
2023-08-04	AFMC	ETF	25.515	25.63	25.351	25.351	2200.0
2023-08-04	AFSM	ETF	25.71	25.71	25.71	25.71	100.0
2023-08-04	AFTY	ETF	15.96	15.96	15.95	15.95	200.0
2023-08-04	AGG	ETF	96.25	96.75	96.25	96.68	6400400.0
2023-08-04	AGGH	ETF	22.22	22.29	22.18	22.29	19061.0
2023-08-04	AGGY	ETF	42.48	42.7	42.48	42.67	236200.0
2023-08-04	AGNG	ETF	27.36	27.469	27.235	27.235	1900.0
2023-08-04	AGOV	ETF	74.985	74.985	74.985	74.985	15.0
2023-08-04	AGOX	ETF	23.86	23.969	23.59	23.617	25300.0
2023-08-04	AGQ	ETF	28.61	29.0	28.38	28.53	715600.0
2023-08-04	AGRH	ETF	25.59	25.65	25.59	25.6	224.0
2023-08-04	AGZ	ETF	106.26	106.66	106.26	106.63	9700.0
2023-08-04	AGZD	ETF	22.09	22.175	22.065	22.095	29200.0
2023-08-04	AHYB	ETF	44.01	44.05	43.921	43.921	500.0
2023-08-04	AIA	ETF	61.06	61.44	60.65	60.65	26900.0
2023-08-04	AIEQ	ETF	32.82	32.97	32.39	32.5	9400.0
2023-08-04	AIQ	ETF	28.65	28.81	28.35	28.37	369100.0

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

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