PREVIEW / etf_daily / 2023-12-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-14.parquet
  size:    116 KB
  rows:    3,216

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-12-14	SPY	ETF	472.5	473.73	469.25	472.01	119026000.0
2023-12-14	QQQ	ETF	404.98	406.3	400.34	403.39	55447808.0
2023-12-14	IWM	ETF	196.87	200.04	196.48	198.71	83649300.0
2023-12-14	DIA	ETF	372.71	373.67	371.26	373.33	5507000.0
2023-12-14	GLD	ETF	188.86	189.82	188.08	188.73	9107200.0
2023-12-14	TLT	ETF	97.66	99.04	97.42	99.04	87798600.0
2023-12-14	AAA	ETF	25.05	25.05	24.958	25.0	5400.0
2023-12-14	AAAU	ETF	20.18	20.28	20.09	20.17	1919100.0
2023-12-14	AADR	ETF	55.71	55.71	55.55	55.64	1300.0
2023-12-14	AAPB	ETF	28.76	29.15	28.31	28.77	18290.0
2023-12-14	AAPD	ETF	19.79	19.9912	19.65	19.8	117188.0
2023-12-14	AAPU	ETF	28.93	29.2628	28.5901	28.97	128030.0
2023-12-14	AAPY	ETF	27.25	27.25	27.1327	27.2219	1057.0
2023-12-14	AAXJ	ETF	65.66	66.33	65.66	66.29	2296700.0
2023-12-14	ABEQ	ETF	28.59	28.62	28.466	28.487	2000.0
2023-12-14	ACES	ETF	34.59	36.925	34.59	36.396	117900.0
2023-12-14	ACIO	ETF	32.99	33.055	32.84	32.95	49900.0
2023-12-14	ACSI	ETF	50.065	50.065	50.065	50.065	100.0
2023-12-14	ACT	ETF	28.5	28.91	28.5	28.65	432542.0
2023-12-14	ACTV	ETF	33.52	33.52	33.19	33.224	3700.0
2023-12-14	ACVF	ETF	36.2	36.31	36.075	36.127	16300.0
2023-12-14	ACWF	ETF	37.87	37.98	37.87	37.8832	3254.0
2023-12-14	ACWI	ETF	101.33	101.69	100.89	101.4	3648600.0
2023-12-14	ACWV	ETF	101.35	101.35	100.45	100.59	83200.0
2023-12-14	ACWX	ETF	50.72	50.98	50.65	50.83	2938000.0
2023-12-14	ADFI	ETF	8.59	8.59	8.56	8.57	10400.0
2023-12-14	ADIV	ETF	13.76	13.766	13.74	13.766	1000.0
2023-12-14	ADME	ETF	38.1	38.2	38.06	38.117	10400.0
2023-12-14	ADPV	ETF	24.33	24.425	24.31	24.425	4816.0
2023-12-14	ADVE	ETF	30.83	30.8863	30.83	30.8863	1635.0
2023-12-14	AEMB	ETF	38.226	38.226	38.226	38.226	100.0
2023-12-14	AESR	ETF	13.63	13.67	13.55	13.63	15700.0
2023-12-14	AETH	ETF	34.1101	34.7	33.87	34.1308	15335.0
2023-12-14	AFIF	ETF	9.01	9.01	8.95	8.96	32600.0
2023-12-14	AFK	ETF	14.15	14.15	13.93	14.11	12300.0
2023-12-14	AFLG	ETF	27.323	27.323	27.323	27.323	100.0
2023-12-14	AFMC	ETF	26.819	26.819	26.819	26.819	100.0
2023-12-14	AFSM	ETF	26.907	26.907	26.907	26.907	100.0
2023-12-14	AFTY	ETF	13.507	13.507	13.507	13.507	100.0
2023-12-14	AGG	ETF	98.68	99.04	98.61	98.92	12651200.0
2023-12-14	AGGH	ETF	22.26	22.26	22.0	22.09	41542.0
2023-12-14	AGGY	ETF	43.86	44.055	43.86	44.05	82600.0
2023-12-14	AGNG	ETF	28.29	28.3	28.12	28.16	1700.0
2023-12-14	AGOX	ETF	24.22	24.38	24.145	24.308	33200.0
2023-12-14	AGQ	ETF	27.84	28.25	27.78	28.15	1921100.0
2023-12-14	AGQI	ETF	13.09	13.1552	13.08	13.08	50667.0
2023-12-14	AGZ	ETF	107.97	108.1	107.87	108.1	55200.0
2023-12-14	AGZD	ETF	22.15	22.15	21.92	21.99	368200.0
2023-12-14	AHLT	ETF	23.78	23.79	23.74	23.7629	3606.0
2023-12-14	AHYB	ETF	45.506	45.506	45.373	45.45	14500.0

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

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