PREVIEW / etf_daily / 2023-12-27

all etf daily files

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

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-27	SPY	ETF	475.44	476.66	474.89	476.51	68000300.0
2023-12-27	QQQ	ETF	410.95	411.7875	410.08	411.5	31980481.0
2023-12-27	IWM	ETF	204.44	205.49	203.4	204.82	35806400.0
2023-12-27	DIA	ETF	375.1	376.79	374.75	376.56	3061200.0
2023-12-27	GLD	ETF	191.77	193.18	191.54	192.59	5813300.0
2023-12-27	TLT	ETF	99.78	100.53	99.5	100.51	45082800.0
2023-12-27	AAA	ETF	25.0	25.15	25.0	25.12	2800.0
2023-12-27	AAAU	ETF	20.54	20.64	20.48	20.59	1609900.0
2023-12-27	AADR	ETF	56.34	56.34	56.0	56.09	1000.0
2023-12-27	AAPB	ETF	22.98	23.1899	22.7	23.14	56719.0
2023-12-27	AAPD	ETF	20.17	20.305	20.06	20.09	294970.0
2023-12-27	AAPU	ETF	27.4	27.606	27.09	27.56	148501.0
2023-12-27	AAXJ	ETF	65.71	65.83	65.53	65.73	1208200.0
2023-12-27	ABCS	ETF	25.75	25.75	25.451	25.451	1030.0
2023-12-27	ABEQ	ETF	28.75	28.78	28.68	28.744	4000.0
2023-12-27	ACES	ETF	36.79	36.79	36.355	36.47	237000.0
2023-12-27	ACIO	ETF	33.12	33.22	33.12	33.21	115700.0
2023-12-27	ACSI	ETF	50.122	50.122	50.122	50.122	100.0
2023-12-27	ACT	ETF	29.24	29.43	29.2	29.35	115279.0
2023-12-27	ACTV	ETF	33.56	33.634	33.41	33.495	6300.0
2023-12-27	ACVF	ETF	36.5	36.61	36.5	36.545	4500.0
2023-12-27	ACWF	ETF	37.82	37.96	37.82	37.8822	2916.0
2023-12-27	ACWI	ETF	101.72	102.03	101.6	101.96	3906000.0
2023-12-27	ACWV	ETF	99.6	99.76	99.24	99.74	285500.0
2023-12-27	ACWX	ETF	50.62	51.03	50.62	50.98	2012100.0
2023-12-27	ADFI	ETF	8.626	8.66	8.62	8.645	4100.0
2023-12-27	ADIV	ETF	13.805	13.81	13.76	13.799	700.0
2023-12-27	ADME	ETF	38.485	38.49	38.411	38.48	14500.0
2023-12-27	ADPV	ETF	25.08	25.1713	25.08	25.1713	5890.0
2023-12-27	ADVE	ETF	31.373	31.373	31.3727	31.3727	1502.0
2023-12-27	AEMB	ETF	38.345	38.345	38.345	38.345	100.0
2023-12-27	AESR	ETF	13.88	13.902	13.84	13.9	8900.0
2023-12-27	AETH	ETF	32.25	32.96	32.25	32.8266	6024.0
2023-12-27	AFIF	ETF	9.03	9.03	9.02	9.03	7400.0
2023-12-27	AFK	ETF	14.13	14.13	13.85	13.99	16200.0
2023-12-27	AFLG	ETF	27.28	27.28	27.28	27.28	200.0
2023-12-27	AFMC	ETF	26.99	27.04	26.907	26.907	600.0
2023-12-27	AFSM	ETF	27.853	27.87	27.778	27.778	1400.0
2023-12-27	AFTY	ETF	13.14	13.14	13.135	13.135	1600.0
2023-12-27	AGG	ETF	99.4	99.7	99.31	99.66	6919900.0
2023-12-27	AGGH	ETF	22.1	22.2	22.05	22.2	35219.0
2023-12-27	AGGY	ETF	43.98	44.15	43.965	44.15	59300.0
2023-12-27	AGNG	ETF	28.39	28.45	28.36	28.45	900.0
2023-12-27	AGOX	ETF	24.45	24.49	24.2	24.35	56300.0
2023-12-27	AGQ	ETF	28.0	28.76	27.99	28.37	2157500.0
2023-12-27	AGQI	ETF	13.21	13.2783	13.21	13.27	35043.0
2023-12-27	AGZ	ETF	108.41	108.56	108.37	108.56	39500.0
2023-12-27	AGZD	ETF	21.9	21.92	21.82	21.91	143100.0
2023-12-27	AHLT	ETF	22.2399	22.28	22.21	22.256	18969.0
2023-12-27	AHOY	ETF	21.77	21.77	21.7154	21.7154	421.0

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

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