PREVIEW / etf_daily / 2021-11-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-12.parquet
  size:    96 KB
  rows:    2,559

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-11-12	SPY	ETF	465.12	467.86	464.11	467.27	53466700.0
2021-11-12	QQQ	ETF	391.77	395.25	390.13	394.7	34730564.0
2021-11-12	IWM	ETF	239.92	240.21	238.74	239.5	20526700.0
2021-11-12	DIA	ETF	360.69	361.74	359.58	361.28	3099800.0
2021-11-12	GLD	ETF	173.51	174.67	173.4	174.45	7894800.0
2021-11-12	TLT	ETF	148.0	148.51	146.76	147.33	12712000.0
2021-11-12	AAA	ETF	25.04	25.06	25.02	25.02	2548.0
2021-11-12	AAAU	ETF	18.46	18.58	18.45	18.56	302100.0
2021-11-12	AADR	ETF	65.32	65.36	65.19	65.28	1600.0
2021-11-12	AAXJ	ETF	87.59	88.0	87.49	87.93	716100.0
2021-11-12	ABEQ	ETF	28.352	28.352	28.352	28.352	100.0
2021-11-12	ACES	ETF	80.21	81.29	79.89	80.53	51300.0
2021-11-12	ACIO	ETF	31.96	32.05	31.859	32.004	25600.0
2021-11-12	ACSI	ETF	53.1389	53.1389	53.1389	53.1389	2.0
2021-11-12	ACT	ETF	22.02	22.28	21.88	22.0	144185.0
2021-11-12	ACTV	ETF	39.03	39.15	39.0115	39.0643	5032.0
2021-11-12	ACTX	ETF	0.8505	1.01	0.8505	1.01	9132.0
2021-11-12	ACVF	ETF	35.1	35.16	34.959	35.16	7300.0
2021-11-12	ACWF	ETF	39.01	39.23	39.01	39.21	7138.0
2021-11-12	ACWI	ETF	106.6	107.11	106.43	107.07	3337800.0
2021-11-12	ACWV	ETF	106.84	107.41	106.84	107.33	59400.0
2021-11-12	ACWX	ETF	57.75	57.93	57.68	57.92	505150.0
2021-11-12	ADFI	ETF	9.67	9.67	9.64	9.655	7000.0
2021-11-12	ADIV	ETF	17.865	17.865	17.865	17.865	100.0
2021-11-12	ADME	ETF	42.44	42.65	42.37	42.605	22200.0
2021-11-12	ADRE	ETF	50.9	51.265	50.9	51.265	2135.0
2021-11-12	AEMB	ETF	48.82	48.82	48.76	48.777	3500.0
2021-11-12	AESR	ETF	14.73	14.85	14.72	14.84	19300.0
2021-11-12	AFIF	ETF	9.61	9.63	9.59	9.591	29591.0
2021-11-12	AFK	ETF	21.67	21.73	21.61	21.68	2582.0
2021-11-12	AFLG	ETF	27.46	27.51	27.46	27.462	900.0
2021-11-12	AFMC	ETF	27.173	27.173	27.173	27.173	100.0
2021-11-12	AFSM	ETF	28.87	28.87	28.834	28.834	300.0
2021-11-12	AFTY	ETF	21.115	21.13	21.08	21.1	3000.0
2021-11-12	AGG	ETF	114.5	114.59	114.26	114.32	4554700.0
2021-11-12	AGGY	ETF	51.87	51.97	51.814	51.84	70000.0
2021-11-12	AGNG	ETF	29.78	29.85	29.72	29.82	4400.0
2021-11-12	AGOV	ETF	99.13	99.28	99.05	99.05	13121.0
2021-11-12	AGOX	ETF	26.31	26.43	26.23	26.43	39400.0
2021-11-12	AGQ	ETF	40.83	41.96	40.66	41.71	757300.0
2021-11-12	AGZ	ETF	117.87	117.98	117.8	117.85	11515.0
2021-11-12	AGZD	ETF	23.55	23.55	23.42	23.45	73200.0
2021-11-12	AIA	ETF	81.24	81.7	81.12	81.6	56589.0
2021-11-12	AIEQ	ETF	44.27	44.53	44.1	44.53	26300.0
2021-11-12	AIQ	ETF	32.68	33.11	32.67	33.11	37049.0
2021-11-12	AIRR	ETF	47.23	47.62	47.23	47.56	36800.0
2021-11-12	AIVI	ETF	41.57	41.63	41.56	41.61	2700.0
2021-11-12	ALTL	ETF	44.69	44.7867	44.5272	44.75	27064.0
2021-11-12	ALTY	ETF	13.589	13.589	13.5	13.5	10800.0
2021-11-12	AMJ	ETF	19.41	19.465	19.255	19.46	503592.0

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

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