PREVIEW / etf_daily / 2023-09-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-05.parquet
  size:    108 KB
  rows:    3,023

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-09-05	SPY	ETF	450.73	451.06	449.17	449.24	55166200.0
2023-09-05	QQQ	ETF	376.77	379.3093	375.83	378.07	32344222.0
2023-09-05	IWM	ETF	189.65	189.9	186.77	186.83	27160100.0
2023-09-05	DIA	ETF	349.08	349.28	346.9	346.98	1906900.0
2023-09-05	GLD	ETF	179.33	179.44	178.64	178.64	7056800.0
2023-09-05	TLT	ETF	94.28	94.29	93.49	93.52	29435900.0
2023-09-05	AAA	ETF	24.7	24.763	24.69	24.74	800.0
2023-09-05	AAAU	ETF	19.16	19.16	19.08	19.08	1256500.0
2023-09-05	AADR	ETF	50.43	52.22	50.43	51.61	3300.0
2023-09-05	AAPB	ETF	27.2	27.67	27.2	27.65	11664.0
2023-09-05	AAPD	ETF	20.8	20.86	20.5952	20.6223	80028.0
2023-09-05	AAPU	ETF	27.47	27.86	27.36	27.81	114073.0
2023-09-05	AAXJ	ETF	66.0	66.22	65.92	65.99	359700.0
2023-09-05	ABEQ	ETF	28.205	28.205	27.96	27.96	10000.0
2023-09-05	ACES	ETF	41.65	41.87	41.29	41.59	251500.0
2023-09-05	ACIO	ETF	31.514	31.54	31.46	31.47	15200.0
2023-09-05	ACSI	ETF	46.329	46.329	46.329	46.329	100.0
2023-09-05	ACT	ETF	28.71	28.71	27.88	27.89	300380.0
2023-09-05	ACTV	ETF	32.295	32.38	31.645	31.645	6700.0
2023-09-05	ACVF	ETF	34.72	34.72	34.608	34.63	5700.0
2023-09-05	ACWF	ETF	35.75	35.79	35.7048	35.7048	3977.0
2023-09-05	ACWI	ETF	96.59	96.63	96.21	96.21	2095100.0
2023-09-05	ACWV	ETF	97.49	97.49	96.91	96.91	206200.0
2023-09-05	ACWX	ETF	48.75	48.77	48.51	48.53	1220800.0
2023-09-05	ADFI	ETF	8.395	8.41	8.394	8.394	2500.0
2023-09-05	ADIV	ETF	13.704	13.704	13.704	13.704	100.0
2023-09-05	ADME	ETF	36.8	36.875	36.731	36.731	3800.0
2023-09-05	ADPV	ETF	25.13	25.14	25.06	25.06	807.0
2023-09-05	AEMB	ETF	36.695	36.695	36.695	36.695	100.0
2023-09-05	AESR	ETF	12.922	12.925	12.87	12.89	26100.0
2023-09-05	AFIF	ETF	9.02	9.02	8.89	8.89	19400.0
2023-09-05	AFK	ETF	14.93	14.98	14.65	14.68	15500.0
2023-09-05	AFLG	ETF	25.59	25.59	25.587	25.587	200.0
2023-09-05	AFMC	ETF	24.97	24.99	24.77	24.77	2400.0
2023-09-05	AFSM	ETF	24.773	24.773	24.773	24.773	100.0
2023-09-05	AFTY	ETF	15.1	15.15	15.1	15.144	200.0
2023-09-05	AGG	ETF	95.85	95.87	95.52	95.52	6111400.0
2023-09-05	AGGH	ETF	22.0	22.0	21.88	21.9034	5120.0
2023-09-05	AGGY	ETF	42.35	42.36	42.23	42.23	132600.0
2023-09-05	AGNG	ETF	27.14	27.14	26.95	26.979	7000.0
2023-09-05	AGOV	ETF	74.1744	74.1744	74.1744	74.1744	30.0
2023-09-05	AGOX	ETF	23.67	23.73	23.626	23.65	15500.0
2023-09-05	AGQ	ETF	28.7	28.84	27.94	28.05	580600.0
2023-09-05	AGZ	ETF	106.4	106.4	106.28	106.29	24000.0
2023-09-05	AGZD	ETF	22.22	22.23	22.04	22.22	46200.0
2023-09-05	AHLT	ETF	25.87	25.92	25.74	25.8806	2172.0
2023-09-05	AHYB	ETF	43.948	43.95	43.864	43.864	900.0
2023-09-05	AIA	ETF	58.6	58.76	58.49	58.6	32500.0
2023-09-05	AIEQ	ETF	31.49	31.49	31.23	31.258	10900.0
2023-09-05	AIQ	ETF	28.71	28.879	28.61	28.8	347000.0

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

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