PREVIEW / etf_daily / 2020-04-15

all etf daily files

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

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-15	SPY	ETF	277.57	283.94	275.46	277.76	121775000.0
2020-04-15	QQQ	ETF	208.48	211.8338	207.12	209.43	47035953.0
2020-04-15	IWM	ETF	117.86	119.11	116.66	117.8	34809900.0
2020-04-15	DIA	ETF	234.48	236.58	232.39	235.08	6828000.0
2020-04-15	GLD	ETF	161.8	162.54	160.81	161.85	12141900.0
2020-04-15	TLT	ETF	166.8	168.6	166.74	168.18	10027800.0
2020-04-15	AAAU	ETF	17.17	17.22	17.05	17.19	218000.0
2020-04-15	AADR	ETF	43.48	43.56	43.1	43.52	5700.0
2020-04-15	AAXJ	ETF	61.88	62.06	61.48	61.75	1246000.0
2020-04-15	ABEQ	ETF	21.34	21.35	19.98	21.142	41200.0
2020-04-15	ACES	ETF	31.55	31.99	30.7	30.93	22800.0
2020-04-15	ACIO	ETF	23.78	23.78	23.648	23.695	7800.0
2020-04-15	ACSI	ETF	29.8	29.9459	29.8	29.9459	1002.0
2020-04-15	ACTX	ETF	5.7821	5.7821	4.543	4.543	212.0
2020-04-15	ACWF	ETF	25.35	25.495	25.14	25.22	17139.0
2020-04-15	ACWI	ETF	65.74	66.18	65.37	65.73	4626000.0
2020-04-15	ACWV	ETF	85.29	85.9	85.0	85.36	436200.0
2020-04-15	ACWX	ETF	38.45	38.67	38.265	38.4	1819028.0
2020-04-15	ADME	ETF	29.91	29.91	29.34	29.635	21200.0
2020-04-15	ADRE	ETF	34.79	35.2355	34.68	35.0794	6171.0
2020-04-15	AESR	ETF	8.935	9.01	8.935	8.936	268200.0
2020-04-15	AFIF	ETF	10.08	10.08	9.77	9.82	358234.0
2020-04-15	AFK	ETF	14.2	14.24	13.51	14.03	29491.0
2020-04-15	AFLG	ETF	16.87	16.889	16.8	16.889	200.0
2020-04-15	AFSM	ETF	14.16	14.16	14.121	14.121	300.0
2020-04-15	AFTY	ETF	15.245	15.245	15.205	15.206	700.0
2020-04-15	AGG	ETF	117.03	117.31	116.71	117.24	4367400.0
2020-04-15	AGGY	ETF	53.31	53.31	53.05	53.2	305700.0
2020-04-15	AGNG	ETF	21.53	21.698	21.41	21.551	3200.0
2020-04-15	AGQ	ETF	22.53	22.53	21.74	22.32	328400.0
2020-04-15	AGZ	ETF	120.18	120.55	120.18	120.35	73499.0
2020-04-15	AGZD	ETF	23.48	23.57	23.4	23.46	12800.0
2020-04-15	AIA	ETF	57.55	57.655	57.1469	57.53	110735.0
2020-04-15	AIEQ	ETF	24.11	24.587	24.0	24.56	13900.0
2020-04-15	AIQ	ETF	16.86	16.9	16.68	16.81	7753.0
2020-04-15	AIRR	ETF	20.26	20.31	19.93	19.977	17500.0
2020-04-15	AIVI	ETF	32.18	32.18	31.95	31.99	18000.0
2020-04-15	ALTY	ETF	9.42	9.587	9.33	9.39	11800.0
2020-04-15	AMJ	ETF	10.37	10.64	10.18	10.54	9413793.0
2020-04-15	AMLP	ETF	19.95	20.1	19.25	20.0	5623140.0
2020-04-15	AMOM	ETF	24.48	24.496	24.465	24.465	400.0
2020-04-15	AMUB	ETF	6.52	6.6596	6.5102	6.6423	2939.0
2020-04-15	AMZA	ETF	13.5	13.5	12.65	13.06	136400.0
2020-04-15	ANGL	ETF	27.16	27.59	27.02	27.32	1059000.0
2020-04-15	AOA	ETF	49.56	49.76	49.29	49.47	87900.0
2020-04-15	AOK	ETF	34.65	34.86	34.6	34.78	151031.0
2020-04-15	AOM	ETF	37.56	37.74	37.42	37.54	289634.0
2020-04-15	AOR	ETF	42.86	42.96	42.5857	42.71	242772.0
2020-04-15	ARGT	ETF	17.18	17.82	16.79	17.82	12500.0
2020-04-15	ARKF	ETF	22.16	22.388	21.961	22.34	51800.0

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

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