PREVIEW / etf_daily / 2023-08-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-15.parquet
  size:    107 KB
  rows:    2,981

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-15	SPY	ETF	446.27	446.64	442.3	442.89	75707500.0
2023-08-15	QQQ	ETF	369.36	370.169	365.74	366.42	45539891.0
2023-08-15	IWM	ETF	189.52	189.64	188.04	188.14	25491300.0
2023-08-15	DIA	ETF	351.67	352.02	349.18	349.61	2818700.0
2023-08-15	GLD	ETF	176.75	177.43	176.33	176.59	7582700.0
2023-08-15	TLT	ETF	94.8	95.2	94.56	94.58	24125000.0
2023-08-15	AAA	ETF	24.77	24.83	24.77	24.827	8100.0
2023-08-15	AAAU	ETF	18.88	18.95	18.83	18.86	1262100.0
2023-08-15	AADR	ETF	51.01	51.02	50.97	51.02	700.0
2023-08-15	AAPB	ETF	25.199	25.199	24.74	24.82	12984.0
2023-08-15	AAPD	ETF	21.8	22.0399	21.77	22.0	63082.0
2023-08-15	AAPU	ETF	25.59	25.66	25.21	25.31	110552.0
2023-08-15	AAXJ	ETF	65.54	65.54	65.05	65.14	325600.0
2023-08-15	ABEQ	ETF	27.975	27.975	27.84	27.84	8800.0
2023-08-15	ACES	ETF	42.48	42.48	41.37	41.37	39500.0
2023-08-15	ACIO	ETF	31.203	31.23	31.11	31.13	38500.0
2023-08-15	ACSI	ETF	46.425	46.425	46.425	46.425	100.0
2023-08-15	ACT	ETF	29.06	29.38	29.0061	29.26	208069.0
2023-08-15	ACTV	ETF	31.94	31.94	31.717	31.717	4600.0
2023-08-15	ACVF	ETF	34.22	34.22	34.06	34.1	13100.0
2023-08-15	ACWF	ETF	35.4026	35.4026	35.18	35.1873	11566.0
2023-08-15	ACWI	ETF	95.86	95.88	94.98	95.12	4823700.0
2023-08-15	ACWV	ETF	98.1	98.1	97.51	97.54	284100.0
2023-08-15	ACWX	ETF	48.69	48.69	48.25	48.32	508700.0
2023-08-15	ADFI	ETF	8.37	8.38	8.35	8.37	28600.0
2023-08-15	ADIV	ETF	13.51	13.51	13.455	13.455	200.0
2023-08-15	ADME	ETF	36.47	36.47	36.27	36.27	29500.0
2023-08-15	ADPV	ETF	25.0	25.03	24.9541	24.9541	647.0
2023-08-15	AEMB	ETF	36.835	36.835	36.835	36.835	100.0
2023-08-15	AESR	ETF	12.78	12.82	12.73	12.76	35400.0
2023-08-15	AFIF	ETF	8.92	8.94	8.9	8.91	6300.0
2023-08-15	AFK	ETF	15.01	15.04	14.8	14.8	7700.0
2023-08-15	AFLG	ETF	25.41	25.41	25.36	25.405	3900.0
2023-08-15	AFMC	ETF	25.053	25.053	25.053	25.053	100.0
2023-08-15	AFTY	ETF	14.88	14.905	14.84	14.905	1000.0
2023-08-15	AGG	ETF	95.81	96.07	95.74	95.74	6522500.0
2023-08-15	AGGH	ETF	22.1	22.16	22.03	22.03	38890.0
2023-08-15	AGGY	ETF	42.36	42.445	42.33	42.34	106000.0
2023-08-15	AGNG	ETF	27.47	27.509	27.43	27.498	9700.0
2023-08-15	AGOV	ETF	74.715	74.715	74.715	74.715	7.0
2023-08-15	AGOX	ETF	23.34	23.43	23.33	23.38	12200.0
2023-08-15	AGQ	ETF	25.76	26.26	25.49	25.88	670400.0
2023-08-15	AGZ	ETF	106.29	106.38	106.23	106.23	9500.0
2023-08-15	AGZD	ETF	22.23	22.26	22.13	22.18	32000.0
2023-08-15	AHYB	ETF	43.948	43.948	43.871	43.871	400.0
2023-08-15	AIA	ETF	58.07	58.07	57.5	57.59	14600.0
2023-08-15	AIEQ	ETF	31.53	31.53	31.23	31.289	13700.0
2023-08-15	AIQ	ETF	27.78	27.794	27.48	27.56	435800.0
2023-08-15	AIRR	ETF	54.74	54.78	54.182	54.33	46500.0
2023-08-15	AIVI	ETF	38.65	38.65	38.49	38.51	2500.0

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

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