PREVIEW / etf_daily / 2020-07-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-23.parquet
  size:    77 KB
  rows:    2,045

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-07-23	SPY	ETF	326.47	327.23	321.48	322.96	75738000.0
2020-07-23	QQQ	ETF	264.55	265.24	256.55	258.01	51363538.0
2020-07-23	IWM	ETF	147.98	150.2	146.7	148.26	21704900.0
2020-07-23	DIA	ETF	269.64	269.78	265.62	266.69	2838000.0
2020-07-23	GLD	ETF	176.17	178.41	175.65	177.18	23006800.0
2020-07-23	TLT	ETF	168.92	169.88	168.48	169.75	10471800.0
2020-07-23	AAAU	ETF	18.7	18.94	18.65	18.82	892300.0
2020-07-23	AADR	ETF	57.9	57.97	56.5	56.5	2500.0
2020-07-23	AAXJ	ETF	74.86	75.15	74.03	74.42	695500.0
2020-07-23	ABEQ	ETF	23.23	23.23	23.11	23.111	1400.0
2020-07-23	ACES	ETF	46.86	47.06	45.83	46.17	54900.0
2020-07-23	ACIO	ETF	26.12	26.12	25.8	25.838	9200.0
2020-07-23	ACSI	ETF	35.39	35.39	35.1611	35.1611	860.0
2020-07-23	ACTX	ETF	2.6491	2.7642	2.301	2.7642	60.0
2020-07-23	ACWF	ETF	29.48	29.68	29.26	29.39	10879.0
2020-07-23	ACWI	ETF	78.33	78.6	77.33	77.62	1694200.0
2020-07-23	ACWV	ETF	91.24	91.77	90.87	91.06	215700.0
2020-07-23	ACWX	ETF	45.83	46.04	45.44	45.56	1214022.0
2020-07-23	ADME	ETF	33.78	33.795	33.091	33.15	8300.0
2020-07-23	ADRE	ETF	44.23	44.499	43.652	43.8514	3632.0
2020-07-23	AESR	ETF	10.5	10.5	10.35	10.35	2400.0
2020-07-23	AFIF	ETF	9.84	9.87	9.83	9.855	74575.0
2020-07-23	AFK	ETF	17.4273	17.46	17.105	17.1726	4696.0
2020-07-23	AFLG	ETF	19.639	19.639	19.639	19.639	100.0
2020-07-23	AFMC	ETF	17.94	17.94	17.801	17.801	800.0
2020-07-23	AFSM	ETF	17.518	17.518	17.518	17.518	100.0
2020-07-23	AFTY	ETF	18.94	18.94	18.795	18.82	9500.0
2020-07-23	AGG	ETF	119.35	119.39	119.25	119.32	12117200.0
2020-07-23	AGGY	ETF	54.5	54.58	54.465	54.58	85700.0
2020-07-23	AGNG	ETF	25.938	26.08	25.718	25.718	3500.0
2020-07-23	AGQ	ETF	43.96	45.66	42.4	43.5	3662400.0
2020-07-23	AGZ	ETF	121.51	121.58	121.36	121.58	31840.0
2020-07-23	AGZD	ETF	23.7	23.7	23.675	23.685	5200.0
2020-07-23	AIA	ETF	69.31	69.585	68.64	68.82	48704.0
2020-07-23	AIEQ	ETF	30.2	30.44	29.81	29.82	18500.0
2020-07-23	AIQ	ETF	22.04	22.15	21.58	21.61	20705.0
2020-07-23	AIRR	ETF	24.65	24.89	24.65	24.785	4100.0
2020-07-23	AIVI	ETF	37.09	37.09	36.8	36.82	4700.0
2020-07-23	ALTL	ETF	25.46	25.46	25.19	25.2034	1737.0
2020-07-23	ALTY	ETF	10.75	10.78	10.67	10.705	5000.0
2020-07-23	AMJ	ETF	13.18	13.1899	12.9	13.03	1125517.0
2020-07-23	AMLP	ETF	24.42	24.51	23.95	24.28	2059400.0
2020-07-23	AMNA	ETF	23.76	23.85	23.74	23.85	1235.0
2020-07-23	AMND	ETF	25.1	25.28	25.0	25.1327	1200.0
2020-07-23	AMOM	ETF	33.55	33.55	32.115	32.115	1900.0
2020-07-23	AMUB	ETF	8.22	8.29	8.11	8.2143	57664.0
2020-07-23	AMZA	ETF	17.44	17.595	17.019	17.25	67000.0
2020-07-23	ANGL	ETF	30.01	30.06	29.71	29.98	1528500.0
2020-07-23	AOA	ETF	57.24	57.36	56.68	56.82	42000.0
2020-07-23	AOK	ETF	37.19	37.305	37.07	37.14	96469.0

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

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