PREVIEW / etf_daily / 2021-01-29

all etf daily files

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

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-29	SPY	ETF	375.63	376.67	368.27	370.07	126765100.0
2021-01-29	QQQ	ETF	319.58	320.7193	312.76	314.56	55259018.0
2021-01-29	IWM	ETF	209.73	210.99	204.84	205.56	40591900.0
2021-01-29	DIA	ETF	303.92	304.78	298.59	299.81	5929900.0
2021-01-29	GLD	ETF	174.87	175.16	172.61	172.61	11252800.0
2021-01-29	TLT	ETF	151.42	152.49	151.3	152.0	14965900.0
2021-01-29	AAA	ETF	25.16	25.16	25.145	25.145	3101.0
2021-01-29	AAAU	ETF	18.56	18.59	18.35	18.35	616300.0
2021-01-29	AADR	ETF	60.8	60.87	59.75	60.16	6100.0
2021-01-29	AAXJ	ETF	94.05	94.46	93.15	93.52	1113700.0
2021-01-29	ABEQ	ETF	25.92	25.92	25.24	25.339	11300.0
2021-01-29	ACES	ETF	93.84	94.87	90.95	91.62	185300.0
2021-01-29	ACIO	ETF	27.32	27.38	27.1	27.15	26100.0
2021-01-29	ACSI	ETF	43.1391	43.1391	42.65	42.8622	8888.0
2021-01-29	ACTV	ETF	33.09	33.35	32.63	32.726	38109.0
2021-01-29	ACTX	ETF	4.6	4.6	4.6	4.6	712.0
2021-01-29	ACVF	ETF	27.97	27.97	27.357	27.548	9400.0
2021-01-29	ACWF	ETF	34.32	34.32	33.8257	33.94	2115.0
2021-01-29	ACWI	ETF	91.44	91.75	89.97	90.44	5009100.0
2021-01-29	ACWV	ETF	95.98	96.35	95.0	95.24	304900.0
2021-01-29	ACWX	ETF	53.64	53.81	52.95	53.19	1075113.0
2021-01-29	ADFI	ETF	9.92	9.92	9.88	9.88	200.0
2021-01-29	ADME	ETF	36.18	36.18	35.39	35.46	17700.0
2021-01-29	ADRE	ETF	59.69	60.05	58.8	59.13	22510.0
2021-01-29	AESR	ETF	11.65	11.756	11.65	11.756	17900.0
2021-01-29	AFIF	ETF	9.7378	9.76	9.7101	9.7351	233821.0
2021-01-29	AFK	ETF	20.97	20.97	19.795	20.04	274748.0
2021-01-29	AFLG	ETF	22.42	22.42	22.23	22.393	5800.0
2021-01-29	AFMC	ETF	21.917	21.917	21.917	21.917	100.0
2021-01-29	AFSM	ETF	23.79	23.79	23.329	23.329	200.0
2021-01-29	AFTY	ETF	24.06	24.12	24.0	24.034	17800.0
2021-01-29	AGG	ETF	117.16	117.4	116.56	117.31	12164800.0
2021-01-29	AGGY	ETF	53.17	53.26	53.13	53.18	127800.0
2021-01-29	AGNG	ETF	28.47	28.485	27.978	28.202	7400.0
2021-01-29	AGQ	ETF	53.25	53.91	51.0	51.81	3037300.0
2021-01-29	AGZ	ETF	119.45	119.5253	119.4146	119.48	27802.0
2021-01-29	AGZD	ETF	23.61	23.655	23.58	23.645	7600.0
2021-01-29	AIA	ETF	94.29	94.4	93.26	93.67	292211.0
2021-01-29	AIEQ	ETF	39.21	39.3	38.047	38.57	110200.0
2021-01-29	AIQ	ETF	28.0	28.06	27.48	27.65	64107.0
2021-01-29	AIRR	ETF	35.43	35.43	34.525	34.61	73300.0
2021-01-29	AIVI	ETF	41.1	41.12	40.65	40.72	35400.0
2021-01-29	ALTL	ETF	32.5	32.5	31.72	31.72	3852.0
2021-01-29	ALTY	ETF	11.88	11.936	11.78	11.85	24100.0
2021-01-29	AMJ	ETF	14.85	14.99	14.5308	14.71	787455.0
2021-01-29	AMLP	ETF	27.25	27.65	26.81	27.05	3082000.0
2021-01-29	AMNA	ETF	26.167	26.167	26.167	26.167	0.0
2021-01-29	AMND	ETF	27.8485	27.8485	27.8485	27.8485	0.0
2021-01-29	AMOM	ETF	31.89	32.004	31.58	31.58	6000.0
2021-01-29	AMTR	ETF	30.0676	30.0676	30.0676	30.0676	5.0

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

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