PREVIEW / etf_daily / 2016-07-12

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-12.parquet
  size:    52 KB
  rows:    1,310

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
2016-07-12	SPY	ETF	214.53	215.3	213.43	214.95	101275600.0
2016-07-12	QQQ	ETF	111.59	111.79	111.34	111.49	21906145.0
2016-07-12	IWM	ETF	119.0	120.42	118.83	119.72	44153000.0
2016-07-12	DIA	ETF	183.01	183.62	182.78	183.39	3128000.0
2016-07-12	GLD	ETF	128.52	128.54	126.99	127.15	26459600.0
2016-07-12	TLT	ETF	140.42	140.86	139.64	140.0	15810600.0
2016-07-12	AADR	ETF	40.0	40.0	40.0	40.0	500.0
2016-07-12	AAXJ	ETF	56.05	56.39	56.01	56.25	947000.0
2016-07-12	ACTX	ETF	4.13	4.13	3.54	4.13	2633.0
2016-07-12	ACWI	ETF	57.38	57.65	57.36	57.5	1666600.0
2016-07-12	ACWV	ETF	77.76	77.76	77.42	77.51	199800.0
2016-07-12	ACWX	ETF	39.78	39.96	39.73	39.81	365223.0
2016-07-12	ADRE	ETF	32.25	32.44	32.16	32.16	6986.0
2016-07-12	AFK	ETF	20.49	20.8	20.45	20.62	44298.0
2016-07-12	AFTY	ETF	13.12	13.18	13.12	13.18	5600.0
2016-07-12	AGG	ETF	112.81	112.81	112.49	112.61	1970600.0
2016-07-12	AGGY	ETF	52.08	52.163	52.0	52.07	12400.0
2016-07-12	AGQ	ETF	55.58	55.94	53.49	54.1	315600.0
2016-07-12	AGZ	ETF	117.44	117.44	115.325	115.49	19458.0
2016-07-12	AGZD	ETF	24.095	24.095	24.095	24.095	400.0
2016-07-12	AIA	ETF	45.55	45.84	45.55	45.75	28185.0
2016-07-12	AIQ	ETF	6.21	6.21	6.05	6.15	10343.0
2016-07-12	AIRR	ETF	19.06	19.463	19.06	19.43	6600.0
2016-07-12	AIVI	ETF	38.46	38.64	38.41	38.48	34200.0
2016-07-12	ALTY	ETF	15.338	15.36	15.306	15.306	1600.0
2016-07-12	AMJ	ETF	31.85	32.62	31.85	32.4	5944449.0
2016-07-12	AMLP	ETF	64.25	65.05	64.05	64.6	2086680.0
2016-07-12	AMZA	ETF	110.2	113.4	110.0	112.3	17200.0
2016-07-12	ANGL	ETF	28.24	28.24	28.01	28.1	366700.0
2016-07-12	AOA	ETF	46.43	46.59	46.36	46.47	45500.0
2016-07-12	AOK	ETF	33.15	33.19	33.0	33.11	57721.0
2016-07-12	AOM	ETF	35.7	35.7	35.54	35.59	92833.0
2016-07-12	AOR	ETF	40.51	40.61	40.2948	40.44	74612.0
2016-07-12	ARGT	ETF	23.03	23.04	22.8	22.95	38900.0
2016-07-12	ARKG	ETF	18.135	18.135	18.135	18.135	200.0
2016-07-12	ARKK	ETF	20.4	20.46	20.4	20.46	700.0
2016-07-12	ARKQ	ETF	20.2	20.24	20.2	20.24	800.0
2016-07-12	ARKW	ETF	23.35	23.46	23.35	23.44	600.0
2016-07-12	ASEA	ETF	13.92	13.92	13.88	13.91	2300.0
2016-07-12	ASHR	ETF	24.61	24.84	24.61	24.79	1428000.0
2016-07-12	ASHS	ETF	35.38	35.4	35.24	35.32	28900.0
2016-07-12	ATMP	ETF	22.44	22.83	22.44	22.71	172600.0
2016-07-12	BAB	ETF	31.64	31.73	31.52	31.62	563857.0
2016-07-12	BAL	ETF	44.99	47.2699	44.99	47.15	50721.0
2016-07-12	BBC	ETF	19.22	19.65	19.22	19.4101	8490.0
2016-07-12	BBH	ETF	108.67	109.27	108.35	108.46	94900.0
2016-07-12	BBP	ETF	28.83	28.97	28.712	28.712	5800.0
2016-07-12	BCM	ETF	27.0	27.32	27.0	27.27	92225.0
2016-07-12	BFIT	ETF	15.7058	15.7058	15.7058	15.7058	1000.0
2016-07-12	BFOR	ETF	7.865	7.9375	7.865	7.9175	54800.0

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

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