PREVIEW / etf_daily / 2023-12-12

all etf daily files

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

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-12	SPY	ETF	461.63	464.2	460.6	464.1	68327600.0
2023-12-12	QQQ	ETF	395.56	398.79	394.41	398.67	39221152.0
2023-12-12	IWM	ETF	186.97	187.66	185.34	187.0	32024000.0
2023-12-12	DIA	ETF	365.41	366.68	364.43	366.41	3239600.0
2023-12-12	GLD	ETF	183.84	183.98	183.26	183.49	5056900.0
2023-12-12	TLT	ETF	94.15	94.7	93.9	94.62	36996900.0
2023-12-12	AAA	ETF	25.04	25.04	24.995	24.995	8500.0
2023-12-12	AAAU	ETF	19.65	19.66	19.59	19.61	1077300.0
2023-12-12	AADR	ETF	54.36	54.61	54.3	54.61	400.0
2023-12-12	AAPB	ETF	27.5508	27.9	27.451	27.9	10638.0
2023-12-12	AAPD	ETF	20.3	20.439	20.14	20.14	104117.0
2023-12-12	AAPU	ETF	27.84	28.22	27.6	28.22	55270.0
2023-12-12	AAXJ	ETF	64.58	64.9	64.35	64.88	808000.0
2023-12-12	ABEQ	ETF	27.91	27.94	27.905	27.931	3900.0
2023-12-12	ACES	ETF	32.04	32.04	30.96	31.43	93300.0
2023-12-12	ACIO	ETF	32.49	32.68	32.49	32.64	80100.0
2023-12-12	ACSI	ETF	49.071	49.071	49.071	49.071	100.0
2023-12-12	ACT	ETF	27.64	27.83	27.4	27.68	273728.0
2023-12-12	ACTV	ETF	31.53	31.78	31.51	31.68	7500.0
2023-12-12	ACTX	ETF	0.0004	0.0004	0.0003	0.0003	1116.0
2023-12-12	ACVF	ETF	35.46	35.6	35.18	35.574	9200.0
2023-12-12	ACWF	ETF	37.0	37.194	36.94	37.194	2845.0
2023-12-12	ACWI	ETF	98.95	99.41	98.69	99.38	3356200.0
2023-12-12	ACWV	ETF	99.65	100.07	99.49	100.03	144400.0
2023-12-12	ACWX	ETF	49.62	49.67	49.34	49.67	1652700.0
2023-12-12	ADFI	ETF	8.451	8.48	8.451	8.475	33900.0
2023-12-12	ADIV	ETF	13.38	13.42	13.35	13.407	1100.0
2023-12-12	ADME	ETF	37.44	37.7	37.44	37.67	6200.0
2023-12-12	ADPV	ETF	23.81	23.85	23.75	23.8	1660.0
2023-12-12	AEMB	ETF	37.279	37.279	37.279	37.279	100.0
2023-12-12	AESR	ETF	13.26	13.35	13.26	13.34	69100.0
2023-12-12	AETH	ETF	33.06	33.06	32.41	32.5935	3223.0
2023-12-12	AFIF	ETF	9.01	9.04	9.01	9.03	17900.0
2023-12-12	AFK	ETF	13.52	13.69	13.51	13.54	13300.0
2023-12-12	AFLG	ETF	26.91	26.91	26.84	26.84	1300.0
2023-12-12	AFMC	ETF	25.564	25.585	25.544	25.544	500.0
2023-12-12	AFSM	ETF	25.606	25.7	25.574	25.574	5600.0
2023-12-12	AFTY	ETF	13.628	13.628	13.628	13.628	100.0
2023-12-12	AGG	ETF	96.94	97.19	96.82	97.19	11711400.0
2023-12-12	AGGH	ETF	21.69	21.69	21.55	21.68	15589.0
2023-12-12	AGGY	ETF	43.02	43.11	42.954	43.11	132100.0
2023-12-12	AGNG	ETF	27.24	27.43	27.24	27.43	400.0
2023-12-12	AGOX	ETF	23.81	24.05	23.81	24.005	17700.0
2023-12-12	AGQ	ETF	25.35	25.37	24.91	25.08	1167400.0
2023-12-12	AGQI	ETF	12.86	12.92	12.84	12.9	60263.0
2023-12-12	AGRH	ETF	25.73	25.7571	25.73	25.7571	118.0
2023-12-12	AGZ	ETF	107.26	107.26	107.1	107.17	13400.0
2023-12-12	AGZD	ETF	22.03	22.08	21.93	21.95	36200.0
2023-12-12	AHLT	ETF	23.97	24.06	23.97	24.0361	3964.0
2023-12-12	AHYB	ETF	44.45	44.64	44.45	44.64	800.0

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

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