PREVIEW / etf_daily / 2021-08-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-26.parquet
  size:    92 KB
  rows:    2,442

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-08-26	SPY	ETF	448.61	448.86	446.16	446.26	57829600.0
2021-08-26	QQQ	ETF	373.92	374.62	371.97	372.42	29133325.0
2021-08-26	IWM	ETF	222.14	223.16	219.74	220.2	22380300.0
2021-08-26	DIA	ETF	354.47	355.0	352.07	352.16	3008900.0
2021-08-26	GLD	ETF	167.21	168.21	166.83	167.67	4371900.0
2021-08-26	TLT	ETF	147.97	148.57	147.51	148.45	16657400.0
2021-08-26	AAA	ETF	25.03	25.03	25.015	25.015	133.0
2021-08-26	AAAU	ETF	17.79	17.87	17.74	17.83	170800.0
2021-08-26	AADR	ETF	68.0	68.0	67.71	67.83	1100.0
2021-08-26	AAXJ	ETF	86.81	86.81	86.29	86.3	1025700.0
2021-08-26	ABEQ	ETF	27.78	27.78	27.715	27.72	3300.0
2021-08-26	ACES	ETF	70.12	70.89	69.485	69.58	26700.0
2021-08-26	ACIO	ETF	30.901	30.94	30.86	30.87	28600.0
2021-08-26	ACSI	ETF	51.0548	51.0548	51.0548	51.0548	38.0
2021-08-26	ACTV	ETF	38.1	38.1	37.7299	37.7299	2957.0
2021-08-26	ACTX	ETF	1.5	1.5	1.5	1.5	339.0
2021-08-26	ACVF	ETF	33.49	33.49	33.15	33.163	28000.0
2021-08-26	ACWF	ETF	38.65	38.65	38.4594	38.4594	7730.0
2021-08-26	ACWI	ETF	103.41	103.53	102.95	102.99	3598100.0
2021-08-26	ACWV	ETF	106.14	106.14	105.73	105.78	67700.0
2021-08-26	ACWX	ETF	56.76	56.8	56.53	56.6	1738615.0
2021-08-26	ADFI	ETF	9.71	9.75	9.71	9.72	1800.0
2021-08-26	ADIV	ETF	17.929	17.929	17.929	17.929	1400.0
2021-08-26	ADME	ETF	40.915	41.0	40.865	40.882	29600.0
2021-08-26	ADRE	ETF	51.5	51.56	51.135	51.3199	4539.0
2021-08-26	AEMB	ETF	49.89	49.89	49.89	49.89	100.0
2021-08-26	AESR	ETF	14.16	14.19	14.149	14.149	7800.0
2021-08-26	AFIF	ETF	9.68	9.69	9.675	9.6798	8473.0
2021-08-26	AFK	ETF	21.63	21.63	21.51	21.51	1817.0
2021-08-26	AFLG	ETF	26.55	26.55	26.451	26.451	3200.0
2021-08-26	AFMC	ETF	25.94	25.94	25.799	25.799	1900.0
2021-08-26	AFSM	ETF	26.28	26.28	26.112	26.112	1900.0
2021-08-26	AFTY	ETF	19.9	19.9	19.897	19.897	400.0
2021-08-26	AGG	ETF	115.76	115.79	115.64	115.78	4879200.0
2021-08-26	AGGY	ETF	52.39	52.44	52.36	52.42	71600.0
2021-08-26	AGNG	ETF	30.72	30.736	30.591	30.591	1200.0
2021-08-26	AGOV	ETF	100.035	100.14	100.0342	100.055	4835.0
2021-08-26	AGOX	ETF	26.65	26.65	26.285	26.39	23000.0
2021-08-26	AGQ	ETF	37.0	37.26	36.3	36.72	716200.0
2021-08-26	AGZ	ETF	118.88	119.05	118.88	118.96	433600.0
2021-08-26	AGZD	ETF	23.375	23.45	23.375	23.38	14600.0
2021-08-26	AIA	ETF	81.49	81.62	81.1801	81.25	55752.0
2021-08-26	AIEQ	ETF	42.27	42.4	42.18	42.18	6300.0
2021-08-26	AIQ	ETF	31.25	31.35	31.06	31.1	8383.0
2021-08-26	AIRR	ETF	41.913	42.07	41.65	41.65	14500.0
2021-08-26	AIVI	ETF	43.02	43.02	42.87	42.87	3400.0
2021-08-26	ALTL	ETF	43.3	43.3	42.9999	43.08	33074.0
2021-08-26	ALTY	ETF	13.69	13.749	13.61	13.65	32800.0
2021-08-26	AMJ	ETF	17.64	17.74	17.3	17.3	372935.0
2021-08-26	AMLP	ETF	32.56	32.67	31.85	31.88	1658200.0

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

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