PREVIEW / etf_daily / 2020-09-24

all etf daily files

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

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-24	SPY	ETF	321.22	326.8	319.8	323.5	76681300.0
2020-09-24	QQQ	ETF	261.58	268.7	261.22	265.39	70631704.0
2020-09-24	IWM	ETF	144.04	146.53	142.09	144.07	31723700.0
2020-09-24	DIA	ETF	266.86	270.88	265.27	268.1	4432100.0
2020-09-24	GLD	ETF	174.36	176.24	173.77	175.44	11759200.0
2020-09-24	TLT	ETF	164.96	165.12	164.62	165.12	8278100.0
2020-09-24	AAA	ETF	24.99	24.9909	24.98	24.98	7080.0
2020-09-24	AAAU	ETF	18.5	18.7	18.45	18.62	849600.0
2020-09-24	AADR	ETF	53.03	54.05	53.03	54.03	2100.0
2020-09-24	AAXJ	ETF	74.31	75.31	74.18	74.86	1582800.0
2020-09-24	ABEQ	ETF	23.05	23.07	22.93	23.07	8700.0
2020-09-24	ACES	ETF	49.3	50.31	48.211	49.68	30500.0
2020-09-24	ACIO	ETF	26.16	26.23	25.982	26.1	3800.0
2020-09-24	ACSI	ETF	35.57	35.9752	35.57	35.9752	293.0
2020-09-24	ACTX	ETF	2.4249	2.4249	2.2656	2.2715	89.0
2020-09-24	ACWF	ETF	28.8	29.0409	28.78	28.9354	8538.0
2020-09-24	ACWI	ETF	77.25	78.43	76.94	77.74	3658200.0
2020-09-24	ACWV	ETF	89.31	90.34	89.08	89.8	224000.0
2020-09-24	ACWX	ETF	45.03	45.54	44.89	45.25	1177374.0
2020-09-24	ADME	ETF	32.874	32.874	32.61	32.712	1000.0
2020-09-24	ADRE	ETF	44.73	45.13	43.95	45.13	4242.0
2020-09-24	AESR	ETF	10.43	10.512	10.43	10.512	1971000.0
2020-09-24	AFIF	ETF	9.8109	9.83	9.79	9.815	1460178.0
2020-09-24	AFK	ETF	17.0	17.2778	17.0	17.2778	2387.0
2020-09-24	AFLG	ETF	19.492	19.492	19.492	19.492	100.0
2020-09-24	AFMC	ETF	17.16	17.16	17.105	17.105	300.0
2020-09-24	AFSM	ETF	17.21	17.217	17.21	17.217	300.0
2020-09-24	AFTY	ETF	18.88	19.07	18.88	19.038	6000.0
2020-09-24	AGG	ETF	118.01	118.16	118.01	118.09	4145000.0
2020-09-24	AGGY	ETF	53.89	53.89	53.8	53.8	51000.0
2020-09-24	AGNG	ETF	24.73	24.77	24.696	24.71	2300.0
2020-09-24	AGQ	ETF	37.87	42.17	37.31	41.49	4234200.0
2020-09-24	AGZ	ETF	121.14	121.5	121.0	121.0	61255.0
2020-09-24	AGZD	ETF	23.425	23.49	23.425	23.455	18200.0
2020-09-24	AIA	ETF	69.65	70.63	69.4254	70.25	56974.0
2020-09-24	AIEQ	ETF	29.11	29.71	28.95	29.3	43600.0
2020-09-24	AIQ	ETF	22.35	22.689	22.22	22.4575	9420.0
2020-09-24	AIRR	ETF	24.76	25.16	24.75	24.879	69200.0
2020-09-24	AIVI	ETF	35.64	35.84	35.4	35.49	67000.0
2020-09-24	ALTL	ETF	24.165	24.45	24.165	24.3557	45148.0
2020-09-24	ALTY	ETF	10.32	10.38	10.22	10.275	8200.0
2020-09-24	AMJ	ETF	10.77	10.77	10.25	10.55	1983271.0
2020-09-24	AMLP	ETF	19.66	19.84	18.93	19.5	4215400.0
2020-09-24	AMNA	ETF	21.34	21.85	21.3	21.6835	2100.0
2020-09-24	AMND	ETF	22.5915	22.5915	22.5915	22.5915	4.0
2020-09-24	AMOM	ETF	33.47	34.2	33.47	33.867	2000.0
2020-09-24	AMUB	ETF	6.66	6.745	6.48	6.63	67272.0
2020-09-24	AMZA	ETF	13.01	13.11	12.4	12.83	173800.0
2020-09-24	ANGL	ETF	29.5	29.57	29.36	29.41	2719200.0
2020-09-24	AOA	ETF	56.36	57.07	56.2	56.67	67500.0

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

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