PREVIEW / etf_daily / 2023-04-19

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-19.parquet
  size:    109 KB
  rows:    2,945

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-04-19	SPY	ETF	412.22	415.08	412.16	414.14	55227300.0
2023-04-19	QQQ	ETF	316.41	319.79	316.28	318.71	38960127.0
2023-04-19	IWM	ETF	177.08	178.79	176.58	178.25	19306800.0
2023-04-19	DIA	ETF	339.11	339.63	338.19	338.99	2854700.0
2023-04-19	GLD	ETF	184.35	185.58	184.28	185.36	7373500.0
2023-04-19	TLT	ETF	103.91	104.24	103.48	104.1	16093900.0
2023-04-19	AAA	ETF	24.55	24.56	24.55	24.56	112.0
2023-04-19	AAAU	ETF	19.68	19.81	19.67	19.77	2380000.0
2023-04-19	AADR	ETF	49.1	49.1	48.76	48.85	1300.0
2023-04-19	AAPB	ETF	22.9799	23.27	22.9793	23.22	6284.0
2023-04-19	AAPD	ETF	23.58	23.58	23.23	23.29	196567.0
2023-04-19	AAPU	ETF	23.43	23.93	23.38	23.83	70940.0
2023-04-19	AAXJ	ETF	67.36	67.65	67.31	67.54	433100.0
2023-04-19	ABEQ	ETF	28.646	28.646	28.646	28.646	600.0
2023-04-19	ACES	ETF	44.34	44.59	44.07	44.44	73700.0
2023-04-19	ACIO	ETF	30.04	30.36	30.04	30.3	51000.0
2023-04-19	ACSI	ETF	44.6552	44.6552	44.6552	44.6552	49.0
2023-04-19	ACT	ETF	24.36	24.805	24.33	24.59	121957.0
2023-04-19	ACTV	ETF	29.17	29.31	28.801	29.2149	28259.0
2023-04-19	ACTX	ETF	0.32	0.32	0.32	0.32	407.0
2023-04-19	ACVF	ETF	31.5	31.68	31.5	31.62	2000.0
2023-04-19	ACWF	ETF	34.0234	34.12	34.0234	34.075	3915.0
2023-04-19	ACWI	ETF	92.14	92.61	92.1	92.45	4394400.0
2023-04-19	ACWV	ETF	98.52	98.85	98.52	98.66	75200.0
2023-04-19	ACWX	ETF	49.58	49.74	49.58	49.69	652415.0
2023-04-19	ADFI	ETF	8.49	8.5	8.485	8.485	9700.0
2023-04-19	ADIV	ETF	13.81	13.81	13.81	13.81	100.0
2023-04-19	ADME	ETF	34.86	35.06	34.79	35.03	6500.0
2023-04-19	ADPV	ETF	23.21	23.2517	23.21	23.2517	250.0
2023-04-19	AEMB	ETF	37.495	37.495	37.495	37.495	100.0
2023-04-19	AESR	ETF	12.06	12.15	12.06	12.15	27900.0
2023-04-19	AFIF	ETF	8.78	8.82	8.78	8.8	12879.0
2023-04-19	AFK	ETF	16.02	16.075	15.88	16.07	37229.0
2023-04-19	AFLG	ETF	24.131	24.131	24.131	24.131	100.0
2023-04-19	AFMC	ETF	23.16	23.16	23.138	23.138	100.0
2023-04-19	AFSM	ETF	23.386	23.386	23.356	23.356	400.0
2023-04-19	AFTY	ETF	16.357	16.357	16.357	16.357	100.0
2023-04-19	AGG	ETF	98.89	98.93	98.71	98.89	3592900.0
2023-04-19	AGGH	ETF	23.0	23.0	22.9907	22.9907	762.0
2023-04-19	AGGY	ETF	43.51	43.53	43.42	43.51	70900.0
2023-04-19	AGNG	ETF	27.88	28.1	27.88	28.05	600.0
2023-04-19	AGOV	ETF	76.13	76.13	76.13	76.13	14.0
2023-04-19	AGOX	ETF	21.788	21.92	21.75	21.918	22200.0
2023-04-19	AGQ	ETF	33.84	34.46	33.76	34.25	566900.0
2023-04-19	AGZ	ETF	107.78	107.78	107.69	107.77	14361.0
2023-04-19	AGZD	ETF	21.79	21.875	21.79	21.83	175800.0
2023-04-19	AHYB	ETF	43.909	43.909	43.888	43.891	700.0
2023-04-19	AIA	ETF	59.91	60.0842	59.75	60.0403	13144.0
2023-04-19	AIEQ	ETF	28.29	28.46	28.193	28.34	11900.0
2023-04-19	AIQ	ETF	23.91	24.0599	23.83	23.95	37723.0

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

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