PREVIEW / etf_daily / 2020-08-26

all etf daily files

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

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-26	SPY	ETF	344.76	347.86	344.17	347.57	50790200.0
2020-08-26	QQQ	ETF	287.11	292.22	285.829	291.96	42216690.0
2020-08-26	IWM	ETF	156.5	156.77	155.18	155.42	13772700.0
2020-08-26	DIA	ETF	282.61	283.61	281.57	283.43	2647500.0
2020-08-26	GLD	ETF	180.26	183.58	180.2	183.36	12715800.0
2020-08-26	TLT	ETF	164.05	164.33	163.28	164.03	8276600.0
2020-08-26	AAAU	ETF	19.13	19.48	19.12	19.46	627400.0
2020-08-26	AADR	ETF	56.4	57.46	56.4	57.38	6800.0
2020-08-26	AAXJ	ETF	78.94	79.15	78.66	79.06	635000.0
2020-08-26	ABEQ	ETF	23.495	23.562	23.495	23.562	1100.0
2020-08-26	ACES	ETF	52.49	52.81	52.3	52.52	68100.0
2020-08-26	ACIO	ETF	27.11	27.22	27.08	27.22	14300.0
2020-08-26	ACSI	ETF	38.405	38.405	38.405	38.405	204.0
2020-08-26	ACTX	ETF	2.1358	2.4131	2.1358	2.1889	48.0
2020-08-26	ACWF	ETF	30.4611	30.471	30.45	30.45	1488.0
2020-08-26	ACWI	ETF	81.82	82.49	81.79	82.47	4648200.0
2020-08-26	ACWV	ETF	92.95	93.22	92.68	93.07	359200.0
2020-08-26	ACWX	ETF	47.2	47.495	47.18	47.44	553378.0
2020-08-26	ADFI	ETF	10.015	10.015	10.015	10.015	100.0
2020-08-26	ADME	ETF	34.805	35.05	34.805	35.05	8700.0
2020-08-26	ADRE	ETF	47.9	47.9296	47.5619	47.9296	8847.0
2020-08-26	AESR	ETF	11.25	11.279	11.25	11.279	10700.0
2020-08-26	AFIF	ETF	9.81	9.82	9.72	9.72	44643.0
2020-08-26	AFK	ETF	17.68	17.825	17.6073	17.7574	5772.0
2020-08-26	AFLG	ETF	20.79	20.895	20.79	20.895	200.0
2020-08-26	AFMC	ETF	18.38	18.409	18.38	18.409	200.0
2020-08-26	AFSM	ETF	18.53	18.53	18.523	18.523	200.0
2020-08-26	AFTY	ETF	19.28	19.28	19.23	19.249	2000.0
2020-08-26	AGG	ETF	118.35	118.42	118.21	118.36	5139800.0
2020-08-26	AGGY	ETF	53.9	53.98	53.88	53.95	64400.0
2020-08-26	AGNG	ETF	25.47	25.57	25.43	25.563	7900.0
2020-08-26	AGQ	ETF	56.0	60.4	55.96	60.21	3374700.0
2020-08-26	AGZ	ETF	121.05	121.26	121.03	121.04	255184.0
2020-08-26	AGZD	ETF	23.515	23.53	23.51	23.525	4600.0
2020-08-26	AIA	ETF	73.23	73.75	73.23	73.61	37886.0
2020-08-26	AIEQ	ETF	31.15	31.55	31.15	31.52	12600.0
2020-08-26	AIQ	ETF	23.61	24.14	23.5901	24.1139	338978.0
2020-08-26	AIRR	ETF	26.77	26.97	26.64	26.82	16600.0
2020-08-26	AIVI	ETF	37.29	37.49	37.29	37.45	11500.0
2020-08-26	ALTL	ETF	25.275	25.48	25.27	25.4494	856.0
2020-08-26	ALTY	ETF	10.959	10.959	10.855	10.857	6200.0
2020-08-26	AMJ	ETF	13.04	13.04	12.64	12.84	536050.0
2020-08-26	AMLP	ETF	23.4	23.4	22.63	22.71	3534900.0
2020-08-26	AMNA	ETF	24.52	24.53	24.09	24.1656	6400.0
2020-08-26	AMND	ETF	25.4078	25.4078	25.4078	25.4078	0.0
2020-08-26	AMOM	ETF	35.99	36.37	35.8	36.304	5200.0
2020-08-26	AMUB	ETF	7.76	8.23	7.76	7.76	85433.0
2020-08-26	AMZA	ETF	17.04	17.04	16.26	16.32	125600.0
2020-08-26	ANGL	ETF	30.62	30.66	30.58	30.59	903200.0
2020-08-26	AOA	ETF	59.09	59.57	59.09	59.47	72200.0

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

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