PREVIEW / etf_daily / 2020-12-28

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-28.parquet
  size:    83 KB
  rows:    2,195

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-28	SPY	ETF	371.74	372.59	371.07	372.17	39000400.0
2020-12-28	QQQ	ETF	312.25	313.17	310.36	312.68	22497745.0
2020-12-28	IWM	ETF	201.16	201.18	198.13	198.27	27168400.0
2020-12-28	DIA	ETF	303.69	305.15	303.35	304.0	2382400.0
2020-12-28	GLD	ETF	177.26	177.91	175.63	175.71	7778700.0
2020-12-28	TLT	ETF	156.38	157.45	156.1	157.36	7791100.0
2020-12-28	AAA	ETF	25.08	25.09	25.08	25.09	796.0
2020-12-28	AAAU	ETF	18.8	18.88	18.64	18.66	487900.0
2020-12-28	AADR	ETF	60.66	60.66	60.17	60.31	3400.0
2020-12-28	AAXJ	ETF	87.15	87.28	86.81	86.95	839500.0
2020-12-28	ABEQ	ETF	25.05	25.61	25.05	25.61	4300.0
2020-12-28	ACES	ETF	83.73	83.73	79.175	79.21	187200.0
2020-12-28	ACIO	ETF	27.75	27.87	27.595	27.73	25700.0
2020-12-28	ACSI	ETF	43.2618	43.2618	43.2618	43.2618	354.0
2020-12-28	ACTV	ETF	31.57	31.5766	31.35	31.3697	12343.0
2020-12-28	ACTX	ETF	2.74	2.74	1.58	2.5	4174.0
2020-12-28	ACVF	ETF	28.08	28.08	27.77	27.819	5900.0
2020-12-28	ACWF	ETF	33.5	33.5	33.28	33.3121	7906.0
2020-12-28	ACWI	ETF	90.33	90.33	90.06	90.18	2035300.0
2020-12-28	ACWV	ETF	96.17	96.36	95.99	96.09	176800.0
2020-12-28	ACWX	ETF	52.76	52.78	52.53	52.6	1143742.0
2020-12-28	ADFI	ETF	9.96	9.96	9.96	9.96	100.0
2020-12-28	ADME	ETF	36.12	36.12	35.82	35.89	20000.0
2020-12-28	ADRE	ETF	54.64	54.85	54.0901	54.29	23169.0
2020-12-28	AESR	ETF	11.92	11.96	11.92	11.92	6900.0
2020-12-28	AFIF	ETF	9.73	9.78	9.73	9.78	24810.0
2020-12-28	AFK	ETF	21.25	21.25	20.0	20.1	52977.0
2020-12-28	AFLG	ETF	22.3	22.3	22.239	22.239	600.0
2020-12-28	AFMC	ETF	21.411	21.411	21.411	21.411	100.0
2020-12-28	AFSM	ETF	22.307	22.307	22.307	22.307	100.0
2020-12-28	AFTY	ETF	22.35	22.35	22.201	22.27	7900.0
2020-12-28	AGG	ETF	117.97	118.05	117.83	118.01	4567200.0
2020-12-28	AGGY	ETF	53.45	53.52	53.45	53.52	281600.0
2020-12-28	AGNG	ETF	27.94	27.94	27.76	27.77	43800.0
2020-12-28	AGQ	ETF	52.0	52.65	50.67	50.87	1458300.0
2020-12-28	AGZ	ETF	119.5	119.559	119.4543	119.49	76261.0
2020-12-28	AGZD	ETF	23.725	23.725	23.505	23.55	8400.0
2020-12-28	AIA	ETF	84.39	84.44	84.17	84.21	128406.0
2020-12-28	AIEQ	ETF	36.72	36.85	35.61	35.68	37300.0
2020-12-28	AIQ	ETF	27.26	27.26	26.9167	26.945	50869.0
2020-12-28	AIRR	ETF	34.37	34.44	34.084	34.084	9400.0
2020-12-28	AIVI	ETF	40.57	40.59	40.45	40.48	5300.0
2020-12-28	ALTL	ETF	31.88	31.88	31.5537	31.5537	4797.0
2020-12-28	ALTY	ETF	11.73	11.74	11.65	11.68	14800.0
2020-12-28	AMJ	ETF	14.26	14.28	13.78	13.9	1685431.0
2020-12-28	AMLP	ETF	26.29	26.43	25.49	25.75	3051700.0
2020-12-28	AMNA	ETF	25.23	25.3078	25.23	25.3078	103.0
2020-12-28	AMND	ETF	26.8794	26.8794	26.8794	26.8794	0.0
2020-12-28	AMOM	ETF	32.41	35.47	31.9	32.0	14900.0
2020-12-28	AMTR	ETF	28.86	28.93	28.44	28.4794	4501.0

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

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