PREVIEW / etf_daily / 2023-08-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-09.parquet
  size:    106 KB
  rows:    2,978

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-09	SPY	ETF	449.03	449.2	444.96	445.75	78789600.0
2023-08-09	QQQ	ETF	372.29	372.45	367.14	367.91	51150900.0
2023-08-09	IWM	ETF	192.87	192.88	190.75	191.57	22293200.0
2023-08-09	DIA	ETF	352.87	353.68	350.54	351.28	2873300.0
2023-08-09	GLD	ETF	178.68	178.92	177.78	177.79	4644000.0
2023-08-09	TLT	ETF	96.88	97.29	96.84	97.19	20151100.0
2023-08-09	AAA	ETF	24.739	24.77	24.71	24.77	2300.0
2023-08-09	AAAU	ETF	19.08	19.1	18.98	18.98	559300.0
2023-08-09	AADR	ETF	51.89	51.89	51.89	51.89	100.0
2023-08-09	AAPB	ETF	25.68	25.68	24.7224	24.99	23165.0
2023-08-09	AAPD	ETF	21.58	22.06	21.58	21.92	171554.0
2023-08-09	AAPU	ETF	26.04	26.04	25.19	25.45	181920.0
2023-08-09	AAXJ	ETF	67.64	67.69	67.17	67.39	375500.0
2023-08-09	ABEQ	ETF	28.17	28.28	28.07	28.07	13900.0
2023-08-09	ACES	ETF	44.21	44.41	43.623	43.72	15300.0
2023-08-09	ACIO	ETF	31.27	31.42	31.24	31.25	76500.0
2023-08-09	ACSI	ETF	47.27	47.27	46.991	46.991	300.0
2023-08-09	ACT	ETF	29.4	29.46	29.02	29.35	171189.0
2023-08-09	ACTV	ETF	32.54	32.58	32.42	32.42	6400.0
2023-08-09	ACVF	ETF	34.53	34.53	34.184	34.184	5700.0
2023-08-09	ACWF	ETF	35.7909	35.7909	35.57	35.6205	3997.0
2023-08-09	ACWI	ETF	96.89	96.9	96.14	96.32	1622300.0
2023-08-09	ACWV	ETF	98.49	98.74	98.29	98.5	70600.0
2023-08-09	ACWX	ETF	49.56	49.63	49.32	49.44	1800800.0
2023-08-09	ADFI	ETF	8.42	8.43	8.39	8.43	13600.0
2023-08-09	ADIV	ETF	13.876	13.876	13.876	13.876	100.0
2023-08-09	ADME	ETF	36.695	36.7	36.47	36.506	73300.0
2023-08-09	ADPV	ETF	25.35	25.38	25.2678	25.2678	903.0
2023-08-09	AEMB	ETF	37.5	37.515	37.5	37.515	400.0
2023-08-09	AESR	ETF	12.89	12.903	12.77	12.79	25800.0
2023-08-09	AFIF	ETF	8.93	8.94	8.92	8.93	3100.0
2023-08-09	AFK	ETF	15.2	15.45	15.19	15.19	5900.0
2023-08-09	AFLG	ETF	25.626	25.626	25.626	25.626	100.0
2023-08-09	AFMC	ETF	25.34	25.34	25.226	25.226	900.0
2023-08-09	AFSM	ETF	25.535	25.535	25.535	25.535	100.0
2023-08-09	AFTY	ETF	15.69	15.728	15.69	15.728	400.0
2023-08-09	AGG	ETF	97.01	97.12	96.91	97.0	5634700.0
2023-08-09	AGGH	ETF	22.34	22.36	22.24	22.24	14834.0
2023-08-09	AGGY	ETF	42.8	42.83	42.78	42.81	69300.0
2023-08-09	AGNG	ETF	27.68	27.68	27.58	27.58	4000.0
2023-08-09	AGOV	ETF	75.33	75.33	75.33	75.33	52.0
2023-08-09	AGOX	ETF	23.615	23.625	23.44	23.44	13500.0
2023-08-09	AGQ	ETF	26.39	26.75	26.13	26.28	568400.0
2023-08-09	AGZ	ETF	106.71	106.82	106.71	106.74	12400.0
2023-08-09	AGZD	ETF	22.11	22.17	22.085	22.14	43600.0
2023-08-09	AHOY	ETF	20.79	20.79	20.6641	20.6641	1071.0
2023-08-09	AHYB	ETF	44.085	44.085	44.085	44.085	200.0
2023-08-09	AIA	ETF	60.24	60.28	59.8	59.98	26500.0
2023-08-09	AIEQ	ETF	32.41	32.41	31.94	31.94	12800.0
2023-08-09	AIQ	ETF	28.27	28.27	27.755	27.86	257300.0

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

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