PREVIEW / etf_daily / 2021-11-05

all etf daily files

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

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-05	SPY	ETF	469.28	470.65	466.92	468.53	66390600.0
2021-11-05	QQQ	ETF	400.04	400.99	397.16	398.6	43383802.0
2021-11-05	IWM	ETF	241.17	243.4	240.2	241.81	42041700.0
2021-11-05	DIA	ETF	362.96	364.94	361.89	363.3	4489000.0
2021-11-05	GLD	ETF	168.42	169.94	167.85	169.84	9368900.0
2021-11-05	TLT	ETF	148.52	149.58	148.13	149.3	21513000.0
2021-11-05	AAA	ETF	24.99	25.035	24.99	25.035	1297.0
2021-11-05	AAAU	ETF	17.91	18.07	17.86	18.06	360200.0
2021-11-05	AADR	ETF	65.12	65.22	65.02	65.22	1700.0
2021-11-05	AAXJ	ETF	86.46	86.56	85.73	85.97	505600.0
2021-11-05	ABEQ	ETF	28.14	28.276	28.14	28.276	500.0
2021-11-05	ACES	ETF	80.98	81.15	79.07	80.03	64600.0
2021-11-05	ACIO	ETF	31.9	32.12	31.9	32.05	30900.0
2021-11-05	ACSI	ETF	53.6552	53.6552	53.6552	53.6552	46.0
2021-11-05	ACT	ETF	23.69	23.9141	23.11	23.23	164886.0
2021-11-05	ACTV	ETF	39.78	39.78	39.525	39.598	6628.0
2021-11-05	ACTX	ETF	0.98	0.98	0.98	0.98	1670.0
2021-11-05	ACVF	ETF	35.47	35.535	35.21	35.28	11000.0
2021-11-05	ACWF	ETF	38.765	38.82	38.485	38.5801	6968.0
2021-11-05	ACWI	ETF	107.23	107.36	106.66	107.02	1733500.0
2021-11-05	ACWV	ETF	106.54	106.76	106.19	106.41	136100.0
2021-11-05	ACWX	ETF	57.77	57.77	57.5129	57.75	1021095.0
2021-11-05	ADFI	ETF	9.72	9.725	9.7	9.725	1400.0
2021-11-05	ADIV	ETF	17.68	17.69	17.68	17.68	400.0
2021-11-05	ADME	ETF	42.69	42.7	42.435	42.538	24900.0
2021-11-05	ADRE	ETF	49.885	49.8946	49.355	49.45	5842.0
2021-11-05	AEMB	ETF	49.26	49.26	49.26	49.26	200.0
2021-11-05	AESR	ETF	14.81	14.92	14.81	14.85	6100.0
2021-11-05	AFIF	ETF	9.67	9.68	9.67	9.6752	15834.0
2021-11-05	AFK	ETF	21.65	21.65	21.52	21.58	1415.0
2021-11-05	AFLG	ETF	27.267	27.267	27.267	27.267	100.0
2021-11-05	AFMC	ETF	26.987	27.006	26.987	27.006	400.0
2021-11-05	AFSM	ETF	28.95	28.96	28.739	28.813	16000.0
2021-11-05	AFTY	ETF	20.96	21.017	20.96	21.017	1700.0
2021-11-05	AGG	ETF	114.99	115.32	114.9	115.22	7283100.0
2021-11-05	AGGY	ETF	52.21	52.34	52.145	52.307	123300.0
2021-11-05	AGNG	ETF	30.17	30.53	30.17	30.42	6700.0
2021-11-05	AGOV	ETF	98.675	98.85	98.675	98.74	475.0
2021-11-05	AGOX	ETF	26.26	26.3	26.15	26.24	53900.0
2021-11-05	AGQ	ETF	37.74	38.06	36.94	38.03	780600.0
2021-11-05	AGZ	ETF	118.23	118.51	118.23	118.5	29104.0
2021-11-05	AGZD	ETF	23.4	23.415	23.375	23.4	208400.0
2021-11-05	AIA	ETF	80.26	80.26	79.39	79.62	67777.0
2021-11-05	AIEQ	ETF	44.62	44.703	44.32	44.496	10500.0
2021-11-05	AIQ	ETF	32.89	32.94	32.65	32.68	25157.0
2021-11-05	AIRR	ETF	46.06	46.967	46.06	46.85	17800.0
2021-11-05	AIVI	ETF	41.72	41.8	41.67	41.79	3200.0
2021-11-05	ALTL	ETF	44.64	44.894	44.4547	44.59	47988.0
2021-11-05	ALTY	ETF	13.56	13.67	13.56	13.65	36500.0
2021-11-05	AMJ	ETF	19.13	19.18	18.96	19.14	954356.0

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

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