PREVIEW / etf_daily / 2016-11-29

all etf daily files

  file:    by_date/etf_daily/2016/2016-11-29.parquet
  size:    53 KB
  rows:    1,332

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-29	SPY	ETF	220.52	221.44	220.17	220.91	69886700.0
2016-11-29	QQQ	ETF	118.63	119.51	118.3	118.94	18552957.0
2016-11-29	IWM	ETF	132.51	133.09	132.1	132.26	27993700.0
2016-11-29	DIA	ETF	190.83	191.42	190.68	191.19	2264900.0
2016-11-29	GLD	ETF	112.76	113.48	112.69	113.27	7438600.0
2016-11-29	TLT	ETF	121.44	122.4	121.21	122.22	8363000.0
2016-11-29	AADR	ETF	40.65	40.91	40.54	40.54	9600.0
2016-11-29	AAXJ	ETF	56.65	57.04	56.59	56.91	335200.0
2016-11-29	ACSI	ETF	26.63	26.73	26.6185	26.7	13034.0
2016-11-29	ACTX	ETF	33.6303	34.8103	29.5003	31.8603	1420.0
2016-11-29	ACWI	ETF	58.52	58.83	58.43	58.72	1739900.0
2016-11-29	ACWV	ETF	72.91	73.31	72.91	73.21	157100.0
2016-11-29	ACWX	ETF	39.75	40.02	39.69	39.94	1468674.0
2016-11-29	ADRE	ETF	33.05	33.28	33.05	33.15	4874.0
2016-11-29	AFK	ETF	19.38	19.5909	19.35	19.59	11950.0
2016-11-29	AFTY	ETF	14.2	14.28	14.2	14.28	6200.0
2016-11-29	AGG	ETF	108.5	108.72	108.43	108.67	2178600.0
2016-11-29	AGGY	ETF	49.8	49.93	49.79	49.93	3800.0
2016-11-29	AGQ	ETF	34.61	35.8	34.53	35.37	88200.0
2016-11-29	AGZ	ETF	112.94	113.466	112.94	113.27	12753.0
2016-11-29	AGZD	ETF	24.03	24.03	24.02	24.025	10000.0
2016-11-29	AIA	ETF	48.06	48.2315	47.92	48.13	15942.0
2016-11-29	AIQ	ETF	7.3	7.4	7.275	7.35	8423.0
2016-11-29	AIRR	ETF	23.07	23.07	22.82	22.9	81100.0
2016-11-29	AIVI	ETF	36.22	36.53	36.22	36.4	27400.0
2016-11-29	ALTY	ETF	14.96	14.96	14.878	14.878	300.0
2016-11-29	AMJ	ETF	29.26	29.31	28.84	29.26	4079972.0
2016-11-29	AMLP	ETF	59.9	59.9	58.85	59.7	2088060.0
2016-11-29	AMZA	ETF	106.0	106.35	104.2	106.3	18400.0
2016-11-29	ANGL	ETF	28.57	28.65	28.57	28.59	107700.0
2016-11-29	AOA	ETF	46.79	46.97	46.7	46.92	154600.0
2016-11-29	AOK	ETF	32.37	32.5299	32.3401	32.48	133078.0
2016-11-29	AOM	ETF	35.13	35.2499	35.0001	35.18	202107.0
2016-11-29	AOR	ETF	40.34	40.4	40.2	40.33	512352.0
2016-11-29	ARGT	ETF	22.83	23.04	22.82	22.9	50300.0
2016-11-29	ARKG	ETF	18.32	18.36	18.13	18.295	1800.0
2016-11-29	ARKK	ETF	20.64	20.64	20.36	20.36	3800.0
2016-11-29	ARKQ	ETF	21.89	21.89	21.75	21.78	1100.0
2016-11-29	ARKW	ETF	25.92	25.92	25.5	25.5	1000.0
2016-11-29	ASEA	ETF	12.97	12.97	12.88	12.93	3600.0
2016-11-29	ASHR	ETF	25.98	26.14	25.9	26.13	1497900.0
2016-11-29	ASHS	ETF	34.79	34.95	34.79	34.9	8200.0
2016-11-29	ATMP	ETF	22.18	22.2	21.68	22.04	116800.0
2016-11-29	BAB	ETF	29.43	29.5	29.36	29.44	284615.0
2016-11-29	BAL	ETF	46.9853	47.22	46.79	46.79	4131.0
2016-11-29	BBC	ETF	20.62	20.8008	20.62	20.7333	12042.0
2016-11-29	BBH	ETF	111.55	112.07	110.58	111.31	47900.0
2016-11-29	BBP	ETF	34.462	34.999	34.462	34.68	15000.0
2016-11-29	BCM	ETF	26.17	26.1979	26.07	26.084	14189.0
2016-11-29	BFOR	ETF	8.6225	8.6875	8.6225	8.6675	76800.0

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

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