PREVIEW / etf_daily / 2020-12-31

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-31.parquet
  size:    82 KB
  rows:    2,204

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-12-31	SPY	ETF	371.78	374.66	371.23	373.88	78520700.0
2020-12-31	QQQ	ETF	312.87	314.24	311.76	313.74	21611412.0
2020-12-31	IWM	ETF	196.62	196.84	194.62	196.06	24747700.0
2020-12-31	DIA	ETF	304.0	306.29	303.35	305.79	2797000.0
2020-12-31	GLD	ETF	178.07	178.4	177.32	178.36	7540800.0
2020-12-31	TLT	ETF	157.46	158.08	157.45	157.73	7742100.0
2020-12-31	AAA	ETF	25.07	25.07	25.07	25.07	88.0
2020-12-31	AAAU	ETF	18.89	18.94	18.83	18.94	282500.0
2020-12-31	AADR	ETF	61.09	61.09	60.61	60.89	6500.0
2020-12-31	AAXJ	ETF	90.11	90.12	89.11	89.61	950700.0
2020-12-31	ABEQ	ETF	25.46	25.46	25.443	25.443	100.0
2020-12-31	ACES	ETF	80.15	80.54	79.32	80.15	111600.0
2020-12-31	ACIO	ETF	28.14	28.14	27.56	27.82	36100.0
2020-12-31	ACSI	ETF	43.08	43.2319	43.063	43.2319	1071.0
2020-12-31	ACTV	ETF	31.37	31.45	31.365	31.38	9270.0
2020-12-31	ACTX	ETF	2.2	2.425	2.2	2.25	784.0
2020-12-31	ACVF	ETF	27.7	27.831	27.6	27.831	2800.0
2020-12-31	ACWF	ETF	33.5	33.67	33.49	33.6639	32698.0
2020-12-31	ACWI	ETF	90.63	90.82	90.32	90.72	4451900.0
2020-12-31	ACWV	ETF	96.45	96.99	96.21	96.91	158700.0
2020-12-31	ACWX	ETF	53.39	53.41	52.93	53.04	1422502.0
2020-12-31	ADFI	ETF	9.974	9.974	9.974	9.974	100.0
2020-12-31	ADME	ETF	35.785	36.07	35.72	36.07	23100.0
2020-12-31	ADRE	ETF	56.89	56.89	56.1027	56.3063	16288.0
2020-12-31	AESR	ETF	11.828	11.918	11.828	11.918	500.0
2020-12-31	AFIF	ETF	9.794	9.8	9.7841	9.7841	14268.0
2020-12-31	AFK	ETF	20.63	20.63	20.32	20.38	10021.0
2020-12-31	AFLG	ETF	22.28	22.28	22.28	22.28	100.0
2020-12-31	AFSM	ETF	22.113	22.113	22.113	22.113	100.0
2020-12-31	AFTY	ETF	22.99	22.99	22.87	22.954	6400.0
2020-12-31	AGG	ETF	118.18	118.24	118.12	118.19	4834700.0
2020-12-31	AGGY	ETF	53.58	53.7	53.58	53.69	85100.0
2020-12-31	AGNG	ETF	27.88	27.95	27.79	27.92	17500.0
2020-12-31	AGQ	ETF	51.46	51.9	50.47	51.28	1042300.0
2020-12-31	AGZ	ETF	119.52	119.6189	119.52	119.55	39600.0
2020-12-31	AGZD	ETF	23.615	23.615	23.52	23.565	5200.0
2020-12-31	AIA	ETF	87.64	87.64	86.55	87.17	144338.0
2020-12-31	AIEQ	ETF	35.74	35.74	35.412	35.48	12400.0
2020-12-31	AIQ	ETF	27.18	27.2	27.0683	27.2	24159.0
2020-12-31	AIRR	ETF	33.675	34.11	33.66	33.938	21600.0
2020-12-31	AIVI	ETF	40.48	40.55	40.37	40.43	4400.0
2020-12-31	ALTL	ETF	31.71	31.9282	31.71	31.9282	1785.0
2020-12-31	ALTY	ETF	11.61	11.69	11.562	11.69	23200.0
2020-12-31	AMJ	ETF	13.69	13.96	13.68	13.89	1771423.0
2020-12-31	AMLP	ETF	25.48	25.85	25.29	25.66	4224600.0
2020-12-31	AMNA	ETF	25.2679	25.2679	25.2679	25.2679	0.0
2020-12-31	AMND	ETF	26.87	26.87	26.87	26.87	62.0
2020-12-31	AMOM	ETF	31.823	32.054	31.823	32.054	3100.0
2020-12-31	AMTR	ETF	28.4868	28.4868	28.4868	28.4868	0.0
2020-12-31	AMUB	ETF	8.64	8.74	8.61	8.717	17613.0

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

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