PREVIEW / etf_daily / 2020-12-14

all etf daily files

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

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-14	SPY	ETF	368.64	369.8	364.47	364.66	69216200.0
2020-12-14	QQQ	ETF	303.08	306.05	303.01	304.04	28804832.0
2020-12-14	IWM	ETF	191.96	193.12	189.88	189.93	32237700.0
2020-12-14	DIA	ETF	303.02	303.8	299.0	299.1	3646100.0
2020-12-14	GLD	ETF	171.91	172.52	170.91	171.54	7644400.0
2020-12-14	TLT	ETF	157.49	158.69	157.11	158.33	7535900.0
2020-12-14	AAA	ETF	25.06	25.06	25.06	25.06	1201.0
2020-12-14	AAAU	ETF	18.26	18.31	18.15	18.2	434000.0
2020-12-14	AADR	ETF	58.44	58.44	57.98	58.09	3400.0
2020-12-14	AAXJ	ETF	87.07	87.12	86.47	86.47	1886300.0
2020-12-14	ABEQ	ETF	25.247	25.247	25.01	25.04	3000.0
2020-12-14	ACES	ETF	71.09	71.09	69.72	69.78	78000.0
2020-12-14	ACIO	ETF	27.456	27.54	27.34	27.34	29700.0
2020-12-14	ACSI	ETF	43.01	43.04	42.4584	42.4584	1587.0
2020-12-14	ACTV	ETF	30.76	30.76	30.6308	30.6308	1249.0
2020-12-14	ACVF	ETF	27.43	27.43	27.101	27.101	5100.0
2020-12-14	ACWF	ETF	32.77	32.87	32.63	32.63	16345.0
2020-12-14	ACWI	ETF	89.03	89.16	88.21	88.21	1317200.0
2020-12-14	ACWV	ETF	95.86	96.1	95.12	95.12	586500.0
2020-12-14	ACWX	ETF	52.17	52.185	51.76	51.78	980821.0
2020-12-14	ADFI	ETF	9.985	9.985	9.985	9.985	100.0
2020-12-14	ADME	ETF	34.97	35.4	34.97	35.04	33600.0
2020-12-14	ADRE	ETF	54.9	54.9348	54.525	54.6692	18771.0
2020-12-14	AESR	ETF	11.78	11.795	11.71	11.71	10300.0
2020-12-14	AFIF	ETF	9.775	9.81	9.775	9.7949	30040.0
2020-12-14	AFK	ETF	20.7	20.7	20.445	20.57	13213.0
2020-12-14	AFLG	ETF	21.95	21.954	21.826	21.826	1900.0
2020-12-14	AFMC	ETF	20.792	20.792	20.792	20.792	200.0
2020-12-14	AFTY	ETF	22.009	22.01	21.99	21.993	2700.0
2020-12-14	AGG	ETF	117.86	118.03	117.8	117.96	4705600.0
2020-12-14	AGGY	ETF	53.53	53.64	53.48	53.59	90800.0
2020-12-14	AGNG	ETF	27.36	27.37	27.076	27.076	2600.0
2020-12-14	AGQ	ETF	42.67	43.37	41.83	42.0	684300.0
2020-12-14	AGZ	ETF	119.66	119.77	119.595	119.7	32122.0
2020-12-14	AGZD	ETF	23.52	23.54	23.51	23.525	15800.0
2020-12-14	AIA	ETF	84.15	84.15	83.62	83.63	118649.0
2020-12-14	AIEQ	ETF	35.52	35.52	35.15	35.18	18800.0
2020-12-14	AIQ	ETF	26.5	26.59	26.445	26.5	35783.0
2020-12-14	AIRR	ETF	33.67	33.77	33.03	33.14	25200.0
2020-12-14	AIVI	ETF	40.5	40.5	40.17	40.24	21200.0
2020-12-14	ALTL	ETF	32.14	32.14	31.5013	31.5013	1705.0
2020-12-14	ALTY	ETF	11.83	11.92	11.76	11.779	14400.0
2020-12-14	AMJ	ETF	15.52	15.52	14.62	14.73	1715622.0
2020-12-14	AMLP	ETF	28.51	28.65	27.09	27.22	4413400.0
2020-12-14	AMNA	ETF	26.7084	26.7084	26.7084	26.7084	0.0
2020-12-14	AMND	ETF	28.55	28.57	28.48	28.54	2868.0
2020-12-14	AMOM	ETF	39.08	39.08	38.916	38.916	1700.0
2020-12-14	AMTR	ETF	30.85	30.85	30.04	30.14	13943.0
2020-12-14	AMUB	ETF	9.64	9.64	9.19	9.24	30233.0
2020-12-14	AMZA	ETF	21.63	21.71	20.32	20.5	115000.0

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

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