PREVIEW / etf_daily / 2017-04-06

all etf daily files

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

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-06	SPY	ETF	234.94	236.04	234.43	235.44	69135800.0
2017-04-06	QQQ	ETF	132.12	132.39	131.7	132.04	18832193.0
2017-04-06	IWM	ETF	134.54	135.63	133.83	135.58	41012100.0
2017-04-06	DIA	ETF	206.45	207.29	205.92	206.45	3186900.0
2017-04-06	GLD	ETF	119.22	119.42	118.98	119.18	4633500.0
2017-04-06	TLT	ETF	121.24	121.41	120.52	121.2	6497000.0
2017-04-06	AADR	ETF	46.67	46.87	46.42	46.69	5500.0
2017-04-06	AAXJ	ETF	63.3	63.3	63.06	63.22	412100.0
2017-04-06	ACSI	ETF	27.82	27.94	27.82	27.9099	1580.0
2017-04-06	ACTX	ETF	104.4309	110.921	104.4309	106.201	568.0
2017-04-06	ACWI	ETF	63.14	63.28	63.01	63.16	1652600.0
2017-04-06	ACWV	ETF	77.32	77.33	77.17	77.29	132300.0
2017-04-06	ACWX	ETF	43.51	43.55	43.3991	43.46	440083.0
2017-04-06	ADRE	ETF	36.69	36.7196	36.5092	36.5092	4328.0
2017-04-06	AFK	ETF	20.69	20.9579	20.67	20.84	4170.0
2017-04-06	AGG	ETF	108.64	108.71	108.48	108.68	1725300.0
2017-04-06	AGGY	ETF	49.995	49.995	49.86	49.969	12000.0
2017-04-06	AGQ	ETF	41.11	41.54	40.97	41.34	52800.0
2017-04-06	AGZ	ETF	113.15	113.185	113.0329	113.115	5783.0
2017-04-06	AGZD	ETF	24.02	24.02	24.01	24.01	2000.0
2017-04-06	AIA	ETF	52.96	52.96	52.72	52.7775	38541.0
2017-04-06	AIQ	ETF	10.15	10.15	10.05	10.05	901.0
2017-04-06	AIRR	ETF	23.46	23.768	23.414	23.75	20900.0
2017-04-06	AIVI	ETF	39.42	39.56	39.39	39.45	18500.0
2017-04-06	ALTY	ETF	15.44	15.44	15.421	15.436	2700.0
2017-04-06	AMJ	ETF	32.23	32.6799	32.155	32.67	736516.0
2017-04-06	AMLP	ETF	63.55	64.2	63.55	64.0	1664560.0
2017-04-06	AMZA	ETF	106.5	107.4	106.5	107.4	52130.0
2017-04-06	ANGL	ETF	29.45	29.54	29.42	29.52	861400.0
2017-04-06	AOA	ETF	49.7	49.78	49.61	49.72	42600.0
2017-04-06	AOK	ETF	33.3	33.31	33.25	33.31	60975.0
2017-04-06	AOM	ETF	36.34	36.34	36.1901	36.3	61597.0
2017-04-06	AOR	ETF	42.16	42.21	42.1	42.21	55297.0
2017-04-06	ARCM	ETF	100.05	100.05	100.05	100.05	2100.0
2017-04-06	ARGT	ETF	28.49	28.9	28.49	28.8	37600.0
2017-04-06	ARKG	ETF	20.01	20.01	19.892	20.0	4300.0
2017-04-06	ARKK	ETF	23.81	23.83	23.63	23.766	6400.0
2017-04-06	ARKQ	ETF	24.33	24.59	24.33	24.59	4800.0
2017-04-06	ARKW	ETF	28.93	29.01	28.85	28.999	4300.0
2017-04-06	ASEA	ETF	14.19	14.21	14.07	14.15	29500.0
2017-04-06	ASET	ETF	26.6573	26.69	26.6573	26.6898	315.0
2017-04-06	ASHR	ETF	25.56	25.56	25.45	25.45	328200.0
2017-04-06	ASHS	ETF	34.61	34.61	34.49	34.49	5200.0
2017-04-06	ATMP	ETF	23.76	24.15	23.76	24.15	8600.0
2017-04-06	BAB	ETF	29.42	29.49	29.31	29.37	85417.0
2017-04-06	BAL	ETF	48.42	48.42	48.2911	48.31	1291.0
2017-04-06	BBC	ETF	21.85	21.8704	21.515	21.66	12696.0
2017-04-06	BBH	ETF	117.57	117.82	117.06	117.58	31800.0
2017-04-06	BBP	ETF	36.56	36.56	36.24	36.49	20700.0
2017-04-06	BCD	ETF	25.16	25.21	25.137	25.185	1700.0

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

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