PREVIEW / etf_daily / 2023-12-08

all etf daily files

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

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-08	SPY	ETF	457.46	460.75	457.21	460.2	83080900.0
2023-12-08	QQQ	ETF	388.67	392.62	388.4801	392.17	46687525.0
2023-12-08	IWM	ETF	185.15	187.75	184.86	186.8	36020400.0
2023-12-08	DIA	ETF	361.76	363.68	361.38	363.12	2926000.0
2023-12-08	GLD	ETF	185.93	186.78	184.9	185.64	7880300.0
2023-12-08	TLT	ETF	94.42	94.72	93.91	94.54	44800500.0
2023-12-08	AAA	ETF	24.951	24.951	24.95	24.95	600.0
2023-12-08	AAAU	ETF	19.88	19.96	19.76	19.85	1951500.0
2023-12-08	AADR	ETF	53.02	54.21	53.02	54.05	1400.0
2023-12-08	AAPB	ETF	27.829	28.241	27.74	28.2	12947.0
2023-12-08	AAPD	ETF	20.21	20.24	20.0099	20.02	93789.0
2023-12-08	AAPU	ETF	28.1195	28.495	28.01	28.47	96072.0
2023-12-08	AAXJ	ETF	64.27	64.55	64.13	64.39	796900.0
2023-12-08	ABEQ	ETF	27.96	27.985	27.83	27.91	4200.0
2023-12-08	ACES	ETF	32.18	32.78	31.85	32.25	82400.0
2023-12-08	ACIO	ETF	32.31	32.48	32.28	32.42	51800.0
2023-12-08	ACSI	ETF	48.854	48.854	48.854	48.854	100.0
2023-12-08	ACT	ETF	27.33	27.63	27.12	27.54	197545.0
2023-12-08	ACTV	ETF	31.29	31.4	31.24	31.358	27300.0
2023-12-08	ACVF	ETF	34.8	35.15	34.8	35.105	3100.0
2023-12-08	ACWF	ETF	36.69	36.99	36.69	36.9051	2968.0
2023-12-08	ACWI	ETF	98.13	98.82	98.13	98.71	2459800.0
2023-12-08	ACWV	ETF	99.18	99.2	98.68	99.05	157900.0
2023-12-08	ACWX	ETF	49.23	49.55	49.22	49.48	2454600.0
2023-12-08	ADFI	ETF	8.44	8.45	8.43	8.45	15400.0
2023-12-08	ADIV	ETF	13.248	13.248	13.248	13.248	100.0
2023-12-08	ADME	ETF	37.12	37.37	37.12	37.31	16000.0
2023-12-08	ADVE	ETF	30.23	30.3173	30.23	30.3173	295.0
2023-12-08	AEMB	ETF	37.255	37.255	37.255	37.255	100.0
2023-12-08	AESR	ETF	13.22	13.22	13.13	13.19	22800.0
2023-12-08	AETH	ETF	35.22	35.3799	35.06	35.3799	3284.0
2023-12-08	AFIF	ETF	9.06	9.06	9.01	9.02	39800.0
2023-12-08	AFK	ETF	13.77	13.99	13.7	13.96	6700.0
2023-12-08	AFLG	ETF	26.55	26.572	26.55	26.572	600.0
2023-12-08	AFMC	ETF	25.44	25.47	25.43	25.43	2900.0
2023-12-08	AFTY	ETF	13.52	13.52	13.52	13.52	200.0
2023-12-08	AGG	ETF	96.99	97.07	96.72	96.89	6696600.0
2023-12-08	AGGH	ETF	21.63	21.63	21.55	21.62	8269.0
2023-12-08	AGGY	ETF	43.03	43.1	42.94	43.02	127600.0
2023-12-08	AGNG	ETF	26.972	27.07	26.95	27.07	1300.0
2023-12-08	AGOX	ETF	23.98	23.98	23.81	23.87	18000.0
2023-12-08	AGQ	ETF	26.38	26.86	25.51	25.68	2405700.0
2023-12-08	AGQI	ETF	12.76	12.8401	12.76	12.84	16655.0
2023-12-08	AGRH	ETF	25.715	25.715	25.715	25.715	257.0
2023-12-08	AGZ	ETF	107.14	107.26	107.05	107.08	22000.0
2023-12-08	AGZD	ETF	21.89	21.95	21.82	21.95	25800.0
2023-12-08	AHLT	ETF	23.9218	23.93	23.9078	23.93	345.0
2023-12-08	AHYB	ETF	44.55	44.58	44.485	44.58	1300.0
2023-12-08	AIA	ETF	55.7	55.95	55.61	55.77	28700.0
2023-12-08	AIEQ	ETF	32.22	32.862	32.22	32.735	10700.0

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

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