PREVIEW / etf_daily / 2023-02-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-09.parquet
  size:    110 KB
  rows:    2,947

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-09	SPY	ETF	414.41	414.57	405.81	407.09	78694900.0
2023-02-09	QQQ	ETF	308.84	308.99	300.2	301.68	49137818.0
2023-02-09	IWM	ETF	194.23	195.12	189.43	189.93	20516600.0
2023-02-09	DIA	ETF	341.75	342.56	336.06	337.08	3094700.0
2023-02-09	GLD	ETF	175.49	175.52	172.87	173.03	5361300.0
2023-02-09	TLT	ETF	106.47	106.62	104.39	104.56	20469900.0
2023-02-09	AAA	ETF	24.6	24.62	24.6	24.62	583.0
2023-02-09	AAAU	ETF	18.72	18.72	18.44	18.45	831700.0
2023-02-09	AADR	ETF	48.97	48.97	48.77	48.78	3200.0
2023-02-09	AAPB	ETF	20.21	20.33	19.74	19.74	7483.0
2023-02-09	AAPD	ETF	25.47	26.06	25.4	25.9959	120071.0
2023-02-09	AAPU	ETF	21.27	21.3002	20.5699	20.67	82289.0
2023-02-09	AAXJ	ETF	70.69	70.75	69.83	70.03	412100.0
2023-02-09	ABEQ	ETF	28.68	28.68	28.265	28.265	6500.0
2023-02-09	ACES	ETF	52.21	52.56	50.02	50.34	526500.0
2023-02-09	ACIO	ETF	30.28	30.28	29.922	29.97	24700.0
2023-02-09	ACSI	ETF	45.95	45.95	45.6598	45.6598	228.0
2023-02-09	ACT	ETF	24.6	25.03	24.31	24.37	111476.0
2023-02-09	ACTV	ETF	33.13	33.3511	32.47	32.5005	8864.0
2023-02-09	ACVF	ETF	31.82	31.82	31.399	31.399	4000.0
2023-02-09	ACWF	ETF	33.85	33.86	33.49	33.546	2634.0
2023-02-09	ACWI	ETF	92.28	92.35	90.61	90.88	3025700.0
2023-02-09	ACWV	ETF	96.43	96.43	95.21	95.27	207100.0
2023-02-09	ACWX	ETF	49.6	49.6	48.88	48.99	1032447.0
2023-02-09	ADFI	ETF	8.564	8.58	8.525	8.525	23000.0
2023-02-09	ADIV	ETF	14.27	14.27	14.22	14.22	200.0
2023-02-09	ADME	ETF	35.13	35.13	34.548	34.62	12000.0
2023-02-09	ADPV	ETF	25.42	25.44	25.16	25.16	22101.0
2023-02-09	ADRE	ETF	42.49	42.57	41.91	42.19	41704.0
2023-02-09	AEMB	ETF	38.445	38.445	38.445	38.445	100.0
2023-02-09	AESR	ETF	11.89	11.893	11.775	11.775	31500.0
2023-02-09	AFIF	ETF	8.93	8.94	8.89	8.91	28271.0
2023-02-09	AFK	ETF	16.99	17.14	16.88	16.91	9362.0
2023-02-09	AFLG	ETF	24.36	24.36	24.284	24.284	100.0
2023-02-09	AFMC	ETF	23.906	23.906	23.906	23.906	100.0
2023-02-09	AFSM	ETF	24.348	24.348	24.348	24.348	100.0
2023-02-09	AFTY	ETF	17.05	17.1	17.05	17.071	2800.0
2023-02-09	AGG	ETF	99.54	99.56	98.83	98.85	5594800.0
2023-02-09	AGGH	ETF	22.55	22.55	22.43	22.43	1684.0
2023-02-09	AGGY	ETF	43.89	43.89	43.617	43.63	88300.0
2023-02-09	AGNG	ETF	27.24	27.24	26.831	26.831	4400.0
2023-02-09	AGOV	ETF	77.96	77.96	77.96	77.96	102.0
2023-02-09	AGOX	ETF	22.39	22.39	22.04	22.07	13600.0
2023-02-09	AGQ	ETF	27.71	27.71	26.27	26.4	652700.0
2023-02-09	AGZ	ETF	107.65	107.82	107.41	107.56	107187.0
2023-02-09	AGZD	ETF	21.955	21.975	21.905	21.95	74600.0
2023-02-09	AHHX	ETF	8.725	8.725	8.6614	8.6672	9349.0
2023-02-09	AHYB	ETF	44.232	44.232	43.946	43.946	400.0
2023-02-09	AIA	ETF	65.17	65.27	64.32	64.59	77128.0
2023-02-09	AIEQ	ETF	32.5	32.5	31.31	31.374	58100.0

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

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