PREVIEW / etf_daily / 2016-11-11

all etf daily files

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

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-11	SPY	ETF	216.08	216.7	215.32	216.42	100552700.0
2016-11-11	QQQ	ETF	115.21	116.05	114.84	115.8	41115166.0
2016-11-11	IWM	ETF	125.03	127.72	124.55	127.36	95612800.0
2016-11-11	DIA	ETF	187.95	188.63	187.41	188.47	5003800.0
2016-11-11	GLD	ETF	119.65	119.69	116.23	117.1	20381800.0
2016-11-11	TLT	ETF	122.96	123.05	121.65	122.04	10040200.0
2016-11-11	AADR	ETF	39.35	39.35	38.86	39.09	1100.0
2016-11-11	AAXJ	ETF	55.81	56.05	55.28	55.73	2637500.0
2016-11-11	ACSI	ETF	25.54	25.7	25.54	25.7	18489.0
2016-11-11	ACTX	ETF	16.5201	16.5201	10.0301	12.9801	5179.0
2016-11-11	ACWI	ETF	57.88	58.16	57.56	57.92	2193100.0
2016-11-11	ACWV	ETF	72.44	72.7	72.27	72.48	149500.0
2016-11-11	ACWX	ETF	39.85	39.85	39.52	39.79	791062.0
2016-11-11	ADRE	ETF	32.74	32.8809	32.201	32.8809	13618.0
2016-11-11	AFK	ETF	19.37	19.5	18.89	19.2476	57167.0
2016-11-11	AFTY	ETF	13.43	13.64	13.43	13.61	7100.0
2016-11-11	AGG	ETF	109.46	109.5	109.22	109.25	2804600.0
2016-11-11	AGGY	ETF	50.458	50.475	50.32	50.396	6900.0
2016-11-11	AGQ	ETF	44.12	44.12	37.92	38.68	1431100.0
2016-11-11	AGZ	ETF	113.2	113.95	113.2	113.79	10022.0
2016-11-11	AGZD	ETF	24.02	24.05	23.91	23.91	6200.0
2016-11-11	AIA	ETF	46.74	47.13	46.51	46.9	70417.0
2016-11-11	AIQ	ETF	7.4	7.5	7.25	7.45	4470.0
2016-11-11	AIRR	ETF	22.34	22.34	21.52	22.067	231300.0
2016-11-11	AIVI	ETF	36.9	36.9	36.62	36.75	10300.0
2016-11-11	AMJ	ETF	30.47	30.51	29.8	30.09	4407600.0
2016-11-11	AMLP	ETF	60.75	60.9	59.5	60.2	2334120.0
2016-11-11	AMZA	ETF	108.1	108.9	106.6	108.3	20790.0
2016-11-11	ANGL	ETF	28.37	28.37	27.69	27.76	201400.0
2016-11-11	AOA	ETF	46.27	46.48	46.18	46.38	106600.0
2016-11-11	AOK	ETF	32.43	32.54	32.35	32.45	189776.0
2016-11-11	AOM	ETF	35.09	35.13	35.0106	35.09	85442.0
2016-11-11	AOR	ETF	40.01	40.1	39.9	40.0	68670.0
2016-11-11	ARGT	ETF	22.68	22.73	22.13	22.42	85600.0
2016-11-11	ARKG	ETF	18.83	18.9	18.735	18.79	13900.0
2016-11-11	ARKK	ETF	20.361	20.361	20.361	20.361	600.0
2016-11-11	ARKQ	ETF	21.301	21.301	21.301	21.301	200.0
2016-11-11	ARKW	ETF	25.058	25.058	25.058	25.058	100.0
2016-11-11	ASEA	ETF	12.98	12.98	12.67	12.71	2600.0
2016-11-11	ASHR	ETF	25.01	25.15	24.94	25.11	1249100.0
2016-11-11	ASHS	ETF	34.8	35.06	34.8	35.06	10500.0
2016-11-11	ASHX	ETF	23.29	23.29	23.29	23.29	150.0
2016-11-11	ATMP	ETF	22.67	22.67	22.1	22.43	397400.0
2016-11-11	BAB	ETF	29.6	29.67	29.34	29.44	320406.0
2016-11-11	BAL	ETF	46.12	46.1662	45.3	45.3999	17729.0
2016-11-11	BBC	ETF	21.06	21.69	21.014	21.69	21779.0
2016-11-11	BBH	ETF	114.94	114.94	111.91	113.37	103300.0
2016-11-11	BBP	ETF	35.05	35.32	34.18	35.19	70500.0
2016-11-11	BCM	ETF	25.6	25.63	25.6	25.6064	4074.0
2016-11-11	BFOR	ETF	8.1925	8.3125	8.1925	8.3125	52000.0

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

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