PREVIEW / etf_daily / 2023-01-23

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-23.parquet
  size:    107 KB
  rows:    2,886

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-01-23	SPY	ETF	396.72	402.65	395.72	400.63	84178800.0
2023-01-23	QQQ	ETF	283.54	290.21	282.73	288.96	52799905.0
2023-01-23	IWM	ETF	185.43	188.12	184.58	187.33	20329900.0
2023-01-23	DIA	ETF	334.69	337.75	333.05	336.17	3985300.0
2023-01-23	GLD	ETF	178.35	179.69	177.78	179.63	5265500.0
2023-01-23	TLT	ETF	105.57	106.2	105.49	105.7	12961500.0
2023-01-23	AAA	ETF	24.515	24.515	24.515	24.515	101.0
2023-01-23	AAAU	ETF	19.02	19.17	18.98	19.16	463400.0
2023-01-23	AADR	ETF	50.67	50.68	50.22	50.35	4800.0
2023-01-23	AAPB	ETF	17.2504	18.07	17.2504	17.63	1815.0
2023-01-23	AAPD	ETF	28.39	28.43	27.375	27.8106	321244.0
2023-01-23	AAPU	ETF	18.18	19.13	18.18	18.73	86058.0
2023-01-23	AAXJ	ETF	71.94	72.66	71.82	72.38	882400.0
2023-01-23	ABEQ	ETF	28.784	28.8	28.77	28.8	2300.0
2023-01-23	ACES	ETF	49.73	51.63	49.55	51.62	37700.0
2023-01-23	ACIO	ETF	29.357	29.67	29.357	29.522	55500.0
2023-01-23	ACSI	ETF	44.39	44.39	44.39	44.39	24.0
2023-01-23	ACT	ETF	24.5	24.74	24.42	24.49	176520.0
2023-01-23	ACTV	ETF	31.24	31.75	31.24	31.52	4620.0
2023-01-23	ACVF	ETF	30.55	31.078	30.55	30.945	4700.0
2023-01-23	ACWF	ETF	33.6	33.735	33.55	33.6879	5004.0
2023-01-23	ACWI	ETF	89.67	90.78	89.55	90.46	7665800.0
2023-01-23	ACWV	ETF	96.58	97.12	96.31	96.77	165400.0
2023-01-23	ACWX	ETF	49.27	49.715	49.26	49.65	2874710.0
2023-01-23	ADFI	ETF	8.57	8.575	8.57	8.575	17700.0
2023-01-23	ADIV	ETF	14.46	14.64	14.44	14.581	1500.0
2023-01-23	ADME	ETF	34.1	34.25	33.901	34.089	34600.0
2023-01-23	ADPV	ETF	25.16	25.16	25.1	25.1	23279.0
2023-01-23	ADRE	ETF	43.03	43.755	43.03	43.6	10065.0
2023-01-23	AEMB	ETF	39.28	39.36	39.28	39.29	700.0
2023-01-23	AESR	ETF	11.701	11.78	11.701	11.733	15700.0
2023-01-23	AFIF	ETF	8.845	8.85	8.83	8.83	115250.0
2023-01-23	AFK	ETF	17.3	17.43	17.23	17.35	10458.0
2023-01-23	AFLG	ETF	23.9	23.984	23.9	23.984	200.0
2023-01-23	AFSM	ETF	23.76	23.883	23.76	23.883	600.0
2023-01-23	AFTY	ETF	17.65	17.65	17.632	17.632	200.0
2023-01-23	AGG	ETF	99.8	100.06	99.78	99.84	6573200.0
2023-01-23	AGGH	ETF	22.7594	22.7594	22.71	22.71	217.0
2023-01-23	AGGY	ETF	43.98	44.095	43.98	44.03	119600.0
2023-01-23	AGNG	ETF	27.06	27.12	26.99	27.07	1700.0
2023-01-23	AGOV	ETF	80.5	81.225	80.5	81.21	601.0
2023-01-23	AGOX	ETF	21.4	21.88	21.4	21.75	21500.0
2023-01-23	AGQ	ETF	29.29	30.55	28.61	30.42	1492500.0
2023-01-23	AGZ	ETF	108.28	108.355	108.14	108.14	25639.0
2023-01-23	AGZD	ETF	21.87	21.9	21.77	21.865	270600.0
2023-01-23	AHHX	ETF	8.675	8.675	8.65	8.67	2120.0
2023-01-23	AHYB	ETF	44.325	44.325	44.325	44.325	300.0
2023-01-23	AIA	ETF	65.69	66.48	65.56	66.2	112435.0
2023-01-23	AIEQ	ETF	30.91	31.76	30.91	31.699	4300.0
2023-01-23	AIQ	ETF	22.36	22.83	22.36	22.79	13835.0

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

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