PREVIEW / etf_daily / 2023-11-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-13.parquet
  size:    109 KB
  rows:    3,049

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-11-13	SPY	ETF	439.23	441.33	438.42	440.19	52236100.0
2023-11-13	QQQ	ETF	376.79	378.28	375.24	377.21	40733505.0
2023-11-13	IWM	ETF	168.24	169.77	167.52	169.17	27610300.0
2023-11-13	DIA	ETF	342.38	344.3	342.23	343.57	2624500.0
2023-11-13	GLD	ETF	179.4	180.73	179.11	180.51	5385900.0
2023-11-13	TLT	ETF	87.22	87.94	86.9	87.79	25661500.0
2023-11-13	AAA	ETF	24.91	24.91	24.855	24.855	5800.0
2023-11-13	AAAU	ETF	19.17	19.31	19.15	19.31	4484900.0
2023-11-13	AADR	ETF	49.85	49.85	49.78	49.78	200.0
2023-11-13	AAPB	ETF	26.07	26.07	25.64	25.77	8147.0
2023-11-13	AAPD	ETF	21.01	21.16	20.9909	21.12	71031.0
2023-11-13	AAPU	ETF	26.47	26.47	26.1199	26.21	116445.0
2023-11-13	AAPY	ETF	26.68	26.68	26.645	26.645	531.0
2023-11-13	AAXJ	ETF	63.71	64.25	63.68	64.0	350500.0
2023-11-13	ABEQ	ETF	27.05	27.146	27.05	27.146	4200.0
2023-11-13	ACES	ETF	28.15	28.58	27.96	28.37	149100.0
2023-11-13	ACIO	ETF	31.33	31.498	31.3	31.44	623900.0
2023-11-13	ACT	ETF	27.93	28.13	27.69	27.69	800710.0
2023-11-13	ACTV	ETF	28.13	28.35	28.13	28.205	10300.0
2023-11-13	ACVF	ETF	33.77	33.828	33.74	33.8	3900.0
2023-11-13	ACWF	ETF	35.07	35.2424	35.04	35.222	7491.0
2023-11-13	ACWI	ETF	93.96	94.55	93.86	94.33	3011000.0
2023-11-13	ACWV	ETF	96.0	96.43	95.97	96.37	77300.0
2023-11-13	ACWX	ETF	47.16	47.5	47.07	47.42	1463600.0
2023-11-13	ADFI	ETF	8.22	8.25	8.22	8.225	11000.0
2023-11-13	ADIV	ETF	13.435	13.435	13.435	13.435	100.0
2023-11-13	ADME	ETF	35.96	36.108	35.96	36.05	9400.0
2023-11-13	ADPV	ETF	22.95	23.0	22.9207	22.9525	6283.0
2023-11-13	ADVE	ETF	29.88	29.88	29.8257	29.8257	800.0
2023-11-13	AEMB	ETF	35.6	35.6	35.6	35.6	500.0
2023-11-13	AESR	ETF	12.54	12.645	12.53	12.58	602200.0
2023-11-13	AETH	ETF	31.23	31.7	30.86	31.4476	2699.0
2023-11-13	AFIF	ETF	8.89	8.93	8.89	8.92	86700.0
2023-11-13	AFK	ETF	13.43	13.44	13.23	13.43	6400.0
2023-11-13	AFMC	ETF	23.42	23.457	23.42	23.457	100.0
2023-11-13	AFTY	ETF	14.2	14.2	14.189	14.189	2200.0
2023-11-13	AGG	ETF	93.64	93.97	93.53	93.95	9679500.0
2023-11-13	AGGH	ETF	21.199	21.24	21.14	21.23	29436.0
2023-11-13	AGGY	ETF	41.57	41.645	41.509	41.625	101000.0
2023-11-13	AGNG	ETF	25.34	25.65	25.34	25.565	3400.0
2023-11-13	AGOV	ETF	72.57	72.57	72.57	72.57	50.0
2023-11-13	AGOX	ETF	23.015	23.14	22.98	23.07	12100.0
2023-11-13	AGQ	ETF	23.8	24.5	23.6	24.4	719800.0
2023-11-13	AGRH	ETF	25.6	25.6	25.59	25.59	129.0
2023-11-13	AGZ	ETF	105.77	105.83	105.65	105.73	85300.0
2023-11-13	AGZD	ETF	22.2	22.29	22.18	22.27	20200.0
2023-11-13	AHLT	ETF	25.76	26.03	25.6514	25.87	2821.0
2023-11-13	AHYB	ETF	43.61	43.61	43.58	43.58	400.0
2023-11-13	AIA	ETF	56.8	57.26	56.72	56.95	12800.0
2023-11-13	AIEQ	ETF	29.82	29.95	29.752	29.892	14100.0

> showing 50 of 3,049 rows — these rows as CSV

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