PREVIEW / etf_daily / 2023-02-06

all etf daily files

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

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-06	SPY	ETF	409.79	411.29	408.1	409.83	60295300.0
2023-02-06	QQQ	ETF	303.51	305.91	302.22	303.59	40802348.0
2023-02-06	IWM	ETF	195.65	196.38	193.37	194.14	18160100.0
2023-02-06	DIA	ETF	337.65	339.56	336.69	338.48	2708400.0
2023-02-06	GLD	ETF	174.11	174.46	173.28	173.82	8957000.0
2023-02-06	TLT	ETF	105.75	106.31	105.68	105.91	15182400.0
2023-02-06	AAA	ETF	24.525	24.525	24.525	24.525	105.0
2023-02-06	AAAU	ETF	18.57	18.6	18.48	18.54	8385400.0
2023-02-06	AADR	ETF	48.18	48.59	48.18	48.59	3700.0
2023-02-06	AAPB	ETF	20.27	20.27	19.79	19.9452	7926.0
2023-02-06	AAPD	ETF	25.69	25.98	25.63	25.86	106839.0
2023-02-06	AAPU	ETF	20.99	21.114	20.67	20.82	196079.0
2023-02-06	AAXJ	ETF	69.28	69.36	68.76	69.22	1048100.0
2023-02-06	ABEQ	ETF	28.3	28.39	28.3	28.364	3200.0
2023-02-06	ACES	ETF	52.81	52.861	52.16	52.51	28100.0
2023-02-06	ACIO	ETF	29.98	30.01	29.95	30.01	23800.0
2023-02-06	ACSI	ETF	46.24	46.24	46.13	46.13	2871.0
2023-02-06	ACT	ETF	25.2	25.2	24.73	24.81	161861.0
2023-02-06	ACTV	ETF	34.45	34.45	32.94	33.01	14512.0
2023-02-06	ACTX	ETF	0.375	0.375	0.375	0.375	203.0
2023-02-06	ACVF	ETF	31.39	31.525	30.6	31.493	4000.0
2023-02-06	ACWF	ETF	33.59	33.6499	33.56	33.5836	1889.0
2023-02-06	ACWI	ETF	91.23	91.29	90.67	91.1	4259400.0
2023-02-06	ACWV	ETF	95.29	95.84	95.29	95.67	229600.0
2023-02-06	ACWX	ETF	48.77	48.86	48.475	48.75	2402981.0
2023-02-06	ADFI	ETF	8.55	8.56	8.54	8.54	58100.0
2023-02-06	ADIV	ETF	14.2	14.2	14.185	14.185	1600.0
2023-02-06	ADME	ETF	34.88	34.88	34.68	34.71	5600.0
2023-02-06	ADPV	ETF	25.58	25.58	25.27	25.34	26315.0
2023-02-06	ADRE	ETF	41.16	41.53	41.0055	41.53	19300.0
2023-02-06	AEMB	ETF	38.74	38.74	38.74	38.74	100.0
2023-02-06	AESR	ETF	11.81	11.84	11.76	11.82	57800.0
2023-02-06	AFIF	ETF	8.905	8.9115	8.902	8.902	2806.0
2023-02-06	AFK	ETF	17.38	17.38	16.74	16.83	8976.0
2023-02-06	AFLG	ETF	24.461	24.461	24.41	24.442	2100.0
2023-02-06	AFMC	ETF	24.23	24.283	24.23	24.283	100.0
2023-02-06	AFSM	ETF	24.714	24.72	24.667	24.667	2100.0
2023-02-06	AFTY	ETF	16.76	16.816	16.76	16.816	400.0
2023-02-06	AGG	ETF	99.31	99.42	99.23	99.27	9198900.0
2023-02-06	AGGH	ETF	22.55	22.5857	22.55	22.5857	111.0
2023-02-06	AGGY	ETF	43.84	43.865	43.782	43.81	90400.0
2023-02-06	AGNG	ETF	26.97	27.08	26.932	26.932	2100.0
2023-02-06	AGOV	ETF	80.02	81.0082	80.0	81.0082	2161.0
2023-02-06	AGOX	ETF	22.27	22.27	22.082	22.12	44800.0
2023-02-06	AGQ	ETF	27.33	27.63	26.9	27.15	411600.0
2023-02-06	AGZ	ETF	107.3	107.78	107.3	107.46	19142.0
2023-02-06	AGZD	ETF	21.885	21.96	21.86	21.945	212000.0
2023-02-06	AHHX	ETF	8.75	8.76	8.72	8.72	2102.0
2023-02-06	AHYB	ETF	44.202	44.202	44.202	44.202	100.0
2023-02-06	AIA	ETF	63.24	63.4997	62.84	63.35	87101.0

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

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