PREVIEW / etf_daily / 2023-07-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-07.parquet
  size:    108 KB
  rows:    2,991

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-07-07	SPY	ETF	438.63	442.64	438.3	438.55	86076100.0
2023-07-07	QQQ	ETF	367.23	370.48	366.01	366.24	47133749.0
2023-07-07	IWM	ETF	182.98	186.49	182.93	184.71	31690400.0
2023-07-07	DIA	ETF	337.97	340.4	337.19	337.43	2849600.0
2023-07-07	GLD	ETF	178.38	179.65	178.35	178.64	5200300.0
2023-07-07	TLT	ETF	99.18	99.6	98.99	99.08	28979600.0
2023-07-07	AAA	ETF	24.585	24.585	24.585	24.585	100.0
2023-07-07	AAAU	ETF	19.04	19.17	19.04	19.08	910200.0
2023-07-07	AADR	ETF	48.34	48.95	48.34	48.67	1400.0
2023-07-07	AAPB	ETF	28.54	28.94	28.36	28.46	8619.0
2023-07-07	AAPD	ETF	20.32	20.4601	20.22	20.43	109777.0
2023-07-07	AAPU	ETF	28.54	28.7993	28.27	28.34	93519.0
2023-07-07	AAXJ	ETF	65.57	66.38	65.55	66.05	851700.0
2023-07-07	ABEQ	ETF	27.92	27.97	27.88	27.88	10300.0
2023-07-07	ACES	ETF	45.05	46.7	45.05	45.95	46100.0
2023-07-07	ACIO	ETF	30.919	30.972	30.79	30.79	42600.0
2023-07-07	ACSI	ETF	46.687	46.687	46.687	46.687	100.0
2023-07-07	ACT	ETF	25.14	25.5	25.14	25.38	318586.0
2023-07-07	ACTV	ETF	31.22	31.74	31.22	31.462	6300.0
2023-07-07	ACTX	ETF	0.21	0.21	0.21	0.21	526.0
2023-07-07	ACVF	ETF	33.53	33.714	33.444	33.444	8200.0
2023-07-07	ACWF	ETF	34.82	35.16	34.82	34.9312	3086.0
2023-07-07	ACWI	ETF	94.48	95.42	94.44	94.71	949000.0
2023-07-07	ACWV	ETF	97.05	97.16	96.57	96.67	201500.0
2023-07-07	ACWX	ETF	48.1	48.67	48.09	48.47	3119400.0
2023-07-07	ADFI	ETF	8.38	8.39	8.37	8.38	21200.0
2023-07-07	ADIV	ETF	13.37	13.39	13.37	13.39	900.0
2023-07-07	ADME	ETF	36.02	36.17	35.94	35.94	4200.0
2023-07-07	ADPV	ETF	24.57	24.63	24.57	24.5865	725.0
2023-07-07	AEMB	ETF	36.93	36.93	36.93	36.93	100.0
2023-07-07	AESR	ETF	12.71	12.76	12.661	12.661	21500.0
2023-07-07	AFIF	ETF	8.81	8.85	8.81	8.82	5900.0
2023-07-07	AFK	ETF	14.6	14.69	14.59	14.69	5200.0
2023-07-07	AFLG	ETF	25.158	25.158	25.158	25.158	100.0
2023-07-07	AFMC	ETF	24.78	24.78	24.598	24.598	100.0
2023-07-07	AFSM	ETF	24.378	24.378	24.378	24.378	100.0
2023-07-07	AFTY	ETF	14.79	14.797	14.779	14.779	600.0
2023-07-07	AGG	ETF	96.42	96.75	96.42	96.53	8310500.0
2023-07-07	AGGH	ETF	22.17	22.2437	22.16	22.1926	64053.0
2023-07-07	AGGY	ETF	42.51	42.65	42.51	42.54	123200.0
2023-07-07	AGNG	ETF	27.0	27.12	27.0	27.09	800.0
2023-07-07	AGOV	ETF	74.795	74.795	74.795	74.795	2.0
2023-07-07	AGOX	ETF	23.229	23.34	23.12	23.12	41600.0
2023-07-07	AGQ	ETF	27.0	27.83	27.0	27.69	787300.0
2023-07-07	AGRH	ETF	25.62	25.64	25.5776	25.5776	3759.0
2023-07-07	AGZ	ETF	106.05	106.3	106.05	106.17	16300.0
2023-07-07	AGZD	ETF	22.14	22.175	22.06	22.145	30400.0
2023-07-07	AHYB	ETF	43.52	43.52	43.387	43.387	500.0
2023-07-07	AIA	ETF	58.7	59.64	58.66	59.3	19900.0
2023-07-07	AIEQ	ETF	31.27	31.674	31.27	31.462	10200.0

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

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