PREVIEW / etf_daily / 2023-12-01

all etf daily files

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

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-01	SPY	ETF	455.77	459.65	455.16	459.1	89097900.0
2023-12-01	QQQ	ETF	387.75	390.54	386.0726	389.94	40490068.0
2023-12-01	IWM	ETF	179.2	185.18	178.21	184.91	64172400.0
2023-12-01	DIA	ETF	360.02	363.25	359.86	363.05	5850900.0
2023-12-01	GLD	ETF	188.81	192.4	188.69	192.01	16724900.0
2023-12-01	TLT	ETF	91.31	93.06	91.13	92.99	64141700.0
2023-12-01	AAA	ETF	24.93	24.93	24.79	24.803	7500.0
2023-12-01	AAAU	ETF	20.18	20.56	20.17	20.52	1831700.0
2023-12-01	AADR	ETF	54.09	54.45	54.09	54.45	400.0
2023-12-01	AAPB	ETF	26.87	27.19	26.709	27.19	16984.0
2023-12-01	AAPD	ETF	20.595	20.7	20.45	20.47	119144.0
2023-12-01	AAPU	ETF	27.29	27.57	27.11	27.53	56196.0
2023-12-01	AAXJ	ETF	64.88	65.62	64.77	65.6	544300.0
2023-12-01	ABEQ	ETF	28.224	28.274	28.224	28.274	2900.0
2023-12-01	ACES	ETF	31.12	32.79	31.12	32.78	210700.0
2023-12-01	ACIO	ETF	32.28	32.41	32.22	32.41	51000.0
2023-12-01	ACSI	ETF	48.566	48.566	48.566	48.566	100.0
2023-12-01	ACT	ETF	27.63	27.99	27.62	27.9	173699.0
2023-12-01	ACTV	ETF	30.02	30.842	30.02	30.842	2500.0
2023-12-01	ACVF	ETF	34.89	35.15	34.89	35.095	5800.0
2023-12-01	ACWF	ETF	36.6405	36.953	36.6405	36.928	7265.0
2023-12-01	ACWI	ETF	97.83	98.85	97.78	98.75	5299500.0
2023-12-01	ACWV	ETF	98.75	99.31	98.6	99.25	139500.0
2023-12-01	ACWX	ETF	49.19	49.78	49.17	49.75	2283400.0
2023-12-01	ADFI	ETF	8.41	8.46	8.41	8.44	14400.0
2023-12-01	ADIV	ETF	13.71	13.79	13.71	13.79	300.0
2023-12-01	ADME	ETF	37.261	37.282	37.261	37.27	2700.0
2023-12-01	ADPV	ETF	23.67	23.92	23.67	23.88	31205.0
2023-12-01	AEMB	ETF	37.255	37.255	37.255	37.255	100.0
2023-12-01	AESR	ETF	13.01	13.13	13.01	13.1	14600.0
2023-12-01	AETH	ETF	31.15	31.45	31.112	31.3101	3457.0
2023-12-01	AFIF	ETF	8.99	8.99	8.98	8.99	4300.0
2023-12-01	AFK	ETF	14.02	14.25	13.93	14.25	15700.0
2023-12-01	AFLG	ETF	26.51	26.51	26.51	26.51	100.0
2023-12-01	AFSM	ETF	25.347	25.347	25.347	25.347	100.0
2023-12-01	AFTY	ETF	14.003	14.003	14.003	14.003	100.0
2023-12-01	AGG	ETF	96.0	96.87	95.97	96.83	11774300.0
2023-12-01	AGGH	ETF	21.3873	21.57	21.3873	21.52	9660.0
2023-12-01	AGGY	ETF	42.64	42.955	42.61	42.93	136300.0
2023-12-01	AGNG	ETF	26.68	27.045	26.68	27.045	1500.0
2023-12-01	AGOX	ETF	23.9	23.99	23.864	23.95	26000.0
2023-12-01	AGQ	ETF	31.03	31.82	30.88	31.68	1115900.0
2023-12-01	AGQI	ETF	12.74	12.8499	12.74	12.8	734953.0
2023-12-01	AGZ	ETF	106.76	107.28	106.47	107.24	24500.0
2023-12-01	AGZD	ETF	22.37	22.39	22.27	22.32	77700.0
2023-12-01	AHLT	ETF	23.09	24.22	22.565	24.06	8494.0
2023-12-01	AHYB	ETF	44.24	44.624	44.24	44.624	2100.0
2023-12-01	AIA	ETF	56.71	57.47	56.69	57.45	24600.0
2023-12-01	AIEQ	ETF	31.08	32.47	31.08	32.44	18900.0
2023-12-01	AIQ	ETF	29.61	29.92	29.49	29.9	352400.0

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

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