PREVIEW / etf_daily / 2021-01-20

all etf daily files

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

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-20	SPY	ETF	381.11	384.79	380.69	383.89	61836100.0
2021-01-20	QQQ	ETF	320.14	324.74	316.509	323.77	30728096.0
2021-01-20	IWM	ETF	214.36	215.98	213.07	214.39	25474200.0
2021-01-20	DIA	ETF	310.43	312.34	309.94	311.77	2398400.0
2021-01-20	GLD	ETF	174.37	175.47	173.82	175.39	9456000.0
2021-01-20	TLT	ETF	151.99	152.48	151.79	152.46	5368900.0
2021-01-20	AAA	ETF	25.15	25.15	25.15	25.15	33.0
2021-01-20	AAAU	ETF	18.52	18.63	18.46	18.63	355500.0
2021-01-20	AADR	ETF	63.73	64.42	63.53	64.41	4400.0
2021-01-20	AAXJ	ETF	98.39	98.62	97.94	98.57	1155400.0
2021-01-20	ABEQ	ETF	26.0	26.06	25.89	25.946	57900.0
2021-01-20	ACES	ETF	96.16	96.235	93.52	94.71	174400.0
2021-01-20	ACIO	ETF	27.96	28.05	27.93	28.035	98300.0
2021-01-20	ACSI	ETF	44.3951	44.6038	44.3951	44.6038	1342.0
2021-01-20	ACTV	ETF	33.56	33.56	33.395	33.56	5970.0
2021-01-20	ACTX	ETF	3.1	3.5	3.1	3.3	1320.0
2021-01-20	ACVF	ETF	28.34	28.54	28.32	28.511	7500.0
2021-01-20	ACWF	ETF	35.45	35.56	35.39	35.5587	3280.0
2021-01-20	ACWI	ETF	93.69	94.3	93.56	94.19	2434800.0
2021-01-20	ACWV	ETF	97.64	98.05	97.35	97.96	621600.0
2021-01-20	ACWX	ETF	55.48	55.7	55.36	55.69	654566.0
2021-01-20	ADFI	ETF	9.901	9.901	9.901	9.901	100.0
2021-01-20	ADME	ETF	36.36	36.56	36.16	36.48	83200.0
2021-01-20	ADRE	ETF	63.21	63.21	62.015	62.49	37205.0
2021-01-20	AESR	ETF	12.17	12.193	12.15	12.193	23900.0
2021-01-20	AFIF	ETF	9.76	9.78	9.75	9.765	142894.0
2021-01-20	AFK	ETF	21.41	21.709	21.41	21.6	26176.0
2021-01-20	AFLG	ETF	23.03	23.105	23.03	23.105	1000.0
2021-01-20	AFMC	ETF	22.91	22.92	22.9	22.92	400.0
2021-01-20	AFTY	ETF	24.1	24.1	24.03	24.087	4500.0
2021-01-20	AGG	ETF	117.35	117.43	117.31	117.42	6229100.0
2021-01-20	AGGY	ETF	53.23	53.35	53.23	53.31	206500.0
2021-01-20	AGNG	ETF	29.36	29.365	29.261	29.365	3900.0
2021-01-20	AGQ	ETF	46.54	48.15	46.41	47.99	1339200.0
2021-01-20	AGZ	ETF	119.31	119.35	119.29	119.3	88798.0
2021-01-20	AGZD	ETF	23.655	23.675	23.605	23.61	9400.0
2021-01-20	AIA	ETF	98.18	98.59	97.95	98.55	463438.0
2021-01-20	AIEQ	ETF	39.44	39.44	38.88	39.2	67500.0
2021-01-20	AIQ	ETF	28.39	28.67	28.39	28.64	41109.0
2021-01-20	AIRR	ETF	37.48	37.54	37.09	37.44	23400.0
2021-01-20	AIVI	ETF	42.08	42.28	42.08	42.21	23000.0
2021-01-20	ALTL	ETF	34.81	34.81	34.59	34.66	7092.0
2021-01-20	ALTY	ETF	12.04	12.09	12.02	12.075	8100.0
2021-01-20	AMJ	ETF	15.96	16.0	15.58	15.63	562832.0
2021-01-20	AMLP	ETF	29.54	29.6	28.76	28.91	3116100.0
2021-01-20	AMNA	ETF	27.9135	27.9135	27.9135	27.9135	3.0
2021-01-20	AMND	ETF	29.5501	29.5501	29.5501	29.5501	3.0
2021-01-20	AMOM	ETF	32.57	32.57	32.507	32.507	600.0
2021-01-20	AMTR	ETF	32.0698	32.0698	32.0698	32.0698	2.0
2021-01-20	AMUB	ETF	9.96	9.96	9.83	9.8406	42887.0

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

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