PREVIEW / etf_daily / 2023-06-02

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-02.parquet
  size:    111 KB
  rows:    3,008

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-02	SPY	ETF	424.5	428.74	423.95	427.92	91366700.0
2023-06-02	QQQ	ETF	353.8	355.83	352.01	354.65	53372113.0
2023-06-02	IWM	ETF	178.01	182.09	177.45	182.02	50193400.0
2023-06-02	DIA	ETF	333.24	338.5	333.11	338.07	5582600.0
2023-06-02	GLD	ETF	183.53	183.56	180.96	181.05	8724800.0
2023-06-02	TLT	ETF	103.0	103.07	101.94	101.99	19122100.0
2023-06-02	AAA	ETF	24.46	24.49	24.46	24.49	147.0
2023-06-02	AAAU	ETF	19.59	19.59	19.31	19.32	1813800.0
2023-06-02	AADR	ETF	47.53	48.5	46.81	47.97	22900.0
2023-06-02	AAPB	ETF	26.31	26.45	26.02	26.24	13736.0
2023-06-02	AAPD	ETF	21.63	21.7985	21.55	21.6472	94916.0
2023-06-02	AAPU	ETF	26.57	26.64	26.165	26.52	155815.0
2023-06-02	AAXJ	ETF	66.91	67.24	66.91	67.04	522500.0
2023-06-02	ABEQ	ETF	28.04	28.18	28.04	28.18	8300.0
2023-06-02	ACES	ETF	44.5	44.69	43.96	44.58	41400.0
2023-06-02	ACIO	ETF	30.45	30.54	30.333	30.48	27400.0
2023-06-02	ACSI	ETF	44.7401	45.1099	44.74	45.0924	1870.0
2023-06-02	ACT	ETF	25.05	25.43	24.965	25.22	492950.0
2023-06-02	ACTV	ETF	30.029	30.37	30.029	30.3643	11633.0
2023-06-02	ACVF	ETF	32.24	32.52	32.24	32.514	12500.0
2023-06-02	ACWF	ETF	34.46	34.7216	34.46	34.7002	2895.0
2023-06-02	ACWI	ETF	93.64	94.26	93.49	94.09	5408800.0
2023-06-02	ACWV	ETF	97.18	97.74	96.99	97.66	351200.0
2023-06-02	ACWX	ETF	49.3	49.3763	49.2	49.33	1188861.0
2023-06-02	ADFI	ETF	8.455	8.47	8.45	8.465	19800.0
2023-06-02	ADIV	ETF	13.558	13.558	13.558	13.558	100.0
2023-06-02	ADME	ETF	35.06	35.43	35.06	35.36	31000.0
2023-06-02	ADPV	ETF	23.245	23.5301	23.245	23.4976	2450.0
2023-06-02	AEMB	ETF	37.25	37.28	37.25	37.28	100.0
2023-06-02	AESR	ETF	12.34	12.41	12.34	12.4	33500.0
2023-06-02	AFIF	ETF	8.82	8.82	8.77	8.8	42791.0
2023-06-02	AFK	ETF	15.15	15.4	15.15	15.305	14492.0
2023-06-02	AFLG	ETF	24.25	24.42	24.25	24.42	2600.0
2023-06-02	AFMC	ETF	23.41	23.41	23.41	23.41	10700.0
2023-06-02	AFTY	ETF	15.13	15.14	15.075	15.075	1900.0
2023-06-02	AGG	ETF	98.54	98.58	98.08	98.09	6877200.0
2023-06-02	AGGH	ETF	22.7799	22.78	22.68	22.746	31375.0
2023-06-02	AGGY	ETF	43.31	43.38	43.15	43.19	203500.0
2023-06-02	AGNG	ETF	27.59	27.69	27.28	27.69	11700.0
2023-06-02	AGOV	ETF	77.0001	77.3518	76.399	77.3518	967.0
2023-06-02	AGOX	ETF	22.47	22.69	22.47	22.62	26000.0
2023-06-02	AGQ	ETF	30.06	30.11	29.16	29.28	612900.0
2023-06-02	AGZ	ETF	107.27	107.53	107.21	107.27	73755.0
2023-06-02	AGZD	ETF	21.79	21.96	21.785	21.925	39000.0
2023-06-02	AHYB	ETF	43.74	43.74	43.74	43.74	400.0
2023-06-02	AIA	ETF	60.13	60.54	60.13	60.35	60548.0
2023-06-02	AIEQ	ETF	30.06	30.286	29.8	30.26	15500.0
2023-06-02	AIQ	ETF	26.78	26.898	26.56	26.74	346471.0
2023-06-02	AIRR	ETF	48.92	50.58	48.92	50.58	21500.0
2023-06-02	AIVI	ETF	39.43	39.44	39.37	39.44	2700.0

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

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