PREVIEW / etf_daily / 2023-08-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-01.parquet
  size:    107 KB
  rows:    3,012

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-01	SPY	ETF	456.27	457.25	455.49	456.48	55291500.0
2023-08-01	QQQ	ETF	382.31	383.56	380.69	382.79	41308457.0
2023-08-01	IWM	ETF	197.43	197.94	195.78	197.8	27444300.0
2023-08-01	DIA	ETF	355.27	356.7	355.14	356.2	2581900.0
2023-08-01	GLD	ETF	180.85	181.38	180.19	180.46	6239700.0
2023-08-01	TLT	ETF	98.84	98.92	97.9	98.14	34943400.0
2023-08-01	AAA	ETF	24.591	24.67	24.591	24.65	300.0
2023-08-01	AAAU	ETF	19.31	19.35	19.24	19.27	1037700.0
2023-08-01	AADR	ETF	52.7	52.7	52.58	52.58	400.0
2023-08-01	AAPB	ETF	29.68	29.72	29.4393	29.53	15069.0
2023-08-01	AAPD	ETF	19.93	20.0199	19.88	19.99	73421.0
2023-08-01	AAPU	ETF	29.56	29.5644	29.2809	29.35	105394.0
2023-08-01	AAXJ	ETF	69.95	69.97	69.55	69.7	614300.0
2023-08-01	ABEQ	ETF	28.568	28.587	28.53	28.587	5500.0
2023-08-01	ACES	ETF	47.79	47.99	47.4	47.46	23700.0
2023-08-01	ACIO	ETF	31.776	31.85	31.775	31.821	64400.0
2023-08-01	ACSI	ETF	48.041	48.041	48.041	48.041	100.0
2023-08-01	ACT	ETF	27.19	27.2	26.85	27.04	160049.0
2023-08-01	ACTV	ETF	33.42	33.42	33.25	33.38	10600.0
2023-08-01	ACVF	ETF	34.98	34.98	34.75	34.86	15500.0
2023-08-01	ACWF	ETF	36.49	36.5	36.38	36.4345	5689.0
2023-08-01	ACWI	ETF	98.83	99.01	98.53	98.7	3209200.0
2023-08-01	ACWV	ETF	99.41	99.54	98.94	99.04	336500.0
2023-08-01	ACWX	ETF	50.7	50.79	50.43	50.52	1092000.0
2023-08-01	ADFI	ETF	8.435	8.44	8.421	8.435	8600.0
2023-08-01	ADIV	ETF	14.33	14.33	14.22	14.235	600.0
2023-08-01	ADME	ETF	37.35	37.35	37.22	37.32	46400.0
2023-08-01	ADPV	ETF	25.5211	25.6355	25.5211	25.6355	3779.0
2023-08-01	AEMB	ETF	37.6	37.6	37.6	37.6	100.0
2023-08-01	AESR	ETF	13.1	13.12	13.1	13.114	24500.0
2023-08-01	AFIF	ETF	8.9	8.94	8.88	8.9	11100.0
2023-08-01	AFK	ETF	15.88	15.88	15.46	15.65	13900.0
2023-08-01	AFLG	ETF	26.052	26.122	26.05	26.122	800.0
2023-08-01	AFMC	ETF	25.708	25.708	25.708	25.708	100.0
2023-08-01	AFSM	ETF	26.08	26.08	26.08	26.08	100.0
2023-08-01	AFTY	ETF	15.92	15.92	15.88	15.88	1000.0
2023-08-01	AGG	ETF	97.01	97.09	96.71	96.77	8810400.0
2023-08-01	AGGH	ETF	22.21	22.27	22.17	22.17	2546.0
2023-08-01	AGGY	ETF	42.83	42.86	42.72	42.76	89100.0
2023-08-01	AGNG	ETF	27.705	27.74	27.68	27.74	2500.0
2023-08-01	AGOV	ETF	75.53	76.2	75.235	75.56	5839.0
2023-08-01	AGOX	ETF	24.06	24.17	23.98	24.124	51900.0
2023-08-01	AGQ	ETF	30.45	30.71	29.9	30.32	551200.0
2023-08-01	AGZ	ETF	106.43	106.44	106.34	106.38	9200.0
2023-08-01	AGZD	ETF	22.175	22.19	22.145	22.17	86600.0
2023-08-01	AHYB	ETF	44.215	44.215	43.956	43.956	100.0
2023-08-01	AIA	ETF	62.78	62.82	62.4	62.49	41100.0
2023-08-01	AIEQ	ETF	33.45	33.45	32.95	33.318	18900.0
2023-08-01	AIQ	ETF	29.41	29.45	29.213	29.41	370500.0
2023-08-01	AIRR	ETF	54.37	54.845	54.331	54.82	56400.0

> showing 50 of 3,012 rows — these rows as CSV

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