PREVIEW / etf_daily / 2020-07-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-20.parquet
  size:    77 KB
  rows:    2,040

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-07-20	SPY	ETF	321.43	325.13	320.62	324.32	56308800.0
2020-07-20	QQQ	ETF	260.12	267.43	258.79	266.78	40610128.0
2020-07-20	IWM	ETF	146.12	146.85	145.15	145.96	19663300.0
2020-07-20	DIA	ETF	266.39	267.64	265.03	266.82	4017400.0
2020-07-20	GLD	ETF	170.76	171.07	170.27	170.94	10095500.0
2020-07-20	TLT	ETF	167.51	167.62	166.8	167.19	6907200.0
2020-07-20	AAAU	ETF	18.12	18.15	18.06	18.13	360100.0
2020-07-20	AADR	ETF	57.24	58.08	57.24	57.81	4200.0
2020-07-20	AAXJ	ETF	74.37	74.91	74.11	74.82	680500.0
2020-07-20	ABEQ	ETF	22.76	22.8	22.6	22.69	12000.0
2020-07-20	ACES	ETF	45.89	46.34	45.565	46.282	51500.0
2020-07-20	ACIO	ETF	25.787	25.94	25.787	25.894	18900.0
2020-07-20	ACSI	ETF	34.9716	34.9716	34.9716	34.9716	114.0
2020-07-20	ACTX	ETF	2.2715	2.8615	2.2715	2.8055	63.0
2020-07-20	ACWF	ETF	29.235	29.4227	29.235	29.4227	3187.0
2020-07-20	ACWI	ETF	77.33	78.07	77.13	77.94	2587600.0
2020-07-20	ACWV	ETF	90.54	90.84	90.45	90.71	298300.0
2020-07-20	ACWX	ETF	45.44	45.73	45.37	45.7	2698297.0
2020-07-20	ADME	ETF	32.88	33.59	32.88	33.57	27700.0
2020-07-20	ADRE	ETF	43.8	44.2599	43.8	44.22	7488.0
2020-07-20	AESR	ETF	10.498	10.498	10.498	10.498	100.0
2020-07-20	AFIF	ETF	9.83	9.86	9.81	9.825	47608.0
2020-07-20	AFK	ETF	17.48	17.48	17.31	17.3997	5999.0
2020-07-20	AFLG	ETF	19.742	19.742	19.742	19.742	100.0
2020-07-20	AFMC	ETF	17.43	17.45	17.43	17.45	800.0
2020-07-20	AFSM	ETF	17.294	17.294	17.294	17.294	100.0
2020-07-20	AFTY	ETF	19.08	19.12	19.0	19.12	3600.0
2020-07-20	AGG	ETF	119.03	119.06	118.91	119.01	3989200.0
2020-07-20	AGGY	ETF	54.3	54.34	54.26	54.3	87800.0
2020-07-20	AGNG	ETF	25.835	25.93	25.835	25.925	1200.0
2020-07-20	AGQ	ETF	34.48	35.05	33.99	34.97	1178800.0
2020-07-20	AGZ	ETF	121.36	121.36	121.225	121.25	20690.0
2020-07-20	AGZD	ETF	23.625	23.645	23.605	23.615	6800.0
2020-07-20	AIA	ETF	68.48	69.07	68.42	69.07	45061.0
2020-07-20	AIEQ	ETF	29.7	30.179	29.625	30.17	19300.0
2020-07-20	AIQ	ETF	21.56	22.07	21.5098	22.07	16069.0
2020-07-20	AIRR	ETF	24.36	24.36	23.971	24.09	8000.0
2020-07-20	AIVI	ETF	36.78	37.07	36.78	37.01	13600.0
2020-07-20	ALTL	ETF	24.475	24.54	24.475	24.4934	1180.0
2020-07-20	ALTY	ETF	10.6	10.615	10.501	10.574	13800.0
2020-07-20	AMJ	ETF	12.75	12.97	12.69	12.89	977817.0
2020-07-20	AMLP	ETF	23.7	24.08	23.55	23.59	2428900.0
2020-07-20	AMNA	ETF	23.4038	23.4038	23.4038	23.4038	0.0
2020-07-20	AMND	ETF	24.6773	24.6773	24.6773	24.6773	0.0
2020-07-20	AMOM	ETF	31.75	33.088	31.75	33.088	2300.0
2020-07-20	AMUB	ETF	8.1	8.1	7.98	7.9911	18764.0
2020-07-20	AMZA	ETF	16.8	17.03	16.61	16.71	140100.0
2020-07-20	ANGL	ETF	29.61	29.73	29.53	29.73	623200.0
2020-07-20	AOA	ETF	56.47	56.97	56.42	56.93	38200.0
2020-07-20	AOK	ETF	37.0	37.15	36.95	37.02	144707.0

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

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