PREVIEW / etf_daily / 2020-01-31

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-31.parquet
  size:    74 KB
  rows:    1,946

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-01-31	SPY	ETF	327.0	327.17	320.73	321.73	113845600.0
2020-01-31	QQQ	ETF	223.5	223.56	218.285	219.07	52015832.0
2020-01-31	IWM	ETF	163.32	163.92	160.03	160.53	30439000.0
2020-01-31	DIA	ETF	286.96	287.23	281.61	282.42	4885700.0
2020-01-31	GLD	ETF	148.88	149.68	148.81	149.33	14788300.0
2020-01-31	TLT	ETF	145.17	145.99	145.09	145.9	14538100.0
2020-01-31	AAAU	ETF	15.79	15.85	15.79	15.83	80600.0
2020-01-31	AADR	ETF	54.03	54.24	53.65	53.83	5700.0
2020-01-31	AAXJ	ETF	69.29	69.31	68.52	68.87	2805500.0
2020-01-31	ABEQ	ETF	24.595	24.595	24.485	24.513	15900.0
2020-01-31	ACES	ETF	37.1	37.1	36.25	36.403	40900.0
2020-01-31	ACIO	ETF	25.075	25.09	25.05	25.075	6600.0
2020-01-31	ACSI	ETF	36.152	36.152	35.7	35.7298	1225.0
2020-01-31	ACTX	ETF	8.2601	10.6201	7.381	10.0301	206.0
2020-01-31	ACWF	ETF	30.76	30.76	30.341	30.4383	11755.0
2020-01-31	ACWI	ETF	79.11	79.12	77.9	78.11	5488400.0
2020-01-31	ACWV	ETF	97.63	97.81	96.85	97.02	291500.0
2020-01-31	ACWX	ETF	47.69	47.73	47.205	47.44	2627553.0
2020-01-31	ADME	ETF	30.59	30.61	30.49	30.54	4900.0
2020-01-31	ADRE	ETF	42.02	42.02	41.41	41.5017	35479.0
2020-01-31	AESR	ETF	10.14	10.15	10.078	10.096	120300.0
2020-01-31	AFIF	ETF	9.75	9.7701	9.75	9.7701	5228.0
2020-01-31	AFK	ETF	19.51	19.51	19.21	19.24	12542.0
2020-01-31	AFLG	ETF	20.35	20.35	20.347	20.347	900.0
2020-01-31	AFMC	ETF	19.92	19.922	19.92	19.922	200.0
2020-01-31	AFSM	ETF	19.91	19.91	19.693	19.693	200.0
2020-01-31	AFTY	ETF	15.47	15.48	15.36	15.36	14400.0
2020-01-31	AGG	ETF	114.48	114.67	114.38	114.65	5281900.0
2020-01-31	AGGY	ETF	53.18	53.25	53.17	53.2	140800.0
2020-01-31	AGNG	ETF	23.35	23.416	23.25	23.416	3000.0
2020-01-31	AGQ	ETF	31.4	32.18	31.4	31.91	255600.0
2020-01-31	AGZ	ETF	117.33	117.54	117.3214	117.47	24298.0
2020-01-31	AGZD	ETF	23.99	24.04	23.985	24.015	13200.0
2020-01-31	AIA	ETF	62.82	62.82	62.05	62.15	128226.0
2020-01-31	AIEQ	ETF	29.1	29.105	28.562	28.68	16400.0
2020-01-31	AIQ	ETF	18.79	18.79	18.44	18.4427	14421.0
2020-01-31	AIRR	ETF	28.55	28.57	27.94	27.962	20400.0
2020-01-31	AIVI	ETF	41.45	41.45	41.24	41.28	7300.0
2020-01-31	ALTY	ETF	14.89	14.89	14.805	14.805	6200.0
2020-01-31	AMJ	ETF	20.85	20.92	20.5	20.55	3031549.0
2020-01-31	AMLP	ETF	40.45	40.8	39.9	40.1	4928740.0
2020-01-31	AMOM	ETF	26.44	26.44	26.383	26.383	300.0
2020-01-31	AMUB	ETF	12.94	13.16	12.94	12.9624	52098.0
2020-01-31	AMZA	ETF	40.8	40.97	40.0	40.1	95100.0
2020-01-31	ANGL	ETF	30.03	30.04	29.82	29.85	683700.0
2020-01-31	AOA	ETF	57.98	57.98	57.22	57.38	73400.0
2020-01-31	AOK	ETF	36.62	36.62	36.41	36.5	540141.0
2020-01-31	AOM	ETF	40.44	40.44	40.1856	40.21	243454.0
2020-01-31	AOR	ETF	47.85	47.8885	47.5121	47.64	110347.0
2020-01-31	ARCM	ETF	100.19	100.19	100.19	100.19	100.0

> showing 50 of 1,946 rows — these rows as CSV

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