PREVIEW / etf_daily / 2016-09-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-15.parquet
  size:    51 KB
  rows:    1,287

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-09-15	SPY	ETF	212.96	215.73	212.75	215.28	134427900.0
2016-09-15	QQQ	ETF	115.89	117.815	115.86	117.64	39466531.0
2016-09-15	IWM	ETF	120.68	122.19	120.51	122.04	29499800.0
2016-09-15	DIA	ETF	180.37	182.62	180.23	182.26	3932400.0
2016-09-15	GLD	ETF	125.73	126.1	124.91	125.37	12790400.0
2016-09-15	TLT	ETF	133.61	134.05	133.03	133.67	9874500.0
2016-09-15	AADR	ETF	39.37	39.65	39.37	39.65	26200.0
2016-09-15	AAXJ	ETF	58.95	59.71	58.76	59.64	2046000.0
2016-09-15	ACTX	ETF	4.72	7.0801	4.72	5.7821	8767.0
2016-09-15	ACWI	ETF	57.7	58.34	57.58	58.25	1450400.0
2016-09-15	ACWV	ETF	74.73	75.42	74.56	75.29	74100.0
2016-09-15	ACWX	ETF	40.47	40.9226	40.41	40.86	427264.0
2016-09-15	ADRE	ETF	34.03	34.415	33.887	34.31	5831.0
2016-09-15	AFTY	ETF	13.43	13.454	13.43	13.454	600.0
2016-09-15	AGG	ETF	111.6	111.76	111.49	111.72	2253800.0
2016-09-15	AGGY	ETF	51.6	51.69	51.52	51.65	25600.0
2016-09-15	AGQ	ETF	47.32	47.96	46.54	47.39	132500.0
2016-09-15	AGZ	ETF	115.03	115.24	114.95	115.11	17744.0
2016-09-15	AGZD	ETF	23.88	23.88	23.88	23.88	400.0
2016-09-15	AIA	ETF	48.45	49.1399	48.45	48.98	86593.0
2016-09-15	AIQ	ETF	6.3092	6.39	6.25	6.3	7145.0
2016-09-15	AIRR	ETF	19.09	19.4	19.09	19.4	1500.0
2016-09-15	AIVI	ETF	38.01	38.35	37.98	38.31	13700.0
2016-09-15	ALTY	ETF	15.55	15.55	15.39	15.4	400.0
2016-09-15	AMJ	ETF	29.98	30.2099	29.77	29.83	1957696.0
2016-09-15	AMLP	ETF	60.85	61.15	60.25	60.4	3118620.0
2016-09-15	AMZA	ETF	111.3	112.7	111.0	111.4	12000.0
2016-09-15	ANGL	ETF	28.29	28.39	28.24	28.32	212500.0
2016-09-15	AOA	ETF	46.53	47.01	46.48	46.94	39200.0
2016-09-15	AOK	ETF	32.89	33.0844	32.8201	33.06	65423.0
2016-09-15	AOM	ETF	35.56	35.7399	35.41	35.71	64903.0
2016-09-15	AOR	ETF	40.43	40.7	40.3301	40.67	51906.0
2016-09-15	ARGT	ETF	22.25	22.67	22.19	22.67	15400.0
2016-09-15	ARKG	ETF	19.37	19.37	19.25	19.25	300.0
2016-09-15	ARKK	ETF	20.96	21.2	20.96	21.2	300.0
2016-09-15	ARKQ	ETF	20.99	21.105	20.99	21.105	6400.0
2016-09-15	ARKW	ETF	24.2	24.49	24.2	24.49	900.0
2016-09-15	ASEA	ETF	13.78	13.8	13.78	13.8	1600.0
2016-09-15	ASET	ETF	26.11	26.19	26.11	26.19	200.0
2016-09-15	ASHR	ETF	24.4	24.65	24.4	24.61	805200.0
2016-09-15	ASHS	ETF	34.48	34.62	34.27	34.56	16700.0
2016-09-15	ASHX	ETF	22.34	22.34	22.31	22.31	1600.0
2016-09-15	ATMP	ETF	22.38	22.4	22.0	22.0	33900.0
2016-09-15	BAB	ETF	31.03	31.0767	30.9	30.98	154633.0
2016-09-15	BAL	ETF	44.39	44.9	44.39	44.9	9210.0
2016-09-15	BBC	ETF	21.52	21.9	21.4799	21.85	13856.0
2016-09-15	BBH	ETF	114.94	116.56	114.44	116.3	35200.0
2016-09-15	BBP	ETF	32.124	32.71	32.124	32.652	8100.0
2016-09-15	BCM	ETF	25.576	25.63	25.5601	25.6172	3391.0
2016-09-15	BFIT	ETF	15.7	15.7	15.7	15.7	200.0

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

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