PREVIEW / etf_daily / 2022-01-31

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-31.parquet
  size:    100 KB
  rows:    2,670

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-01-31	SPY	ETF	441.24	450.28	439.81	449.91	152251400.0
2022-01-31	QQQ	ETF	353.2	363.65	351.52	363.05	94326389.0
2022-01-31	IWM	ETF	194.39	201.24	193.85	201.24	53393800.0
2022-01-31	DIA	ETF	345.78	351.36	344.72	351.08	8379100.0
2022-01-31	GLD	ETF	167.79	168.14	167.46	168.09	8539300.0
2022-01-31	TLT	ETF	142.18	142.95	141.96	142.39	13998400.0
2022-01-31	AAA	ETF	25.01	25.01	24.99	25.01	2624.0
2022-01-31	AAAU	ETF	17.87	17.89	17.83	17.89	205700.0
2022-01-31	AADR	ETF	61.44	62.0	61.12	61.98	1900.0
2022-01-31	AAXJ	ETF	79.83	81.73	79.83	81.65	1027000.0
2022-01-31	ABEQ	ETF	27.7	28.321	27.7	28.321	10000.0
2022-01-31	ACES	ETF	49.74	53.51	49.74	53.43	427800.0
2022-01-31	ACIO	ETF	31.18	31.59	31.03	31.59	33400.0
2022-01-31	ACSI	ETF	50.0193	50.0193	50.0193	50.0193	191.0
2022-01-31	ACT	ETF	21.08	21.94	21.06	21.88	141661.0
2022-01-31	ACTV	ETF	34.45	34.9	34.4205	34.9	8461.0
2022-01-31	ACVF	ETF	33.31	33.585	33.0	33.585	10800.0
2022-01-31	ACWF	ETF	36.38	37.0674	36.38	37.0674	4336.0
2022-01-31	ACWI	ETF	99.0	101.05	98.88	100.97	3866600.0
2022-01-31	ACWV	ETF	102.12	103.38	101.91	103.33	160000.0
2022-01-31	ACWX	ETF	53.3	54.21	53.265	54.18	3966590.0
2022-01-31	ADFI	ETF	9.32	9.345	9.32	9.345	7100.0
2022-01-31	ADIV	ETF	15.92	16.13	15.92	16.13	500.0
2022-01-31	ADME	ETF	41.109	41.58	41.079	41.58	24100.0
2022-01-31	ADRE	ETF	45.16	46.8028	45.16	46.76	17875.0
2022-01-31	AEMB	ETF	46.85	46.85	46.85	46.85	100.0
2022-01-31	AESR	ETF	12.92	13.09	12.92	13.087	30200.0
2022-01-31	AFIF	ETF	9.4323	9.44	9.42	9.435	23879.0
2022-01-31	AFK	ETF	20.18	20.52	20.18	20.52	6398.0
2022-01-31	AFLG	ETF	26.401	26.401	26.401	26.401	100.0
2022-01-31	AFMC	ETF	24.613	24.613	24.613	24.613	100.0
2022-01-31	AFSM	ETF	24.969	24.969	24.969	24.969	100.0
2022-01-31	AFTY	ETF	19.726	19.726	19.726	19.726	100.0
2022-01-31	AGG	ETF	111.64	111.89	111.6	111.8	12837400.0
2022-01-31	AGGY	ETF	50.22	50.32	50.22	50.28	125500.0
2022-01-31	AGNG	ETF	26.3	26.68	26.3	26.67	29400.0
2022-01-31	AGOV	ETF	96.27	96.51	96.27	96.3557	1429.0
2022-01-31	AGOX	ETF	23.37	24.1	23.37	23.99	44400.0
2022-01-31	AGQ	ETF	31.93	32.19	31.63	32.02	681500.0
2022-01-31	AGZ	ETF	115.84	116.037	115.83	115.83	54200.0
2022-01-31	AGZD	ETF	23.22	23.31	23.22	23.29	196200.0
2022-01-31	AHHX	ETF	9.84	9.94	9.84	9.8945	21262.0
2022-01-31	AHYB	ETF	48.776	48.82	48.77	48.81	2900.0
2022-01-31	AIA	ETF	75.51	77.49	75.472	77.4	88878.0
2022-01-31	AIEQ	ETF	35.53	36.839	35.53	36.8	8900.0
2022-01-31	AIQ	ETF	27.78	28.795	27.78	28.79	38111.0
2022-01-31	AIRR	ETF	39.65	41.01	39.65	40.88	48300.0
2022-01-31	AIVI	ETF	41.65	42.21	41.65	42.13	8100.0
2022-01-31	AIVL	ETF	96.69	98.63	96.69	98.6	19100.0
2022-01-31	ALTL	ETF	44.15	44.82	44.15	44.81	57376.0

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

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