PREVIEW / etf_daily / 2020-07-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-17.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-07-17	SPY	ETF	321.88	322.57	319.74	321.72	62774900.0
2020-07-17	QQQ	ETF	259.71	260.31	257.17	259.42	35137871.0
2020-07-17	IWM	ETF	146.68	147.59	145.51	146.59	20644100.0
2020-07-17	DIA	ETF	267.95	268.07	266.17	266.74	3415100.0
2020-07-17	GLD	ETF	169.94	170.27	169.61	170.12	10296000.0
2020-07-17	TLT	ETF	167.27	167.4	166.47	166.78	8549900.0
2020-07-17	AAAU	ETF	18.01	18.06	18.0	18.05	196800.0
2020-07-17	AADR	ETF	56.43	56.86	56.42	56.74	3500.0
2020-07-17	AAXJ	ETF	74.02	74.12	73.6	73.94	936500.0
2020-07-17	ABEQ	ETF	22.871	22.871	22.8	22.851	3100.0
2020-07-17	ACES	ETF	45.38	45.79	45.135	45.71	39700.0
2020-07-17	ACIO	ETF	25.72	25.82	25.66	25.758	2600.0
2020-07-17	ACSI	ETF	34.9264	34.9264	34.9264	34.9264	122.0
2020-07-17	ACTX	ETF	2.36	3.127	2.3305	3.127	1136.0
2020-07-17	ACWF	ETF	29.07	29.1802	29.04	29.1802	19181.0
2020-07-17	ACWI	ETF	77.28	77.38	76.84	77.26	4161900.0
2020-07-17	ACWV	ETF	90.05	90.69	90.01	90.62	558500.0
2020-07-17	ACWX	ETF	45.29	45.39	45.14	45.39	2224704.0
2020-07-17	ADME	ETF	32.897	33.2	32.897	33.096	5100.0
2020-07-17	ADRE	ETF	43.33	43.3916	43.22	43.2764	1876.0
2020-07-17	AESR	ETF	10.33	10.375	10.32	10.375	4800.0
2020-07-17	AFIF	ETF	9.82	9.85	9.82	9.835	114028.0
2020-07-17	AFK	ETF	17.42	17.5	17.23	17.28	16009.0
2020-07-17	AFLG	ETF	19.631	19.631	19.631	19.631	100.0
2020-07-17	AFMC	ETF	17.52	17.52	17.52	17.52	100.0
2020-07-17	AFSM	ETF	17.337	17.337	17.337	17.337	100.0
2020-07-17	AFTY	ETF	18.7	18.7	18.58	18.68	3800.0
2020-07-17	AGG	ETF	118.94	118.99	118.77	118.88	2549100.0
2020-07-17	AGGY	ETF	54.33	54.33	54.21	54.26	114000.0
2020-07-17	AGNG	ETF	25.33	25.58	25.33	25.57	3200.0
2020-07-17	AGQ	ETF	32.89	33.2	32.57	33.07	792200.0
2020-07-17	AGZ	ETF	121.06	121.27	121.06	121.14	29176.0
2020-07-17	AGZD	ETF	23.625	23.625	23.625	23.625	1400.0
2020-07-17	AIA	ETF	68.62	68.67	68.41	68.52	32169.0
2020-07-17	AIEQ	ETF	29.5	29.72	29.33	29.7	9200.0
2020-07-17	AIQ	ETF	21.48	21.56	21.29	21.46	16554.0
2020-07-17	AIRR	ETF	24.37	24.602	24.36	24.38	13800.0
2020-07-17	AIVI	ETF	36.7	36.9	36.7	36.88	15300.0
2020-07-17	ALTL	ETF	24.81	24.81	24.7554	24.7554	708.0
2020-07-17	ALTY	ETF	10.67	10.67	10.58	10.595	3600.0
2020-07-17	AMJ	ETF	12.9	13.18	12.71	12.74	678214.0
2020-07-17	AMLP	ETF	23.89	24.43	23.56	23.65	4442800.0
2020-07-17	AMNA	ETF	23.7623	23.7623	23.7623	23.7623	0.0
2020-07-17	AMND	ETF	24.9335	24.9335	24.9335	24.9335	143.0
2020-07-17	AMOM	ETF	31.5	31.84	31.34	31.75	2900.0
2020-07-17	AMUB	ETF	8.06	8.091	8.02	8.02	2941.0
2020-07-17	AMZA	ETF	16.976	17.45	16.8	16.81	45000.0
2020-07-17	ANGL	ETF	29.5	29.58	29.39	29.53	3097500.0
2020-07-17	AOA	ETF	56.54	56.8	56.29	56.55	33000.0
2020-07-17	AOK	ETF	36.97	37.0	36.865	36.99	65364.0

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

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