PREVIEW / etf_daily / 2021-01-19

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-19.parquet
  size:    85 KB
  rows:    2,245

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
2021-01-19	SPY	ETF	378.34	379.23	376.75	378.65	51233300.0
2021-01-19	QQQ	ETF	314.25	316.93	313.12	316.41	24537049.0
2021-01-19	IWM	ETF	213.34	213.61	211.72	213.45	19744300.0
2021-01-19	DIA	ETF	310.36	310.74	308.6	309.32	2781700.0
2021-01-19	GLD	ETF	172.71	172.85	171.92	172.58	7485700.0
2021-01-19	TLT	ETF	151.62	152.36	151.51	152.31	9575600.0
2021-01-19	AAA	ETF	25.16	25.16	25.149	25.15	2893.0
2021-01-19	AAAU	ETF	18.34	18.35	18.26	18.31	3583100.0
2021-01-19	AADR	ETF	63.23	63.43	62.81	63.43	5400.0
2021-01-19	AAXJ	ETF	97.01	97.1	96.5	96.57	1293200.0
2021-01-19	ABEQ	ETF	25.81	25.95	25.81	25.95	6700.0
2021-01-19	ACES	ETF	94.16	95.5	93.2	95.21	202000.0
2021-01-19	ACIO	ETF	27.2	27.814	27.2	27.73	42900.0
2021-01-19	ACSI	ETF	43.73	43.8913	43.73	43.8913	429.0
2021-01-19	ACTV	ETF	33.31	33.3101	33.19	33.21	5429.0
2021-01-19	ACTX	ETF	3.1	3.5	3.0	3.5	3393.0
2021-01-19	ACVF	ETF	28.15	28.15	27.949	28.094	8200.0
2021-01-19	ACWF	ETF	35.19	35.29	33.8	35.2442	54091.0
2021-01-19	ACWI	ETF	93.02	93.13	92.68	93.03	4114200.0
2021-01-19	ACWV	ETF	97.56	97.7	97.29	97.37	359800.0
2021-01-19	ACWX	ETF	55.21	55.24	54.95	55.11	1949527.0
2021-01-19	ADFI	ETF	9.901	9.901	9.901	9.901	100.0
2021-01-19	ADME	ETF	35.71	35.99	35.71	35.89	46800.0
2021-01-19	ADRE	ETF	61.45	61.62	61.02	61.365	48178.0
2021-01-19	AESR	ETF	11.98	12.024	11.98	12.024	41900.0
2021-01-19	AFIF	ETF	9.767	9.78	9.74	9.765	75801.0
2021-01-19	AFK	ETF	21.36	21.37	21.2615	21.32	19020.0
2021-01-19	AFLG	ETF	22.77	22.83	22.77	22.819	2100.0
2021-01-19	AFMC	ETF	22.68	22.704	22.68	22.704	500.0
2021-01-19	AFSM	ETF	24.078	24.078	24.078	24.078	100.0
2021-01-19	AFTY	ETF	24.04	24.04	23.924	23.933	4400.0
2021-01-19	AGG	ETF	117.27	117.42	117.22	117.41	7601100.0
2021-01-19	AGGY	ETF	53.19	53.31	53.18	53.3	152300.0
2021-01-19	AGNG	ETF	29.21	29.21	28.99	29.07	15800.0
2021-01-19	AGQ	ETF	45.84	46.01	44.93	45.49	1351800.0
2021-01-19	AGZ	ETF	119.32	119.34	119.239	119.31	38940.0
2021-01-19	AGZD	ETF	23.505	23.66	23.505	23.61	19200.0
2021-01-19	AIA	ETF	97.08	97.13	96.5893	96.76	287845.0
2021-01-19	AIEQ	ETF	38.46	38.96	38.46	38.96	23700.0
2021-01-19	AIQ	ETF	27.79	27.98	27.67	27.98	54682.0
2021-01-19	AIRR	ETF	37.26	37.56	37.195	37.334	60400.0
2021-01-19	AIVI	ETF	41.92	41.93	41.8	41.91	3000.0
2021-01-19	ALTL	ETF	34.61	34.7152	34.59	34.62	15738.0
2021-01-19	ALTY	ETF	12.02	12.07	11.96	12.013	24300.0
2021-01-19	AMJ	ETF	15.99	16.05	15.77	15.85	1681849.0
2021-01-19	AMLP	ETF	29.7	29.74	29.13	29.27	3413200.0
2021-01-19	AMNA	ETF	28.0543	28.0543	28.0543	28.0543	5.0
2021-01-19	AMND	ETF	29.7773	29.7773	29.7773	29.7773	0.0
2021-01-19	AMOM	ETF	32.43	32.57	32.39	32.57	1600.0
2021-01-19	AMTR	ETF	32.2317	32.2317	32.2317	32.2317	0.0

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

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