PREVIEW / etf_daily / 2023-12-07

all etf daily files

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

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-07	SPY	ETF	456.91	458.9	456.29	458.23	66995400.0
2023-12-07	QQQ	ETF	388.07	391.27	386.96	390.43	49593545.0
2023-12-07	IWM	ETF	184.33	185.56	183.39	185.39	32662300.0
2023-12-07	DIA	ETF	361.96	362.36	360.93	361.83	3295600.0
2023-12-07	GLD	ETF	188.45	188.59	187.26	188.15	5802000.0
2023-12-07	TLT	ETF	95.18	96.08	95.06	95.32	47970200.0
2023-12-07	AAA	ETF	24.95	24.99	24.95	24.95	5200.0
2023-12-07	AAAU	ETF	20.14	20.15	20.02	20.11	1551300.0
2023-12-07	AADR	ETF	53.01	53.7	53.01	53.7	500.0
2023-12-07	AAPB	ETF	27.8	28.0689	27.77	27.84	15839.0
2023-12-07	AAPD	ETF	20.25	20.25	20.0986	20.17	303553.0
2023-12-07	AAPU	ETF	27.99	28.3	27.99	28.13	96866.0
2023-12-07	AAXJ	ETF	64.37	64.68	64.31	64.64	296400.0
2023-12-07	ABEQ	ETF	27.98	27.98	27.96	27.963	2800.0
2023-12-07	ACES	ETF	32.09	32.54	32.02	32.18	110100.0
2023-12-07	ACIO	ETF	32.2	32.359	32.2	32.32	46300.0
2023-12-07	ACSI	ETF	48.474	48.727	48.474	48.727	100.0
2023-12-07	ACT	ETF	27.23	27.4	26.98	27.38	189679.0
2023-12-07	ACTV	ETF	31.04	31.243	31.04	31.243	9800.0
2023-12-07	ACVF	ETF	34.76	34.97	34.76	34.931	13400.0
2023-12-07	ACWF	ETF	36.69	36.85	36.6	36.85	14157.0
2023-12-07	ACWI	ETF	98.14	98.51	97.92	98.39	2923200.0
2023-12-07	ACWV	ETF	99.24	99.39	99.02	99.17	259700.0
2023-12-07	ACWX	ETF	49.33	49.49	49.12	49.41	1701400.0
2023-12-07	ADFI	ETF	8.49	8.49	8.46	8.48	8400.0
2023-12-07	ADIV	ETF	13.55	13.584	13.55	13.584	700.0
2023-12-07	ADME	ETF	37.02	37.21	37.02	37.204	11900.0
2023-12-07	ADPV	ETF	23.27	23.36	23.27	23.356	3004.0
2023-12-07	AEMB	ETF	37.5	37.5	37.426	37.426	200.0
2023-12-07	AESR	ETF	13.09	13.14	13.07	13.1	17500.0
2023-12-07	AETH	ETF	35.12	35.26	34.7867	35.0987	1294.0
2023-12-07	AFIF	ETF	9.02	9.06	9.01	9.03	77500.0
2023-12-07	AFK	ETF	13.7	13.96	13.61	13.68	15400.0
2023-12-07	AFMC	ETF	25.238	25.238	25.238	25.238	100.0
2023-12-07	AFSM	ETF	25.05	25.341	25.05	25.341	1600.0
2023-12-07	AFTY	ETF	13.59	13.59	13.59	13.59	100.0
2023-12-07	AGG	ETF	97.22	97.56	97.22	97.38	7157900.0
2023-12-07	AGGH	ETF	21.8	21.8	21.67	21.74	12530.0
2023-12-07	AGGY	ETF	43.16	43.28	43.13	43.2	110700.0
2023-12-07	AGNG	ETF	27.02	27.14	27.02	27.02	700.0
2023-12-07	AGOX	ETF	23.81	23.93	23.71	23.735	33800.0
2023-12-07	AGQ	ETF	27.74	27.76	26.99	27.49	1111600.0
2023-12-07	AGQI	ETF	12.75	12.81	12.75	12.79	20777.0
2023-12-07	AGZ	ETF	107.44	107.56	107.41	107.49	17500.0
2023-12-07	AGZD	ETF	21.86	21.96	21.85	21.88	21200.0
2023-12-07	AHLT	ETF	23.79	23.7962	23.77	23.7962	2837.0
2023-12-07	AHYB	ETF	44.61	44.68	44.6	44.6	34700.0
2023-12-07	AIA	ETF	55.59	55.96	55.59	55.96	15900.0
2023-12-07	AIEQ	ETF	32.03	32.328	31.891	32.295	13100.0
2023-12-07	AIQ	ETF	29.53	29.745	29.46	29.72	418400.0

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

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