PREVIEW / etf_daily / 2020-12-03

all etf daily files

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

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-03	SPY	ETF	366.68	368.19	365.5	366.69	62882000.0
2020-12-03	QQQ	ETF	304.07	305.88	303.531	304.28	22828727.0
2020-12-03	IWM	ETF	183.34	185.18	182.94	183.92	19603600.0
2020-12-03	DIA	ETF	299.38	301.4	299.05	300.06	3140900.0
2020-12-03	GLD	ETF	172.64	172.85	171.08	172.81	10457300.0
2020-12-03	TLT	ETF	156.94	157.82	156.58	157.51	9626500.0
2020-12-03	AAA	ETF	25.04	25.04	25.04	25.04	487.0
2020-12-03	AAAU	ETF	18.32	18.35	18.16	18.34	266800.0
2020-12-03	AADR	ETF	58.7	58.7	58.54	58.61	2100.0
2020-12-03	AAXJ	ETF	87.12	87.56	86.95	87.19	869400.0
2020-12-03	ABEQ	ETF	25.021	25.19	24.98	25.19	21400.0
2020-12-03	ACES	ETF	68.78	69.01	68.0	68.08	91100.0
2020-12-03	ACIO	ETF	27.6	27.6	27.392	27.42	58200.0
2020-12-03	ACSI	ETF	42.91	42.9887	42.8411	42.8411	1119.0
2020-12-03	ACTV	ETF	29.43	29.8808	29.43	29.7223	21109.0
2020-12-03	ACTX	ETF	2.65	3.0	2.65	2.78	1342.0
2020-12-03	ACVF	ETF	27.27	27.27	27.135	27.135	1700.0
2020-12-03	ACWF	ETF	32.86	32.885	32.7403	32.7403	1599.0
2020-12-03	ACWI	ETF	88.91	89.25	88.7	88.9	1967200.0
2020-12-03	ACWV	ETF	96.02	96.25	95.78	95.98	198000.0
2020-12-03	ACWX	ETF	52.1	52.29	51.97	52.06	1260345.0
2020-12-03	ADME	ETF	35.57	35.57	35.13	35.17	41600.0
2020-12-03	ADRE	ETF	54.32	54.8033	54.2579	54.298	14267.0
2020-12-03	AESR	ETF	11.72	11.79	11.72	11.728	6400.0
2020-12-03	AFIF	ETF	9.84	9.84	9.794	9.815	518033.0
2020-12-03	AFK	ETF	20.33	20.3696	19.7	20.3225	22432.0
2020-12-03	AFLG	ETF	21.844	21.844	21.729	21.729	100.0
2020-12-03	AFSM	ETF	20.658	20.658	20.658	20.658	200.0
2020-12-03	AFTY	ETF	22.46	22.48	22.375	22.375	900.0
2020-12-03	AGG	ETF	117.92	117.98	117.77	117.91	5198400.0
2020-12-03	AGGY	ETF	53.75	53.82	53.73	53.8	112500.0
2020-12-03	AGNG	ETF	26.982	27.0	26.9	26.95	3200.0
2020-12-03	AGQ	ETF	42.7	43.13	41.65	43.13	1086600.0
2020-12-03	AGZ	ETF	119.39	119.56	119.39	119.56	39316.0
2020-12-03	AGZD	ETF	23.57	23.6	23.545	23.6	29200.0
2020-12-03	AIA	ETF	83.95	84.39	83.79	83.92	148045.0
2020-12-03	AIEQ	ETF	34.19	34.4	34.06	34.28	14100.0
2020-12-03	AIQ	ETF	26.19	26.42	26.17	26.23	53282.0
2020-12-03	AIRR	ETF	31.666	32.1	31.666	32.1	6200.0
2020-12-03	AIVI	ETF	40.0	40.04	39.83	39.83	3500.0
2020-12-03	ALTL	ETF	31.11	31.6895	31.11	31.4281	1075.0
2020-12-03	ALTY	ETF	11.73	11.75	11.649	11.73	15800.0
2020-12-03	AMJ	ETF	14.06	14.89	14.04	14.73	2369696.0
2020-12-03	AMLP	ETF	26.24	27.63	26.03	27.29	5025000.0
2020-12-03	AMNA	ETF	26.2403	26.2403	26.2403	26.2403	0.0
2020-12-03	AMND	ETF	28.1197	28.1197	28.1197	28.1197	7.0
2020-12-03	AMOM	ETF	38.319	38.319	38.319	38.319	100.0
2020-12-03	AMTR	ETF	29.6036	29.6036	29.6036	29.6036	0.0
2020-12-03	AMUB	ETF	9.1411	9.3	9.1411	9.2416	4026.0
2020-12-03	AMZA	ETF	19.3	20.59	19.3	20.38	126400.0

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

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