PREVIEW / etf_daily / 2020-05-22

all etf daily files

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

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-22	SPY	ETF	294.57	295.63	293.22	295.44	63958200.0
2020-05-22	QQQ	ETF	228.46	229.87	227.5	229.66	28762389.0
2020-05-22	IWM	ETF	134.67	135.05	133.02	134.89	24035200.0
2020-05-22	DIA	ETF	244.91	245.1	243.17	244.88	2521100.0
2020-05-22	GLD	ETF	162.88	163.47	162.74	163.21	8540900.0
2020-05-22	TLT	ETF	164.72	165.68	164.61	165.55	4956700.0
2020-05-22	AAAU	ETF	17.28	17.33	17.26	17.3	202300.0
2020-05-22	AADR	ETF	46.94	47.24	46.94	47.03	4900.0
2020-05-22	AAXJ	ETF	63.19	63.19	62.58	62.72	693900.0
2020-05-22	ABEQ	ETF	21.789	21.93	21.789	21.921	14300.0
2020-05-22	ACES	ETF	35.01	35.41	34.66	34.85	27800.0
2020-05-22	ACIO	ETF	24.22	24.3	24.22	24.3	43600.0
2020-05-22	ACSI	ETF	31.38	31.38	31.3746	31.3746	2562.0
2020-05-22	ACTX	ETF	4.13	5.605	4.13	4.897	339.0
2020-05-22	ACWF	ETF	26.66	26.66	26.511	26.65	5115.0
2020-05-22	ACWI	ETF	69.59	69.79	69.28	69.79	4058400.0
2020-05-22	ACWV	ETF	85.96	86.15	85.73	86.09	186100.0
2020-05-22	ACWX	ETF	40.11	40.19	39.94	40.19	1604822.0
2020-05-22	ADME	ETF	31.24	31.33	31.24	31.304	6500.0
2020-05-22	ADRE	ETF	35.68	35.68	35.2141	35.3221	8908.0
2020-05-22	AFIF	ETF	9.82	9.8202	9.79	9.8202	832.0
2020-05-22	AFK	ETF	15.16	15.33	15.06	15.16	8999.0
2020-05-22	AFLG	ETF	18.031	18.031	18.031	18.031	100.0
2020-05-22	AFMC	ETF	16.26	16.274	16.26	16.274	1000.0
2020-05-22	AFSM	ETF	15.95	15.965	15.95	15.965	500.0
2020-05-22	AFTY	ETF	15.44	15.544	15.38	15.51	13600.0
2020-05-22	AGG	ETF	117.6	117.6	117.39	117.44	2794000.0
2020-05-22	AGGY	ETF	53.39	53.43	53.33	53.42	140800.0
2020-05-22	AGNG	ETF	23.56	23.63	23.463	23.495	8800.0
2020-05-22	AGQ	ETF	27.15	27.61	27.01	27.3	422000.0
2020-05-22	AGZ	ETF	121.13	121.16	120.9889	121.15	27048.0
2020-05-22	AGZD	ETF	23.295	23.355	23.26	23.3	4000.0
2020-05-22	AIA	ETF	57.95	57.98	57.5	57.65	162006.0
2020-05-22	AIEQ	ETF	26.94	27.1	26.849	27.097	13300.0
2020-05-22	AIQ	ETF	18.94	19.11	18.87	19.02	18909.0
2020-05-22	AIRR	ETF	22.01	22.01	21.73	21.85	2100.0
2020-05-22	AIVI	ETF	33.18	33.31	33.14	33.26	4000.0
2020-05-22	ALTY	ETF	10.375	10.44	10.345	10.431	7400.0
2020-05-22	AMJ	ETF	14.32	14.6	14.12	14.56	1017700.0
2020-05-22	AMLP	ETF	26.06	26.45	25.58	26.44	2169100.0
2020-05-22	AMOM	ETF	27.875	27.875	27.861	27.861	200.0
2020-05-22	AMUB	ETF	8.85	9.18	8.85	9.1683	3668.0
2020-05-22	AMZA	ETF	19.62	19.75	18.89	19.73	42400.0
2020-05-22	ANGL	ETF	27.47	27.63	27.37	27.5	832000.0
2020-05-22	AOA	ETF	51.86	51.97	51.64	51.97	83200.0
2020-05-22	AOK	ETF	35.44	35.44	35.3073	35.43	41240.0
2020-05-22	AOM	ETF	38.48	38.631	38.35	38.61	244272.0
2020-05-22	AOR	ETF	44.26	44.38	44.14	44.35	100465.0
2020-05-22	ARB	ETF	24.21	24.4	24.2	24.3838	2454.0
2020-05-22	ARCM	ETF	100.67	100.67	100.67	100.67	100.0

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

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