PREVIEW / etf_daily / 2023-08-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-07.parquet
  size:    107 KB
  rows:    2,994

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-08-07	SPY	ETF	448.71	450.87	447.99	450.71	58357500.0
2023-08-07	QQQ	ETF	373.88	375.29	371.51	375.19	37230444.0
2023-08-07	IWM	ETF	194.66	195.06	192.68	194.3	20185000.0
2023-08-07	DIA	ETF	352.04	354.87	351.88	354.62	2390800.0
2023-08-07	GLD	ETF	180.15	180.15	179.27	179.78	4510400.0
2023-08-07	TLT	ETF	96.11	96.2	95.5	95.58	35862900.0
2023-08-07	AAA	ETF	24.82	24.83	24.71	24.75	600.0
2023-08-07	AAAU	ETF	19.23	19.23	19.14	19.19	735600.0
2023-08-07	AADR	ETF	51.59	51.77	51.59	51.77	600.0
2023-08-07	AAPB	ETF	25.6	25.6	24.8	25.15	50812.0
2023-08-07	AAPD	ETF	21.4	21.99	21.33	21.84	365308.0
2023-08-07	AAPU	ETF	26.26	26.5	25.2821	25.59	335674.0
2023-08-07	AAXJ	ETF	68.41	68.41	67.86	68.12	421100.0
2023-08-07	ABEQ	ETF	28.4	28.45	28.36	28.42	15700.0
2023-08-07	ACES	ETF	44.83	44.83	43.461	43.89	43200.0
2023-08-07	ACIO	ETF	31.39	31.53	31.389	31.52	57100.0
2023-08-07	ACSI	ETF	47.43	47.508	47.43	47.508	600.0
2023-08-07	ACT	ETF	29.15	29.59	29.141	29.57	246038.0
2023-08-07	ACTV	ETF	32.99	32.99	32.92	32.92	3700.0
2023-08-07	ACVF	ETF	34.36	34.52	34.36	34.502	12500.0
2023-08-07	ACWF	ETF	35.88	36.07	35.78	35.9471	16174.0
2023-08-07	ACWI	ETF	97.08	97.33	96.74	97.29	1602700.0
2023-08-07	ACWV	ETF	98.31	98.55	98.27	98.49	77000.0
2023-08-07	ACWX	ETF	49.77	49.81	49.52	49.79	703800.0
2023-08-07	ADFI	ETF	8.41	8.41	8.39	8.405	15600.0
2023-08-07	ADIV	ETF	14.075	14.075	14.075	14.075	100.0
2023-08-07	ADME	ETF	36.76	36.83	36.67	36.83	24300.0
2023-08-07	ADPV	ETF	25.7	25.734	25.69	25.734	1286.0
2023-08-07	AEMB	ETF	37.49	37.49	37.395	37.395	400.0
2023-08-07	AESR	ETF	12.89	12.98	12.86	12.98	42000.0
2023-08-07	AFIF	ETF	8.93	8.95	8.9	8.92	417200.0
2023-08-07	AFK	ETF	15.36	15.36	15.21	15.29	5700.0
2023-08-07	AFLG	ETF	25.852	25.852	25.852	25.852	100.0
2023-08-07	AFMC	ETF	25.617	25.617	25.617	25.617	100.0
2023-08-07	AFTY	ETF	15.79	15.799	15.77	15.799	1700.0
2023-08-07	AGG	ETF	96.64	96.7	96.48	96.7	9732600.0
2023-08-07	AGGH	ETF	22.23	22.26	22.15	22.26	8871.0
2023-08-07	AGGY	ETF	42.67	42.7	42.62	42.64	107800.0
2023-08-07	AGNG	ETF	27.3	27.46	27.27	27.46	15100.0
2023-08-07	AGOV	ETF	75.7	75.7	75.5478	75.5478	139.0
2023-08-07	AGOX	ETF	23.64	23.85	23.64	23.76	48900.0
2023-08-07	AGQ	ETF	28.35	28.35	27.22	27.29	929100.0
2023-08-07	AGZ	ETF	106.55	106.64	106.53	106.57	12600.0
2023-08-07	AGZD	ETF	22.12	22.135	21.99	22.11	35800.0
2023-08-07	AHYB	ETF	43.99	43.999	43.926	43.999	1100.0
2023-08-07	AIA	ETF	61.0	61.0	60.45	60.73	15800.0
2023-08-07	AIEQ	ETF	32.55	32.692	32.397	32.682	5000.0
2023-08-07	AIQ	ETF	28.59	28.59	28.32	28.55	311500.0
2023-08-07	AIRR	ETF	53.94	54.1	53.59	54.0	50100.0
2023-08-07	AIVI	ETF	39.47	39.53	39.47	39.53	600.0

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

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