PREVIEW / etf_daily / 2020-08-07

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-07.parquet
  size:    78 KB
  rows:    2,059

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-08-07	SPY	ETF	333.28	334.88	332.3	334.57	57308300.0
2020-08-07	QQQ	ETF	274.04	274.8818	269.245	271.47	44969356.0
2020-08-07	IWM	ETF	153.45	156.25	153.15	156.17	20475200.0
2020-08-07	DIA	ETF	273.23	274.82	272.48	274.62	2311300.0
2020-08-07	GLD	ETF	192.71	192.96	189.33	190.81	24570200.0
2020-08-07	TLT	ETF	171.28	171.5	169.58	169.88	8176900.0
2020-08-07	AAAU	ETF	20.46	20.47	20.09	20.25	962300.0
2020-08-07	AADR	ETF	58.28	58.34	57.59	57.59	2400.0
2020-08-07	AAXJ	ETF	76.24	76.49	75.62	76.01	1107600.0
2020-08-07	ABEQ	ETF	21.23	23.3	21.23	23.26	2700.0
2020-08-07	ACES	ETF	48.63	50.195	48.63	49.684	118700.0
2020-08-07	ACIO	ETF	26.51	26.57	26.4	26.48	11100.0
2020-08-07	ACSI	ETF	37.01	37.1893	37.01	37.1893	489.0
2020-08-07	ACTX	ETF	2.95	2.95	2.4013	2.4013	379.0
2020-08-07	ACWF	ETF	29.79	29.8875	29.7572	29.8875	4577.0
2020-08-07	ACWI	ETF	79.19	79.46	78.87	79.36	4791100.0
2020-08-07	ACWV	ETF	91.24	92.07	91.24	92.05	378600.0
2020-08-07	ACWX	ETF	45.78	45.95	45.68	45.95	650481.0
2020-08-07	ADME	ETF	34.11	34.11	33.82	33.955	11400.0
2020-08-07	ADRE	ETF	46.04	46.04	45.15	45.48	6858.0
2020-08-07	AESR	ETF	10.82	10.83	10.71	10.759	11700.0
2020-08-07	AFIF	ETF	9.8431	9.88	9.8431	9.86	25763.0
2020-08-07	AFK	ETF	17.48	17.75	17.05	17.2462	4411.0
2020-08-07	AFLG	ETF	20.23	20.28	20.23	20.28	500.0
2020-08-07	AFSM	ETF	18.502	18.502	18.502	18.502	100.0
2020-08-07	AFTY	ETF	18.68	18.734	18.68	18.734	2300.0
2020-08-07	AGG	ETF	119.66	119.73	119.4	119.43	5559100.0
2020-08-07	AGGY	ETF	54.67	54.73	54.61	54.62	81900.0
2020-08-07	AGNG	ETF	25.55	25.71	25.55	25.59	6100.0
2020-08-07	AGQ	ETF	66.24	66.74	62.13	65.61	5322700.0
2020-08-07	AGZ	ETF	121.53	121.735	121.53	121.58	41140.0
2020-08-07	AGZD	ETF	23.64	23.68	23.585	23.635	40000.0
2020-08-07	AIA	ETF	71.02	71.2358	70.58	70.95	121124.0
2020-08-07	AIEQ	ETF	30.79	30.997	30.48	30.77	11800.0
2020-08-07	AIQ	ETF	22.83	22.97	22.38	22.56	31956.0
2020-08-07	AIRR	ETF	26.27	26.999	26.27	26.999	3100.0
2020-08-07	AIVI	ETF	36.34	36.58	36.34	36.58	4400.0
2020-08-07	ALTL	ETF	25.0793	25.19	25.0793	25.1878	5942.0
2020-08-07	ALTY	ETF	10.931	11.0	10.91	11.0	13800.0
2020-08-07	AMJ	ETF	13.64	13.8	13.43	13.8	868768.0
2020-08-07	AMLP	ETF	25.13	25.31	24.92	25.22	1575900.0
2020-08-07	AMNA	ETF	24.75	24.8443	24.67	24.8443	1900.0
2020-08-07	AMND	ETF	26.14	26.234	26.14	26.234	200.0
2020-08-07	AMOM	ETF	34.88	34.93	33.88	34.37	3200.0
2020-08-07	AMUB	ETF	8.23	8.83	8.23	8.83	33534.0
2020-08-07	AMZA	ETF	18.25	18.25	17.89	18.16	34000.0
2020-08-07	ANGL	ETF	30.74	30.77	30.6	30.69	1101400.0
2020-08-07	AOA	ETF	57.84	58.0	57.71	57.99	28300.0
2020-08-07	AOK	ETF	37.48	37.61	37.4	37.48	62137.0
2020-08-07	AOM	ETF	41.22	41.3	41.07	41.24	74737.0

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

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