PREVIEW / etf_daily / 2023-02-02

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-02.parquet
  size:    109 KB
  rows:    2,956

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-02-02	SPY	ETF	414.86	418.31	412.88	416.78	101654500.0
2023-02-02	QQQ	ETF	307.57	313.68	306.73	311.72	83070628.0
2023-02-02	IWM	ETF	196.01	199.26	194.35	198.32	31020400.0
2023-02-02	DIA	ETF	341.51	341.51	338.01	340.43	5169400.0
2023-02-02	GLD	ETF	181.08	181.11	177.74	177.9	8842400.0
2023-02-02	TLT	ETF	108.92	109.35	108.09	108.32	19548400.0
2023-02-02	AAA	ETF	24.53	24.53	24.505	24.5297	1830.0
2023-02-02	AAAU	ETF	19.32	19.32	18.96	18.97	1375000.0
2023-02-02	AADR	ETF	50.14	50.14	49.51	49.64	4700.0
2023-02-02	AAPB	ETF	19.45	19.83	19.23	19.76	24459.0
2023-02-02	AAPD	ETF	26.37	26.4604	25.95	25.98	367239.0
2023-02-02	AAPU	ETF	20.3	20.7299	20.14	20.68	400730.0
2023-02-02	AAXJ	ETF	72.22	72.22	71.21	71.54	1216500.0
2023-02-02	ABEQ	ETF	28.7	28.83	28.7	28.73	5300.0
2023-02-02	ACES	ETF	54.62	55.516	53.58	54.213	45800.0
2023-02-02	ACIO	ETF	30.06	30.17	29.955	30.11	207500.0
2023-02-02	ACSI	ETF	47.0866	47.0866	47.0866	47.0866	54.0
2023-02-02	ACT	ETF	24.99	25.1	24.83	24.9	138101.0
2023-02-02	ACTV	ETF	33.13	34.06	33.13	33.8	8676.0
2023-02-02	ACTX	ETF	0.44	0.4499	0.4125	0.44	51075.0
2023-02-02	ACVF	ETF	31.89	32.042	31.865	31.984	6000.0
2023-02-02	ACWF	ETF	34.37	34.37	34.11	34.2505	4221.0
2023-02-02	ACWI	ETF	92.95	93.24	92.22	92.93	3485900.0
2023-02-02	ACWV	ETF	97.24	97.24	96.5	96.85	342700.0
2023-02-02	ACWX	ETF	50.15	50.15	49.62	49.88	1523315.0
2023-02-02	ADFI	ETF	8.675	8.69	8.675	8.675	12300.0
2023-02-02	ADIV	ETF	14.528	14.528	14.528	14.528	100.0
2023-02-02	ADME	ETF	34.815	35.02	34.81	34.96	130500.0
2023-02-02	ADPV	ETF	25.37	25.48	25.35	25.35	40469.0
2023-02-02	ADRE	ETF	43.44	43.44	42.72	42.98	42924.0
2023-02-02	AEMB	ETF	39.76	39.76	39.76	39.76	100.0
2023-02-02	AESR	ETF	12.01	12.01	11.91	11.97	26700.0
2023-02-02	AFIF	ETF	8.93	8.93	8.91	8.915	102625.0
2023-02-02	AFK	ETF	17.46	17.46	17.1801	17.28	7331.0
2023-02-02	AFLG	ETF	24.822	24.94	24.822	24.851	1200.0
2023-02-02	AFMC	ETF	24.64	24.726	24.64	24.726	100.0
2023-02-02	AFTY	ETF	17.49	17.51	17.38	17.433	1900.0
2023-02-02	AGG	ETF	101.04	101.15	100.74	100.79	9197800.0
2023-02-02	AGGH	ETF	22.71	22.71	22.69	22.69	525.0
2023-02-02	AGGY	ETF	44.54	44.58	44.42	44.52	166600.0
2023-02-02	AGNG	ETF	27.23	27.294	27.22	27.294	500.0
2023-02-02	AGOV	ETF	79.7195	79.7195	79.7195	79.7195	1.0
2023-02-02	AGOX	ETF	22.469	22.67	22.425	22.58	13900.0
2023-02-02	AGQ	ETF	33.09	33.14	30.3	30.42	1147500.0
2023-02-02	AGZ	ETF	108.52	108.6697	108.35	108.35	44271.0
2023-02-02	AGZD	ETF	21.895	21.895	21.855	21.87	44000.0
2023-02-02	AHHX	ETF	8.85	8.87	8.8101	8.845	3786.0
2023-02-02	AHYB	ETF	44.867	44.867	44.867	44.867	100.0
2023-02-02	AIA	ETF	66.44	66.44	65.54	65.87	284060.0
2023-02-02	AIEQ	ETF	33.18	33.583	32.831	33.24	293600.0

> showing 50 of 2,956 rows — these rows as CSV

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