PREVIEW / etf_daily / 2016-07-15

all etf daily files

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

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-15	SPY	ETF	216.78	217.01	215.31	215.83	107155400.0
2016-07-15	QQQ	ETF	112.22	112.3	111.55	111.8	17999312.0
2016-07-15	IWM	ETF	119.89	120.04	119.28	119.7	23857300.0
2016-07-15	DIA	ETF	185.35	185.5	184.45	184.88	3837200.0
2016-07-15	GLD	ETF	126.38	127.19	126.33	126.84	13892100.0
2016-07-15	TLT	ETF	138.89	139.11	138.18	138.39	9958600.0
2016-07-15	AADR	ETF	39.24	39.66	39.24	39.51	2100.0
2016-07-15	AAXJ	ETF	56.91	56.91	56.58	56.72	554800.0
2016-07-15	ACTX	ETF	4.13	4.13	3.54	4.13	1314.0
2016-07-15	ACWF	ETF	23.2801	23.47	23.28	23.47	8150.0
2016-07-15	ACWI	ETF	57.89	57.94	57.6	57.71	1802700.0
2016-07-15	ACWV	ETF	77.65	77.65	77.21	77.4	202600.0
2016-07-15	ACWX	ETF	40.05	40.12	39.92	39.98	5011370.0
2016-07-15	ADRE	ETF	32.49	32.49	32.3309	32.37	4684.0
2016-07-15	AFK	ETF	20.65	20.65	20.58	20.58	1825.0
2016-07-15	AFTY	ETF	13.09	13.09	13.06	13.08	2100.0
2016-07-15	AGG	ETF	112.58	112.58	112.22	112.26	3612200.0
2016-07-15	AGGY	ETF	51.99	51.99	51.946	51.989	1100.0
2016-07-15	AGQ	ETF	54.11	54.52	53.61	54.07	226600.0
2016-07-15	AGZ	ETF	115.48	117.4	114.176	115.41	66339.0
2016-07-15	AIA	ETF	46.46	46.495	46.31	46.4611	54133.0
2016-07-15	AIQ	ETF	6.1	6.42	6.06	6.06	11656.0
2016-07-15	AIRR	ETF	19.4	19.42	19.33	19.41	6900.0
2016-07-15	AIVI	ETF	38.78	38.78	38.54	38.66	16100.0
2016-07-15	ALTY	ETF	15.31	15.31	15.19	15.19	200.0
2016-07-15	AMJ	ETF	32.26	32.41	31.91	32.08	1553163.0
2016-07-15	AMLP	ETF	65.05	65.05	64.2	64.4	1043420.0
2016-07-15	AMZA	ETF	112.2	114.2	111.5	111.7	10090.0
2016-07-15	ANGL	ETF	28.17	28.36	28.14	28.16	200900.0
2016-07-15	AOA	ETF	46.6	46.64	46.44	46.55	17200.0
2016-07-15	AOK	ETF	33.25	33.25	33.01	33.04	34307.0
2016-07-15	AOM	ETF	35.69	35.69	35.531	35.58	68629.0
2016-07-15	AOR	ETF	40.49	40.49	40.32	40.44	58625.0
2016-07-15	ARGT	ETF	23.18	23.18	22.84	22.94	11100.0
2016-07-15	ARKG	ETF	17.935	17.935	17.935	17.935	400.0
2016-07-15	ARKK	ETF	20.28	20.295	20.22	20.295	1000.0
2016-07-15	ARKQ	ETF	20.14	20.182	20.14	20.182	200.0
2016-07-15	ARKW	ETF	23.44	23.44	23.44	23.44	400.0
2016-07-15	ASEA	ETF	14.0	14.0	13.9	13.98	6100.0
2016-07-15	ASET	ETF	27.21	27.21	27.21	27.21	100.0
2016-07-15	ASHR	ETF	24.68	24.68	24.57	24.62	1098800.0
2016-07-15	ASHS	ETF	35.42	35.42	35.31	35.38	6700.0
2016-07-15	ASHX	ETF	22.57	22.63	22.56	22.6	1752.0
2016-07-15	ATMP	ETF	22.99	22.99	22.6	22.76	41300.0
2016-07-15	BAB	ETF	31.42	31.456	31.28	31.37	160358.0
2016-07-15	BAL	ETF	49.42	49.6	48.91	49.5	18005.0
2016-07-15	BBC	ETF	18.49	18.8009	18.49	18.73	5906.0
2016-07-15	BBH	ETF	107.51	109.34	107.15	108.78	64700.0
2016-07-15	BBP	ETF	28.0	28.654	28.0	28.579	5700.0
2016-07-15	BCM	ETF	27.15	27.15	26.91	26.96	16455.0

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

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