PREVIEW / etf_daily / 2016-09-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-26.parquet
  size:    52 KB
  rows:    1,314

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-26	SPY	ETF	215.02	215.23	214.01	214.24	89827300.0
2016-09-26	QQQ	ETF	117.66	117.8	117.17	117.34	16403881.0
2016-09-26	IWM	ETF	123.8	124.17	123.1	123.23	20028000.0
2016-09-26	DIA	ETF	181.51	181.55	180.58	180.75	2639800.0
2016-09-26	GLD	ETF	127.96	128.04	127.42	127.55	5842700.0
2016-09-26	TLT	ETF	137.07	137.83	137.02	137.69	8661300.0
2016-09-26	AADR	ETF	40.02	40.02	39.95	39.95	2800.0
2016-09-26	AAXJ	ETF	60.1	60.21	59.86	59.87	663600.0
2016-09-26	ACTX	ETF	6.4311	6.4901	5.9001	6.2541	269.0
2016-09-26	ACWF	ETF	24.11	24.11	24.11	24.11	159.0
2016-09-26	ACWI	ETF	58.71	58.81	58.55	58.6	1320500.0
2016-09-26	ACWV	ETF	76.26	76.39	76.16	76.21	309600.0
2016-09-26	ACWX	ETF	41.27	41.3	41.12	41.12	527450.0
2016-09-26	ADRE	ETF	34.79	34.79	34.45	34.49	6700.0
2016-09-26	AFK	ETF	20.67	20.7	20.48	20.5	50722.0
2016-09-26	AFTY	ETF	13.3	13.3	13.3	13.3	400.0
2016-09-26	AGG	ETF	112.28	112.45	112.28	112.37	2326900.0
2016-09-26	AGGY	ETF	51.91	52.01	51.91	51.98	2400.0
2016-09-26	AGQ	ETF	50.36	50.61	49.03	49.15	131800.0
2016-09-26	AGZ	ETF	115.51	115.662	115.4601	115.58	6800.0
2016-09-26	AGZD	ETF	23.92	23.92	23.87	23.87	600.0
2016-09-26	AIA	ETF	49.37	49.46	49.22	49.22	55883.0
2016-09-26	AIQ	ETF	6.74	7.07	6.46	6.46	20595.0
2016-09-26	AIRR	ETF	19.99	19.99	19.954	19.954	4300.0
2016-09-26	AIVI	ETF	38.26	38.39	38.22	38.27	40900.0
2016-09-26	ALTY	ETF	15.94	15.94	15.74	15.765	26000.0
2016-09-26	AMJ	ETF	31.28	31.52	31.1145	31.16	1162698.0
2016-09-26	AMLP	ETF	63.25	63.35	62.7	62.8	1119160.0
2016-09-26	AMZA	ETF	115.3	115.62	114.4	114.4	12280.0
2016-09-26	ANGL	ETF	28.74	28.74	28.55	28.6	252800.0
2016-09-26	AOA	ETF	47.35	47.35	47.11	47.13	30000.0
2016-09-26	AOK	ETF	33.23	33.3199	33.23	33.27	32638.0
2016-09-26	AOM	ETF	35.94	35.9999	35.781	35.92	67961.0
2016-09-26	AOR	ETF	40.99	40.99	40.8201	40.86	29969.0
2016-09-26	ARGT	ETF	23.23	23.28	23.04	23.05	30300.0
2016-09-26	ARKG	ETF	20.08	20.08	20.05	20.05	1100.0
2016-09-26	ARKK	ETF	21.71	21.71	21.69	21.69	500.0
2016-09-26	ARKQ	ETF	21.6	21.654	21.6	21.63	500.0
2016-09-26	ARKW	ETF	24.98	25.05	24.98	25.03	2500.0
2016-09-26	ASEA	ETF	13.99	13.99	13.99	13.99	400.0
2016-09-26	ASET	ETF	26.74	26.74	26.74	26.74	121.0
2016-09-26	ASHR	ETF	24.16	24.18	24.07	24.12	1081500.0
2016-09-26	ASHS	ETF	33.89	33.97	33.88	33.9	11700.0
2016-09-26	ATMP	ETF	22.99	23.19	22.88	22.96	18600.0
2016-09-26	BAB	ETF	31.34	31.43	31.313	31.4	247735.0
2016-09-26	BAL	ETF	46.61	46.66	46.489	46.59	2980.0
2016-09-26	BBC	ETF	22.921	23.05	22.85	22.89	2367.0
2016-09-26	BBH	ETF	117.86	117.86	116.83	117.02	67500.0
2016-09-26	BBP	ETF	34.5	34.5	33.959	33.97	8300.0
2016-09-26	BCM	ETF	26.052	26.052	26.0328	26.0328	3833.0

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

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