PREVIEW / etf_daily / 2020-08-05

all etf daily files

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

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-05	SPY	ETF	331.47	332.39	331.18	332.11	42697700.0
2020-08-05	QQQ	ETF	270.83	271.52	269.96	271.05	21685921.0
2020-08-05	IWM	ETF	152.29	153.89	151.78	153.79	18190200.0
2020-08-05	DIA	ETF	269.99	272.27	269.9	272.0	2122900.0
2020-08-05	GLD	ETF	191.65	193.13	190.62	191.35	27078100.0
2020-08-05	TLT	ETF	170.06	170.56	169.69	170.07	6954100.0
2020-08-05	AAAU	ETF	20.32	20.48	20.22	20.3	605200.0
2020-08-05	AADR	ETF	58.71	58.99	58.7	58.76	2700.0
2020-08-05	AAXJ	ETF	77.09	77.6	77.09	77.34	744100.0
2020-08-05	ABEQ	ETF	23.4	23.44	23.39	23.44	8500.0
2020-08-05	ACES	ETF	48.45	49.235	47.514	48.7	98500.0
2020-08-05	ACIO	ETF	26.37	26.45	26.37	26.402	94600.0
2020-08-05	ACSI	ETF	36.6276	36.6276	36.6276	36.6276	102.0
2020-08-05	ACTX	ETF	2.3895	3.304	2.3895	2.3895	336.0
2020-08-05	ACWF	ETF	29.95	30.07	29.92	29.96	3732.0
2020-08-05	ACWI	ETF	79.42	79.63	79.28	79.44	2652800.0
2020-08-05	ACWV	ETF	92.24	92.36	91.58	91.65	325500.0
2020-08-05	ACWX	ETF	46.37	46.53	46.23	46.29	1174394.0
2020-08-05	ADME	ETF	34.12	34.19	34.116	34.151	64100.0
2020-08-05	ADRE	ETF	46.55	47.11	46.55	46.875	2574.0
2020-08-05	AESR	ETF	10.74	10.74	10.71	10.716	6100.0
2020-08-05	AFIF	ETF	9.87	9.87	9.85	9.8549	53679.0
2020-08-05	AFK	ETF	17.68	17.68	17.3965	17.3965	4662.0
2020-08-05	AFSM	ETF	18.341	18.341	18.341	18.341	100.0
2020-08-05	AFTY	ETF	19.012	19.094	19.01	19.02	5000.0
2020-08-05	AGG	ETF	119.39	119.49	119.31	119.4	17345700.0
2020-08-05	AGGY	ETF	54.64	54.64	54.53	54.61	90500.0
2020-08-05	AGNG	ETF	25.56	25.74	25.56	25.604	13100.0
2020-08-05	AGQ	ETF	60.65	61.54	58.32	60.57	4061200.0
2020-08-05	AGZ	ETF	121.81	121.81	121.5	121.65	34582.0
2020-08-05	AGZD	ETF	23.655	23.655	23.63	23.645	5600.0
2020-08-05	AIA	ETF	72.17	72.544	72.06	72.12	272600.0
2020-08-05	AIEQ	ETF	31.11	31.162	30.904	30.95	14300.0
2020-08-05	AIQ	ETF	22.82	22.85	22.735	22.81	33448.0
2020-08-05	AIRR	ETF	26.0	26.37	26.0	26.37	10000.0
2020-08-05	AIVI	ETF	37.15	37.15	36.93	36.94	2600.0
2020-08-05	ALTL	ETF	25.2087	25.2087	24.97	25.0245	4095.0
2020-08-05	ALTY	ETF	10.9	10.9	10.83	10.87	23200.0
2020-08-05	AMJ	ETF	13.33	13.71	13.29	13.45	1896491.0
2020-08-05	AMLP	ETF	24.75	25.46	24.64	25.01	3297000.0
2020-08-05	AMNA	ETF	24.9344	24.9344	24.9344	24.9344	0.0
2020-08-05	AMND	ETF	26.3582	26.3582	26.3582	26.3582	1.0
2020-08-05	AMOM	ETF	36.61	36.61	34.88	35.224	6300.0
2020-08-05	AMUB	ETF	8.39	8.49	8.36	8.482	18524.0
2020-08-05	AMZA	ETF	17.68	18.09	17.5	17.88	91200.0
2020-08-05	ANGL	ETF	30.44	30.6	30.44	30.51	1255000.0
2020-08-05	AOA	ETF	57.73	57.98	57.73	57.88	37400.0
2020-08-05	AOK	ETF	37.39	37.4768	37.39	37.43	309894.0
2020-08-05	AOM	ETF	41.26	41.29	41.12	41.25	139602.0
2020-08-05	AOR	ETF	48.33	48.53	48.33	48.4	123704.0

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

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