PREVIEW / etf_daily / 2020-10-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-28.parquet
  size:    80 KB
  rows:    2,131

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-10-28	SPY	ETF	332.1	338.25	326.13	326.66	127094300.0
2020-10-28	QQQ	ETF	278.13	278.6401	271.38	271.64	53413523.0
2020-10-28	IWM	ETF	154.66	155.44	153.04	153.31	32338700.0
2020-10-28	DIA	ETF	269.0	270.75	265.02	265.48	5815200.0
2020-10-28	GLD	ETF	176.45	176.85	175.44	176.13	11734100.0
2020-10-28	TLT	ETF	161.38	161.46	160.2	160.7	11765800.0
2020-10-28	AAA	ETF	24.95	24.962	24.95	24.955	1305.0
2020-10-28	AAAU	ETF	18.73	18.77	18.62	18.7	977000.0
2020-10-28	AADR	ETF	53.86	53.87	53.36	53.64	51300.0
2020-10-28	AAXJ	ETF	79.38	79.46	78.67	78.76	1472700.0
2020-10-28	ABEQ	ETF	22.91	23.0	22.91	22.93	5100.0
2020-10-28	ACES	ETF	55.66	56.78	55.55	56.08	59100.0
2020-10-28	ACIO	ETF	26.32	26.369	26.23	26.28	42800.0
2020-10-28	ACSI	ETF	37.5284	37.5284	37.5284	37.5284	104.0
2020-10-28	ACTV	ETF	24.13	24.34	24.06	24.07	612539.0
2020-10-28	ACTX	ETF	2.85	2.85	2.01	2.05	743.0
2020-10-28	ACWF	ETF	29.4421	29.4421	29.19	29.19	10238.0
2020-10-28	ACWI	ETF	79.25	79.37	78.12	78.2	6290500.0
2020-10-28	ACWV	ETF	90.55	90.9	89.56	89.56	320800.0
2020-10-28	ACWX	ETF	45.49	45.51	45.06	45.1	2466484.0
2020-10-28	ADFI	ETF	9.95	9.95	9.95	9.95	100.0
2020-10-28	ADME	ETF	33.41	33.43	33.25	33.26	33300.0
2020-10-28	ADRE	ETF	49.17	49.17	48.5526	48.75	5532.0
2020-10-28	AESR	ETF	10.82	10.82	10.648	10.648	600.0
2020-10-28	AFIF	ETF	9.7808	9.7808	9.76	9.775	2712.0
2020-10-28	AFK	ETF	17.9	17.9	17.381	17.5136	7739.0
2020-10-28	AFLG	ETF	20.07	20.07	19.713	19.713	500.0
2020-10-28	AFMC	ETF	18.1	18.1	17.951	17.951	400.0
2020-10-28	AFTY	ETF	20.082	20.165	20.082	20.125	6800.0
2020-10-28	AGG	ETF	117.81	117.96	117.72	117.73	7329200.0
2020-10-28	AGGY	ETF	53.67	53.7	53.55	53.55	82400.0
2020-10-28	AGNG	ETF	25.15	25.15	24.82	24.86	6300.0
2020-10-28	AGQ	ETF	41.81	42.03	40.17	41.63	2433800.0
2020-10-28	AGZ	ETF	121.03	121.03	120.9	120.9	43491.0
2020-10-28	AGZD	ETF	23.485	23.485	23.425	23.425	24000.0
2020-10-28	AIA	ETF	75.15	75.165	74.53	74.59	219814.0
2020-10-28	AIEQ	ETF	30.88	30.88	30.33	30.51	19700.0
2020-10-28	AIQ	ETF	23.79	23.79	23.33	23.3859	59561.0
2020-10-28	AIRR	ETF	26.415	26.415	26.315	26.316	1900.0
2020-10-28	AIVI	ETF	34.67	34.67	34.35	34.35	5600.0
2020-10-28	ALTL	ETF	24.82	24.82	24.4394	24.4394	3992.0
2020-10-28	ALTY	ETF	10.51	10.51	10.36	10.36	11700.0
2020-10-28	AMJ	ETF	11.46	11.46	11.03	11.14	1120293.0
2020-10-28	AMLP	ETF	21.09	21.14	20.42	20.69	3533400.0
2020-10-28	AMNA	ETF	21.36	21.36	21.0588	21.0588	1400.0
2020-10-28	AMND	ETF	22.53	22.53	22.2694	22.2694	1300.0
2020-10-28	AMOM	ETF	35.279	35.279	35.279	35.279	200.0
2020-10-28	AMTR	ETF	24.13	24.14	23.65	23.67	58200.0
2020-10-28	AMUB	ETF	7.13	7.13	6.93	7.0252	11252.0
2020-10-28	AMZA	ETF	14.25	14.25	13.477	13.7	135900.0

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

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