PREVIEW / etf_daily / 2021-05-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-05-28.parquet
  size:    89 KB
  rows:    2,340

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-05-28	SPY	ETF	420.97	421.25	419.79	420.04	58520200.0
2021-05-28	QQQ	ETF	334.12	335.5699	333.6	333.93	29927449.0
2021-05-28	IWM	ETF	227.08	227.18	225.05	225.5	20668400.0
2021-05-28	DIA	ETF	346.38	346.48	345.35	345.64	2641400.0
2021-05-28	GLD	ETF	177.46	178.43	177.24	178.38	9967000.0
2021-05-28	TLT	ETF	138.58	139.3	138.34	138.44	10258000.0
2021-05-28	AAA	ETF	25.015	25.02	25.005	25.005	3428.0
2021-05-28	AAAU	ETF	18.87	18.96	18.84	18.95	409000.0
2021-05-28	AADR	ETF	66.17	66.47	66.17	66.29	2300.0
2021-05-28	AAXJ	ETF	94.08	94.59	94.01	94.33	847400.0
2021-05-28	ABEQ	ETF	28.29	28.32	28.26	28.31	2300.0
2021-05-28	ACES	ETF	70.2	70.49	69.01	69.17	267600.0
2021-05-28	ACIO	ETF	30.04	30.04	29.78	29.8	17400.0
2021-05-28	ACSI	ETF	49.1132	49.1132	49.1132	49.1132	424.0
2021-05-28	ACTV	ETF	39.0	39.0	38.62	38.8041	9604.0
2021-05-28	ACVF	ETF	31.4	31.46	31.363	31.363	1000.0
2021-05-28	ACWF	ETF	38.45	38.489	38.395	38.42	16786.0
2021-05-28	ACWI	ETF	100.7	100.93	100.6	100.65	1943200.0
2021-05-28	ACWV	ETF	103.04	103.55	103.04	103.45	84700.0
2021-05-28	ACWX	ETF	58.22	58.52	58.22	58.34	965420.0
2021-05-28	ADFI	ETF	9.699	9.73	9.69	9.69	1200.0
2021-05-28	ADIV	ETF	19.0	19.072	19.0	19.03	1000.0
2021-05-28	ADME	ETF	39.13	39.13	38.75	38.75	7400.0
2021-05-28	ADRE	ETF	56.09	56.7986	56.09	56.79	7650.0
2021-05-28	AESR	ETF	13.32	13.38	13.32	13.321	21800.0
2021-05-28	AFIF	ETF	9.71	9.73	9.7	9.71	134811.0
2021-05-28	AFK	ETF	22.35	22.68	22.35	22.58	14788.0
2021-05-28	AFLG	ETF	25.14	25.14	25.078	25.078	600.0
2021-05-28	AFSM	ETF	26.145	26.145	26.145	26.145	100.0
2021-05-28	AFTY	ETF	24.46	24.611	24.46	24.611	5200.0
2021-05-28	AGG	ETF	114.55	114.68	114.5	114.55	6768200.0
2021-05-28	AGGY	ETF	51.7	51.79	51.66	51.66	107000.0
2021-05-28	AGNG	ETF	29.15	29.311	29.15	29.189	4600.0
2021-05-28	AGOX	ETF	25.85	25.87	25.786	25.786	10300.0
2021-05-28	AGQ	ETF	52.12	53.46	52.08	53.33	690700.0
2021-05-28	AGZ	ETF	118.24	118.39	118.24	118.34	40718.0
2021-05-28	AGZD	ETF	23.46	23.51	23.46	23.485	18200.0
2021-05-28	AIA	ETF	90.94	91.571	90.94	91.31	128511.0
2021-05-28	AIEQ	ETF	38.24	38.24	38.06	38.063	9600.0
2021-05-28	AIQ	ETF	28.88	29.099	28.88	28.97	40934.0
2021-05-28	AIRR	ETF	41.73	41.904	41.26	41.76	36900.0
2021-05-28	AIVI	ETF	44.41	44.44	44.36	44.36	5200.0
2021-05-28	ALTL	ETF	41.28	41.41	41.27	41.27	19492.0
2021-05-28	ALTY	ETF	13.57	13.57	13.441	13.49	21800.0
2021-05-28	AMJ	ETF	19.03	19.03	18.58	18.63	776713.0
2021-05-28	AMLP	ETF	34.66	34.66	34.12	34.34	2749900.0
2021-05-28	AMNA	ETF	33.0918	33.0918	33.0918	33.0918	0.0
2021-05-28	AMND	ETF	35.0189	35.0189	35.0189	35.0189	0.0
2021-05-28	AMOM	ETF	35.26	35.45	35.26	35.29	11200.0
2021-05-28	AMPS	ETF	9.72	9.82	9.72	9.75	25898.0

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

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