PREVIEW / etf_daily / 2023-12-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-06.parquet
  size:    113 KB
  rows:    3,152

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-06	SPY	ETF	458.81	458.84	454.31	454.76	69124700.0
2023-12-06	QQQ	ETF	390.27	390.37	384.7	385.05	41994072.0
2023-12-06	IWM	ETF	185.7	187.92	183.79	184.06	43637900.0
2023-12-06	DIA	ETF	362.81	363.55	360.83	361.22	5583700.0
2023-12-06	GLD	ETF	188.32	188.46	187.5	187.84	5778600.0
2023-12-06	TLT	ETF	95.08	96.05	94.87	95.87	61606100.0
2023-12-06	AAA	ETF	24.933	25.0	24.9	24.95	9200.0
2023-12-06	AAAU	ETF	20.13	20.13	20.04	20.08	973900.0
2023-12-06	AADR	ETF	54.02	54.02	53.13	53.25	1500.0
2023-12-06	AAPB	ETF	27.97	28.019	27.38	27.4122	14627.0
2023-12-06	AAPD	ETF	20.11	20.38	20.1	20.3616	76651.0
2023-12-06	AAPU	ETF	28.2	28.2581	27.7001	27.75	94711.0
2023-12-06	AAXJ	ETF	64.66	64.81	64.29	64.33	487700.0
2023-12-06	ABEQ	ETF	28.06	28.16	27.988	27.988	2500.0
2023-12-06	ACES	ETF	32.1	32.875	31.93	32.01	59900.0
2023-12-06	ACIO	ETF	32.32	32.33	32.14	32.17	50400.0
2023-12-06	ACT	ETF	27.54	27.85	27.08	27.11	180689.0
2023-12-06	ACTV	ETF	31.32	31.33	31.013	31.03	8000.0
2023-12-06	ACVF	ETF	35.04	35.04	34.69	34.74	4400.0
2023-12-06	ACWF	ETF	36.93	36.93	36.54	36.54	3237.0
2023-12-06	ACWI	ETF	98.6	98.6	97.7	97.76	3211000.0
2023-12-06	ACWV	ETF	99.47	99.47	98.97	99.02	119900.0
2023-12-06	ACWX	ETF	49.6	49.61	49.18	49.19	2180700.0
2023-12-06	ADFI	ETF	8.46	8.51	8.46	8.47	7500.0
2023-12-06	ADIV	ETF	13.61	13.61	13.557	13.557	3600.0
2023-12-06	ADME	ETF	37.15	37.18	36.92	36.98	5700.0
2023-12-06	ADPV	ETF	23.44	23.44	23.3285	23.3285	915.0
2023-12-06	ADVE	ETF	30.4699	30.4699	30.3029	30.3029	295.0
2023-12-06	AEMB	ETF	37.42	37.42	37.42	37.42	100.0
2023-12-06	AESR	ETF	13.09	13.09	12.965	12.965	17900.0
2023-12-06	AETH	ETF	34.0	34.0621	33.68	33.692	2401.0
2023-12-06	AFIF	ETF	9.06	9.06	9.01	9.04	89600.0
2023-12-06	AFK	ETF	13.88	14.0	13.71	13.71	4000.0
2023-12-06	AFLG	ETF	26.252	26.252	26.252	26.252	100.0
2023-12-06	AFSM	ETF	25.24	25.24	25.165	25.165	700.0
2023-12-06	AFTY	ETF	13.537	13.537	13.537	13.537	100.0
2023-12-06	AGG	ETF	97.24	97.49	97.15	97.35	11111200.0
2023-12-06	AGGH	ETF	21.71	21.75	21.6632	21.7	46440.0
2023-12-06	AGGY	ETF	43.17	43.34	43.11	43.34	118700.0
2023-12-06	AGNG	ETF	26.94	27.021	26.9	26.9	2500.0
2023-12-06	AGOX	ETF	23.87	23.89	23.74	23.779	57400.0
2023-12-06	AGQ	ETF	28.49	28.53	27.69	27.84	971100.0
2023-12-06	AGQI	ETF	12.81	12.81	12.73	12.73	29534.0
2023-12-06	AGZ	ETF	107.34	107.44	107.29	107.34	24700.0
2023-12-06	AGZD	ETF	22.39	22.44	22.34	22.42	73900.0
2023-12-06	AHLT	ETF	23.88	23.94	23.8	23.8801	4695.0
2023-12-06	AHYB	ETF	44.561	44.561	44.561	44.561	200.0
2023-12-06	AIA	ETF	55.96	56.0	55.48	55.55	26800.0
2023-12-06	AIEQ	ETF	32.15	32.56	31.965	31.965	10500.0
2023-12-06	AIQ	ETF	29.8	29.8	29.36	29.37	466900.0

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

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