PREVIEW / etf_daily / 2023-02-23

all etf daily files

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

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-23	SPY	ETF	401.56	402.2	396.25	400.66	96242400.0
2023-02-23	QQQ	ETF	297.97	298.13	292.55	296.82	69294443.0
2023-02-23	IWM	ETF	189.35	190.3	186.7	189.28	21311700.0
2023-02-23	DIA	ETF	331.85	332.75	327.98	331.67	5999600.0
2023-02-23	GLD	ETF	169.84	170.13	169.08	169.57	5073500.0
2023-02-23	TLT	ETF	101.54	102.59	101.47	102.3	15829100.0
2023-02-23	AAA	ETF	24.7	24.7	24.7	24.7	24.0
2023-02-23	AAAU	ETF	18.11	18.13	18.04	18.09	837300.0
2023-02-23	AADR	ETF	48.77	48.87	48.77	48.87	400.0
2023-02-23	AAPB	ETF	19.36	19.42	19.0339	19.34	1306.0
2023-02-23	AAPD	ETF	26.08	26.605	26.08	26.24	156941.0
2023-02-23	AAPU	ETF	20.47	20.52	19.91	20.33	65528.0
2023-02-23	AAXJ	ETF	67.51	67.54	66.6	67.02	549900.0
2023-02-23	ABEQ	ETF	27.72	27.875	27.72	27.848	3500.0
2023-02-23	ACES	ETF	48.86	48.92	47.267	48.21	35000.0
2023-02-23	ACIO	ETF	29.5	29.63	29.417	29.61	30900.0
2023-02-23	ACSI	ETF	44.6642	44.6642	44.6642	44.6642	41.0
2023-02-23	ACT	ETF	24.43	24.57	24.03	24.28	75976.0
2023-02-23	ACTV	ETF	32.23	32.38	31.89	32.3629	30981.0
2023-02-23	ACVF	ETF	31.2	31.2	30.745	30.989	1400.0
2023-02-23	ACWF	ETF	33.27	33.3018	33.045	33.1751	891.0
2023-02-23	ACWI	ETF	89.52	89.65	88.47	89.35	2342100.0
2023-02-23	ACWV	ETF	94.96	94.96	94.04	94.49	82300.0
2023-02-23	ACWX	ETF	48.2	48.22	47.685	48.08	1842647.0
2023-02-23	ADFI	ETF	8.36	8.43	8.36	8.42	17500.0
2023-02-23	ADIV	ETF	14.042	14.042	14.042	14.042	100.0
2023-02-23	ADME	ETF	33.94	34.03	33.84	33.97	23500.0
2023-02-23	ADPV	ETF	25.3	25.3	25.17	25.1808	14943.0
2023-02-23	ADRE	ETF	40.49	40.49	39.69	39.98	14605.0
2023-02-23	AEMB	ETF	37.876	37.876	37.876	37.876	100.0
2023-02-23	AESR	ETF	11.62	11.7	11.59	11.69	20700.0
2023-02-23	AFIF	ETF	8.8409	8.86	8.84	8.84	3059.0
2023-02-23	AFK	ETF	16.28	16.3201	16.18	16.2	9400.0
2023-02-23	AFLG	ETF	24.01	24.02	23.976	23.976	4600.0
2023-02-23	AFMC	ETF	23.88	23.88	23.88	23.88	100.0
2023-02-23	AFSM	ETF	24.414	24.414	24.414	24.414	100.0
2023-02-23	AFTY	ETF	16.61	16.61	16.48	16.518	700.0
2023-02-23	AGG	ETF	97.4	97.72	97.37	97.69	8527200.0
2023-02-23	AGGY	ETF	42.82	42.92	42.79	42.88	173400.0
2023-02-23	AGNG	ETF	26.5	26.538	26.5	26.538	1000.0
2023-02-23	AGOV	ETF	74.99	74.99	74.99	74.99	23.0
2023-02-23	AGOX	ETF	21.84	21.87	21.589	21.75	11300.0
2023-02-23	AGQ	ETF	25.4	25.51	24.62	24.82	433700.0
2023-02-23	AGZ	ETF	106.7	106.88	106.695	106.87	23858.0
2023-02-23	AGZD	ETF	21.905	21.945	21.89	21.895	114600.0
2023-02-23	AHHX	ETF	8.52	8.59	8.52	8.59	357.0
2023-02-23	AHYB	ETF	43.33	43.472	43.27	43.472	900.0
2023-02-23	AIA	ETF	60.93	61.0	59.54	59.95	177609.0
2023-02-23	AIEQ	ETF	31.09	31.09	30.06	30.68	48800.0
2023-02-23	AIQ	ETF	23.02	23.02	22.6	22.93	166437.0

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

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