PREVIEW / etf_daily / 2020-06-19

all etf daily files

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

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-19	SPY	ETF	314.17	314.38	306.53	308.64	135549600.0
2020-06-19	QQQ	ETF	246.74	247.0	242.45	244.24	49422112.0
2020-06-19	IWM	ETF	144.42	144.51	139.84	140.99	50293800.0
2020-06-19	DIA	ETF	264.21	264.46	257.61	258.8	5852600.0
2020-06-19	GLD	ETF	162.87	164.09	162.78	164.03	12187400.0
2020-06-19	TLT	ETF	161.0	162.5	160.91	162.39	8565500.0
2020-06-19	AAAU	ETF	17.27	17.4	17.26	17.4	153800.0
2020-06-19	AADR	ETF	51.71	52.18	51.71	52.05	4700.0
2020-06-19	AAXJ	ETF	69.69	69.69	68.59	68.7	1041700.0
2020-06-19	ABEQ	ETF	22.489	22.489	22.359	22.359	13500.0
2020-06-19	ACES	ETF	39.0	39.0	38.06	38.15	35400.0
2020-06-19	ACIO	ETF	25.096	25.28	25.096	25.185	11600.0
2020-06-19	ACSI	ETF	34.12	34.1704	33.443	33.443	1059.0
2020-06-19	ACTX	ETF	3.894	4.248	3.835	4.248	577.0
2020-06-19	ACWF	ETF	28.0936	28.0936	27.6416	27.7817	9545.0
2020-06-19	ACWI	ETF	75.03	75.03	73.57	73.73	1516600.0
2020-06-19	ACWV	ETF	89.18	89.18	87.71	87.73	270500.0
2020-06-19	ACWX	ETF	43.94	43.94	43.2	43.26	2265271.0
2020-06-19	ADME	ETF	32.347	32.347	31.911	32.03	23700.0
2020-06-19	ADRE	ETF	40.34	40.34	40.0	40.0507	1400.0
2020-06-19	AESR	ETF	10.03	10.03	9.911	9.911	5500.0
2020-06-19	AFIF	ETF	9.8189	9.8297	9.78	9.815	22821.0
2020-06-19	AFK	ETF	16.38	16.4715	16.01	16.27	12617.0
2020-06-19	AFLG	ETF	18.874	18.874	18.874	18.874	200.0
2020-06-19	AFMC	ETF	17.2	17.2	17.027	17.027	100.0
2020-06-19	AFSM	ETF	16.84	16.84	16.656	16.656	100.0
2020-06-19	AFTY	ETF	16.532	16.532	16.45	16.45	1700.0
2020-06-19	AGG	ETF	117.8	117.97	117.74	117.8	2917400.0
2020-06-19	AGGY	ETF	53.72	53.76	53.681	53.75	137800.0
2020-06-19	AGNG	ETF	24.5	24.651	24.487	24.651	1000.0
2020-06-19	AGQ	ETF	27.56	28.23	27.47	27.82	394700.0
2020-06-19	AGZ	ETF	120.92	121.01	120.74	120.88	80668.0
2020-06-19	AGZD	ETF	23.545	23.605	23.49	23.55	24200.0
2020-06-19	AIA	ETF	64.5	64.5	63.53	63.6	51750.0
2020-06-19	AIEQ	ETF	28.04	28.129	27.75	27.82	24000.0
2020-06-19	AIQ	ETF	20.81	20.81	20.42	20.53	13409.0
2020-06-19	AIRR	ETF	23.9	23.9	23.38	23.579	15800.0
2020-06-19	AIVI	ETF	36.42	36.42	35.95	35.97	6100.0
2020-06-19	ALTY	ETF	11.29	11.309	11.07	11.07	9400.0
2020-06-19	AMJ	ETF	15.1	15.29	14.52	14.52	857485.0
2020-06-19	AMLP	ETF	28.22	28.45	27.07	27.13	3269400.0
2020-06-19	AMOM	ETF	29.294	29.294	29.294	29.294	500.0
2020-06-19	AMUB	ETF	9.58	9.58	9.1823	9.1823	25243.0
2020-06-19	AMZA	ETF	21.24	21.53	20.319	20.36	34600.0
2020-06-19	ANGL	ETF	29.03	29.18	28.88	28.99	504700.0
2020-06-19	AOA	ETF	55.52	55.52	54.68	54.89	39000.0
2020-06-19	AOK	ETF	36.43	36.55	36.25	36.36	222828.0
2020-06-19	AOM	ETF	40.04	40.15	39.75	39.89	128310.0
2020-06-19	AOR	ETF	46.71	46.81	46.2061	46.38	137767.0
2020-06-19	APRW	ETF	24.9305	24.9305	24.9305	24.9305	2.0

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

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