PREVIEW / etf_daily / 2022-12-23

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-23.parquet
  size:    107 KB
  rows:    2,884

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
2022-12-23	SPY	ETF	379.65	383.06	378.03	382.91	59857300.0
2022-12-23	QQQ	ETF	265.47	268.04	263.53	267.36	39373584.0
2022-12-23	IWM	ETF	173.48	174.45	172.34	174.39	11647700.0
2022-12-23	DIA	ETF	329.62	332.19	328.06	331.93	3997900.0
2022-12-23	GLD	ETF	166.88	167.8	166.66	167.26	2912300.0
2022-12-23	TLT	ETF	102.58	102.81	102.02	102.16	15408900.0
2022-12-23	AAA	ETF	24.4	24.43	24.4	24.43	772.0
2022-12-23	AAAU	ETF	17.8	17.89	17.78	17.84	341100.0
2022-12-23	AADR	ETF	48.5	48.5	48.2	48.2	1800.0
2022-12-23	AAPB	ETF	15.62	15.87	15.49	15.87	1332.0
2022-12-23	AAPD	ETF	30.0	30.327	29.71	29.89	96818.0
2022-12-23	AAPU	ETF	16.92	17.13	16.67	17.06	52558.0
2022-12-23	AAXJ	ETF	64.6	64.65	64.21	64.51	409900.0
2022-12-23	ABEQ	ETF	27.855	28.1	27.855	28.1	4500.0
2022-12-23	ACES	ETF	46.77	46.88	46.02	46.51	48200.0
2022-12-23	ACIO	ETF	28.787	29.01	28.787	29.0	62100.0
2022-12-23	ACSI	ETF	41.937	41.937	41.937	41.937	102.0
2022-12-23	ACT	ETF	23.97	24.23	23.91	24.19	60582.0
2022-12-23	ACTV	ETF	28.67	28.9	28.54	28.87	5305.0
2022-12-23	ACTX	ETF	0.4299	0.4299	0.4299	0.4299	328.0
2022-12-23	ACVF	ETF	29.548	29.8	29.548	29.795	20900.0
2022-12-23	ACWF	ETF	31.51	31.74	31.47	31.7299	10073.0
2022-12-23	ACWI	ETF	84.51	85.07	84.17	85.06	4502300.0
2022-12-23	ACWV	ETF	94.69	95.17	94.63	95.17	143800.0
2022-12-23	ACWX	ETF	45.43	45.6646	45.3	45.59	2210927.0
2022-12-23	ADFI	ETF	8.37	8.385	8.361	8.375	1900.0
2022-12-23	ADIV	ETF	13.016	13.016	13.016	13.016	100.0
2022-12-23	ADME	ETF	33.84	33.93	33.81	33.9	45500.0
2022-12-23	ADPV	ETF	25.07	25.0928	25.07	25.07	20198.0
2022-12-23	ADRE	ETF	37.71	37.71	37.375	37.3811	1412.0
2022-12-23	AEMB	ETF	37.745	37.745	37.745	37.745	100.0
2022-12-23	AESR	ETF	11.37	11.52	11.37	11.52	6800.0
2022-12-23	AFIF	ETF	8.79	8.81	8.78	8.8	17675.0
2022-12-23	AFK	ETF	16.24	16.466	16.104	16.27	25788.0
2022-12-23	AFLG	ETF	23.22	23.231	23.21	23.231	1600.0
2022-12-23	AFMC	ETF	22.26	22.301	22.26	22.301	100.0
2022-12-23	AFSM	ETF	22.68	22.773	22.68	22.773	200.0
2022-12-23	AFTY	ETF	15.53	15.57	15.53	15.56	5600.0
2022-12-23	AGG	ETF	98.05	98.11	97.9	97.97	4823400.0
2022-12-23	AGGH	ETF	22.63	22.68	22.59	22.59	5401.0
2022-12-23	AGGY	ETF	43.03	43.11	43.02	43.055	121500.0
2022-12-23	AGNG	ETF	26.12	26.18	26.12	26.18	500.0
2022-12-23	AGOV	ETF	80.02	80.5622	79.54	80.5622	421.0
2022-12-23	AGOX	ETF	20.47	20.61	20.4	20.61	9000.0
2022-12-23	AGQ	ETF	31.22	31.75	31.02	31.47	645600.0
2022-12-23	AGZ	ETF	107.01	107.1	107.0	107.04	14017.0
2022-12-23	AGZD	ETF	21.77	21.77	21.685	21.73	161000.0
2022-12-23	AHHX	ETF	8.4359	8.5099	8.4359	8.5	4020.0
2022-12-23	AHYB	ETF	43.17	43.332	43.16	43.332	800.0
2022-12-23	AIA	ETF	56.83	56.94	56.39	56.69	38943.0

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

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