PREVIEW / etf_daily / 2023-08-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-14.parquet
  size:    107 KB
  rows:    2,996

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-08-14	SPY	ETF	444.7	448.11	444.38	448.11	47867400.0
2023-08-14	QQQ	ETF	365.43	370.47	364.7	370.35	42130802.0
2023-08-14	IWM	ETF	189.94	190.7	188.64	190.66	20354900.0
2023-08-14	DIA	ETF	352.73	353.5	351.77	353.21	3134100.0
2023-08-14	GLD	ETF	176.86	177.58	176.58	177.06	9554500.0
2023-08-14	TLT	ETF	95.21	95.93	94.9	95.16	19072000.0
2023-08-14	AAA	ETF	24.8	24.8	24.71	24.77	2300.0
2023-08-14	AAAU	ETF	18.89	18.96	18.86	18.91	1049700.0
2023-08-14	AADR	ETF	50.06	51.49	50.06	51.39	3500.0
2023-08-14	AAPB	ETF	24.89	25.3498	24.76	25.31	17896.0
2023-08-14	AAPD	ETF	21.96	21.98	21.73	21.7635	65448.0
2023-08-14	AAPU	ETF	25.3	25.74	25.28	25.74	156001.0
2023-08-14	AAXJ	ETF	65.67	66.1	65.43	66.02	576500.0
2023-08-14	ABEQ	ETF	28.23	28.23	28.075	28.16	8500.0
2023-08-14	ACES	ETF	42.12	42.7	41.61	42.7	36400.0
2023-08-14	ACIO	ETF	31.23	31.36	31.23	31.36	69000.0
2023-08-14	ACSI	ETF	47.05	47.077	47.05	47.077	100.0
2023-08-14	ACT	ETF	28.87	29.23	28.74	29.18	175285.0
2023-08-14	ACTV	ETF	32.06	32.21	32.05	32.178	5400.0
2023-08-14	ACVF	ETF	34.01	34.34	34.01	34.337	4600.0
2023-08-14	ACWF	ETF	35.4474	35.5725	35.438	35.5725	1351.0
2023-08-14	ACWI	ETF	95.63	96.3	95.5	96.3	3811000.0
2023-08-14	ACWV	ETF	97.98	98.36	97.98	98.28	184300.0
2023-08-14	ACWX	ETF	48.74	49.0	48.55	48.95	1106000.0
2023-08-14	ADFI	ETF	8.36	8.39	8.36	8.375	1900.0
2023-08-14	ADIV	ETF	13.55	13.59	13.544	13.59	700.0
2023-08-14	ADME	ETF	36.514	36.67	36.514	36.63	47700.0
2023-08-14	ADPV	ETF	25.02	25.26	25.02	25.2596	1949.0
2023-08-14	AEMB	ETF	37.125	37.125	37.125	37.125	100.0
2023-08-14	AESR	ETF	12.78	12.87	12.78	12.87	12100.0
2023-08-14	AFIF	ETF	8.96	8.96	8.85	8.88	16700.0
2023-08-14	AFK	ETF	15.13	15.4	15.02	15.09	12100.0
2023-08-14	AFLG	ETF	25.58	25.661	25.55	25.661	400.0
2023-08-14	AFMC	ETF	25.269	25.34	25.269	25.34	700.0
2023-08-14	AFTY	ETF	15.06	15.06	15.06	15.06	100.0
2023-08-14	AGG	ETF	95.98	96.22	95.83	96.0	7901300.0
2023-08-14	AGGH	ETF	22.09	22.19	22.05	22.1305	17172.0
2023-08-14	AGGY	ETF	42.44	42.505	42.36	42.42	66300.0
2023-08-14	AGNG	ETF	27.51	27.64	27.462	27.592	5700.0
2023-08-14	AGOV	ETF	74.32	74.525	74.32	74.525	101.0
2023-08-14	AGOX	ETF	23.33	23.605	23.33	23.54	14500.0
2023-08-14	AGQ	ETF	25.98	26.2	25.48	26.01	685900.0
2023-08-14	AGZ	ETF	106.21	106.29	106.17	106.17	9500.0
2023-08-14	AGZD	ETF	22.17	22.23	22.16	22.2	38000.0
2023-08-14	AHYB	ETF	43.904	43.992	43.89	43.992	1000.0
2023-08-14	AIA	ETF	58.24	58.54	58.0	58.54	57000.0
2023-08-14	AIEQ	ETF	31.76	31.808	31.62	31.806	16400.0
2023-08-14	AIQ	ETF	27.52	27.88	27.42	27.88	656400.0
2023-08-14	AIRR	ETF	54.7	54.99	54.348	54.87	42400.0
2023-08-14	AIVI	ETF	38.97	39.05	38.86	39.05	1600.0

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

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