PREVIEW / etf_daily / 2023-10-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-18.parquet
  size:    110 KB
  rows:    3,067

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-10-18	SPY	ETF	434.19	435.18	429.09	430.21	93559800.0
2023-10-18	QQQ	ETF	365.67	367.91	362.02	363.37	54280490.0
2023-10-18	IWM	ETF	173.64	173.66	171.0	171.35	38501400.0
2023-10-18	DIA	ETF	339.74	339.97	336.0	336.63	4141200.0
2023-10-18	GLD	ETF	180.89	182.02	179.75	180.87	13920800.0
2023-10-18	TLT	ETF	84.38	84.72	83.85	84.5	63724600.0
2023-10-18	AAA	ETF	24.845	24.845	24.819	24.845	1000.0
2023-10-18	AAAU	ETF	19.32	19.45	19.2	19.32	1643000.0
2023-10-18	AADR	ETF	49.57	49.57	49.03	49.1	2100.0
2023-10-18	AAPB	ETF	23.69	24.111	23.69	23.79	5624.0
2023-10-18	AAPD	ETF	22.18	22.23	21.9401	22.17	155668.0
2023-10-18	AAPU	ETF	24.39	24.77	24.295	24.41	129562.0
2023-10-18	AAXJ	ETF	63.13	63.31	62.78	62.86	342300.0
2023-10-18	ABEQ	ETF	27.68	27.68	27.42	27.427	12100.0
2023-10-18	ACES	ETF	34.22	34.22	32.87	32.89	89200.0
2023-10-18	ACIO	ETF	30.79	30.905	30.626	30.65	133100.0
2023-10-18	ACSI	ETF	45.33	45.33	44.685	44.685	700.0
2023-10-18	ACT	ETF	28.24	28.24	27.71	27.86	140960.0
2023-10-18	ACTV	ETF	29.12	29.15	28.93	28.931	4200.0
2023-10-18	ACVF	ETF	33.51	33.51	33.12	33.125	10000.0
2023-10-18	ACWF	ETF	34.68	34.68	34.38	34.3965	3015.0
2023-10-18	ACWI	ETF	93.15	93.26	92.1	92.32	5959300.0
2023-10-18	ACWV	ETF	95.88	95.98	95.17	95.25	149000.0
2023-10-18	ACWX	ETF	46.66	46.72	46.26	46.29	1846100.0
2023-10-18	ADFI	ETF	8.065	8.07	8.05	8.065	3800.0
2023-10-18	ADIV	ETF	13.055	13.055	13.055	13.055	100.0
2023-10-18	ADME	ETF	35.64	35.7	35.31	35.41	57800.0
2023-10-18	ADPV	ETF	24.0	24.082	23.57	23.57	1000.0
2023-10-18	ADVE	ETF	29.19	29.23	29.157	29.157	440.0
2023-10-18	AEMB	ETF	34.875	34.875	34.875	34.875	100.0
2023-10-18	AESR	ETF	12.34	12.37	12.225	12.27	17900.0
2023-10-18	AETH	ETF	23.55	23.55	23.37	23.3734	15861.0
2023-10-18	AFIF	ETF	8.86	8.87	8.85	8.86	12100.0
2023-10-18	AFK	ETF	14.23	14.34	13.75	14.08	8700.0
2023-10-18	AFLG	ETF	25.22	25.22	24.917	24.917	500.0
2023-10-18	AFTY	ETF	14.225	14.225	14.209	14.209	200.0
2023-10-18	AGG	ETF	92.29	92.38	91.94	92.02	9352700.0
2023-10-18	AGGH	ETF	20.88	20.9699	20.83	20.83	10909.0
2023-10-18	AGGY	ETF	40.89	40.93	40.78	40.785	88800.0
2023-10-18	AGNG	ETF	25.9	25.9	25.713	25.713	700.0
2023-10-18	AGOV	ETF	72.5	72.78	72.5	72.78	183.0
2023-10-18	AGOX	ETF	22.7	22.714	22.55	22.55	11000.0
2023-10-18	AGQ	ETF	26.58	26.89	25.5	25.93	1633500.0
2023-10-18	AGRH	ETF	25.54	25.54	25.49	25.49	2619.0
2023-10-18	AGZ	ETF	104.97	105.09	104.87	104.87	19500.0
2023-10-18	AGZD	ETF	22.27	22.27	22.15	22.18	25200.0
2023-10-18	AHLT	ETF	26.89	27.105	26.89	27.0686	2870.0
2023-10-18	AHOY	ETF	19.66	19.66	19.66	19.66	102.0
2023-10-18	AHYB	ETF	42.456	42.456	42.456	42.456	100.0
2023-10-18	AIA	ETF	55.72	55.79	55.33	55.38	35200.0

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

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