PREVIEW / etf_daily / 2023-01-20

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-20.parquet
  size:    109 KB
  rows:    2,918

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-01-20	SPY	ETF	390.1	396.04	388.38	395.88	91806400.0
2023-01-20	QQQ	ETF	276.79	283.02	275.71	282.68	60613606.0
2023-01-20	IWM	ETF	182.71	185.15	181.27	185.04	36070300.0
2023-01-20	DIA	ETF	330.82	333.73	329.35	333.67	4120200.0
2023-01-20	GLD	ETF	179.06	179.66	178.65	179.29	5754800.0
2023-01-20	TLT	ETF	106.96	107.24	106.11	106.2	22754100.0
2023-01-20	AAA	ETF	24.52	24.52	24.51	24.51	117.0
2023-01-20	AAAU	ETF	19.1	19.16	19.06	19.13	446300.0
2023-01-20	AADR	ETF	49.86	50.36	49.86	50.36	1500.0
2023-01-20	AAPB	ETF	16.94	16.94	16.94	16.94	426.0
2023-01-20	AAPD	ETF	29.09	29.2594	28.46	28.46	183086.0
2023-01-20	AAPU	ETF	17.55	18.14	17.4473	18.14	88886.0
2023-01-20	AAXJ	ETF	71.13	71.71	70.94	71.68	478300.0
2023-01-20	ABEQ	ETF	28.36	28.666	28.35	28.666	12600.0
2023-01-20	ACES	ETF	48.89	49.57	48.434	49.57	41000.0
2023-01-20	ACIO	ETF	29.1	29.264	29.014	29.24	46700.0
2023-01-20	ACSI	ETF	43.32	43.7161	43.32	43.7161	2701.0
2023-01-20	ACT	ETF	24.35	24.645	24.0	24.4	194133.0
2023-01-20	ACTV	ETF	30.68	31.12	30.68	31.095	16539.0
2023-01-20	ACVF	ETF	30.29	30.575	30.29	30.575	4300.0
2023-01-20	ACWF	ETF	32.98	33.352	32.98	33.352	4791.0
2023-01-20	ACWI	ETF	88.45	89.68	88.19	89.67	5019800.0
2023-01-20	ACWV	ETF	95.9	96.58	95.64	96.54	214400.0
2023-01-20	ACWX	ETF	48.96	49.39	48.81	49.39	1407836.0
2023-01-20	ADFI	ETF	8.57	8.6	8.56	8.595	7600.0
2023-01-20	ADIV	ETF	14.379	14.431	14.379	14.431	200.0
2023-01-20	ADME	ETF	33.57	33.83	33.465	33.83	6000.0
2023-01-20	ADPV	ETF	25.15	25.18	25.1	25.1	43949.0
2023-01-20	ADRE	ETF	42.55	43.0	42.55	43.0	45850.0
2023-01-20	AEMB	ETF	39.235	39.235	39.235	39.235	100.0
2023-01-20	AESR	ETF	11.48	11.64	11.48	11.63	46400.0
2023-01-20	AFIF	ETF	8.85	8.85	8.83	8.8439	87701.0
2023-01-20	AFK	ETF	17.31	17.315	17.04	17.2	7716.0
2023-01-20	AFLG	ETF	23.64	23.726	23.64	23.726	900.0
2023-01-20	AFMC	ETF	22.95	23.186	22.95	23.186	600.0
2023-01-20	AFSM	ETF	23.55	23.685	23.55	23.685	800.0
2023-01-20	AFTY	ETF	17.545	17.545	17.545	17.545	100.0
2023-01-20	AGG	ETF	100.17	100.26	99.89	100.09	6095800.0
2023-01-20	AGGH	ETF	22.79	22.79	22.79	22.79	103.0
2023-01-20	AGGY	ETF	44.16	44.185	44.03	44.15	173700.0
2023-01-20	AGNG	ETF	26.775	27.002	26.775	27.002	900.0
2023-01-20	AGOV	ETF	82.0458	82.0458	81.31	81.6747	3274.0
2023-01-20	AGOX	ETF	21.06	21.54	21.06	21.464	10700.0
2023-01-20	AGQ	ETF	31.71	31.88	31.16	31.8	583200.0
2023-01-20	AGZ	ETF	108.2	108.85	108.2	108.48	876636.0
2023-01-20	AGZD	ETF	21.875	21.885	21.785	21.885	97000.0
2023-01-20	AHHX	ETF	8.6566	8.68	8.65	8.675	3369.0
2023-01-20	AHYB	ETF	44.247	44.377	44.18	44.377	1100.0
2023-01-20	AIA	ETF	64.77	65.45	64.565	65.45	80980.0
2023-01-20	AIEQ	ETF	30.12	30.86	30.12	30.859	5500.0

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

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