PREVIEW / etf_daily / 2020-10-05

all etf daily files

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

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-05	SPY	ETF	336.06	339.96	336.01	339.76	45713100.0
2020-10-05	QQQ	ETF	276.34	280.49	276.23	280.16	28184581.0
2020-10-05	IWM	ETF	154.49	157.31	154.48	157.07	18553600.0
2020-10-05	DIA	ETF	278.79	281.59	278.75	281.51	1862500.0
2020-10-05	GLD	ETF	179.02	180.14	178.9	179.41	6969600.0
2020-10-05	TLT	ETF	160.95	160.95	159.52	159.57	14726000.0
2020-10-05	AAA	ETF	24.91	24.94	24.91	24.915	29105.0
2020-10-05	AAAU	ETF	19.0	19.11	18.99	19.04	620800.0
2020-10-05	AADR	ETF	56.2	56.33	56.16	56.33	1100.0
2020-10-05	AAXJ	ETF	77.56	78.06	77.56	78.06	535900.0
2020-10-05	ABEQ	ETF	23.57	23.57	23.54	23.566	19000.0
2020-10-05	ACES	ETF	57.19	58.58	57.19	58.54	56700.0
2020-10-05	ACIO	ETF	26.56	26.775	26.54	26.775	6500.0
2020-10-05	ACSI	ETF	38.2111	38.2111	38.2111	38.2111	303.0
2020-10-05	ACTX	ETF	1.77	2.124	1.77	1.947	415.0
2020-10-05	ACWF	ETF	29.97	30.32	29.97	30.32	10725.0
2020-10-05	ACWI	ETF	80.39	81.25	80.39	81.23	3072500.0
2020-10-05	ACWV	ETF	92.53	93.12	92.53	93.06	361800.0
2020-10-05	ACWX	ETF	46.5	46.83	46.5	46.83	731512.0
2020-10-05	ADME	ETF	33.62	33.88	33.62	33.88	6600.0
2020-10-05	ADRE	ETF	46.97	47.4605	46.97	47.455	19335.0
2020-10-05	AESR	ETF	10.98	11.034	10.98	11.034	29700.0
2020-10-05	AFIF	ETF	9.78	9.82	9.78	9.7899	179187.0
2020-10-05	AFK	ETF	17.38	17.93	17.38	17.52	7966.0
2020-10-05	AFLG	ETF	20.38	20.508	20.38	20.508	900.0
2020-10-05	AFSM	ETF	18.838	18.838	18.838	18.838	100.0
2020-10-05	AFTY	ETF	19.64	19.655	19.6	19.655	1400.0
2020-10-05	AGG	ETF	117.74	117.74	117.52	117.52	4890800.0
2020-10-05	AGGY	ETF	53.72	53.72	53.622	53.65	153900.0
2020-10-05	AGNG	ETF	25.7	26.13	25.7	26.11	6900.0
2020-10-05	AGQ	ETF	44.45	46.5	44.39	45.81	1337200.0
2020-10-05	AGZ	ETF	120.9	120.909	120.79	120.79	27022.0
2020-10-05	AGZD	ETF	23.4	23.425	23.335	23.415	11400.0
2020-10-05	AIA	ETF	72.1	72.74	72.1	72.74	47299.0
2020-10-05	AIEQ	ETF	31.01	31.51	31.01	31.485	10600.0
2020-10-05	AIQ	ETF	23.61	23.88	23.595	23.88	21796.0
2020-10-05	AIRR	ETF	26.51	26.93	26.51	26.93	3700.0
2020-10-05	AIVI	ETF	36.3	36.56	36.3	36.56	7700.0
2020-10-05	ALTL	ETF	25.09	25.26	25.0817	25.2464	2206.0
2020-10-05	ALTY	ETF	10.69	10.69	10.64	10.661	6800.0
2020-10-05	AMJ	ETF	10.96	11.31	10.9299	11.3	1048870.0
2020-10-05	AMLP	ETF	20.3	20.95	20.21	20.9	2760900.0
2020-10-05	AMNA	ETF	22.2258	22.2258	22.2258	22.2258	0.0
2020-10-05	AMND	ETF	23.3533	23.3533	23.3533	23.3533	0.0
2020-10-05	AMOM	ETF	35.6	36.239	35.6	36.239	3800.0
2020-10-05	AMUB	ETF	6.96	7.0976	6.96	7.0976	2264.0
2020-10-05	AMZA	ETF	13.79	14.2	13.598	14.18	115600.0
2020-10-05	ANGL	ETF	29.7	29.88	29.69	29.87	2419100.0
2020-10-05	AOA	ETF	58.17	58.63	58.17	58.63	39700.0
2020-10-05	AOK	ETF	37.22	37.33	37.17	37.33	133038.0

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

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