PREVIEW / etf_daily / 2016-11-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-01.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-11-01	SPY	ETF	212.93	212.99	209.6	211.01	122781800.0
2016-11-01	QQQ	ETF	117.19	117.21	115.1047	116.11	23498712.0
2016-11-01	IWM	ETF	118.66	118.7	116.28	117.05	34147200.0
2016-11-01	DIA	ETF	181.52	181.52	179.14	180.12	3622300.0
2016-11-01	GLD	ETF	122.8	123.21	122.57	122.73	13384300.0
2016-11-01	TLT	ETF	130.16	131.6	129.88	131.01	12622400.0
2016-11-01	AADR	ETF	41.68	41.78	40.86	40.98	5000.0
2016-11-01	AAXJ	ETF	59.24	59.29	58.41	58.78	682000.0
2016-11-01	ACSI	ETF	24.99	24.99	24.68	24.78	20088.0
2016-11-01	ACTX	ETF	14.1601	14.4551	11.2101	12.3901	1907.0
2016-11-01	ACWF	ETF	23.97	23.97	23.58	23.63	2130.0
2016-11-01	ACWI	ETF	58.14	58.17	57.29	57.61	3575900.0
2016-11-01	ACWV	ETF	74.01	74.01	73.28	73.43	163700.0
2016-11-01	ACWX	ETF	40.89	40.89	40.41	40.59	742600.0
2016-11-01	ADRE	ETF	35.37	35.37	34.581	34.86	12741.0
2016-11-01	AFK	ETF	20.8	20.8	20.57	20.65	13664.0
2016-11-01	AFTY	ETF	13.56	13.56	13.56	13.56	500.0
2016-11-01	AGG	ETF	110.88	111.13	110.82	111.03	4725000.0
2016-11-01	AGGY	ETF	51.26	51.35	51.214	51.26	6300.0
2016-11-01	AGQ	ETF	43.46	44.36	43.25	43.73	244100.0
2016-11-01	AGZ	ETF	114.76	115.1899	114.658	114.91	30323.0
2016-11-01	AIA	ETF	49.47	49.47	48.71	49.03	54884.0
2016-11-01	AIQ	ETF	8.2	8.6	7.95	8.4	16643.0
2016-11-01	AIRR	ETF	19.43	19.43	19.08	19.15	6700.0
2016-11-01	AIVI	ETF	37.75	37.75	37.37	37.47	15000.0
2016-11-01	ALTY	ETF	14.8	14.8	14.734	14.734	600.0
2016-11-01	AMJ	ETF	30.2	30.42	29.74	29.82	1847468.0
2016-11-01	AMLP	ETF	61.6	61.75	60.65	60.8	1580500.0
2016-11-01	AMZA	ETF	106.6	107.1	105.6	105.8	17020.0
2016-11-01	ANGL	ETF	28.63	28.74	28.48	28.52	205600.0
2016-11-01	AOA	ETF	46.83	46.83	46.15	46.34	104000.0
2016-11-01	AOK	ETF	32.86	32.9099	32.7355	32.81	51400.0
2016-11-01	AOM	ETF	35.52	35.52	35.2369	35.34	95213.0
2016-11-01	AOR	ETF	40.51	40.51	40.05	40.2	86382.0
2016-11-01	ARGT	ETF	23.8	23.94	23.5	23.69	31200.0
2016-11-01	ARKG	ETF	16.62	16.78	16.54	16.54	65800.0
2016-11-01	ARKK	ETF	20.06	20.06	19.698	19.719	2600.0
2016-11-01	ARKQ	ETF	20.8	20.8	20.439	20.5	2600.0
2016-11-01	ARKW	ETF	24.321	24.389	24.321	24.378	1000.0
2016-11-01	ASEA	ETF	13.6	13.62	13.48	13.48	7000.0
2016-11-01	ASHR	ETF	24.84	24.84	24.68	24.82	548200.0
2016-11-01	ASHS	ETF	34.65	34.86	34.51	34.66	9800.0
2016-11-01	ATMP	ETF	22.62	22.62	22.04	22.11	36600.0
2016-11-01	BAB	ETF	30.67	30.78	30.658	30.78	306836.0
2016-11-01	BAL	ETF	45.49	46.1547	45.15	46.1547	4374.0
2016-11-01	BBC	ETF	18.14	18.3527	17.82	18.2248	65209.0
2016-11-01	BBH	ETF	102.82	104.13	102.19	103.89	187500.0
2016-11-01	BBP	ETF	28.862	29.38	28.8	29.34	7600.0
2016-11-01	BCM	ETF	26.262	26.262	26.262	26.262	1130.0
2016-11-01	BFIT	ETF	15.14	15.14	14.953	14.953	402.0

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

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