PREVIEW / etf_daily / 2023-12-20

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-20.parquet
  size:    117 KB
  rows:    3,232

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-20	SPY	ETF	473.96	475.9	467.82	468.26	102921000.0
2023-12-20	QQQ	ETF	408.35	410.4699	402.9	403.08	54042443.0
2023-12-20	IWM	ETF	199.86	202.17	196.16	196.28	62360300.0
2023-12-20	DIA	ETF	374.67	376.34	370.61	370.8	4564700.0
2023-12-20	GLD	ETF	188.69	188.96	188.09	188.1	6002400.0
2023-12-20	TLT	ETF	99.11	99.69	98.58	99.56	51229400.0
2023-12-20	AAA	ETF	25.1	25.1	25.01	25.07	14100.0
2023-12-20	AAAU	ETF	20.17	20.19	20.09	20.1	1250000.0
2023-12-20	AADR	ETF	55.51	55.75	54.44	54.8	800.0
2023-12-20	AAPB	ETF	28.39	28.6	27.93	27.93	16680.0
2023-12-20	AAPD	ETF	19.94	20.14	19.87	20.14	113430.0
2023-12-20	AAPU	ETF	28.71	28.81	28.22	28.23	134122.0
2023-12-20	AAPY	ETF	26.92	26.92	26.8394	26.8394	129.0
2023-12-20	AAXJ	ETF	64.73	64.86	63.92	63.95	695100.0
2023-12-20	ABCS	ETF	25.35	25.37	24.8448	24.8448	101158.0
2023-12-20	ABEQ	ETF	28.625	28.63	28.33	28.33	38400.0
2023-12-20	ACES	ETF	36.49	36.549	34.99	34.994	209900.0
2023-12-20	ACIO	ETF	33.13	33.305	32.868	32.87	66900.0
2023-12-20	ACSI	ETF	50.5	50.5	49.883	49.883	500.0
2023-12-20	ACT	ETF	29.03	29.49	28.83	28.89	596124.0
2023-12-20	ACTV	ETF	33.1	33.25	32.49	32.492	66300.0
2023-12-20	ACVF	ETF	36.47	36.55	35.997	35.997	5900.0
2023-12-20	ACWF	ETF	37.5844	37.67	37.09	37.13	7904.0
2023-12-20	ACWI	ETF	101.03	101.35	99.76	99.78	8277200.0
2023-12-20	ACWV	ETF	98.6	98.6	97.53	97.56	194500.0
2023-12-20	ACWX	ETF	50.22	50.27	49.58	49.62	1524200.0
2023-12-20	ADFI	ETF	8.551	8.59	8.551	8.585	35400.0
2023-12-20	ADIV	ETF	13.62	13.62	13.51	13.51	700.0
2023-12-20	ADME	ETF	38.38	38.577	37.99	37.99	11600.0
2023-12-20	ADPV	ETF	24.974	24.974	24.4	24.4035	2417.0
2023-12-20	ADVE	ETF	31.04	31.04	30.6779	30.6779	3832.0
2023-12-20	AEMB	ETF	38.08	38.21	37.99	38.064	1700.0
2023-12-20	AESR	ETF	13.8	13.86	13.57	13.57	69600.0
2023-12-20	AETH	ETF	33.56	33.63	32.16	32.4135	5717.0
2023-12-20	AFIF	ETF	9.0	9.03	8.98	9.0	8700.0
2023-12-20	AFK	ETF	13.75	13.77	13.55	13.55	27800.0
2023-12-20	AFLG	ETF	27.217	27.217	27.217	27.217	100.0
2023-12-20	AFMC	ETF	26.551	26.551	26.551	26.551	100.0
2023-12-20	AFSM	ETF	27.25	27.25	27.079	27.079	300.0
2023-12-20	AFTY	ETF	13.3	13.3	13.181	13.181	300.0
2023-12-20	AGG	ETF	98.87	99.04	98.69	98.97	9994100.0
2023-12-20	AGGH	ETF	22.42	22.42	22.15	22.18	36079.0
2023-12-20	AGGY	ETF	43.98	44.21	43.9	44.21	85400.0
2023-12-20	AGNG	ETF	28.0	28.06	27.68	27.68	3600.0
2023-12-20	AGOX	ETF	24.31	24.42	24.09	24.16	32200.0
2023-12-20	AGQ	ETF	28.51	28.63	27.95	27.95	1168800.0
2023-12-20	AGQI	ETF	13.09	13.13	12.94	12.94	57363.0
2023-12-20	AGZ	ETF	108.16	108.21	108.06	108.2	27100.0
2023-12-20	AGZD	ETF	21.92	21.99	21.81	21.98	100300.0
2023-12-20	AHLT	ETF	23.95	23.985	23.7075	23.7075	10826.0

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

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