PREVIEW / etf_daily / 2020-05-26

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-26.parquet
  size:    75 KB
  rows:    1,996

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-05-26	SPY	ETF	301.93	302.19	295.46	299.08	88951400.0
2020-05-26	QQQ	ETF	233.44	233.57	228.79	229.04	33055346.0
2020-05-26	IWM	ETF	140.09	140.38	134.99	138.78	36971000.0
2020-05-26	DIA	ETF	250.84	252.02	249.88	250.25	4872300.0
2020-05-26	GLD	ETF	162.58	162.58	160.69	160.89	13972000.0
2020-05-26	TLT	ETF	163.71	163.79	162.98	163.33	8098900.0
2020-05-26	AAAU	ETF	17.26	17.26	17.04	17.05	559900.0
2020-05-26	AADR	ETF	48.59	48.59	48.26	48.28	2700.0
2020-05-26	AAXJ	ETF	64.4	64.61	63.8	63.9	1188600.0
2020-05-26	ABEQ	ETF	22.21	22.32	22.2	22.305	18100.0
2020-05-26	ACES	ETF	35.81	36.866	35.7	35.85	27800.0
2020-05-26	ACIO	ETF	24.38	24.47	24.302	24.302	3800.0
2020-05-26	ACSI	ETF	32.23	32.23	32.1234	32.1234	1083.0
2020-05-26	ACTX	ETF	4.2185	5.2481	4.1743	5.0463	864.0
2020-05-26	ACWF	ETF	27.28	27.36	27.1	27.1	15183.0
2020-05-26	ACWI	ETF	71.52	71.62	70.97	71.1	6089400.0
2020-05-26	ACWV	ETF	87.72	87.72	86.88	86.94	371300.0
2020-05-26	ACWX	ETF	41.37	41.5	41.21	41.22	2191860.0
2020-05-26	ADME	ETF	31.63	31.63	31.278	31.278	4700.0
2020-05-26	ADRE	ETF	36.38	36.597	36.195	36.195	5562.0
2020-05-26	AESR	ETF	9.54	9.61	9.51	9.519	56400.0
2020-05-26	AFIF	ETF	9.81	9.84	9.8	9.81	155895.0
2020-05-26	AFK	ETF	15.16	15.49	15.11	15.23	19357.0
2020-05-26	AFLG	ETF	18.27	18.27	18.27	18.27	200.0
2020-05-26	AFMC	ETF	16.797	16.797	16.797	16.797	100.0
2020-05-26	AFTY	ETF	15.7	15.77	15.589	15.589	10100.0
2020-05-26	AGG	ETF	117.38	117.44	117.24	117.25	6164700.0
2020-05-26	AGGY	ETF	53.3	53.302	53.19	53.19	85500.0
2020-05-26	AGNG	ETF	24.16	24.16	23.586	23.586	4600.0
2020-05-26	AGQ	ETF	28.36	28.41	26.77	27.03	473200.0
2020-05-26	AGZ	ETF	121.04	122.02	120.891	121.07	64606.0
2020-05-26	AGZD	ETF	23.285	23.33	23.2	23.33	10200.0
2020-05-26	AIA	ETF	59.35	59.485	58.78	58.94	58043.0
2020-05-26	AIEQ	ETF	27.63	27.63	26.845	26.845	38800.0
2020-05-26	AIQ	ETF	19.65	19.65	19.0201	19.06	29229.0
2020-05-26	AIRR	ETF	22.68	23.19	22.68	23.146	9200.0
2020-05-26	AIVI	ETF	34.11	34.17	34.03	34.03	29700.0
2020-05-26	ALTY	ETF	10.78	10.81	10.68	10.745	12900.0
2020-05-26	AMJ	ETF	14.91	15.05	14.81	14.92	1055292.0
2020-05-26	AMLP	ETF	27.14	27.32	26.82	27.06	3073500.0
2020-05-26	AMOM	ETF	27.9	27.9	27.589	27.589	1100.0
2020-05-26	AMUB	ETF	9.37	9.46	9.31	9.3913	97750.0
2020-05-26	AMZA	ETF	20.57	20.712	20.03	20.55	152100.0
2020-05-26	ANGL	ETF	27.72	28.02	27.6	27.86	1737100.0
2020-05-26	AOA	ETF	52.96	53.1	52.75	52.76	117800.0
2020-05-26	AOK	ETF	35.58	35.7121	35.52	35.66	208107.0
2020-05-26	AOM	ETF	39.0	39.02	38.87	38.9	296758.0
2020-05-26	AOR	ETF	45.01	45.1	44.87	44.94	153335.0
2020-05-26	ARB	ETF	24.45	24.52	24.42	24.5193	1404.0
2020-05-26	ARCM	ETF	100.485	100.485	100.485	100.485	200.0

> showing 50 of 1,996 rows — these rows as CSV

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