PREVIEW / etf_daily / 2023-08-08

all etf daily files

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

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-08	SPY	ETF	448.08	450.7	445.27	448.75	71361300.0
2023-08-08	QQQ	ETF	372.64	372.66	368.82	372.0	44726453.0
2023-08-08	IWM	ETF	192.14	193.29	190.52	193.08	25578200.0
2023-08-08	DIA	ETF	352.42	353.35	349.92	353.02	3033600.0
2023-08-08	GLD	ETF	178.64	179.33	178.46	178.64	6162900.0
2023-08-08	TLT	ETF	96.86	97.37	96.44	96.69	24010500.0
2023-08-08	AAA	ETF	24.73	24.73	24.7	24.73	2300.0
2023-08-08	AAAU	ETF	19.07	19.15	19.05	19.07	702300.0
2023-08-08	AADR	ETF	51.66	51.66	51.62	51.65	800.0
2023-08-08	AAPB	ETF	25.35	25.451	24.9006	25.38	16647.0
2023-08-08	AAPD	ETF	21.76	21.98	21.66	21.7	177486.0
2023-08-08	AAPU	ETF	25.76	25.8725	25.33	25.8	245678.0
2023-08-08	AAXJ	ETF	67.02	67.23	66.71	67.19	626400.0
2023-08-08	ABEQ	ETF	28.07	28.19	28.07	28.18	17100.0
2023-08-08	ACES	ETF	43.2	43.92	42.84	43.91	50400.0
2023-08-08	ACIO	ETF	31.49	31.49	31.275	31.39	54200.0
2023-08-08	ACSI	ETF	47.06	47.306	47.06	47.306	400.0
2023-08-08	ACT	ETF	29.22	29.49	28.98	29.47	159749.0
2023-08-08	ACTV	ETF	32.39	32.71	32.327	32.672	8700.0
2023-08-08	ACVF	ETF	34.24	34.47	34.178	34.426	12500.0
2023-08-08	ACWF	ETF	35.62	35.7669	35.5	35.7669	3001.0
2023-08-08	ACWI	ETF	96.46	96.83	95.98	96.73	2672500.0
2023-08-08	ACWV	ETF	98.26	98.32	97.92	98.17	142800.0
2023-08-08	ACWX	ETF	49.21	49.43	49.03	49.4	789500.0
2023-08-08	ADFI	ETF	8.42	8.425	8.411	8.425	8100.0
2023-08-08	ADIV	ETF	13.92	13.92	13.88	13.91	2100.0
2023-08-08	ADME	ETF	36.58	36.72	36.47	36.69	146700.0
2023-08-08	ADPV	ETF	25.78	25.81	25.78	25.7901	1756.0
2023-08-08	AEMB	ETF	37.43	37.48	37.425	37.44	2000.0
2023-08-08	AESR	ETF	12.83	12.91	12.81	12.91	26300.0
2023-08-08	AFIF	ETF	8.94	8.95	8.84	8.91	18700.0
2023-08-08	AFK	ETF	15.19	15.26	15.16	15.26	2600.0
2023-08-08	AFLG	ETF	25.53	25.754	25.53	25.754	300.0
2023-08-08	AFMC	ETF	25.34	25.42	25.3	25.42	900.0
2023-08-08	AFSM	ETF	25.805	25.805	25.805	25.805	100.0
2023-08-08	AFTY	ETF	15.69	15.69	15.66	15.69	600.0
2023-08-08	AGG	ETF	96.94	97.11	96.84	96.93	6867300.0
2023-08-08	AGGH	ETF	22.28	22.36	22.27	22.36	10113.0
2023-08-08	AGGY	ETF	42.77	42.835	42.735	42.76	58300.0
2023-08-08	AGNG	ETF	27.51	27.59	27.49	27.57	4800.0
2023-08-08	AGOV	ETF	75.43	75.43	75.43	75.43	10.0
2023-08-08	AGOX	ETF	23.45	23.73	23.45	23.61	8100.0
2023-08-08	AGQ	ETF	26.43	26.72	26.24	26.49	847600.0
2023-08-08	AGZ	ETF	106.57	106.84	106.57	106.73	10300.0
2023-08-08	AGZD	ETF	22.125	22.125	22.025	22.085	33400.0
2023-08-08	AHOY	ETF	20.6884	20.7844	20.6884	20.7844	1101.0
2023-08-08	AHYB	ETF	43.96	44.082	43.96	44.082	300.0
2023-08-08	AIA	ETF	59.41	59.6	59.13	59.53	58300.0
2023-08-08	AIEQ	ETF	32.13	32.464	31.856	32.439	9100.0
2023-08-08	AIQ	ETF	28.18	28.22	27.89	28.185	822100.0

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

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