PREVIEW / etf_daily / 2023-10-19

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-19.parquet
  size:    111 KB
  rows:    3,096

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-19	SPY	ETF	430.95	432.82	425.73	426.43	121323000.0
2023-10-19	QQQ	ETF	364.81	366.02	359.16	359.97	72274238.0
2023-10-19	IWM	ETF	170.86	172.15	168.36	168.62	51397300.0
2023-10-19	DIA	ETF	336.69	338.62	333.76	334.12	5201800.0
2023-10-19	GLD	ETF	181.04	183.43	180.82	183.09	13406600.0
2023-10-19	TLT	ETF	83.88	84.57	82.74	82.77	87696900.0
2023-10-19	AAA	ETF	24.85	24.88	24.85	24.85	1100.0
2023-10-19	AAAU	ETF	19.34	19.59	19.31	19.56	2484000.0
2023-10-19	AADR	ETF	48.28	48.28	48.11	48.11	400.0
2023-10-19	AAPB	ETF	24.029	24.25	23.64	23.74	5159.0
2023-10-19	AAPD	ETF	22.1	22.23	21.92	22.22	338420.0
2023-10-19	AAPU	ETF	24.44	24.82	24.28	24.33	154369.0
2023-10-19	AAXJ	ETF	62.6	62.94	62.4	62.47	610200.0
2023-10-19	ABEQ	ETF	27.28	27.49	27.23	27.269	10500.0
2023-10-19	ACES	ETF	32.74	32.74	31.6	31.67	125500.0
2023-10-19	ACIO	ETF	30.66	30.75	30.46	30.52	62000.0
2023-10-19	ACT	ETF	27.72	27.82	27.21	27.25	162011.0
2023-10-19	ACTV	ETF	28.84	28.9	28.45	28.51	16200.0
2023-10-19	ACVF	ETF	33.09	33.09	32.742	32.76	6300.0
2023-10-19	ACWF	ETF	34.38	34.44	34.0783	34.0783	3246.0
2023-10-19	ACWI	ETF	92.25	92.69	91.34	91.49	2798500.0
2023-10-19	ACWV	ETF	95.29	95.33	94.4	94.44	376400.0
2023-10-19	ACWX	ETF	46.13	46.4	45.88	45.94	1033800.0
2023-10-19	ADFI	ETF	8.045	8.06	8.04	8.045	3800.0
2023-10-19	ADIV	ETF	12.95	12.95	12.95	12.95	100.0
2023-10-19	ADME	ETF	35.39	35.431	35.1	35.181	17600.0
2023-10-19	ADPV	ETF	23.2601	23.2767	23.21	23.2385	9138.0
2023-10-19	AEMB	ETF	34.74	34.74	34.695	34.695	100.0
2023-10-19	AESR	ETF	12.28	12.33	12.16	12.18	14300.0
2023-10-19	AETH	ETF	23.42	23.45	23.42	23.4296	1687.0
2023-10-19	AFIF	ETF	8.84	8.88	8.84	8.84	5900.0
2023-10-19	AFK	ETF	13.91	14.1	13.72	13.86	3400.0
2023-10-19	AFLG	ETF	24.67	24.67	24.67	24.67	100.0
2023-10-19	AFMC	ETF	23.077	23.077	22.941	22.941	400.0
2023-10-19	AFSM	ETF	23.066	23.066	23.047	23.047	300.0
2023-10-19	AFTY	ETF	13.91	13.91	13.79	13.81	12700.0
2023-10-19	AGG	ETF	91.89	92.17	91.61	91.67	11552700.0
2023-10-19	AGGH	ETF	20.82	20.878	20.7	20.7	168418.0
2023-10-19	AGGY	ETF	40.76	40.84	40.621	40.67	202600.0
2023-10-19	AGNG	ETF	25.48	25.48	25.31	25.31	1400.0
2023-10-19	AGOV	ETF	72.04	72.04	72.04	72.04	39.0
2023-10-19	AGOX	ETF	22.65	22.71	22.48	22.484	16400.0
2023-10-19	AGQ	ETF	25.82	26.38	25.39	26.25	1334700.0
2023-10-19	AGRH	ETF	25.54	25.54	25.495	25.495	251.0
2023-10-19	AGZ	ETF	104.83	105.04	104.83	104.97	27800.0
2023-10-19	AGZD	ETF	22.16	22.18	22.1	22.14	44000.0
2023-10-19	AHOY	ETF	19.552	19.552	19.4653	19.4653	1505.0
2023-10-19	AHYB	ETF	42.43	42.43	42.364	42.364	600.0
2023-10-19	AIA	ETF	55.21	55.56	55.01	55.04	59100.0
2023-10-19	AIEQ	ETF	29.64	29.66	29.19	29.22	6800.0

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

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