PREVIEW / etf_daily / 2020-04-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-29.parquet
  size:    74 KB
  rows:    1,959

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-04-29	SPY	ETF	291.53	294.88	290.41	293.21	118745600.0
2020-04-29	QQQ	ETF	216.21	219.97	215.14	219.0	48716406.0
2020-04-29	IWM	ETF	133.49	136.85	131.88	135.46	50390500.0
2020-04-29	DIA	ETF	245.48	247.67	244.2	246.45	5015300.0
2020-04-29	GLD	ETF	160.1	161.85	159.76	161.73	12232300.0
2020-04-29	TLT	ETF	169.53	170.26	167.96	168.71	8619600.0
2020-04-29	AAAU	ETF	16.98	17.12	16.87	17.12	275400.0
2020-04-29	AADR	ETF	46.17	46.81	46.13	46.81	6200.0
2020-04-29	AAXJ	ETF	64.68	65.32	64.56	65.2	2189500.0
2020-04-29	ABEQ	ETF	22.37	22.47	21.54	22.463	12500.0
2020-04-29	ACES	ETF	33.97	34.89	33.96	34.8	39700.0
2020-04-29	ACIO	ETF	24.16	24.31	24.16	24.21	10100.0
2020-04-29	ACSI	ETF	31.6885	31.6885	31.6566	31.6566	308.0
2020-04-29	ACTX	ETF	4.1595	5.31	4.13	4.189	139.0
2020-04-29	ACWF	ETF	26.79	27.045	26.79	27.0008	36303.0
2020-04-29	ACWI	ETF	69.3	70.07	69.12	69.8	5434000.0
2020-04-29	ACWV	ETF	88.2	88.31	87.57	87.84	452900.0
2020-04-29	ACWX	ETF	40.67	41.04	40.56	40.89	2021962.0
2020-04-29	ADME	ETF	30.215	30.44	30.065	30.065	8100.0
2020-04-29	ADRE	ETF	36.36	37.17	36.36	37.1389	5516.0
2020-04-29	AESR	ETF	9.33	9.35	9.329	9.329	119000.0
2020-04-29	AFIF	ETF	9.801	9.82	9.78	9.805	491784.0
2020-04-29	AFK	ETF	14.6799	15.3	14.6799	15.1	14399.0
2020-04-29	AFLG	ETF	18.09	18.09	18.031	18.031	300.0
2020-04-29	AFSM	ETF	16.19	16.19	16.168	16.168	300.0
2020-04-29	AFTY	ETF	15.95	15.95	15.9	15.92	19200.0
2020-04-29	AGG	ETF	117.29	117.48	117.2	117.36	4653100.0
2020-04-29	AGGY	ETF	53.12	53.23	53.12	53.17	145900.0
2020-04-29	AGNG	ETF	22.96	23.049	22.836	22.9	2600.0
2020-04-29	AGQ	ETF	21.24	21.54	20.78	21.37	300700.0
2020-04-29	AGZ	ETF	120.84	120.88	120.68	120.82	37829.0
2020-04-29	AGZD	ETF	23.32	23.345	23.165	23.23	12400.0
2020-04-29	AIA	ETF	60.35	60.69	60.16	60.69	91910.0
2020-04-29	AIEQ	ETF	25.84	25.969	25.546	25.827	20500.0
2020-04-29	AIQ	ETF	17.73	18.09	17.65	18.0009	14623.0
2020-04-29	AIRR	ETF	22.688	23.37	22.52	23.062	10700.0
2020-04-29	AIVI	ETF	33.81	34.08	33.81	33.98	22800.0
2020-04-29	ALTY	ETF	10.09	10.41	10.036	10.33	10800.0
2020-04-29	AMJ	ETF	13.34	14.015	13.14	13.91	3948558.0
2020-04-29	AMLP	ETF	24.7	26.3	24.65	26.05	6156240.0
2020-04-29	AMOM	ETF	25.78	25.978	25.73	25.978	10300.0
2020-04-29	AMUB	ETF	8.32	8.77	8.32	8.7191	35309.0
2020-04-29	AMZA	ETF	17.03	18.66	17.03	18.6	289600.0
2020-04-29	ANGL	ETF	26.78	27.08	26.74	27.07	1353900.0
2020-04-29	AOA	ETF	51.72	52.19	51.6	52.03	69800.0
2020-04-29	AOK	ETF	35.33	35.47	35.23	35.39	395722.0
2020-04-29	AOM	ETF	38.4	38.6099	38.3172	38.56	238576.0
2020-04-29	AOR	ETF	44.19	44.4499	44.0723	44.38	170177.0
2020-04-29	ARGT	ETF	18.21	18.87	18.21	18.76	21000.0
2020-04-29	ARKF	ETF	23.91	24.53	23.87	24.48	52900.0

> showing 50 of 1,959 rows — these rows as CSV

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