PREVIEW / etf_daily / 2020-08-31

all etf daily files

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

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-31	SPY	ETF	350.35	351.3	349.06	349.31	66099200.0
2020-08-31	QQQ	ETF	293.16	296.745	292.62	294.88	36321027.0
2020-08-31	IWM	ETF	157.19	157.37	155.3	155.43	17051500.0
2020-08-31	DIA	ETF	286.26	286.34	283.89	284.28	4070100.0
2020-08-31	GLD	ETF	184.79	185.53	184.28	184.83	10251200.0
2020-08-31	TLT	ETF	161.6	163.25	161.56	162.19	11388100.0
2020-08-31	AAAU	ETF	19.61	19.68	19.56	19.61	709800.0
2020-08-31	AADR	ETF	56.51	56.79	56.51	56.67	4300.0
2020-08-31	AAXJ	ETF	77.87	78.0	77.18	77.76	3398900.0
2020-08-31	ABEQ	ETF	23.745	23.77	23.7	23.726	3100.0
2020-08-31	ACES	ETF	53.48	53.891	53.23	53.66	48000.0
2020-08-31	ACIO	ETF	27.58	27.58	27.296	27.35	32700.0
2020-08-31	ACSI	ETF	38.6027	38.6027	38.5948	38.5948	491.0
2020-08-31	ACTX	ETF	2.655	2.95	2.655	2.655	4366.0
2020-08-31	ACWF	ETF	30.45	30.5	30.37	30.39	8798.0
2020-08-31	ACWI	ETF	82.56	82.76	82.25	82.35	2273800.0
2020-08-31	ACWV	ETF	92.88	93.27	92.85	93.06	243700.0
2020-08-31	ACWX	ETF	47.1	47.11	46.77	46.85	1214329.0
2020-08-31	ADFI	ETF	10.0	10.0	10.0	10.0	100.0
2020-08-31	ADME	ETF	35.49	35.49	35.1	35.26	27800.0
2020-08-31	ADRE	ETF	47.47	47.47	47.15	47.15	7650.0
2020-08-31	AESR	ETF	11.33	11.41	11.3	11.36	14400.0
2020-08-31	AFIF	ETF	9.81	9.8399	9.81	9.82	18857.0
2020-08-31	AFK	ETF	17.98	17.98	17.7	17.715	6261.0
2020-08-31	AFLG	ETF	21.019	21.019	21.019	21.019	100.0
2020-08-31	AFTY	ETF	19.53	19.622	19.53	19.622	1200.0
2020-08-31	AGG	ETF	118.14	118.51	118.14	118.37	10894500.0
2020-08-31	AGGY	ETF	53.8	53.95	53.79	53.9	181700.0
2020-08-31	AGNG	ETF	25.56	25.85	25.56	25.69	43700.0
2020-08-31	AGQ	ETF	62.63	64.41	62.19	63.51	2110600.0
2020-08-31	AGZ	ETF	121.22	121.27	121.0218	121.26	166309.0
2020-08-31	AGZD	ETF	23.66	23.66	23.48	23.495	8800.0
2020-08-31	AIA	ETF	72.11	72.23	71.38	72.0	381841.0
2020-08-31	AIEQ	ETF	31.58	31.87	31.51	31.866	27400.0
2020-08-31	AIQ	ETF	24.04	24.175	23.9252	24.08	37403.0
2020-08-31	AIRR	ETF	27.06	27.14	26.86	27.05	13500.0
2020-08-31	AIVI	ETF	37.26	37.26	37.12	37.14	3200.0
2020-08-31	ALTL	ETF	25.4992	25.5586	25.4	25.5586	4229.0
2020-08-31	ALTY	ETF	11.09	11.09	10.91	10.93	26300.0
2020-08-31	AMJ	ETF	12.67	12.73	12.46	12.56	533111.0
2020-08-31	AMLP	ETF	23.53	23.53	22.98	23.09	1881700.0
2020-08-31	AMNA	ETF	24.29	24.34	24.2086	24.2086	4400.0
2020-08-31	AMND	ETF	25.68	25.68	25.5105	25.5105	600.0
2020-08-31	AMOM	ETF	36.22	37.32	36.21	37.244	5300.0
2020-08-31	AMUB	ETF	7.89	7.96	7.84	7.8761	108848.0
2020-08-31	AMZA	ETF	17.22	17.22	16.68	16.73	61400.0
2020-08-31	ANGL	ETF	30.52	30.61	30.47	30.47	1403500.0
2020-08-31	AOA	ETF	59.98	59.98	59.36	59.5	57600.0
2020-08-31	AOK	ETF	37.68	37.72	37.5	37.66	487742.0
2020-08-31	AOM	ETF	41.7	41.71	41.58	41.65	113846.0

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

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