PREVIEW / etf_daily / 2022-02-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-02-02.parquet
  size:    100 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-02-02	SPY	ETF	455.5	458.12	453.05	457.35	117361000.0
2022-02-02	QQQ	ETF	369.76	370.1	364.285	368.49	78777135.0
2022-02-02	IWM	ETF	203.62	203.9	199.29	201.34	42777800.0
2022-02-02	DIA	ETF	353.59	356.66	352.76	356.03	8856400.0
2022-02-02	GLD	ETF	168.34	169.12	168.16	168.84	9085300.0
2022-02-02	TLT	ETF	141.95	143.57	141.93	142.2	18404600.0
2022-02-02	AAA	ETF	25.0	25.0	25.0	25.0	621.0
2022-02-02	AAAU	ETF	17.92	17.99	17.91	17.96	305800.0
2022-02-02	AADR	ETF	63.67	63.95	63.67	63.92	3200.0
2022-02-02	AAXJ	ETF	82.46	82.49	81.54	81.93	923700.0
2022-02-02	ABEQ	ETF	28.41	28.646	28.41	28.646	1100.0
2022-02-02	ACES	ETF	54.38	54.38	52.5	52.63	39900.0
2022-02-02	ACIO	ETF	31.93	32.159	31.87	32.13	69700.0
2022-02-02	ACSI	ETF	50.18	50.33	50.18	50.33	373.0
2022-02-02	ACT	ETF	21.53	22.11	21.4	21.64	200852.0
2022-02-02	ACTV	ETF	35.1194	35.29	35.1194	35.2484	7467.0
2022-02-02	ACTX	ETF	1.05	1.1	1.0	1.0	6603.0
2022-02-02	ACVF	ETF	33.97	34.219	33.82	34.219	3900.0
2022-02-02	ACWF	ETF	37.44	37.64	37.34	37.6149	6494.0
2022-02-02	ACWI	ETF	102.38	102.61	101.68	102.4	2463300.0
2022-02-02	ACWV	ETF	103.41	104.44	103.41	104.28	262900.0
2022-02-02	ACWX	ETF	54.98	54.99	54.583	54.89	2694339.0
2022-02-02	ADFI	ETF	9.39	9.39	9.375	9.375	3200.0
2022-02-02	ADIV	ETF	16.25	16.3	16.25	16.3	900.0
2022-02-02	ADME	ETF	42.39	42.39	41.86	42.12	32500.0
2022-02-02	ADRE	ETF	47.6	47.6	46.5847	46.98	15034.0
2022-02-02	AEMB	ETF	47.04	47.04	47.04	47.04	100.0
2022-02-02	AESR	ETF	13.3	13.382	13.27	13.382	4600.0
2022-02-02	AFIF	ETF	9.49	9.495	9.4751	9.4751	3629.0
2022-02-02	AFK	ETF	21.0	21.0	20.55	20.81	9369.0
2022-02-02	AFLG	ETF	26.77	26.927	26.77	26.927	900.0
2022-02-02	AFMC	ETF	24.95	24.95	24.95	24.95	100.0
2022-02-02	AFSM	ETF	25.194	25.22	25.194	25.22	2700.0
2022-02-02	AFTY	ETF	19.82	19.83	19.807	19.807	1900.0
2022-02-02	AGG	ETF	111.7	111.97	111.67	111.72	7967900.0
2022-02-02	AGGY	ETF	50.3	50.426	50.28	50.28	199200.0
2022-02-02	AGNG	ETF	27.0	27.0	26.74	26.99	3500.0
2022-02-02	AGOV	ETF	96.7554	96.7554	96.7554	96.7554	80.0
2022-02-02	AGOX	ETF	24.27	24.34	24.06	24.23	76900.0
2022-02-02	AGQ	ETF	32.5	32.91	31.9	32.45	846200.0
2022-02-02	AGZ	ETF	115.95	116.13	115.94	116.01	52366.0
2022-02-02	AGZD	ETF	23.2	23.315	23.2	23.26	37800.0
2022-02-02	AHHX	ETF	9.935	9.97	9.9	9.9444	9018.0
2022-02-02	AHYB	ETF	49.03	49.03	49.025	49.025	700.0
2022-02-02	AIA	ETF	78.07	78.45	77.25	77.84	119346.0
2022-02-02	AIEQ	ETF	37.75	37.75	37.0	37.33	11900.0
2022-02-02	AIQ	ETF	29.28	29.29	28.6901	28.88	19605.0
2022-02-02	AIRR	ETF	41.47	41.47	40.57	40.68	56700.0
2022-02-02	AIVI	ETF	42.49	42.61	42.46	42.6	5900.0
2022-02-02	AIVL	ETF	99.09	99.86	99.04	99.85	12200.0

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

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