PREVIEW / etf_daily / 2023-10-11

all etf daily files

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

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-11	SPY	ETF	435.64	436.58	433.18	436.32	62451700.0
2023-10-11	QQQ	ETF	369.94	371.412	368.19	371.22	38215088.0
2023-10-11	IWM	ETF	176.12	177.23	174.38	175.67	27427200.0
2023-10-11	DIA	ETF	338.19	338.84	336.16	338.03	2773900.0
2023-10-11	GLD	ETF	173.6	174.13	173.26	173.79	7128000.0
2023-10-11	TLT	ETF	87.85	88.47	87.6	88.47	58517700.0
2023-10-11	AAA	ETF	24.82	24.83	24.8	24.8	3200.0
2023-10-11	AAAU	ETF	18.54	18.6	18.52	18.57	1602100.0
2023-10-11	AADR	ETF	49.99	50.33	49.82	50.33	800.0
2023-10-11	AAPB	ETF	24.49	24.7798	24.3549	24.76	7634.0
2023-10-11	AAPD	ETF	21.8	21.9	21.63	21.66	127556.0
2023-10-11	AAPU	ETF	24.95	25.29	24.85	25.27	71224.0
2023-10-11	AAXJ	ETF	64.69	64.86	64.46	64.68	584100.0
2023-10-11	ABEQ	ETF	27.41	27.46	27.315	27.445	24600.0
2023-10-11	ACES	ETF	35.45	35.685	34.605	35.08	141000.0
2023-10-11	ACIO	ETF	30.78	30.91	30.733	30.91	58400.0
2023-10-11	ACSI	ETF	45.126	45.126	45.126	45.126	100.0
2023-10-11	ACT	ETF	28.0	28.26	27.76	27.95	119019.0
2023-10-11	ACTV	ETF	29.6	29.621	29.39	29.621	29000.0
2023-10-11	ACVF	ETF	33.54	33.57	33.39	33.554	5300.0
2023-10-11	ACWF	ETF	34.94	34.9759	34.755	34.9759	4008.0
2023-10-11	ACWI	ETF	93.99	94.11	93.41	94.02	1612800.0
2023-10-11	ACWV	ETF	96.35	96.35	95.74	96.13	155000.0
2023-10-11	ACWX	ETF	47.66	47.66	47.29	47.53	641500.0
2023-10-11	ADFI	ETF	8.225	8.31	8.225	8.273	15100.0
2023-10-11	ADIV	ETF	13.46	13.47	13.435	13.435	1100.0
2023-10-11	ADME	ETF	35.59	35.675	35.51	35.675	16300.0
2023-10-11	ADPV	ETF	24.49	24.6189	24.44	24.6189	700.0
2023-10-11	AEMB	ETF	35.477	35.477	35.477	35.477	100.0
2023-10-11	AESR	ETF	12.56	12.56	12.44	12.55	12000.0
2023-10-11	AETH	ETF	23.53	23.53	23.1454	23.3156	1778.0
2023-10-11	AFIF	ETF	8.9	8.91	8.89	8.9	9100.0
2023-10-11	AFK	ETF	14.2	14.2	14.02	14.02	7900.0
2023-10-11	AFMC	ETF	23.98	24.042	23.98	24.042	1000.0
2023-10-11	AFSM	ETF	24.12	24.141	24.12	24.141	100.0
2023-10-11	AFTY	ETF	14.66	14.66	14.66	14.66	100.0
2023-10-11	AGG	ETF	93.94	94.05	93.76	94.05	15347000.0
2023-10-11	AGGH	ETF	21.36	21.38	21.31	21.31	260398.0
2023-10-11	AGGY	ETF	41.56	41.6	41.44	41.575	86600.0
2023-10-11	AGNG	ETF	25.9	26.06	25.88	26.05	2300.0
2023-10-11	AGOV	ETF	73.25	73.25	73.25	73.25	6.0
2023-10-11	AGOX	ETF	22.93	22.935	22.79	22.92	35200.0
2023-10-11	AGQ	ETF	24.09	24.29	23.78	24.1	738000.0
2023-10-11	AGZ	ETF	105.64	105.76	105.57	105.57	7800.0
2023-10-11	AGZD	ETF	22.21	22.22	22.09	22.12	39200.0
2023-10-11	AHLT	ETF	26.17	26.17	25.9712	25.9712	46241.0
2023-10-11	AHYB	ETF	43.27	43.27	43.01	43.19	7300.0
2023-10-11	AIA	ETF	57.02	57.22	56.81	57.05	22300.0
2023-10-11	AIEQ	ETF	29.9	30.04	29.8	30.038	6100.0
2023-10-11	AIQ	ETF	27.77	27.89	27.58	27.78	336900.0

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

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