PREVIEW / etf_daily / 2020-06-30

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-30.parquet
  size:    77 KB
  rows:    2,032

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-30	SPY	ETF	303.99	310.2	303.82	308.36	113394800.0
2020-06-30	QQQ	ETF	242.77	248.16	242.58	247.6	38909219.0
2020-06-30	IWM	ETF	140.67	143.62	140.59	143.18	32865900.0
2020-06-30	DIA	ETF	255.07	259.05	254.72	257.87	3667900.0
2020-06-30	GLD	ETF	166.31	167.99	166.19	167.37	12762300.0
2020-06-30	TLT	ETF	165.23	165.29	163.48	163.93	14841700.0
2020-06-30	AAAU	ETF	17.65	17.8	17.61	17.78	319100.0
2020-06-30	AADR	ETF	52.66	53.0	52.66	52.99	2100.0
2020-06-30	AAXJ	ETF	69.31	69.45	68.85	69.17	934900.0
2020-06-30	ABEQ	ETF	22.299	22.299	22.299	22.299	600.0
2020-06-30	ACES	ETF	39.85	39.85	38.49	39.1	69600.0
2020-06-30	ACIO	ETF	25.095	25.37	25.095	25.223	2000.0
2020-06-30	ACSI	ETF	33.17	33.4927	33.17	33.4927	279.0
2020-06-30	ACTX	ETF	3.304	3.3335	3.304	3.304	151.0
2020-06-30	ACWF	ETF	27.54	27.8686	27.54	27.8686	10241.0
2020-06-30	ACWI	ETF	73.0	74.08	72.94	73.72	2966800.0
2020-06-30	ACWV	ETF	86.91	87.81	86.91	87.58	290100.0
2020-06-30	ACWX	ETF	43.04	43.35	42.98	43.24	2138150.0
2020-06-30	ADME	ETF	31.68	32.08	31.68	32.066	7600.0
2020-06-30	ADRE	ETF	39.5162	39.62	39.43	39.5605	6466.0
2020-06-30	AESR	ETF	9.86	9.952	9.84	9.952	3900.0
2020-06-30	AFIF	ETF	9.815	9.83	9.8	9.815	7226.0
2020-06-30	AFK	ETF	16.1835	16.415	16.1835	16.4	1859.0
2020-06-30	AFLG	ETF	18.65	18.864	18.65	18.864	600.0
2020-06-30	AFMC	ETF	16.73	16.928	16.73	16.928	300.0
2020-06-30	AFSM	ETF	16.58	16.83	16.58	16.83	300.0
2020-06-30	AFTY	ETF	16.773	16.773	16.773	16.773	100.0
2020-06-30	AGG	ETF	118.28	118.32	117.98	118.21	7451100.0
2020-06-30	AGGY	ETF	53.83	53.83	53.71	53.82	112300.0
2020-06-30	AGNG	ETF	24.378	24.46	24.378	24.454	500.0
2020-06-30	AGQ	ETF	28.01	29.62	27.98	29.33	1399300.0
2020-06-30	AGZ	ETF	121.17	121.17	120.96	121.1	30455.0
2020-06-30	AGZD	ETF	23.5	23.57	23.45	23.515	5400.0
2020-06-30	AIA	ETF	65.05	65.2	64.7	64.9	63446.0
2020-06-30	AIEQ	ETF	27.845	28.22	27.771	28.16	7100.0
2020-06-30	AIQ	ETF	20.28	20.6635	20.28	20.6635	9565.0
2020-06-30	AIRR	ETF	23.95	24.237	23.81	24.22	7300.0
2020-06-30	AIVI	ETF	35.3	35.53	35.3	35.53	5200.0
2020-06-30	ALTL	ETF	23.99	24.3572	23.99	24.3572	11609.0
2020-06-30	ALTY	ETF	10.67	10.8	10.666	10.78	9200.0
2020-06-30	AMJ	ETF	13.04	13.31	12.88	13.2	632766.0
2020-06-30	AMLP	ETF	24.17	24.73	23.89	24.68	2585000.0
2020-06-30	AMNA	ETF	23.17	23.9224	23.07	23.9224	25600.0
2020-06-30	AMOM	ETF	29.39	29.861	29.37	29.861	1000.0
2020-06-30	AMUB	ETF	8.12	8.345	8.12	8.345	26027.0
2020-06-30	AMZA	ETF	16.91	17.5	16.83	17.4	101000.0
2020-06-30	ANGL	ETF	28.53	28.73	28.4	28.7	1665800.0
2020-06-30	AOA	ETF	54.35	54.96	54.3	54.88	42300.0
2020-06-30	AOK	ETF	36.28	36.42	36.21	36.41	189992.0
2020-06-30	AOM	ETF	39.76	39.97	39.6401	39.87	348210.0

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

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