PREVIEW / etf_daily / 2020-10-30

all etf daily files

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

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-30	SPY	ETF	328.28	329.69	322.6	326.54	120287300.0
2020-10-30	QQQ	ETF	274.375	275.24	267.07	269.38	65935893.0
2020-10-30	IWM	ETF	154.32	155.28	151.39	153.09	31764500.0
2020-10-30	DIA	ETF	265.03	266.32	261.41	265.06	5271200.0
2020-10-30	GLD	ETF	177.18	177.36	175.95	176.2	7303000.0
2020-10-30	TLT	ETF	159.03	159.35	157.57	157.57	13095400.0
2020-10-30	AAA	ETF	24.9523	24.9523	24.94	24.95	1557.0
2020-10-30	AAAU	ETF	18.82	18.83	18.68	18.71	390500.0
2020-10-30	AADR	ETF	53.8	53.8	52.85	53.35	11900.0
2020-10-30	AAXJ	ETF	79.03	79.1	78.25	78.6	1481800.0
2020-10-30	ABEQ	ETF	22.97	23.1	22.97	23.1	1300.0
2020-10-30	ACES	ETF	56.06	56.325	54.27	55.21	63600.0
2020-10-30	ACIO	ETF	26.37	26.37	25.964	26.15	31100.0
2020-10-30	ACSI	ETF	37.3663	37.3663	37.3663	37.3663	147.0
2020-10-30	ACTV	ETF	24.5099	24.76	24.11	24.2321	18358.0
2020-10-30	ACTX	ETF	2.0	2.5	2.0	2.4	1462.0
2020-10-30	ACVF	ETF	24.04	24.435	24.04	24.435	100.0
2020-10-30	ACWF	ETF	29.01	29.0206	28.9165	29.0206	3844.0
2020-10-30	ACWI	ETF	78.39	78.63	77.34	78.14	11588400.0
2020-10-30	ACWV	ETF	89.27	89.68	88.71	89.46	529700.0
2020-10-30	ACWX	ETF	45.13	45.1699	44.73	45.05	1450814.0
2020-10-30	ADME	ETF	33.221	33.221	32.769	33.06	14200.0
2020-10-30	ADRE	ETF	48.76	48.76	48.1529	48.4199	32617.0
2020-10-30	AESR	ETF	10.65	10.65	10.51	10.53	8400.0
2020-10-30	AFIF	ETF	9.7699	9.77	9.74	9.75	7945.0
2020-10-30	AFK	ETF	17.68	17.7422	17.5719	17.67	8329.0
2020-10-30	AFLG	ETF	19.818	19.818	19.59	19.59	300.0
2020-10-30	AFMC	ETF	17.91	17.91	17.91	17.91	200.0
2020-10-30	AFSM	ETF	17.967	17.967	17.967	17.967	100.0
2020-10-30	AFTY	ETF	20.282	20.298	20.241	20.278	3000.0
2020-10-30	AGG	ETF	117.45	117.52	117.2	117.2	10610000.0
2020-10-30	AGGY	ETF	53.46	53.46	53.28	53.28	69400.0
2020-10-30	AGNG	ETF	24.7	24.7	24.36	24.49	5100.0
2020-10-30	AGQ	ETF	42.8	43.02	41.74	42.49	1055800.0
2020-10-30	AGZ	ETF	120.83	120.83	120.6701	120.73	30628.0
2020-10-30	AGZD	ETF	23.495	23.495	23.38	23.4	11000.0
2020-10-30	AIA	ETF	74.76	74.77	74.0209	74.26	103617.0
2020-10-30	AIEQ	ETF	30.28	30.44	29.394	29.69	21200.0
2020-10-30	AIQ	ETF	23.59	23.59	22.98	23.11	28528.0
2020-10-30	AIRR	ETF	26.51	26.73	26.39	26.54	9100.0
2020-10-30	AIVI	ETF	34.3	34.3	34.05	34.23	6400.0
2020-10-30	ALTL	ETF	24.12	24.24	24.12	24.2367	13904.0
2020-10-30	ALTY	ETF	10.36	10.406	10.25	10.318	8100.0
2020-10-30	AMJ	ETF	11.3	11.33	11.04	11.33	782065.0
2020-10-30	AMLP	ETF	20.89	21.01	20.48	20.86	2517700.0
2020-10-30	AMNA	ETF	20.95	21.2046	20.95	21.2046	300.0
2020-10-30	AMND	ETF	22.04	22.3705	22.03	22.3705	1700.0
2020-10-30	AMOM	ETF	35.22	35.22	34.18	34.344	3300.0
2020-10-30	AMTR	ETF	23.5	23.8459	23.5	23.8459	2300.0
2020-10-30	AMUB	ETF	6.86	7.0801	6.86	7.08	29785.0

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

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