PREVIEW / etf_daily / 2017-04-11

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-11.parquet
  size:    54 KB
  rows:    1,375

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
2017-04-11	SPY	ETF	234.9	235.18	233.34	235.06	88045300.0
2017-04-11	QQQ	ETF	131.86	132.095	130.5	131.45	33778359.0
2017-04-11	IWM	ETF	135.27	136.92	135.08	136.9	32589200.0
2017-04-11	DIA	ETF	206.22	206.42	204.94	206.33	3511500.0
2017-04-11	GLD	ETF	120.33	121.4	120.29	121.19	12455300.0
2017-04-11	TLT	ETF	121.8	122.65	121.72	122.42	11297400.0
2017-04-11	AADR	ETF	46.77	46.77	45.98	46.3	29400.0
2017-04-11	AAXJ	ETF	62.78	62.81	62.29	62.59	2663100.0
2017-04-11	ACSI	ETF	27.78	27.92	27.78	27.92	759.0
2017-04-11	ACTX	ETF	108.561	110.331	102.0709	107.971	1383.0
2017-04-11	ACWF	ETF	25.45	25.45	25.44	25.44	1000.0
2017-04-11	ACWI	ETF	63.13	63.19	62.72	63.16	1235200.0
2017-04-11	ACWV	ETF	77.23	77.37	77.03	77.37	147500.0
2017-04-11	ACWX	ETF	43.52	43.545	43.22	43.54	427409.0
2017-04-11	ADRE	ETF	36.7	36.7	36.11	36.3445	15843.0
2017-04-11	AFK	ETF	20.95	21.0299	20.86	20.86	13484.0
2017-04-11	AFTY	ETF	13.8	13.8	13.795	13.795	1300.0
2017-04-11	AGG	ETF	108.76	108.98	108.75	108.89	2200800.0
2017-04-11	AGGY	ETF	50.04	50.17	50.04	50.15	11900.0
2017-04-11	AGQ	ETF	40.46	41.65	40.43	41.5	143100.0
2017-04-11	AGZ	ETF	113.26	113.4748	113.22	113.3	14169.0
2017-04-11	AGZD	ETF	24.005	24.005	23.975	24.0	12400.0
2017-04-11	AIA	ETF	52.2	52.2	51.82	52.07	88255.0
2017-04-11	AIQ	ETF	12.55	13.05	12.55	12.75	297790.0
2017-04-11	AIRR	ETF	23.84	24.2	23.84	24.2	53700.0
2017-04-11	AIVI	ETF	39.56	39.65	39.39	39.61	14700.0
2017-04-11	ALTY	ETF	15.49	15.5	15.49	15.5	400.0
2017-04-11	AMJ	ETF	32.52	32.63	32.28	32.32	1177955.0
2017-04-11	AMLP	ETF	63.7	64.0	63.6	63.65	1155000.0
2017-04-11	AMZA	ETF	107.0	107.1	106.0	106.2	68340.0
2017-04-11	ANGL	ETF	29.59	29.61	29.42	29.52	220800.0
2017-04-11	AOA	ETF	49.71	49.77	49.46	49.77	70600.0
2017-04-11	AOK	ETF	33.33	33.37	33.25	33.37	48165.0
2017-04-11	AOM	ETF	36.28	36.36	36.184	36.36	71326.0
2017-04-11	AOR	ETF	42.19	42.22	42.0372	42.15	93298.0
2017-04-11	ARCM	ETF	100.0	100.0	100.0	100.0	3000.0
2017-04-11	ARGT	ETF	29.1	29.2	29.03	29.18	28600.0
2017-04-11	ARKG	ETF	20.34	20.34	19.974	20.032	1300.0
2017-04-11	ARKK	ETF	24.03	24.05	23.814	24.027	8800.0
2017-04-11	ARKQ	ETF	24.72	24.78	24.56	24.743	4800.0
2017-04-11	ARKW	ETF	29.2	29.2	29.0	29.17	5000.0
2017-04-11	ASEA	ETF	14.39	14.39	14.32	14.32	900.0
2017-04-11	ASHR	ETF	25.39	25.42	25.31	25.38	506600.0
2017-04-11	ASHS	ETF	34.24	34.78	34.24	34.78	700.0
2017-04-11	ASHX	ETF	19.82	19.82	19.8199	19.8199	252.0
2017-04-11	ATMP	ETF	24.13	24.14	23.8	23.81	105000.0
2017-04-11	BAB	ETF	29.46	29.58	29.46	29.53	79162.0
2017-04-11	BAL	ETF	48.35	48.79	48.29	48.4	3220.0
2017-04-11	BBC	ETF	21.8	21.8035	21.36	21.64	5592.0
2017-04-11	BBH	ETF	117.82	118.29	116.96	117.84	26600.0

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

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