PREVIEW / etf_daily / 2023-06-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-21.parquet
  size:    110 KB
  rows:    2,973

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-06-21	SPY	ETF	436.16	436.99	434.33	434.94	76982300.0
2023-06-21	QQQ	ETF	365.74	366.18	360.96	361.9	53378256.0
2023-06-21	IWM	ETF	184.44	185.91	183.59	184.7	30730200.0
2023-06-21	DIA	ETF	339.62	340.91	338.68	339.43	3050700.0
2023-06-21	GLD	ETF	179.15	179.95	178.19	179.49	6702300.0
2023-06-21	TLT	ETF	102.81	103.65	102.34	103.56	19720100.0
2023-06-21	AAA	ETF	24.65	24.65	24.62	24.62	115.0
2023-06-21	AAAU	ETF	19.13	19.21	19.03	19.17	1883600.0
2023-06-21	AADR	ETF	49.64	49.66	49.48	49.61	1500.0
2023-06-21	AAPB	ETF	27.13	27.13	26.54	26.86	5892.0
2023-06-21	AAPD	ETF	21.04	21.25	20.95	21.1	151693.0
2023-06-21	AAPU	ETF	27.0	27.25	26.7027	26.93	92698.0
2023-06-21	AAXJ	ETF	67.0	67.19	66.78	66.96	280400.0
2023-06-21	ABEQ	ETF	28.214	28.27	28.214	28.22	3600.0
2023-06-21	ACES	ETF	45.02	45.02	44.31	44.49	25800.0
2023-06-21	ACIO	ETF	30.77	30.903	30.76	30.795	30600.0
2023-06-21	ACSI	ETF	46.07	46.07	46.07	46.07	633.0
2023-06-21	ACT	ETF	25.11	25.15	24.9	24.98	127233.0
2023-06-21	ACTV	ETF	30.892	31.2199	30.892	31.0413	12861.0
2023-06-21	ACTX	ETF	0.285	0.285	0.285	0.285	1341.0
2023-06-21	ACVF	ETF	33.36	33.465	33.29	33.31	20400.0
2023-06-21	ACWF	ETF	34.95	35.0625	34.92	34.9454	10860.0
2023-06-21	ACWI	ETF	94.93	95.24	94.69	94.87	2768500.0
2023-06-21	ACWV	ETF	97.65	97.9	97.26	97.69	198800.0
2023-06-21	ACWX	ETF	49.17	49.465	49.15	49.33	899953.0
2023-06-21	ADFI	ETF	8.43	8.46	8.43	8.455	6900.0
2023-06-21	ADIV	ETF	13.62	13.74	13.62	13.706	1200.0
2023-06-21	ADME	ETF	36.12	36.12	35.8	35.83	12800.0
2023-06-21	ADPV	ETF	24.04	24.13	23.89	24.0875	6723.0
2023-06-21	AEMB	ETF	37.84	37.84	37.84	37.84	100.0
2023-06-21	AESR	ETF	12.65	12.65	12.48	12.57	38400.0
2023-06-21	AFIF	ETF	8.93	9.26	8.62	8.71	96733.0
2023-06-21	AFK	ETF	15.05	15.17	15.02	15.09	6539.0
2023-06-21	AFLG	ETF	24.909	24.909	24.909	24.909	100.0
2023-06-21	AFMC	ETF	24.18	24.229	24.14	24.171	1300.0
2023-06-21	AFSM	ETF	24.4	24.4	24.395	24.395	100.0
2023-06-21	AFTY	ETF	14.96	14.976	14.96	14.976	400.0
2023-06-21	AGG	ETF	98.09	98.53	97.98	98.48	5579900.0
2023-06-21	AGGH	ETF	22.7499	22.79	22.695	22.74	2430.0
2023-06-21	AGGY	ETF	43.21	43.36	43.144	43.35	71800.0
2023-06-21	AGNG	ETF	28.03	28.08	27.97	28.065	4600.0
2023-06-21	AGOV	ETF	75.44	76.72	75.44	76.72	112.0
2023-06-21	AGOX	ETF	23.24	23.24	23.09	23.09	47500.0
2023-06-21	AGQ	ETF	27.15	27.22	26.35	26.85	1116900.0
2023-06-21	AGZ	ETF	107.05	107.29	107.05	107.2	35361.0
2023-06-21	AGZD	ETF	22.07	22.075	21.96	22.065	199000.0
2023-06-21	AHYB	ETF	43.66	43.71	43.66	43.71	200.0
2023-06-21	AIA	ETF	60.53	60.69	60.24	60.37	43795.0
2023-06-21	AIEQ	ETF	30.94	31.0	30.76	30.88	39200.0
2023-06-21	AIQ	ETF	28.05	28.07	27.4701	27.61	504432.0

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

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