PREVIEW / etf_daily / 2020-08-06

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-06.parquet
  size:    78 KB
  rows:    2,064

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-08-06	SPY	ETF	331.48	334.46	331.13	334.33	43679400.0
2020-08-06	QQQ	ETF	270.78	274.98	270.19	274.64	28048224.0
2020-08-06	IWM	ETF	153.8	154.44	152.91	153.73	18237700.0
2020-08-06	DIA	ETF	271.63	274.03	271.57	273.9	1948100.0
2020-08-06	GLD	ETF	193.74	194.45	192.52	193.89	20640100.0
2020-08-06	TLT	ETF	171.38	172.25	170.62	171.02	9481800.0
2020-08-06	AAAU	ETF	20.53	20.63	20.43	20.57	770300.0
2020-08-06	AADR	ETF	59.1	59.1	58.48	58.7	2400.0
2020-08-06	AAXJ	ETF	77.13	77.59	76.86	77.59	1478000.0
2020-08-06	ABEQ	ETF	23.365	23.365	23.306	23.306	400.0
2020-08-06	ACES	ETF	51.0	51.0	48.61	48.61	106500.0
2020-08-06	ACIO	ETF	26.38	26.53	26.3	26.53	8700.0
2020-08-06	ACSI	ETF	36.7	36.8387	36.671	36.8387	1842.0
2020-08-06	ACTX	ETF	2.9429	3.0828	2.3895	2.95	1719.0
2020-08-06	ACWF	ETF	29.95	29.95	29.8	29.9397	3767.0
2020-08-06	ACWI	ETF	79.21	79.76	79.07	79.72	4961400.0
2020-08-06	ACWV	ETF	91.63	91.71	91.26	91.67	363700.0
2020-08-06	ACWX	ETF	46.13	46.38	45.99	46.37	1078411.0
2020-08-06	ADME	ETF	34.08	34.29	33.96	34.29	4800.0
2020-08-06	ADRE	ETF	47.0	47.0	46.41	46.525	4489.0
2020-08-06	AESR	ETF	10.72	10.804	10.72	10.804	800.0
2020-08-06	AFIF	ETF	9.895	9.9	9.8811	9.9	1686.0
2020-08-06	AFK	ETF	17.4	17.66	17.285	17.3384	3685.0
2020-08-06	AFLG	ETF	20.17	20.227	20.17	20.227	600.0
2020-08-06	AFMC	ETF	18.19	18.227	18.19	18.227	100.0
2020-08-06	AFTY	ETF	19.0	19.08	18.96	19.052	2300.0
2020-08-06	AGG	ETF	119.62	119.73	119.53	119.57	4608600.0
2020-08-06	AGGY	ETF	54.7	54.74	54.65	54.71	76700.0
2020-08-06	AGNG	ETF	25.59	25.59	25.42	25.523	13400.0
2020-08-06	AGQ	ETF	66.47	69.43	64.41	69.3	5135900.0
2020-08-06	AGZ	ETF	121.71	121.72	121.6	121.72	31621.0
2020-08-06	AGZD	ETF	23.65	23.675	23.58	23.63	11200.0
2020-08-06	AIA	ETF	72.17	72.5	72.0	72.47	70587.0
2020-08-06	AIEQ	ETF	30.9	31.046	30.8	30.935	21000.0
2020-08-06	AIQ	ETF	22.8	22.99	22.6883	22.99	16347.0
2020-08-06	AIRR	ETF	26.41	26.5	26.41	26.47	1100.0
2020-08-06	AIVI	ETF	36.74	36.9	36.64	36.9	5100.0
2020-08-06	ALTL	ETF	24.875	24.9708	24.855	24.9708	1212.0
2020-08-06	ALTY	ETF	10.88	10.955	10.87	10.928	6700.0
2020-08-06	AMJ	ETF	13.45	13.71	13.41	13.64	1323595.0
2020-08-06	AMLP	ETF	25.0	25.44	24.88	25.34	2658000.0
2020-08-06	AMNA	ETF	24.98	24.98	24.953	24.953	250.0
2020-08-06	AMND	ETF	26.3752	26.3752	26.3752	26.3752	0.0
2020-08-06	AMOM	ETF	35.23	35.23	34.695	34.789	5900.0
2020-08-06	AMUB	ETF	8.455	8.63	8.45	8.5775	14645.0
2020-08-06	AMZA	ETF	17.98	18.46	17.93	18.32	83500.0
2020-08-06	ANGL	ETF	30.57	30.73	30.56	30.69	847400.0
2020-08-06	AOA	ETF	57.72	58.13	57.72	58.11	34100.0
2020-08-06	AOK	ETF	37.36	37.546	37.36	37.53	62076.0
2020-08-06	AOM	ETF	41.12	41.32	41.12	41.3	113220.0

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

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