PREVIEW / etf_daily / 2022-01-26

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-26.parquet
  size:    99 KB
  rows:    2,657

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-26	SPY	ETF	440.72	444.04	428.86	433.38	186391100.0
2022-01-26	QQQ	ETF	352.91	356.88	340.78	344.57	146559524.0
2022-01-26	IWM	ETF	201.78	203.55	193.72	195.97	71471700.0
2022-01-26	DIA	ETF	346.04	348.0	338.53	341.46	19047300.0
2022-01-26	GLD	ETF	171.39	171.73	169.48	169.79	17799400.0
2022-01-26	TLT	ETF	142.26	142.57	140.49	140.5	23655500.0
2022-01-26	AAA	ETF	24.99	25.0023	24.99	24.99	4324.0
2022-01-26	AAAU	ETF	18.25	18.28	18.05	18.08	14338200.0
2022-01-26	AADR	ETF	61.68	61.69	60.32	60.32	1300.0
2022-01-26	AAXJ	ETF	81.7	81.7	79.97	80.11	1134800.0
2022-01-26	ABEQ	ETF	28.17	28.24	27.875	27.904	5000.0
2022-01-26	ACES	ETF	52.43	53.3	50.34	50.76	94400.0
2022-01-26	ACIO	ETF	31.06	31.35	30.63	30.73	32400.0
2022-01-26	ACSI	ETF	48.96	48.96	48.3087	48.3087	108.0
2022-01-26	ACT	ETF	21.45	21.9	20.63	21.03	200902.0
2022-01-26	ACTV	ETF	34.77	34.87	33.87	33.949	8392.0
2022-01-26	ACTX	ETF	1.25	1.25	0.97	0.97	1177.0
2022-01-26	ACVF	ETF	32.62	33.08	32.32	32.48	20300.0
2022-01-26	ACWF	ETF	36.96	36.96	36.1	36.3012	8482.0
2022-01-26	ACWI	ETF	99.69	100.17	97.16	97.87	5429500.0
2022-01-26	ACWV	ETF	102.29	102.44	100.4	100.75	234200.0
2022-01-26	ACWX	ETF	54.11	54.22	53.015	53.2	5699896.0
2022-01-26	ADFI	ETF	9.371	9.4	9.335	9.335	4900.0
2022-01-26	ADIV	ETF	16.04	16.17	16.04	16.11	1500.0
2022-01-26	ADME	ETF	40.58	40.982	39.89	40.15	32700.0
2022-01-26	ADRE	ETF	46.63	46.63	44.9615	45.17	20229.0
2022-01-26	AEMB	ETF	46.564	46.564	46.564	46.564	100.0
2022-01-26	AESR	ETF	12.93	12.95	12.65	12.727	11500.0
2022-01-26	AFIF	ETF	9.489	9.49	9.4252	9.4252	22324.0
2022-01-26	AFK	ETF	20.5	20.5	20.0	20.04	6936.0
2022-01-26	AFLG	ETF	25.9	25.99	25.44	25.51	1900.0
2022-01-26	AFMC	ETF	24.27	24.27	23.989	23.989	200.0
2022-01-26	AFSM	ETF	25.22	25.22	24.345	24.345	100.0
2022-01-26	AFTY	ETF	20.43	20.43	20.24	20.251	2100.0
2022-01-26	AGG	ETF	112.06	112.13	111.36	111.36	10729400.0
2022-01-26	AGGY	ETF	50.36	50.53	50.14	50.14	220000.0
2022-01-26	AGNG	ETF	26.23	26.51	26.0	26.037	7000.0
2022-01-26	AGOV	ETF	96.291	96.291	95.76	95.76	1830.0
2022-01-26	AGOX	ETF	23.73	23.962	23.31	23.43	48900.0
2022-01-26	AGQ	ETF	35.76	36.41	34.93	35.12	1313600.0
2022-01-26	AGZ	ETF	115.94	116.326	115.833	115.89	22405.0
2022-01-26	AGZD	ETF	23.25	23.315	23.25	23.28	65800.0
2022-01-26	AHHX	ETF	10.055	10.055	9.98	9.98	1388.0
2022-01-26	AHYB	ETF	49.31	49.36	49.109	49.109	500.0
2022-01-26	AIA	ETF	77.29	77.29	75.29	75.67	262483.0
2022-01-26	AIEQ	ETF	35.76	36.29	34.97	35.1	14000.0
2022-01-26	AIQ	ETF	27.9	28.0493	26.955	27.23	28059.0
2022-01-26	AIRR	ETF	41.3	41.638	39.84	40.37	31100.0
2022-01-26	AIVI	ETF	41.43	42.38	41.43	41.84	19600.0
2022-01-26	AIVL	ETF	97.4	98.45	95.76	96.48	19600.0

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

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