PREVIEW / etf_daily / 2022-01-21

all etf daily files

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

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-21	SPY	ETF	445.56	448.06	437.95	437.98	202271200.0
2022-01-21	QQQ	ETF	359.47	362.18	351.4	351.69	143388920.0
2022-01-21	IWM	ETF	199.76	203.02	196.99	196.99	85821000.0
2022-01-21	DIA	ETF	347.09	348.85	342.14	342.35	16301600.0
2022-01-21	GLD	ETF	172.04	172.12	170.74	171.09	10982500.0
2022-01-21	TLT	ETF	143.4	144.1	142.67	143.63	28916600.0
2022-01-21	AAA	ETF	25.0	25.0	24.985	25.0	3933.0
2022-01-21	AAAU	ETF	18.32	18.32	18.17	18.21	107800.0
2022-01-21	AADR	ETF	62.92	62.92	61.16	61.41	5900.0
2022-01-21	AAXJ	ETF	83.69	83.8	82.54	82.6	692400.0
2022-01-21	ABEQ	ETF	28.32	28.401	28.066	28.066	4400.0
2022-01-21	ACES	ETF	53.99	54.234	52.046	52.26	196200.0
2022-01-21	ACIO	ETF	31.39	31.45	31.01	31.04	78300.0
2022-01-21	ACSI	ETF	49.68	49.68	48.9385	48.9385	982.0
2022-01-21	ACT	ETF	20.98	21.62	20.94	21.08	141124.0
2022-01-21	ACTV	ETF	34.75	34.96	34.34	34.44	13933.0
2022-01-21	ACTX	ETF	1.2	1.23	1.2	1.23	780.0
2022-01-21	ACVF	ETF	33.09	33.43	32.85	32.85	15600.0
2022-01-21	ACWF	ETF	37.39	37.47	36.92	36.93	65370.0
2022-01-21	ACWI	ETF	100.93	101.32	99.44	99.52	8781100.0
2022-01-21	ACWV	ETF	103.66	104.23	103.06	103.09	120800.0
2022-01-21	ACWX	ETF	55.13	55.13	54.37	54.38	3892029.0
2022-01-21	ADFI	ETF	9.42	9.42	9.405	9.405	600.0
2022-01-21	ADIV	ETF	16.357	16.357	16.357	16.357	100.0
2022-01-21	ADME	ETF	40.9	41.071	40.49	40.49	59900.0
2022-01-21	ADRE	ETF	47.98	47.995	46.6703	46.8302	13586.0
2022-01-21	AEMB	ETF	47.015	47.015	47.015	47.015	100.0
2022-01-21	AESR	ETF	12.95	13.041	12.78	12.86	257900.0
2022-01-21	AFIF	ETF	9.52	9.52	9.5001	9.51	17133.0
2022-01-21	AFK	ETF	20.8	20.87	20.565	20.5664	6805.0
2022-01-21	AFLG	ETF	26.23	26.23	25.845	25.845	200.0
2022-01-21	AFMC	ETF	24.508	24.508	24.228	24.228	300.0
2022-01-21	AFSM	ETF	24.77	24.78	24.558	24.558	400.0
2022-01-21	AFTY	ETF	20.535	20.535	20.535	20.535	100.0
2022-01-21	AGG	ETF	112.19	112.35	112.11	112.23	8679600.0
2022-01-21	AGGY	ETF	50.52	50.61	50.45	50.57	181600.0
2022-01-21	AGNG	ETF	26.93	27.09	26.845	26.856	3800.0
2022-01-21	AGOV	ETF	96.68	96.7166	96.68	96.7166	170.0
2022-01-21	AGOX	ETF	23.918	24.03	23.643	23.66	14300.0
2022-01-21	AGQ	ETF	38.47	38.47	37.22	37.39	1340100.0
2022-01-21	AGZ	ETF	116.24	116.39	116.225	116.37	64023.0
2022-01-21	AGZD	ETF	23.265	23.295	23.23	23.255	111200.0
2022-01-21	AHHX	ETF	10.07	10.11	10.02	10.04	10121.0
2022-01-21	AHYB	ETF	49.44	49.44	49.272	49.272	334800.0
2022-01-21	AIA	ETF	78.93	79.06	77.54	77.54	51411.0
2022-01-21	AIEQ	ETF	36.22	36.729	35.82	35.82	34900.0
2022-01-21	AIQ	ETF	28.42	28.56	27.81	27.88	63345.0
2022-01-21	AIRR	ETF	40.72	41.92	40.72	40.827	40900.0
2022-01-21	AIVI	ETF	42.42	42.48	42.16	42.18	12100.0
2022-01-21	AIVL	ETF	98.43	99.35	97.95	98.05	12000.0

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

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