PREVIEW / etf_daily / 2020-11-03

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-03.parquet
  size:    80 KB
  rows:    2,130

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-11-03	SPY	ETF	333.69	338.25	330.29	336.03	93294200.0
2020-11-03	QQQ	ETF	271.86	276.82	270.84	274.65	43604145.0
2020-11-03	IWM	ETF	158.43	161.23	158.06	160.24	30257400.0
2020-11-03	DIA	ETF	272.66	276.43	272.2	274.65	4343000.0
2020-11-03	GLD	ETF	178.95	179.39	178.3	178.92	7577200.0
2020-11-03	TLT	ETF	157.85	157.98	157.04	157.66	16228700.0
2020-11-03	AAA	ETF	24.89	24.89	24.89	24.89	103.0
2020-11-03	AAAU	ETF	18.98	19.04	18.94	18.99	771000.0
2020-11-03	AADR	ETF	55.42	55.6	55.12	55.6	5300.0
2020-11-03	AAXJ	ETF	79.7	80.2	79.36	79.92	896900.0
2020-11-03	ABEQ	ETF	23.64	23.68	23.55	23.611	12700.0
2020-11-03	ACES	ETF	58.45	59.18	58.08	58.53	99400.0
2020-11-03	ACIO	ETF	26.455	26.75	26.455	26.58	30800.0
2020-11-03	ACSI	ETF	38.702	38.702	38.702	38.702	103.0
2020-11-03	ACTV	ETF	25.17	25.36	25.12	25.12	474724.0
2020-11-03	ACTX	ETF	2.94	2.94	2.94	2.94	339.0
2020-11-03	ACVF	ETF	24.99	24.99	24.88	24.989	2200.0
2020-11-03	ACWF	ETF	29.88	30.21	29.88	30.1597	3099.0
2020-11-03	ACWI	ETF	79.95	80.84	79.81	80.45	3304100.0
2020-11-03	ACWV	ETF	91.5	92.45	91.49	92.0	300500.0
2020-11-03	ACWX	ETF	46.27	46.6	46.17	46.47	1448693.0
2020-11-03	ADME	ETF	33.43	33.805	33.43	33.728	62000.0
2020-11-03	ADRE	ETF	48.97	49.65	48.961	49.562	28957.0
2020-11-03	AESR	ETF	10.77	10.88	10.77	10.879	900.0
2020-11-03	AFIF	ETF	9.785	9.785	9.77	9.78	5560.0
2020-11-03	AFK	ETF	18.03	18.29	17.89	18.14	5316.0
2020-11-03	AFLG	ETF	20.15	20.34	20.15	20.316	2600.0
2020-11-03	AFMC	ETF	18.6	18.701	18.6	18.701	600.0
2020-11-03	AFSM	ETF	18.75	18.891	18.75	18.891	600.0
2020-11-03	AFTY	ETF	20.47	20.575	20.47	20.575	3500.0
2020-11-03	AGG	ETF	117.22	117.22	117.05	117.17	7519700.0
2020-11-03	AGGY	ETF	53.35	53.42	53.32	53.35	202100.0
2020-11-03	AGNG	ETF	25.07	25.28	25.07	25.28	1500.0
2020-11-03	AGQ	ETF	44.99	45.08	43.98	44.2	1107100.0
2020-11-03	AGZ	ETF	120.66	120.68	120.55	120.62	47321.0
2020-11-03	AGZD	ETF	23.54	23.54	23.4	23.445	12800.0
2020-11-03	AIA	ETF	76.15	76.45	75.795	76.28	389591.0
2020-11-03	AIEQ	ETF	30.11	30.62	30.01	30.531	11400.0
2020-11-03	AIQ	ETF	23.39	23.72	23.39	23.68	8397.0
2020-11-03	AIRR	ETF	27.74	28.03	27.74	28.015	6500.0
2020-11-03	AIVI	ETF	35.52	35.71	35.51	35.68	4200.0
2020-11-03	ALTL	ETF	25.13	25.1856	24.99	25.1856	9022.0
2020-11-03	ALTY	ETF	10.593	10.66	10.583	10.66	6100.0
2020-11-03	AMJ	ETF	11.44	11.651	11.38	11.59	1162208.0
2020-11-03	AMLP	ETF	21.27	21.61	21.08	21.15	2920100.0
2020-11-03	AMNA	ETF	21.46	21.56	21.46	21.5082	3200.0
2020-11-03	AMND	ETF	22.86	22.92	22.71	22.7717	1230.0
2020-11-03	AMOM	ETF	35.25	36.0	35.248	36.0	5100.0
2020-11-03	AMTR	ETF	24.22	24.23	24.15	24.1907	1999.0
2020-11-03	AMUB	ETF	7.27	7.28	7.2035	7.2035	2271.0

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

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