PREVIEW / etf_daily / 2019-02-13

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-13.parquet
  size:    67 KB
  rows:    1,747

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
2019-02-13	SPY	ETF	275.03	275.93	274.56	274.99	65277200.0
2019-02-13	QQQ	ETF	171.62	172.16	170.82	171.01	26094136.0
2019-02-13	IWM	ETF	153.42	153.76	152.7	153.42	15534500.0
2019-02-13	DIA	ETF	255.53	256.56	255.12	255.8	2918200.0
2019-02-13	GLD	ETF	123.84	124.55	123.31	123.37	7640500.0
2019-02-13	TLT	ETF	121.15	121.39	120.91	121.1	4757700.0
2019-02-13	AAAU	ETF	13.1	13.16	13.04	13.05	20700.0
2019-02-13	AADR	ETF	44.63	44.89	44.6	44.6	11100.0
2019-02-13	AAXJ	ETF	69.03	69.06	68.45	68.6	560200.0
2019-02-13	ACES	ETF	26.12	26.159	26.12	26.12	5900.0
2019-02-13	ACSI	ETF	32.06	32.25	32.06	32.207	6272.0
2019-02-13	ACTX	ETF	45.4304	47.7904	45.4304	46.0204	315.0
2019-02-13	ACWF	ETF	28.81	28.86	28.74	28.74	10678.0
2019-02-13	ACWI	ETF	69.96	70.16	69.82	69.83	2355700.0
2019-02-13	ACWV	ETF	86.32	86.37	86.05	86.26	768800.0
2019-02-13	ACWX	ETF	45.07	45.17	44.89	44.89	1467782.0
2019-02-13	ADRE	ETF	39.89	39.9099	39.85	39.89	1451.0
2019-02-13	AFIF	ETF	9.99	10.01	9.97	10.0	12157.0
2019-02-13	AFK	ETF	21.94	21.94	21.72	21.74	10964.0
2019-02-13	AFTY	ETF	15.05	15.22	15.05	15.14	15800.0
2019-02-13	AGG	ETF	107.08	107.14	107.01	107.06	2526100.0
2019-02-13	AGGY	ETF	48.9	48.93	48.85	48.91	95100.0
2019-02-13	AGNG	ETF	21.36	21.36	21.115	21.151	2400.0
2019-02-13	AGQ	ETF	26.83	27.2	26.28	26.32	140500.0
2019-02-13	AGZ	ETF	111.97	112.0793	111.96	111.97	40139.0
2019-02-13	AGZD	ETF	23.87	23.89	23.79	23.89	42400.0
2019-02-13	AIA	ETF	60.56	60.56	60.06	60.25	46673.0
2019-02-13	AIEQ	ETF	25.3	25.49	25.3	25.33	29400.0
2019-02-13	AIQ	ETF	15.12	15.12	15.0147	15.0147	5364.0
2019-02-13	AIRR	ETF	24.57	24.751	24.494	24.68	22400.0
2019-02-13	AIVI	ETF	40.11	40.13	39.95	39.95	5000.0
2019-02-13	ALTY	ETF	14.687	14.691	14.66	14.68	13600.0
2019-02-13	AMJ	ETF	25.1	25.2466	25.01	25.22	986942.0
2019-02-13	AMLP	ETF	49.3	49.8	49.2	49.7	2835920.0
2019-02-13	AMUB	ETF	15.8712	15.8712	15.8712	15.8712	0.0
2019-02-13	AMZA	ETF	58.5	59.4	58.35	59.35	74460.0
2019-02-13	ANGL	ETF	28.3	28.33	28.22	28.24	231500.0
2019-02-13	AOA	ETF	52.12	52.27	52.04	52.04	167100.0
2019-02-13	AOK	ETF	33.76	33.848	33.72	33.72	85417.0
2019-02-13	AOM	ETF	37.16	37.2387	37.12	37.17	328208.0
2019-02-13	AOR	ETF	43.63	43.7052	43.52	43.52	157842.0
2019-02-13	ARGT	ETF	27.95	28.11	27.57	27.61	54400.0
2019-02-13	ARKF	ETF	20.61	20.71	20.57	20.57	24000.0
2019-02-13	ARKG	ETF	28.71	28.9	28.56	28.74	87300.0
2019-02-13	ARKK	ETF	44.45	44.79	44.31	44.54	432800.0
2019-02-13	ARKQ	ETF	34.5	34.68	34.45	34.55	46300.0
2019-02-13	ARKW	ETF	50.72	50.84	50.383	50.47	87800.0
2019-02-13	ASEA	ETF	15.9	15.98	15.9	15.96	3700.0
2019-02-13	ASET	ETF	27.8901	27.8902	27.8202	27.861	3074.0
2019-02-13	ASHR	ETF	25.15	25.29	25.1	25.16	4676700.0

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

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