PREVIEW / etf_daily / 2020-07-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-21.parquet
  size:    77 KB
  rows:    2,045

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-07-21	SPY	ETF	326.45	326.93	323.94	325.01	57292200.0
2020-07-21	QQQ	ETF	268.41	268.41	263.125	264.0	43442967.0
2020-07-21	IWM	ETF	147.47	149.16	147.2	148.03	24503800.0
2020-07-21	DIA	ETF	268.82	270.27	267.65	268.34	3173200.0
2020-07-21	GLD	ETF	172.53	173.25	172.31	173.0	12826100.0
2020-07-21	TLT	ETF	167.3	167.72	167.08	167.29	8454400.0
2020-07-21	AAAU	ETF	18.31	18.38	18.28	18.36	396700.0
2020-07-21	AADR	ETF	58.53	58.53	57.67	57.85	10500.0
2020-07-21	AAXJ	ETF	75.98	75.98	75.39	75.39	896300.0
2020-07-21	ABEQ	ETF	23.05	23.1	22.88	22.937	15600.0
2020-07-21	ACES	ETF	47.6	47.6	46.09	46.22	64200.0
2020-07-21	ACIO	ETF	25.979	26.02	25.895	25.895	194400.0
2020-07-21	ACSI	ETF	35.26	35.26	35.1754	35.1754	872.0
2020-07-21	ACTX	ETF	2.3866	2.95	2.36	2.95	70.0
2020-07-21	ACWF	ETF	29.51	29.59	29.35	29.35	22482.0
2020-07-21	ACWI	ETF	78.56	78.65	78.04	78.18	2770400.0
2020-07-21	ACWV	ETF	91.0	91.31	90.76	90.94	324000.0
2020-07-21	ACWX	ETF	46.08	46.2	45.91	45.95	1723979.0
2020-07-21	ADME	ETF	33.61	33.65	33.5	33.5	170100.0
2020-07-21	ADRE	ETF	44.92	45.0153	44.725	44.725	7247.0
2020-07-21	AESR	ETF	10.52	10.55	10.469	10.469	139700.0
2020-07-21	AFIF	ETF	9.82	9.88	9.82	9.835	325593.0
2020-07-21	AFK	ETF	17.5	17.5516	17.35	17.45	11874.0
2020-07-21	AFLG	ETF	19.746	19.746	19.746	19.746	100.0
2020-07-21	AFMC	ETF	17.7	17.7	17.618	17.618	1000.0
2020-07-21	AFSM	ETF	17.469	17.469	17.469	17.469	100.0
2020-07-21	AFTY	ETF	18.94	19.03	18.94	18.991	1500.0
2020-07-21	AGG	ETF	119.1	119.1	119.01	119.08	6098200.0
2020-07-21	AGGY	ETF	54.38	54.38	54.32	54.38	110700.0
2020-07-21	AGNG	ETF	25.918	26.01	25.7	25.78	303700.0
2020-07-21	AGQ	ETF	38.6	39.79	38.25	39.21	2809800.0
2020-07-21	AGZ	ETF	121.37	121.43	121.26	121.41	38852.0
2020-07-21	AGZD	ETF	23.625	23.625	23.615	23.625	7600.0
2020-07-21	AIA	ETF	70.49	70.51	70.005	70.07	56618.0
2020-07-21	AIEQ	ETF	30.07	30.19	30.02	30.03	24500.0
2020-07-21	AIQ	ETF	22.3	22.43	21.96	21.995	562192.0
2020-07-21	AIRR	ETF	24.72	24.895	24.68	24.714	27500.0
2020-07-21	AIVI	ETF	37.07	37.24	37.04	37.04	6900.0
2020-07-21	ALTL	ETF	25.31	25.32	25.1366	25.1366	7755.0
2020-07-21	ALTY	ETF	10.58	10.74	10.58	10.71	8000.0
2020-07-21	AMJ	ETF	13.07	13.47	12.95	13.36	928234.0
2020-07-21	AMLP	ETF	23.88	25.05	23.88	24.92	4665600.0
2020-07-21	AMNA	ETF	24.2594	24.2594	24.2594	24.2594	1.0
2020-07-21	AMND	ETF	25.6236	25.6236	25.6236	25.6236	0.0
2020-07-21	AMOM	ETF	33.093	33.26	32.45	32.476	1600.0
2020-07-21	AMUB	ETF	8.355	8.4326	8.355	8.4326	4762.0
2020-07-21	AMZA	ETF	16.93	17.95	16.93	17.83	87900.0
2020-07-21	ANGL	ETF	29.88	29.92	29.75	29.88	647100.0
2020-07-21	AOA	ETF	57.08	57.36	57.01	57.01	57800.0
2020-07-21	AOK	ETF	37.2	37.22	37.1	37.12	128574.0

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

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