PREVIEW / etf_daily / 2023-05-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-09.parquet
  size:    109 KB
  rows:    2,950

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-05-09	SPY	ETF	411.13	412.09	410.69	410.93	49220100.0
2023-05-09	QQQ	ETF	322.0	322.88	321.32	321.64	31768800.0
2023-05-09	IWM	ETF	172.98	174.27	172.16	173.53	21465500.0
2023-05-09	DIA	ETF	335.41	336.68	335.15	335.77	1924900.0
2023-05-09	GLD	ETF	188.12	189.33	188.07	189.02	7098800.0
2023-05-09	TLT	ETF	103.5	103.64	103.0	103.05	19182500.0
2023-05-09	AAA	ETF	24.55	24.55	24.55	24.55	84.0
2023-05-09	AAAU	ETF	20.08	20.2	20.07	20.17	246800.0
2023-05-09	AADR	ETF	45.62	47.16	45.62	46.86	1700.0
2023-05-09	AAPB	ETF	24.0978	24.1	24.04	24.1	1349.0
2023-05-09	AAPD	ETF	22.58	22.75	22.55	22.72	148695.0
2023-05-09	AAPU	ETF	24.86	24.9001	24.577	24.62	54274.0
2023-05-09	AAXJ	ETF	66.28	66.57	66.26	66.47	294600.0
2023-05-09	ABEQ	ETF	28.73	28.777	28.73	28.738	14000.0
2023-05-09	ACES	ETF	41.88	42.44	41.57	42.32	203100.0
2023-05-09	ACIO	ETF	30.17	30.17	30.07	30.095	144000.0
2023-05-09	ACSI	ETF	43.7616	43.7616	43.7616	43.7616	29.0
2023-05-09	ACT	ETF	24.67	24.73	24.07	24.4	120794.0
2023-05-09	ACTV	ETF	28.86	28.86	28.68	28.77	4917.0
2023-05-09	ACVF	ETF	31.26	31.26	31.181	31.181	2400.0
2023-05-09	ACWF	ETF	33.92	33.9903	33.92	33.9475	32418.0
2023-05-09	ACWI	ETF	91.81	92.15	91.75	91.96	1514800.0
2023-05-09	ACWV	ETF	99.68	100.19	99.68	100.01	70500.0
2023-05-09	ACWX	ETF	49.55	49.785	49.51	49.72	1174561.0
2023-05-09	ADFI	ETF	8.49	8.49	8.48	8.49	23400.0
2023-05-09	ADIV	ETF	13.72	13.72	13.72	13.72	100.0
2023-05-09	ADME	ETF	34.7	34.77	34.69	34.73	67500.0
2023-05-09	ADPV	ETF	23.21	23.21	23.1517	23.1517	14855.0
2023-05-09	AEMB	ETF	37.49	37.49	37.49	37.49	100.0
2023-05-09	AESR	ETF	12.021	12.05	12.021	12.03	20300.0
2023-05-09	AFIF	ETF	8.81	8.8524	8.81	8.835	9246.0
2023-05-09	AFK	ETF	15.78	15.78	15.5	15.6447	6019.0
2023-05-09	AFLG	ETF	23.785	23.785	23.785	23.785	100.0
2023-05-09	AFMC	ETF	22.71	22.77	22.71	22.73	300.0
2023-05-09	AFSM	ETF	22.585	22.65	22.585	22.59	400.0
2023-05-09	AFTY	ETF	16.27	16.29	16.27	16.29	800.0
2023-05-09	AGG	ETF	99.11	99.19	99.01	99.01	5712200.0
2023-05-09	AGGH	ETF	23.07	23.07	23.06	23.06	728.0
2023-05-09	AGGY	ETF	43.57	43.59	43.525	43.53	72300.0
2023-05-09	AGNG	ETF	28.19	28.235	28.18	28.18	1300.0
2023-05-09	AGOV	ETF	77.225	77.225	77.225	77.225	116.0
2023-05-09	AGOX	ETF	21.77	21.77	21.48	21.594	15900.0
2023-05-09	AGQ	ETF	34.53	35.13	34.46	34.89	640000.0
2023-05-09	AGZ	ETF	108.2803	108.32	108.21	108.25	102574.0
2023-05-09	AGZD	ETF	21.675	21.775	21.675	21.75	24200.0
2023-05-09	AHYB	ETF	43.604	43.604	43.604	43.604	400.0
2023-05-09	AIA	ETF	58.17	58.35	58.04	58.24	55062.0
2023-05-09	AIEQ	ETF	27.49	27.68	27.364	27.532	11500.0
2023-05-09	AIQ	ETF	23.7	23.9099	23.6	23.72	102139.0
2023-05-09	AIRR	ETF	46.37	46.885	46.2	46.68	28000.0

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

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