PREVIEW / etf_daily / 2021-12-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-27.parquet
  size:    98 KB
  rows:    2,629

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
2021-12-27	SPY	ETF	472.06	477.31	472.01	477.26	56808600.0
2021-12-27	QQQ	ETF	398.25	403.48	398.2194	403.48	32820705.0
2021-12-27	IWM	ETF	222.34	224.24	220.6	224.12	24196700.0
2021-12-27	DIA	ETF	360.06	362.96	359.7	362.92	2594300.0
2021-12-27	GLD	ETF	168.96	169.42	168.78	169.37	4760300.0
2021-12-27	TLT	ETF	148.46	149.01	148.32	148.88	7821800.0
2021-12-27	AAA	ETF	25.015	25.015	25.015	25.015	33.0
2021-12-27	AAAU	ETF	17.98	18.03	17.95	18.01	200400.0
2021-12-27	AADR	ETF	63.5	64.21	63.5	63.96	3300.0
2021-12-27	AAXJ	ETF	82.56	82.93	82.41	82.7	832800.0
2021-12-27	ABEQ	ETF	28.2	28.36	28.2	28.36	5800.0
2021-12-27	ACES	ETF	64.64	65.05	64.0	64.71	107200.0
2021-12-27	ACIO	ETF	32.485	32.75	32.48	32.68	204200.0
2021-12-27	ACSI	ETF	53.225	53.225	53.225	53.225	217.0
2021-12-27	ACT	ETF	20.07	20.25	19.8	20.22	65916.0
2021-12-27	ACTV	ETF	36.01	36.4222	36.01	36.4222	3226.0
2021-12-27	ACTX	ETF	1.34	1.35	1.34	1.35	1081.0
2021-12-27	ACVF	ETF	35.4	35.744	35.4	35.744	4200.0
2021-12-27	ACWF	ETF	38.68	39.1536	38.68	39.1536	13994.0
2021-12-27	ACWI	ETF	105.29	106.25	105.25	106.25	2712200.0
2021-12-27	ACWV	ETF	106.94	107.67	106.94	107.67	249400.0
2021-12-27	ACWX	ETF	55.44	55.82	55.44	55.8	2494967.0
2021-12-27	ADFI	ETF	9.56	9.62	9.56	9.615	3900.0
2021-12-27	ADIV	ETF	16.405	16.47	16.405	16.454	1700.0
2021-12-27	ADME	ETF	42.82	43.53	42.82	43.48	114300.0
2021-12-27	ADRE	ETF	45.15	45.73	45.15	45.33	14417.0
2021-12-27	AEMB	ETF	48.361	48.361	48.361	48.361	600.0
2021-12-27	AESR	ETF	13.95	14.06	13.95	14.06	8700.0
2021-12-27	AFIF	ETF	9.579	9.579	9.56	9.57	11522.0
2021-12-27	AFK	ETF	20.39	20.39	20.09	20.12	15458.0
2021-12-27	AFLG	ETF	28.088	28.088	28.088	28.088	100.0
2021-12-27	AFMC	ETF	26.514	26.514	26.514	26.514	100.0
2021-12-27	AFTY	ETF	21.06	21.12	20.99	21.085	3500.0
2021-12-27	AGG	ETF	114.15	114.3	114.13	114.26	5436800.0
2021-12-27	AGGY	ETF	51.71	51.78	51.689	51.73	170600.0
2021-12-27	AGNG	ETF	28.91	29.07	28.91	29.07	1000.0
2021-12-27	AGOV	ETF	98.955	98.955	98.955	98.955	80.0
2021-12-27	AGOX	ETF	25.27	25.515	25.24	25.46	62800.0
2021-12-27	AGQ	ETF	33.63	34.23	33.53	34.09	542900.0
2021-12-27	AGZ	ETF	117.3	117.3	117.2	117.25	42652.0
2021-12-27	AGZD	ETF	23.325	23.38	23.32	23.325	81400.0
2021-12-27	AHHX	ETF	10.495	10.495	10.375	10.3753	507.0
2021-12-27	AHYB	ETF	50.192	50.25	50.192	50.25	400.0
2021-12-27	AIA	ETF	76.55	77.15	76.55	76.8	88303.0
2021-12-27	AIEQ	ETF	42.17	42.81	42.17	42.772	11500.0
2021-12-27	AIQ	ETF	31.89	32.225	31.89	32.19	24842.0
2021-12-27	AIRR	ETF	44.55	45.11	44.25	45.11	37300.0
2021-12-27	AIVI	ETF	41.65	41.92	41.65	41.92	52000.0
2021-12-27	ALTL	ETF	45.69	46.37	45.53	46.34	49518.0
2021-12-27	ALTY	ETF	13.46	13.46	13.37	13.445	13400.0

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

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