PREVIEW / etf_daily / 2023-05-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-08.parquet
  size:    109 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-05-08	SPY	ETF	412.97	413.24	411.28	412.74	50046800.0
2023-05-08	QQQ	ETF	322.42	324.04	321.315	323.69	36465796.0
2023-05-08	IWM	ETF	175.26	175.55	173.13	174.05	22109900.0
2023-05-08	DIA	ETF	337.17	337.39	335.09	336.22	1789900.0
2023-05-08	GLD	ETF	187.82	188.67	187.49	187.69	6075400.0
2023-05-08	TLT	ETF	103.52	103.87	103.32	103.42	20587000.0
2023-05-08	AAA	ETF	24.5784	24.5784	24.545	24.545	505.0
2023-05-08	AAAU	ETF	20.05	20.13	20.01	20.03	469300.0
2023-05-08	AADR	ETF	47.14	47.31	47.14	47.22	1600.0
2023-05-08	AAPB	ETF	24.41	24.54	24.4	24.45	3273.0
2023-05-08	AAPD	ETF	22.66	22.67	22.47	22.5	177582.0
2023-05-08	AAPU	ETF	24.78	25.04	24.72	25.0	110176.0
2023-05-08	AAXJ	ETF	67.32	67.32	66.97	67.09	285600.0
2023-05-08	ABEQ	ETF	28.867	28.867	28.79	28.81	6600.0
2023-05-08	ACES	ETF	42.34	42.5	41.82	42.25	62100.0
2023-05-08	ACIO	ETF	30.145	30.21	30.114	30.21	37800.0
2023-05-08	ACSI	ETF	43.8826	43.8826	43.8826	43.8826	24.0
2023-05-08	ACT	ETF	23.87	24.23	23.61	23.85	155970.0
2023-05-08	ACTV	ETF	28.95	28.95	28.75	28.88	6802.0
2023-05-08	ACVF	ETF	31.43	31.43	31.24	31.29	3100.0
2023-05-08	ACWF	ETF	34.0489	34.11	33.97	34.11	43084.0
2023-05-08	ACWI	ETF	92.49	92.49	92.09	92.35	1866500.0
2023-05-08	ACWV	ETF	100.4	100.4	99.93	100.02	542300.0
2023-05-08	ACWX	ETF	50.07	50.12	49.87	49.97	542888.0
2023-05-08	ADFI	ETF	8.49	8.5	8.48	8.495	20600.0
2023-05-08	ADIV	ETF	13.85	13.85	13.85	13.85	100.0
2023-05-08	ADME	ETF	34.79	34.846	34.54	34.8	60300.0
2023-05-08	ADPV	ETF	23.16	23.2067	23.16	23.2067	151.0
2023-05-08	AEMB	ETF	37.525	37.525	37.525	37.525	100.0
2023-05-08	AESR	ETF	12.05	12.09	12.04	12.06	27000.0
2023-05-08	AFIF	ETF	8.8	8.83	8.79	8.8148	29052.0
2023-05-08	AFK	ETF	15.85	15.85	15.72	15.775	3998.0
2023-05-08	AFMC	ETF	22.81	22.81	22.801	22.801	700.0
2023-05-08	AFSM	ETF	22.65	22.687	22.65	22.687	100.0
2023-05-08	AFTY	ETF	16.24	16.41	16.24	16.4	10600.0
2023-05-08	AGG	ETF	99.21	99.35	99.08	99.1	5481300.0
2023-05-08	AGGH	ETF	23.035	23.07	23.035	23.0448	2768.0
2023-05-08	AGGY	ETF	43.59	43.64	43.53	43.56	85800.0
2023-05-08	AGNG	ETF	28.24	28.33	28.24	28.3	900.0
2023-05-08	AGOV	ETF	77.6601	77.6601	77.6601	77.6601	164.0
2023-05-08	AGOX	ETF	21.5	21.643	21.5	21.595	16200.0
2023-05-08	AGQ	ETF	34.91	35.16	34.69	34.82	553600.0
2023-05-08	AGRH	ETF	25.45	25.45	25.41	25.41	754.0
2023-05-08	AGZ	ETF	108.25	108.4455	108.25	108.3	15511.0
2023-05-08	AGZD	ETF	21.705	21.76	21.665	21.725	36800.0
2023-05-08	AHYB	ETF	43.615	43.69	43.615	43.69	1100.0
2023-05-08	AIA	ETF	59.11	59.1899	58.93	59.09	31964.0
2023-05-08	AIEQ	ETF	27.57	27.733	27.48	27.6	10000.0
2023-05-08	AIQ	ETF	23.84	23.92	23.73	23.91	71500.0
2023-05-08	AIRR	ETF	46.71	46.71	45.91	46.26	11100.0

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

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