PREVIEW / etf_daily / 2023-07-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-11.parquet
  size:    108 KB
  rows:    2,993

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-07-11	SPY	ETF	440.45	442.97	439.44	442.46	64463800.0
2023-07-11	QQQ	ETF	366.79	368.632	364.62	368.17	38214146.0
2023-07-11	IWM	ETF	188.48	190.08	187.69	189.8	26738800.0
2023-07-11	DIA	ETF	340.74	342.92	339.95	342.64	2483200.0
2023-07-11	GLD	ETF	179.43	179.71	179.13	179.45	2819600.0
2023-07-11	TLT	ETF	99.57	99.97	99.29	99.72	20491100.0
2023-07-11	AAA	ETF	24.648	24.648	24.61	24.61	300.0
2023-07-11	AAAU	ETF	19.15	19.18	19.12	19.16	617000.0
2023-07-11	AADR	ETF	48.79	49.12	48.73	49.12	1300.0
2023-07-11	AAPB	ETF	27.72	27.72	27.36	27.7	18331.0
2023-07-11	AAPD	ETF	20.62	20.879	20.61	20.73	75556.0
2023-07-11	AAPU	ETF	27.97	27.97	27.4662	27.74	119748.0
2023-07-11	AAXJ	ETF	66.7	66.92	66.38	66.85	275200.0
2023-07-11	ABEQ	ETF	27.96	28.021	27.93	28.021	1300.0
2023-07-11	ACES	ETF	47.12	47.525	46.68	47.2	235700.0
2023-07-11	ACIO	ETF	30.925	30.98	30.83	30.95	17900.0
2023-07-11	ACSI	ETF	47.126	47.126	47.126	47.126	100.0
2023-07-11	ACT	ETF	25.97	26.195	25.97	26.18	222367.0
2023-07-11	ACTV	ETF	32.05	32.27	32.05	32.257	12200.0
2023-07-11	ACTX	ETF	0.21	0.21	0.21	0.21	272.0
2023-07-11	ACVF	ETF	33.78	33.865	33.648	33.865	5600.0
2023-07-11	ACWF	ETF	35.2026	35.3033	35.2026	35.3033	2354.0
2023-07-11	ACWI	ETF	95.26	95.77	95.02	95.7	725200.0
2023-07-11	ACWV	ETF	97.19	97.55	96.91	97.48	149600.0
2023-07-11	ACWX	ETF	48.8	49.01	48.65	49.01	530800.0
2023-07-11	ADFI	ETF	8.41	8.42	8.4	8.415	5300.0
2023-07-11	ADIV	ETF	13.55	13.55	13.55	13.55	100.0
2023-07-11	ADME	ETF	35.95	36.14	35.95	36.14	8900.0
2023-07-11	ADPV	ETF	25.22	25.3636	25.2055	25.3636	8412.0
2023-07-11	AEMB	ETF	37.24	37.24	37.24	37.24	100.0
2023-07-11	AESR	ETF	12.71	12.78	12.69	12.779	11100.0
2023-07-11	AFIF	ETF	8.82	8.82	8.81	8.82	6300.0
2023-07-11	AFK	ETF	14.89	14.9	14.77	14.85	3000.0
2023-07-11	AFMC	ETF	25.07	25.188	25.07	25.188	100.0
2023-07-11	AFTY	ETF	14.91	14.972	14.9	14.972	600.0
2023-07-11	AGG	ETF	96.94	97.1	96.86	97.01	5978500.0
2023-07-11	AGGH	ETF	22.36	22.42	22.325	22.325	327785.0
2023-07-11	AGGY	ETF	42.75	42.838	42.729	42.8	92500.0
2023-07-11	AGNG	ETF	27.32	27.39	27.28	27.39	1200.0
2023-07-11	AGOV	ETF	75.7	77.49	74.84	75.17	5753.0
2023-07-11	AGOX	ETF	23.31	23.54	23.31	23.5	15600.0
2023-07-11	AGQ	ETF	27.81	27.98	27.51	27.73	430700.0
2023-07-11	AGRH	ETF	25.64	25.67	25.6	25.6099	3801.0
2023-07-11	AGZ	ETF	106.45	106.55	106.38	106.55	21400.0
2023-07-11	AGZD	ETF	22.095	22.145	22.095	22.145	27000.0
2023-07-11	AHYB	ETF	43.69	43.782	43.68	43.782	1500.0
2023-07-11	AIA	ETF	59.62	60.03	59.35	59.91	49000.0
2023-07-11	AIEQ	ETF	31.75	32.05	31.73	32.043	13300.0
2023-07-11	AIQ	ETF	27.99	28.15	27.75	28.1	338200.0
2023-07-11	AIRR	ETF	53.78	53.91	53.36	53.66	111500.0

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

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