PREVIEW / etf_daily / 2016-07-25

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-25.parquet
  size:    51 KB
  rows:    1,284

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-25	SPY	ETF	217.0	217.06	215.97	216.65	55873100.0
2016-07-25	QQQ	ETF	113.56	113.69	113.28	113.66	12968085.0
2016-07-25	IWM	ETF	120.15	120.46	119.76	120.22	13694600.0
2016-07-25	DIA	ETF	185.27	185.3	184.37	184.81	2316600.0
2016-07-25	GLD	ETF	125.53	126.21	125.11	125.47	13139400.0
2016-07-25	TLT	ETF	138.94	139.26	138.59	138.7	4243800.0
2016-07-25	AADR	ETF	40.69	40.69	40.57	40.59	800.0
2016-07-25	AAXJ	ETF	56.99	57.11	56.77	56.82	429400.0
2016-07-25	ACTX	ETF	3.54	4.13	2.95	4.13	2887.0
2016-07-25	ACWI	ETF	57.97	58.01	57.66	57.81	1242400.0
2016-07-25	ACWV	ETF	77.65	77.65	77.3	77.54	222800.0
2016-07-25	ACWX	ETF	40.0	40.05	39.83	39.9	291215.0
2016-07-25	ADRE	ETF	32.84	32.84	32.6501	32.6983	3057.0
2016-07-25	AFK	ETF	19.83	20.15	19.72	19.72	21935.0
2016-07-25	AFTY	ETF	12.99	13.02	12.99	13.0	5100.0
2016-07-25	AGG	ETF	112.58	112.58	112.4	112.4	1680800.0
2016-07-25	AGGY	ETF	51.95	51.97	51.829	51.89	5900.0
2016-07-25	AGQ	ETF	50.48	51.84	49.8	50.78	210400.0
2016-07-25	AGZ	ETF	115.49	115.649	115.3701	115.54	11758.0
2016-07-25	AGZD	ETF	23.95	23.95	23.805	23.895	4200.0
2016-07-25	AIA	ETF	46.72	46.73	46.51	46.59	31312.0
2016-07-25	AIQ	ETF	6.29	6.29	5.9	5.93	36126.0
2016-07-25	AIRR	ETF	19.18	19.18	19.13	19.15	1200.0
2016-07-25	AIVI	ETF	38.33	38.37	38.14	38.26	19400.0
2016-07-25	ALTY	ETF	15.45	15.58	15.45	15.57	2900.0
2016-07-25	AMJ	ETF	32.08	32.3	31.93	32.0	943668.0
2016-07-25	AMLP	ETF	64.35	64.45	64.1	64.3	702280.0
2016-07-25	AMZA	ETF	112.3	113.5	111.5	112.3	7580.0
2016-07-25	ANGL	ETF	28.35	28.35	28.25	28.25	178400.0
2016-07-25	AOA	ETF	46.71	46.71	46.49	46.6	13900.0
2016-07-25	AOK	ETF	33.24	33.24	33.0501	33.1	42583.0
2016-07-25	AOM	ETF	35.79	35.79	35.551	35.64	56518.0
2016-07-25	AOR	ETF	40.68	40.68	40.4	40.47	64495.0
2016-07-25	ARGT	ETF	22.76	22.76	22.32	22.47	29100.0
2016-07-25	ARKG	ETF	18.0	18.0	18.0	18.0	600.0
2016-07-25	ARKK	ETF	20.1	20.125	20.1	20.125	800.0
2016-07-25	ARKQ	ETF	20.54	20.54	20.47	20.47	500.0
2016-07-25	ARKW	ETF	23.91	23.91	23.7	23.82	1400.0
2016-07-25	ASEA	ETF	13.9	13.9	13.81	13.82	4600.0
2016-07-25	ASHR	ETF	24.42	24.47	24.28	24.28	372000.0
2016-07-25	ASHS	ETF	35.25	35.29	35.24	35.24	12400.0
2016-07-25	ATMP	ETF	22.68	22.73	22.49	22.54	42900.0
2016-07-25	BAB	ETF	31.49	31.54	31.4201	31.49	162850.0
2016-07-25	BAL	ETF	47.91	48.35	47.91	48.19	8527.0
2016-07-25	BBC	ETF	19.1	19.409	19.07	19.33	5977.0
2016-07-25	BBH	ETF	111.96	112.81	111.2	112.62	76000.0
2016-07-25	BBP	ETF	29.79	30.04	29.676	30.01	4000.0
2016-07-25	BCM	ETF	26.01	26.01	25.88	25.92	43438.0
2016-07-25	BFOR	ETF	7.9775	7.985	7.97	7.98	34800.0
2016-07-25	BIB	ETF	45.92	46.75	45.46	46.59	461389.0

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

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