PREVIEW / etf_daily / 2020-06-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-18.parquet
  size:    76 KB
  rows:    2,024

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-06-18	SPY	ETF	310.01	312.3	309.51	311.78	80828700.0
2020-06-18	QQQ	ETF	243.29	244.53	242.49	244.28	30578648.0
2020-06-18	IWM	ETF	140.37	143.31	139.81	141.72	26974100.0
2020-06-18	DIA	ETF	260.04	262.26	259.11	261.45	3268700.0
2020-06-18	GLD	ETF	162.2	162.32	161.44	162.24	5397600.0
2020-06-18	TLT	ETF	162.04	162.48	161.61	162.26	7691400.0
2020-06-18	AAAU	ETF	17.27	17.27	17.14	17.23	102200.0
2020-06-18	AADR	ETF	51.07	51.3	50.87	51.01	4000.0
2020-06-18	AAXJ	ETF	68.64	69.06	68.64	68.91	2335100.0
2020-06-18	ABEQ	ETF	22.333	22.42	22.333	22.379	7000.0
2020-06-18	ACES	ETF	38.7	38.7	37.94	38.28	22600.0
2020-06-18	ACIO	ETF	24.92	25.22	24.92	25.138	21600.0
2020-06-18	ACSI	ETF	33.76	33.806	33.76	33.806	472.0
2020-06-18	ACTX	ETF	4.0238	4.0592	3.835	3.835	461.0
2020-06-18	ACWF	ETF	27.8	27.8	27.74	27.7786	4570.0
2020-06-18	ACWI	ETF	73.86	74.32	73.71	74.15	884300.0
2020-06-18	ACWV	ETF	88.07	88.34	87.82	88.28	892000.0
2020-06-18	ACWX	ETF	43.27	43.56	43.24	43.41	787990.0
2020-06-18	ADME	ETF	31.72	32.1	31.72	32.06	11400.0
2020-06-18	ADRE	ETF	40.0	40.241	39.8666	39.8666	2093.0
2020-06-18	AESR	ETF	9.908	9.927	9.903	9.927	500.0
2020-06-18	AFIF	ETF	9.85	9.85	9.8085	9.8199	20484.0
2020-06-18	AFK	ETF	16.25	16.31	16.17	16.185	9394.0
2020-06-18	AFLG	ETF	18.92	18.92	18.92	18.92	200.0
2020-06-18	AFMC	ETF	17.19	17.19	17.094	17.094	100.0
2020-06-18	AFSM	ETF	16.87	16.87	16.73	16.73	300.0
2020-06-18	AFTY	ETF	16.35	16.44	16.35	16.43	1200.0
2020-06-18	AGG	ETF	117.88	117.88	117.64	117.76	3356800.0
2020-06-18	AGGY	ETF	53.72	53.74	53.66	53.72	125100.0
2020-06-18	AGNG	ETF	24.47	24.47	24.442	24.442	400.0
2020-06-18	AGQ	ETF	26.75	26.85	26.33	26.61	190200.0
2020-06-18	AGZ	ETF	120.89	121.74	120.7	120.7	144785.0
2020-06-18	AGZD	ETF	23.49	23.55	23.485	23.485	6400.0
2020-06-18	AIA	ETF	63.56	63.9509	63.56	63.95	56240.0
2020-06-18	AIEQ	ETF	27.61	27.85	27.5	27.85	25400.0
2020-06-18	AIQ	ETF	20.32	20.55	20.32	20.5069	25311.0
2020-06-18	AIRR	ETF	23.52	23.69	23.52	23.585	4400.0
2020-06-18	AIVI	ETF	36.08	36.12	36.03	36.1	5100.0
2020-06-18	ALTY	ETF	11.129	11.35	11.129	11.181	10400.0
2020-06-18	AMJ	ETF	14.72	15.27	14.72	14.87	891255.0
2020-06-18	AMLP	ETF	27.52	28.46	27.32	27.68	6804500.0
2020-06-18	AMOM	ETF	29.222	29.222	29.222	29.222	100.0
2020-06-18	AMUB	ETF	9.53	9.54	9.34	9.3469	11756.0
2020-06-18	AMZA	ETF	20.43	21.18	20.43	20.6	75400.0
2020-06-18	ANGL	ETF	28.98	29.07	28.89	28.96	774100.0
2020-06-18	AOA	ETF	54.82	55.1	54.77	55.06	41400.0
2020-06-18	AOK	ETF	36.22	36.4	36.11	36.4	177763.0
2020-06-18	AOM	ETF	39.75	39.9785	39.75	39.95	68921.0
2020-06-18	AOR	ETF	46.4	46.518	46.335	46.51	209194.0
2020-06-18	APRT	ETF	25.0708	25.0708	25.0708	25.0708	94.0

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

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