PREVIEW / etf_daily / 2020-09-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-23.parquet
  size:    79 KB
  rows:    2,083

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-09-23	SPY	ETF	330.9	331.2	322.1	322.64	93112200.0
2020-09-23	QQQ	ETF	272.15	272.34	263.2502	264.16	48837270.0
2020-09-23	IWM	ETF	148.41	149.43	143.98	144.07	33403400.0
2020-09-23	DIA	ETF	274.18	274.59	267.08	267.58	3575900.0
2020-09-23	GLD	ETF	176.98	177.26	174.1	174.79	18134000.0
2020-09-23	TLT	ETF	164.3	164.53	163.48	164.49	6224800.0
2020-09-23	AAA	ETF	24.985	24.997	24.985	24.99	4644.0
2020-09-23	AAAU	ETF	18.76	18.8	18.48	18.54	1552300.0
2020-09-23	AADR	ETF	54.47	54.75	53.79	53.82	4300.0
2020-09-23	AAXJ	ETF	76.34	76.43	75.42	75.58	1091700.0
2020-09-23	ABEQ	ETF	23.16	23.16	22.92	22.94	11800.0
2020-09-23	ACES	ETF	51.81	51.84	49.8	49.82	40100.0
2020-09-23	ACIO	ETF	26.31	26.41	26.058	26.086	28600.0
2020-09-23	ACSI	ETF	36.71	36.71	35.9254	35.9254	951.0
2020-09-23	ACTX	ETF	2.301	2.301	2.2715	2.2715	773.0
2020-09-23	ACWF	ETF	29.4	29.4129	28.891	28.891	7361.0
2020-09-23	ACWI	ETF	79.37	79.38	77.61	77.7	10125100.0
2020-09-23	ACWV	ETF	91.08	91.16	89.74	89.85	799200.0
2020-09-23	ACWX	ETF	46.0	46.03	45.3	45.3	814027.0
2020-09-23	ADFI	ETF	9.972	9.972	9.972	9.972	100.0
2020-09-23	ADME	ETF	33.13	33.13	32.61	32.661	23100.0
2020-09-23	ADRE	ETF	45.93	45.93	45.15	45.15	6683.0
2020-09-23	AESR	ETF	10.69	10.69	10.475	10.475	8800.0
2020-09-23	AFIF	ETF	9.83	9.83	9.8	9.81	47147.0
2020-09-23	AFK	ETF	17.53	17.53	17.1	17.1	2971.0
2020-09-23	AFLG	ETF	20.02	20.02	19.501	19.501	1400.0
2020-09-23	AFSM	ETF	17.224	17.224	17.224	17.224	100.0
2020-09-23	AFTY	ETF	19.26	19.27	19.198	19.198	400.0
2020-09-23	AGG	ETF	118.35	118.35	118.07	118.08	5392900.0
2020-09-23	AGGY	ETF	53.99	53.99	53.82	53.83	124800.0
2020-09-23	AGNG	ETF	25.25	25.35	24.87	24.87	5500.0
2020-09-23	AGQ	ETF	43.07	43.75	39.66	40.12	4498900.0
2020-09-23	AGZ	ETF	121.38	121.38	121.05	121.05	878140.0
2020-09-23	AGZD	ETF	23.445	23.5	23.395	23.425	14600.0
2020-09-23	AIA	ETF	71.53	71.65	70.735	70.77	158209.0
2020-09-23	AIEQ	ETF	30.32	30.32	29.458	29.51	45900.0
2020-09-23	AIQ	ETF	23.04	23.05	22.43	22.442	127040.0
2020-09-23	AIRR	ETF	25.5	25.5	24.807	24.807	6400.0
2020-09-23	AIVI	ETF	36.08	36.14	35.57	35.6	14100.0
2020-09-23	ALTL	ETF	24.673	24.673	24.28	24.28	25132.0
2020-09-23	ALTY	ETF	10.68	10.69	10.32	10.398	18800.0
2020-09-23	AMJ	ETF	11.17	11.34	10.61	10.71	1128215.0
2020-09-23	AMLP	ETF	20.64	20.95	19.6	19.64	2920600.0
2020-09-23	AMNA	ETF	22.41	22.5	21.7223	21.7223	2900.0
2020-09-23	AMND	ETF	22.74	22.74	22.6364	22.6364	200.0
2020-09-23	AMOM	ETF	33.751	33.751	33.751	33.751	200.0
2020-09-23	AMUB	ETF	6.95	6.99	6.68	6.68	20141.0
2020-09-23	AMZA	ETF	14.0	14.21	13.09	13.11	129600.0
2020-09-23	ANGL	ETF	29.93	29.94	29.57	29.6	983200.0
2020-09-23	AOA	ETF	57.53	57.71	56.63	56.7	77200.0

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

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