PREVIEW / etf_daily / 2023-07-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-21.parquet
  size:    106 KB
  rows:    2,958

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-21	SPY	ETF	453.96	454.17	452.17	452.18	71245400.0
2023-07-21	QQQ	ETF	379.18	379.92	375.191	375.63	60499643.0
2023-07-21	IWM	ETF	196.39	196.62	194.09	194.46	28972100.0
2023-07-21	DIA	ETF	352.81	353.32	351.71	352.14	2969000.0
2023-07-21	GLD	ETF	182.06	182.46	181.68	182.18	3843500.0
2023-07-21	TLT	ETF	102.16	102.35	101.63	101.73	20655700.0
2023-07-21	AAA	ETF	24.69	24.715	24.68	24.715	6800.0
2023-07-21	AAAU	ETF	19.44	19.48	19.4	19.45	882400.0
2023-07-21	AADR	ETF	51.48	51.53	51.38	51.45	3800.0
2023-07-21	AAPB	ETF	29.2344	29.2344	28.451	28.57	10009.0
2023-07-21	AAPD	ETF	20.11	20.385	20.04	20.35	108166.0
2023-07-21	AAPU	ETF	29.05	29.24	28.42	28.57	79461.0
2023-07-21	AAXJ	ETF	67.62	67.85	67.4	67.45	343600.0
2023-07-21	ABEQ	ETF	28.473	28.529	28.47	28.47	5100.0
2023-07-21	ACES	ETF	49.27	49.27	47.934	48.33	29600.0
2023-07-21	ACIO	ETF	31.54	31.61	31.51	31.54	29000.0
2023-07-21	ACSI	ETF	47.786	47.786	47.786	47.786	100.0
2023-07-21	ACT	ETF	26.84	26.84	26.48	26.5	125659.0
2023-07-21	ACTV	ETF	33.1	33.1	32.83	32.836	5700.0
2023-07-21	ACVF	ETF	34.82	34.82	34.635	34.635	4100.0
2023-07-21	ACWF	ETF	36.3	36.3	36.19	36.1944	17084.0
2023-07-21	ACWI	ETF	98.26	98.32	97.94	97.99	2109400.0
2023-07-21	ACWV	ETF	99.77	99.9	99.62	99.72	445200.0
2023-07-21	ACWX	ETF	50.42	50.46	50.29	50.35	1787000.0
2023-07-21	ADFI	ETF	8.47	8.485	8.47	8.485	4100.0
2023-07-21	ADIV	ETF	13.75	13.75	13.75	13.75	100.0
2023-07-21	ADME	ETF	36.95	37.03	36.92	36.94	27300.0
2023-07-21	ADPV	ETF	25.45	25.47	25.4126	25.4126	469.0
2023-07-21	AEMB	ETF	37.87	37.87	37.87	37.87	100.0
2023-07-21	AESR	ETF	13.06	13.1	13.03	13.04	16400.0
2023-07-21	AFIF	ETF	8.83	8.83	8.8	8.82	11800.0
2023-07-21	AFK	ETF	15.8	15.83	15.65	15.65	4700.0
2023-07-21	AFMC	ETF	25.73	25.73	25.504	25.504	100.0
2023-07-21	AFSM	ETF	25.56	25.56	25.56	25.56	100.0
2023-07-21	AFTY	ETF	15.03	15.037	15.03	15.037	300.0
2023-07-21	AGG	ETF	98.11	98.15	97.94	97.99	7605200.0
2023-07-21	AGGH	ETF	22.64	22.6513	22.55	22.55	3149.0
2023-07-21	AGGY	ETF	43.24	43.27	43.196	43.21	115800.0
2023-07-21	AGNG	ETF	28.105	28.2	28.06	28.16	3900.0
2023-07-21	AGOV	ETF	76.09	77.385	76.0	76.0	1096.0
2023-07-21	AGOX	ETF	24.105	24.15	23.94	23.94	22300.0
2023-07-21	AGQ	ETF	31.55	31.64	31.21	31.27	605400.0
2023-07-21	AGRH	ETF	25.69	25.69	25.6551	25.6551	2850.0
2023-07-21	AGZ	ETF	107.06	107.1	106.98	107.08	23100.0
2023-07-21	AGZD	ETF	22.155	22.18	22.13	22.175	104200.0
2023-07-21	AHYB	ETF	44.228	44.334	44.19	44.257	900.0
2023-07-21	AIA	ETF	60.46	60.47	60.01	60.1	19900.0
2023-07-21	AIEQ	ETF	32.65	32.65	32.42	32.46	15400.0
2023-07-21	AIQ	ETF	28.85	28.938	28.563	28.62	287700.0
2023-07-21	AIRR	ETF	55.09	55.094	54.19	54.33	32300.0

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

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