PREVIEW / etf_daily / 2023-12-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-18.parquet
  size:    115 KB
  rows:    3,202

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-18	SPY	ETF	470.98	472.98	469.89	471.97	70375300.0
2023-12-18	QQQ	ETF	404.93	407.99	404.6	407.08	46609985.0
2023-12-18	IWM	ETF	197.96	198.77	196.68	197.11	44451100.0
2023-12-18	DIA	ETF	373.29	373.87	372.76	372.98	3403200.0
2023-12-18	GLD	ETF	187.5	188.49	187.24	187.85	5358000.0
2023-12-18	TLT	ETF	98.5	98.5	98.02	98.36	34746000.0
2023-12-18	AAA	ETF	25.07	25.07	24.95	25.01	4800.0
2023-12-18	AAAU	ETF	20.04	20.14	20.01	20.06	3420100.0
2023-12-18	AADR	ETF	54.74	55.62	54.74	55.51	1700.0
2023-12-18	AAPB	ETF	28.33	28.34	27.9	28.17	17502.0
2023-12-18	AAPD	ETF	19.98	20.18	19.97	20.04	115273.0
2023-12-18	AAPU	ETF	28.53	28.56	28.14	28.45	168461.0
2023-12-18	AAXJ	ETF	65.78	65.85	65.53	65.77	755500.0
2023-12-18	ABEQ	ETF	28.41	28.475	28.41	28.471	4500.0
2023-12-18	ACES	ETF	36.11	36.28	35.547	35.76	58700.0
2023-12-18	ACIO	ETF	33.056	33.26	33.03	33.14	492500.0
2023-12-18	ACSI	ETF	49.92	50.25	49.92	50.241	1500.0
2023-12-18	ACT	ETF	28.65	28.989	28.41	28.57	268646.0
2023-12-18	ACTV	ETF	33.08	33.09	32.85	32.994	6200.0
2023-12-18	ACVF	ETF	36.35	36.5	36.23	36.357	6900.0
2023-12-18	ACWF	ETF	37.88	37.95	37.8425	37.9156	2676.0
2023-12-18	ACWI	ETF	101.34	101.56	101.16	101.42	2490300.0
2023-12-18	ACWV	ETF	99.85	100.26	99.85	100.24	185500.0
2023-12-18	ACWX	ETF	50.6	50.6	50.32	50.5	1881200.0
2023-12-18	ADFI	ETF	8.56	8.56	8.54	8.545	3900.0
2023-12-18	ADIV	ETF	13.63	13.67	13.6	13.658	4500.0
2023-12-18	ADME	ETF	38.34	38.41	38.34	38.34	5800.0
2023-12-18	ADPV	ETF	24.4833	24.53	24.48	24.4836	1828.0
2023-12-18	AEMB	ETF	37.81	37.93	37.81	37.93	200.0
2023-12-18	AESR	ETF	13.67	13.74	13.67	13.71	48000.0
2023-12-18	AETH	ETF	32.181	32.4754	32.0	32.4754	6010.0
2023-12-18	AFIF	ETF	8.99	9.0	8.95	8.97	7900.0
2023-12-18	AFK	ETF	14.01	14.01	13.63	13.67	48200.0
2023-12-18	AFLG	ETF	27.393	27.393	27.393	27.393	100.0
2023-12-18	AFMC	ETF	26.573	26.573	26.573	26.573	100.0
2023-12-18	AFSM	ETF	26.852	26.852	26.851	26.851	400.0
2023-12-18	AFTY	ETF	13.35	13.36	13.32	13.33	2700.0
2023-12-18	AGG	ETF	98.58	98.58	98.42	98.49	11521000.0
2023-12-18	AGGH	ETF	22.27	22.27	22.03	22.07	51949.0
2023-12-18	AGGY	ETF	43.9	43.9	43.835	43.88	64200.0
2023-12-18	AGNG	ETF	27.87	27.89	27.75	27.89	7500.0
2023-12-18	AGOX	ETF	24.24	24.34	24.18	24.19	19000.0
2023-12-18	AGQ	ETF	27.52	27.53	27.01	27.31	1065800.0
2023-12-18	AGQI	ETF	13.06	13.08	13.03	13.0618	42556.0
2023-12-18	AGZ	ETF	107.85	108.09	107.85	107.98	24200.0
2023-12-18	AGZD	ETF	21.93	21.95	21.79	21.93	63900.0
2023-12-18	AHLT	ETF	23.86	23.88	23.86	23.8747	1044.0
2023-12-18	AHYB	ETF	45.22	45.22	45.06	45.116	4200.0
2023-12-18	AIA	ETF	57.12	57.25	56.81	57.05	24700.0
2023-12-18	AIEQ	ETF	35.29	35.47	35.12	35.23	12400.0

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

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