PREVIEW / etf_daily / 2020-09-10

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-10.parquet
  size:    78 KB
  rows:    2,077

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-09-10	SPY	ETF	341.82	342.53	332.85	333.89	90569500.0
2020-09-10	QQQ	ETF	280.97	282.195	270.56	272.34	69667462.0
2020-09-10	IWM	ETF	152.83	153.88	150.06	150.15	23005500.0
2020-09-10	DIA	ETF	281.13	282.17	274.85	275.79	3455800.0
2020-09-10	GLD	ETF	184.23	184.68	182.28	182.46	9143600.0
2020-09-10	TLT	ETF	162.46	164.35	161.95	164.13	8847700.0
2020-09-10	AAA	ETF	25.06	25.07	25.046	25.068	23632.0
2020-09-10	AAAU	ETF	19.54	19.58	19.34	19.36	541400.0
2020-09-10	AADR	ETF	56.22	56.22	54.88	54.88	3000.0
2020-09-10	AAXJ	ETF	76.94	77.05	75.72	75.76	988800.0
2020-09-10	ABEQ	ETF	23.88	24.04	23.702	23.997	33100.0
2020-09-10	ACES	ETF	50.84	51.21	49.79	49.91	52300.0
2020-09-10	ACIO	ETF	26.76	26.795	26.401	26.472	9600.0
2020-09-10	ACSI	ETF	37.921	37.921	36.9316	36.9316	947.0
2020-09-10	ACTX	ETF	2.2479	2.5978	2.2479	2.5512	147.0
2020-09-10	ACWF	ETF	29.803	29.89	29.4477	29.455	4105.0
2020-09-10	ACWI	ETF	81.12	81.3	79.35	79.51	2213000.0
2020-09-10	ACWV	ETF	92.69	92.69	91.27	91.38	208200.0
2020-09-10	ACWX	ETF	46.86	46.95	46.1	46.1	1485659.0
2020-09-10	ADME	ETF	33.67	33.77	33.335	33.429	5300.0
2020-09-10	ADRE	ETF	46.78	47.0094	45.83	45.9144	13069.0
2020-09-10	AESR	ETF	10.92	10.92	10.72	10.78	3900.0
2020-09-10	AFIF	ETF	9.8	9.82	9.8	9.8143	11100.0
2020-09-10	AFK	ETF	17.96	18.376	17.9238	17.99	10621.0
2020-09-10	AFLG	ETF	20.0	20.0	20.0	20.0	100.0
2020-09-10	AFMC	ETF	17.9	17.9	17.671	17.671	100.0
2020-09-10	AFSM	ETF	18.04	18.04	17.756	17.756	100.0
2020-09-10	AFTY	ETF	19.299	19.299	19.057	19.057	5100.0
2020-09-10	AGG	ETF	118.15	118.29	118.02	118.23	4932600.0
2020-09-10	AGGY	ETF	53.91	54.01	53.85	54.01	121100.0
2020-09-10	AGNG	ETF	25.43	25.48	25.033	25.033	2600.0
2020-09-10	AGQ	ETF	59.93	60.06	56.4	56.64	1868500.0
2020-09-10	AGZ	ETF	121.06	121.2	120.95	121.17	42752.0
2020-09-10	AGZD	ETF	23.545	23.565	23.515	23.54	11800.0
2020-09-10	AIA	ETF	71.97	72.01	71.02	71.02	227785.0
2020-09-10	AIEQ	ETF	30.17	30.435	29.47	29.51	12300.0
2020-09-10	AIQ	ETF	23.32	23.4687	22.68	22.8181	30572.0
2020-09-10	AIRR	ETF	26.59	26.59	26.0	26.05	1900.0
2020-09-10	AIVI	ETF	37.22	37.22	36.59	36.59	7200.0
2020-09-10	ALTL	ETF	25.09	25.14	24.7639	24.8165	3236.0
2020-09-10	ALTY	ETF	10.82	10.822	10.64	10.715	9200.0
2020-09-10	AMJ	ETF	11.98	11.98	11.64	11.67	974918.0
2020-09-10	AMLP	ETF	21.98	22.1	21.44	21.44	2064300.0
2020-09-10	AMNA	ETF	23.48	23.56	23.1	23.1019	5400.0
2020-09-10	AMND	ETF	24.32	24.32	24.2234	24.2234	200.0
2020-09-10	AMOM	ETF	35.14	35.15	34.0	34.123	1300.0
2020-09-10	AMUB	ETF	7.47	7.47	7.33	7.338	12330.0
2020-09-10	AMZA	ETF	15.6	15.669	15.041	15.06	218800.0
2020-09-10	ANGL	ETF	30.28	30.35	30.08	30.15	2933600.0
2020-09-10	AOA	ETF	58.71	58.92	57.85	57.85	27300.0

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

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