PREVIEW / etf_daily / 2017-04-10

all etf daily files

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

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-10	SPY	ETF	235.36	236.26	234.73	235.34	67615300.0
2017-04-10	QQQ	ETF	132.11	132.565	131.6564	132.02	15619276.0
2017-04-10	IWM	ETF	135.47	136.85	135.16	135.82	22779900.0
2017-04-10	DIA	ETF	206.49	207.32	205.95	206.39	2395200.0
2017-04-10	GLD	ETF	119.04	119.69	118.85	119.46	4623700.0
2017-04-10	TLT	ETF	121.14	121.62	121.0	121.27	5314500.0
2017-04-10	AADR	ETF	46.5	46.62	46.4	46.58	9300.0
2017-04-10	AAXJ	ETF	62.9	62.93	62.74	62.86	637800.0
2017-04-10	ACSI	ETF	28.0088	28.0088	27.9276	27.9604	1575.0
2017-04-10	ACTX	ETF	109.151	111.511	106.201	107.027	1147.0
2017-04-10	ACWF	ETF	25.57	25.5851	25.55	25.55	7806.0
2017-04-10	ACWI	ETF	63.1	63.24	62.96	63.08	1817800.0
2017-04-10	ACWV	ETF	77.16	77.3	77.05	77.16	162400.0
2017-04-10	ACWX	ETF	43.39	43.43	43.3147	43.37	532418.0
2017-04-10	ADRE	ETF	36.62	36.62	36.4988	36.608	2227.0
2017-04-10	AFK	ETF	21.18	21.18	20.95	20.95	10431.0
2017-04-10	AFTY	ETF	13.9	13.9	13.77	13.77	4100.0
2017-04-10	AGG	ETF	108.53	108.65	108.49	108.58	1903800.0
2017-04-10	AGGY	ETF	49.937	49.985	49.92	49.96	6800.0
2017-04-10	AGNG	ETF	17.22	17.22	17.09	17.09	200.0
2017-04-10	AGQ	ETF	39.63	40.09	39.13	39.94	153900.0
2017-04-10	AGZ	ETF	113.0889	113.2	113.0105	113.16	28331.0
2017-04-10	AIA	ETF	52.43	52.466	52.33	52.4	30536.0
2017-04-10	AIQ	ETF	10.0	10.15	10.0	10.05	5124.0
2017-04-10	AIRR	ETF	23.98	24.198	23.76	23.9	30800.0
2017-04-10	AIVI	ETF	39.33	39.46	39.33	39.37	12600.0
2017-04-10	ALTY	ETF	15.499	15.53	15.499	15.53	700.0
2017-04-10	AMJ	ETF	32.67	32.6857	32.515	32.53	574652.0
2017-04-10	AMLP	ETF	64.2	64.25	63.8	63.8	1495460.0
2017-04-10	AMZA	ETF	107.5	107.5	106.7	106.8	62340.0
2017-04-10	ANGL	ETF	29.61	29.61	29.56	29.6	355000.0
2017-04-10	AOA	ETF	49.65	49.73	49.59	49.66	49700.0
2017-04-10	AOK	ETF	33.27	33.29	33.24	33.29	59283.0
2017-04-10	AOM	ETF	36.24	36.28	36.2	36.27	62276.0
2017-04-10	AOR	ETF	42.09	42.1999	42.076	42.12	45821.0
2017-04-10	ARCM	ETF	100.0	100.0	100.0	100.0	2000.0
2017-04-10	ARGT	ETF	28.8	29.07	28.8	29.01	131900.0
2017-04-10	ARKG	ETF	20.48	20.48	20.363	20.363	1700.0
2017-04-10	ARKK	ETF	24.218	24.23	24.087	24.087	4500.0
2017-04-10	ARKQ	ETF	24.86	24.865	24.746	24.75	10800.0
2017-04-10	ARKW	ETF	29.23	29.32	29.14	29.17	8300.0
2017-04-10	ASEA	ETF	14.27	14.65	14.21	14.32	61500.0
2017-04-10	ASET	ETF	26.71	26.72	26.71	26.72	261.0
2017-04-10	ASHR	ETF	25.3	25.32	25.23	25.23	506600.0
2017-04-10	ASHS	ETF	34.48	34.48	34.39	34.39	600.0
2017-04-10	ATMP	ETF	24.06	24.15	23.92	23.92	67800.0
2017-04-10	BAB	ETF	29.4	29.46	29.4	29.45	52932.0
2017-04-10	BAL	ETF	47.97	48.68	47.85	48.63	24663.0
2017-04-10	BBC	ETF	21.92	22.2499	21.77	21.77	11108.0
2017-04-10	BBH	ETF	118.81	118.81	117.96	118.05	58000.0

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

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