PREVIEW / etf_daily / 2021-10-20

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-20.parquet
  size:    95 KB
  rows:    2,537

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-10-20	SPY	ETF	451.13	452.73	451.01	452.41	49571600.0
2021-10-20	QQQ	ETF	375.94	376.565	373.46	374.98	31390338.0
2021-10-20	IWM	ETF	225.97	227.98	225.12	227.37	18130500.0
2021-10-20	DIA	ETF	354.51	356.58	354.37	356.03	2873800.0
2021-10-20	GLD	ETF	166.21	167.11	165.93	166.9	5022000.0
2021-10-20	TLT	ETF	143.25	143.68	142.51	142.73	12782500.0
2021-10-20	AAA	ETF	25.0099	25.0099	25.0	25.0	114.0
2021-10-20	AAAU	ETF	17.69	17.77	17.65	17.76	122100.0
2021-10-20	AADR	ETF	66.29	66.29	66.07	66.24	5200.0
2021-10-20	AAXJ	ETF	88.81	88.91	88.45	88.62	562600.0
2021-10-20	ABEQ	ETF	27.83	27.99	27.82	27.912	5700.0
2021-10-20	ACES	ETF	71.99	72.376	71.46	71.66	136100.0
2021-10-20	ACIO	ETF	31.231	31.35	31.231	31.34	87900.0
2021-10-20	ACSI	ETF	51.8559	51.8559	51.8559	51.8559	51.0
2021-10-20	ACT	ETF	23.05	23.33	22.52	23.15	267332.0
2021-10-20	ACTV	ETF	39.31	39.33	39.14	39.1889	19355.0
2021-10-20	ACTX	ETF	1.0	1.25	1.0	1.2	1341.0
2021-10-20	ACVF	ETF	33.631	33.77	33.631	33.71	11200.0
2021-10-20	ACWF	ETF	38.26	38.29	38.201	38.2337	5063.0
2021-10-20	ACWI	ETF	104.66	104.96	104.61	104.88	1264700.0
2021-10-20	ACWV	ETF	105.25	105.77	105.25	105.62	74600.0
2021-10-20	ACWX	ETF	57.49	57.64	57.4	57.58	503318.0
2021-10-20	ADFI	ETF	9.66	9.66	9.645	9.645	700.0
2021-10-20	ADIV	ETF	17.542	17.542	17.542	17.542	100.0
2021-10-20	ADME	ETF	41.181	41.3	41.181	41.27	55000.0
2021-10-20	ADRE	ETF	52.41	52.41	51.9461	52.05	5101.0
2021-10-20	AESR	ETF	14.34	14.35	14.32	14.32	31700.0
2021-10-20	AFIF	ETF	9.62	9.62	9.59	9.6	176198.0
2021-10-20	AFK	ETF	22.12	22.1893	22.1	22.14	8047.0
2021-10-20	AFLG	ETF	26.54	26.62	26.54	26.62	1000.0
2021-10-20	AFSM	ETF	27.049	27.05	26.934	26.934	800.0
2021-10-20	AFTY	ETF	21.53	21.53	21.408	21.408	12000.0
2021-10-20	AGG	ETF	114.17	114.29	114.06	114.08	6183700.0
2021-10-20	AGGY	ETF	51.73	51.749	51.64	51.655	74800.0
2021-10-20	AGNG	ETF	29.53	29.59	29.485	29.496	3100.0
2021-10-20	AGOV	ETF	99.2833	99.61	99.2833	99.445	900.0
2021-10-20	AGOX	ETF	26.85	27.08	26.85	27.01	24200.0
2021-10-20	AGQ	ETF	37.61	39.01	37.34	38.72	1119700.0
2021-10-20	AGZ	ETF	118.01	118.01	117.91	117.9304	15195.0
2021-10-20	AGZD	ETF	23.475	23.485	23.46	23.46	19400.0
2021-10-20	AIA	ETF	83.27	83.27	82.47	82.6	1773371.0
2021-10-20	AIEQ	ETF	42.96	43.21	42.941	43.137	11800.0
2021-10-20	AIQ	ETF	32.13	32.15	31.94	32.02	20640.0
2021-10-20	AIRR	ETF	42.39	42.87	42.11	42.87	11200.0
2021-10-20	AIVI	ETF	41.64	41.87	41.64	41.83	5200.0
2021-10-20	ALTL	ETF	42.83	43.12	42.7475	43.08	28186.0
2021-10-20	ALTY	ETF	13.59	13.69	13.59	13.665	55800.0
2021-10-20	AMJ	ETF	19.81	20.22	19.76	20.22	472481.0
2021-10-20	AMLP	ETF	36.45	37.21	36.39	37.19	2208200.0
2021-10-20	AMNA	ETF	36.0927	36.0927	36.0927	36.0927	99.0

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

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