PREVIEW / etf_daily / 2022-12-09

all etf daily files

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

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-09	SPY	ETF	394.94	397.62	393.15	393.28	81447700.0
2022-12-09	QQQ	ETF	282.81	285.64	281.59	282.04	47860487.0
2022-12-09	IWM	ETF	179.77	180.81	178.56	178.62	22046500.0
2022-12-09	DIA	ETF	337.67	339.11	335.25	335.37	3815500.0
2022-12-09	GLD	ETF	167.26	168.09	166.6	167.06	5431300.0
2022-12-09	TLT	ETF	107.94	108.17	106.27	106.33	25872200.0
2022-12-09	AAA	ETF	24.33	24.33	24.33	24.33	88.0
2022-12-09	AAAU	ETF	17.84	17.91	17.78	17.81	474900.0
2022-12-09	AADR	ETF	48.48	48.51	48.46	48.46	1600.0
2022-12-09	AAPB	ETF	18.2179	18.2179	18.2179	18.2179	231.0
2022-12-09	AAPD	ETF	27.78	28.03	27.2	27.84	308519.0
2022-12-09	AAPU	ETF	19.37	19.9619	19.12	19.34	77427.0
2022-12-09	AAXJ	ETF	67.13	67.27	66.64	66.64	864500.0
2022-12-09	ABEQ	ETF	28.02	28.07	27.881	27.881	11500.0
2022-12-09	ACES	ETF	51.18	51.71	50.8	50.977	66400.0
2022-12-09	ACIO	ETF	29.62	29.69	29.458	29.46	78600.0
2022-12-09	ACSI	ETF	43.8131	43.8131	43.8131	43.8131	8.0
2022-12-09	ACT	ETF	24.31	24.63	24.24	24.32	152235.0
2022-12-09	ACTV	ETF	30.48	30.54	30.1173	30.1173	3454.0
2022-12-09	ACTX	ETF	0.4499	0.4499	0.4499	0.4499	317.0
2022-12-09	ACVF	ETF	30.698	30.74	30.48	30.48	2900.0
2022-12-09	ACWF	ETF	33.1302	33.1302	32.8933	32.8933	9875.0
2022-12-09	ACWI	ETF	87.76	88.2	87.31	87.34	7892800.0
2022-12-09	ACWV	ETF	97.73	97.88	97.16	97.16	79000.0
2022-12-09	ACWX	ETF	46.74	46.94	46.55	46.56	1741402.0
2022-12-09	ADFI	ETF	8.49	8.52	8.49	8.505	4500.0
2022-12-09	ADIV	ETF	13.22	13.22	13.22	13.22	100.0
2022-12-09	ADME	ETF	34.829	34.91	34.702	34.702	18100.0
2022-12-09	ADPV	ETF	26.37	26.6	25.1	25.112	25499.0
2022-12-09	ADRE	ETF	39.47	39.49	39.02	39.02	7446.0
2022-12-09	AEMB	ETF	38.185	38.185	38.185	38.185	100.0
2022-12-09	AESR	ETF	11.77	11.86	11.71	11.71	9600.0
2022-12-09	AFIF	ETF	8.8	8.82	8.79	8.8063	38423.0
2022-12-09	AFK	ETF	17.36	17.37	17.1	17.1	8574.0
2022-12-09	AFLG	ETF	24.0	24.0	23.838	23.838	100.0
2022-12-09	AFMC	ETF	22.82	22.82	22.731	22.731	100.0
2022-12-09	AFSM	ETF	23.16	23.16	23.16	23.16	100.0
2022-12-09	AFTY	ETF	16.3	16.3	16.249	16.249	2700.0
2022-12-09	AGG	ETF	99.12	99.21	98.77	98.79	8994400.0
2022-12-09	AGGH	ETF	22.85	22.85	22.8037	22.8037	208.0
2022-12-09	AGGY	ETF	43.67	43.685	43.52	43.52	95100.0
2022-12-09	AGNG	ETF	26.58	26.58	26.466	26.466	500.0
2022-12-09	AGOV	ETF	82.6	82.6	80.63	81.5766	292.0
2022-12-09	AGOX	ETF	20.94	21.14	20.94	20.976	9900.0
2022-12-09	AGQ	ETF	30.51	31.49	30.04	30.85	1015200.0
2022-12-09	AGZ	ETF	107.1	107.15	107.03	107.03	17864.0
2022-12-09	AGZD	ETF	21.8	21.85	21.75	21.845	96200.0
2022-12-09	AHHX	ETF	8.46	8.55	8.46	8.4973	46075.0
2022-12-09	AHYB	ETF	43.669	43.77	43.669	43.687	1400.0
2022-12-09	AIA	ETF	59.16	59.48	58.73	58.84	31442.0

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

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