PREVIEW / etf_daily / 2023-02-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-08.parquet
  size:    109 KB
  rows:    2,937

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-02-08	SPY	ETF	413.13	414.53	409.93	410.65	76227500.0
2023-02-08	QQQ	ETF	308.54	309.5	303.67	304.37	56720860.0
2023-02-08	IWM	ETF	194.36	195.37	192.2	192.72	17933500.0
2023-02-08	DIA	ETF	340.37	341.46	338.84	339.42	2769500.0
2023-02-08	GLD	ETF	174.94	174.99	173.83	174.41	4075600.0
2023-02-08	TLT	ETF	105.04	105.58	104.39	105.56	13530700.0
2023-02-08	AAA	ETF	24.615	24.615	24.615	24.615	2.0
2023-02-08	AAAU	ETF	18.67	18.67	18.54	18.6	438700.0
2023-02-08	AADR	ETF	47.22	49.13	47.22	48.96	2200.0
2023-02-08	AAPB	ETF	20.3202	20.3202	19.8399	19.97	7174.0
2023-02-08	AAPD	ETF	25.49	25.88	25.39	25.82	68521.0
2023-02-08	AAPU	ETF	21.29	21.38	20.73	20.85	64478.0
2023-02-08	AAXJ	ETF	69.76	69.87	69.24	69.49	1007000.0
2023-02-08	ABEQ	ETF	28.49	28.553	28.46	28.46	12600.0
2023-02-08	ACES	ETF	52.3	53.03	51.53	51.55	545500.0
2023-02-08	ACIO	ETF	30.164	30.2	30.01	30.079	243700.0
2023-02-08	ACSI	ETF	46.05	46.05	46.0442	46.0442	1330.0
2023-02-08	ACT	ETF	23.7	24.58	23.49	24.55	226293.0
2023-02-08	ACTV	ETF	33.49	33.49	32.8083	32.86	13018.0
2023-02-08	ACTX	ETF	0.34	0.35	0.34	0.35	1146.0
2023-02-08	ACVF	ETF	31.826	31.862	31.564	31.564	5000.0
2023-02-08	ACWF	ETF	33.8	33.8	33.6672	33.6672	8306.0
2023-02-08	ACWI	ETF	91.87	91.99	91.15	91.28	2544300.0
2023-02-08	ACWV	ETF	95.75	95.92	95.42	95.59	712600.0
2023-02-08	ACWX	ETF	49.13	49.15	48.77	48.88	997775.0
2023-02-08	ADFI	ETF	8.54	8.565	8.53	8.565	2400.0
2023-02-08	ADIV	ETF	14.19	14.21	14.17	14.21	700.0
2023-02-08	ADME	ETF	34.61	34.865	34.33	34.71	36100.0
2023-02-08	ADPV	ETF	25.37	25.4	25.25	25.37	31219.0
2023-02-08	ADRE	ETF	42.07	42.16	41.81	41.81	8166.0
2023-02-08	AEMB	ETF	38.44	38.8	38.435	38.67	1400.0
2023-02-08	AESR	ETF	11.94	11.97	11.72	11.83	41300.0
2023-02-08	AFIF	ETF	8.93	8.95	8.9	8.94	50763.0
2023-02-08	AFK	ETF	16.95	17.03	16.87	16.91	6450.0
2023-02-08	AFLG	ETF	24.424	24.424	24.424	24.424	100.0
2023-02-08	AFMC	ETF	24.151	24.151	24.151	24.151	100.0
2023-02-08	AFSM	ETF	24.59	24.59	24.57	24.57	1000.0
2023-02-08	AFTY	ETF	16.74	16.84	16.74	16.813	3500.0
2023-02-08	AGG	ETF	99.14	99.43	98.95	99.24	4900600.0
2023-02-08	AGGY	ETF	43.72	43.785	43.639	43.75	85000.0
2023-02-08	AGNG	ETF	27.04	27.12	26.641	26.92	4900.0
2023-02-08	AGOV	ETF	80.2234	80.2234	80.2234	80.2234	167.0
2023-02-08	AGOX	ETF	22.3	22.4	22.22	22.22	24900.0
2023-02-08	AGQ	ETF	27.53	27.61	27.06	27.25	282300.0
2023-02-08	AGZ	ETF	107.2	107.59	107.2	107.59	26098.0
2023-02-08	AGZD	ETF	21.92	21.965	21.895	21.94	157400.0
2023-02-08	AHHX	ETF	8.71	8.725	8.7	8.725	2018.0
2023-02-08	AHYB	ETF	44.198	44.198	44.198	44.198	100.0
2023-02-08	AIA	ETF	64.05	64.1532	63.47	63.59	62719.0
2023-02-08	AIEQ	ETF	32.71	32.719	32.16	32.216	45300.0

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

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