PREVIEW / etf_daily / 2020-08-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-21.parquet
  size:    78 KB
  rows:    2,052

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
2020-08-21	SPY	ETF	337.92	339.72	337.55	339.48	55106600.0
2020-08-21	QQQ	ETF	280.07	282.34	279.461	281.87	34748934.0
2020-08-21	IWM	ETF	155.15	155.72	153.6	154.61	20685100.0
2020-08-21	DIA	ETF	277.04	279.61	276.86	279.29	2601200.0
2020-08-21	GLD	ETF	182.14	182.81	180.47	182.03	12713700.0
2020-08-21	TLT	ETF	165.77	166.33	165.01	166.2	6836000.0
2020-08-21	AAAU	ETF	19.33	19.38	19.15	19.32	250000.0
2020-08-21	AADR	ETF	55.5	56.31	55.5	56.31	6000.0
2020-08-21	AAXJ	ETF	76.34	77.03	76.16	76.94	524100.0
2020-08-21	ABEQ	ETF	22.91	23.45	22.91	23.4	700.0
2020-08-21	ACES	ETF	51.3	51.84	51.3	51.5	61100.0
2020-08-21	ACIO	ETF	26.78	26.89	26.78	26.89	26800.0
2020-08-21	ACSI	ETF	37.62	37.6774	37.62	37.6774	7185.0
2020-08-21	ACTX	ETF	2.7435	2.7435	2.36	2.36	131.0
2020-08-21	ACWF	ETF	29.99	30.0964	29.99	30.0964	1466.0
2020-08-21	ACWI	ETF	80.17	80.68	80.11	80.62	8077800.0
2020-08-21	ACWV	ETF	92.11	92.39	91.99	92.34	308200.0
2020-08-21	ACWX	ETF	46.21	46.47	46.12	46.45	521039.0
2020-08-21	ADME	ETF	34.26	34.33	34.22	34.27	19200.0
2020-08-21	ADRE	ETF	45.49	45.98	45.49	45.9585	12138.0
2020-08-21	AESR	ETF	10.97	11.014	10.97	11.014	4500.0
2020-08-21	AFIF	ETF	9.851	9.8571	9.82	9.835	16537.0
2020-08-21	AFK	ETF	17.49	17.49	17.4	17.4149	2473.0
2020-08-21	AFTY	ETF	19.07	19.11	19.06	19.074	4400.0
2020-08-21	AGG	ETF	118.74	118.76	118.55	118.68	6373300.0
2020-08-21	AGGY	ETF	54.2	54.24	54.14	54.2	71300.0
2020-08-21	AGNG	ETF	25.43	25.43	25.33	25.351	1800.0
2020-08-21	AGQ	ETF	57.05	57.77	55.03	57.25	2797600.0
2020-08-21	AGZ	ETF	121.4	121.75	121.2024	121.46	33568.0
2020-08-21	AGZD	ETF	23.555	23.595	23.525	23.565	6000.0
2020-08-21	AIA	ETF	71.17	71.87	70.99	71.87	72249.0
2020-08-21	AIEQ	ETF	31.21	31.3	31.11	31.225	25600.0
2020-08-21	AIQ	ETF	22.86	22.91	22.79	22.895	17867.0
2020-08-21	AIRR	ETF	26.616	26.66	26.364	26.521	16300.0
2020-08-21	AIVI	ETF	36.85	36.94	36.74	36.94	4600.0
2020-08-21	ALTL	ETF	25.1439	25.2377	25.09	25.2377	17178.0
2020-08-21	ALTY	ETF	10.93	10.93	10.84	10.866	63700.0
2020-08-21	AMJ	ETF	13.26	13.32	13.15	13.25	751279.0
2020-08-21	AMLP	ETF	23.95	23.99	23.55	23.8	2213100.0
2020-08-21	AMNA	ETF	24.75	24.9067	24.74	24.9067	1500.0
2020-08-21	AMND	ETF	26.24	26.2828	26.24	26.2828	1216.0
2020-08-21	AMOM	ETF	35.45	35.715	35.45	35.66	1700.0
2020-08-21	AMUB	ETF	8.34	8.3591	8.34	8.3591	4004.0
2020-08-21	AMZA	ETF	17.45	17.45	17.076	17.4	69800.0
2020-08-21	ANGL	ETF	30.32	30.34	30.22	30.3	546100.0
2020-08-21	AOA	ETF	58.29	58.49	58.2	58.49	37200.0
2020-08-21	AOK	ETF	37.42	37.47	37.3	37.4	75029.0
2020-08-21	AOM	ETF	41.27	41.34	41.03	41.34	125536.0
2020-08-21	AOR	ETF	48.69	48.78	48.55	48.78	90662.0
2020-08-21	APRT	ETF	26.32	26.32	26.32	26.32	0.0

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

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