PREVIEW / etf_daily / 2023-06-20

all etf daily files

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

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-20	SPY	ETF	437.45	438.37	435.03	437.18	76160400.0
2023-06-20	QQQ	ETF	365.95	368.32	363.8899	366.9	49204722.0
2023-06-20	IWM	ETF	185.16	185.57	183.76	185.13	33269300.0
2023-06-20	DIA	ETF	341.3	341.61	339.0	340.46	3387200.0
2023-06-20	GLD	ETF	180.06	180.09	179.22	179.75	7584200.0
2023-06-20	TLT	ETF	103.11	103.66	103.11	103.31	17162900.0
2023-06-20	AAA	ETF	24.64	24.64	24.61	24.61	879.0
2023-06-20	AAAU	ETF	19.22	19.22	19.13	19.19	1622700.0
2023-06-20	AADR	ETF	49.77	49.77	49.61	49.61	1100.0
2023-06-20	AAPB	ETF	27.07	27.37	26.97	27.15	16091.0
2023-06-20	AAPD	ETF	21.32	21.32	21.1011	21.23	59999.0
2023-06-20	AAPU	ETF	27.29	27.57	27.26	27.35	61286.0
2023-06-20	AAXJ	ETF	67.88	67.92	67.22	67.34	1229000.0
2023-06-20	ABEQ	ETF	28.16	28.203	28.15	28.15	6000.0
2023-06-20	ACES	ETF	45.5	45.63	44.64	45.03	73600.0
2023-06-20	ACIO	ETF	31.06	31.06	30.82	30.89	151000.0
2023-06-20	ACSI	ETF	46.0501	46.16	46.0501	46.16	531.0
2023-06-20	ACT	ETF	24.98	25.37	24.94	25.16	328282.0
2023-06-20	ACTV	ETF	31.47	31.47	31.02	31.1876	4906.0
2023-06-20	ACTX	ETF	0.2672	0.2672	0.2672	0.2672	300.0
2023-06-20	ACVF	ETF	33.66	33.66	33.34	33.49	46600.0
2023-06-20	ACWF	ETF	35.12	35.145	34.931	35.044	7151.0
2023-06-20	ACWI	ETF	95.38	95.5	94.85	95.2	4809700.0
2023-06-20	ACWV	ETF	98.05	98.05	97.4	97.4	53600.0
2023-06-20	ACWX	ETF	49.52	49.54	49.22	49.3	1501844.0
2023-06-20	ADFI	ETF	8.46	8.47	8.46	8.465	12100.0
2023-06-20	ADIV	ETF	15.09	15.09	13.74	13.74	1000.0
2023-06-20	ADME	ETF	35.89	35.98	35.865	35.95	20800.0
2023-06-20	ADPV	ETF	24.01	24.0886	24.01	24.0886	276.0
2023-06-20	AESR	ETF	12.79	12.79	12.63	12.71	24800.0
2023-06-20	AFIF	ETF	8.76	8.77	8.76	8.765	32965.0
2023-06-20	AFK	ETF	15.3	15.3	14.9	15.0	45206.0
2023-06-20	AFLG	ETF	24.97	24.998	24.95	24.97	1000.0
2023-06-20	AFMC	ETF	24.11	24.176	24.09	24.145	3200.0
2023-06-20	AFTY	ETF	15.03	15.04	15.0	15.01	2800.0
2023-06-20	AGG	ETF	98.28	98.51	98.17	98.32	6694200.0
2023-06-20	AGGH	ETF	22.1	22.78	22.1	22.78	4809.0
2023-06-20	AGGY	ETF	43.22	43.32	43.22	43.285	84600.0
2023-06-20	AGNG	ETF	28.25	28.25	28.12	28.228	1500.0
2023-06-20	AGOV	ETF	76.89	76.89	76.89	76.89	9.0
2023-06-20	AGOX	ETF	23.42	23.42	23.01	23.2	26700.0
2023-06-20	AGQ	ETF	28.44	28.49	27.73	28.03	1242600.0
2023-06-20	AGZ	ETF	107.17	107.3	107.17	107.25	12071.0
2023-06-20	AGZD	ETF	22.035	22.065	22.035	22.035	38400.0
2023-06-20	AHOY	ETF	20.57	20.57	20.3676	20.3676	145.0
2023-06-20	AHYB	ETF	43.85	43.85	43.815	43.815	300.0
2023-06-20	AIA	ETF	61.58	61.58	60.82	60.87	75034.0
2023-06-20	AIEQ	ETF	31.35	31.37	31.03	31.222	25100.0
2023-06-20	AIQ	ETF	28.17	28.27	27.85	28.1	510075.0
2023-06-20	AIRR	ETF	51.76	52.07	51.37	51.94	28800.0

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

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