PREVIEW / etf_daily / 2015-11-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-11-17.parquet
  size:    49 KB
  rows:    1,211

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
2015-11-17	SPY	ETF	205.99	207.04	204.88	205.47	121123700.0
2015-11-17	QQQ	ETF	111.61	112.29	111.2099	111.49	30579457.0
2015-11-17	IWM	ETF	115.15	116.15	114.45	114.61	34441000.0
2015-11-17	DIA	ETF	175.6	176.25	174.76	175.16	6612200.0
2015-11-17	GLD	ETF	103.38	103.4	101.98	102.34	8593100.0
2015-11-17	TLT	ETF	119.0	120.13	118.66	119.77	5122900.0
2015-11-17	AADR	ETF	38.45	38.45	38.12	38.12	600.0
2015-11-17	AAXJ	ETF	55.17	55.38	55.0	55.16	683500.0
2015-11-17	ACTX	ETF	3.54	4.72	3.54	3.54	2446.0
2015-11-17	ACWI	ETF	57.44	57.6	57.09	57.19	1204900.0
2015-11-17	ACWV	ETF	69.64	69.76	69.22	69.34	148900.0
2015-11-17	ACWX	ETF	40.92	41.06	40.775	40.84	1124586.0
2015-11-17	ADRE	ETF	30.29	30.29	29.9801	29.9801	4024.0
2015-11-17	AFK	ETF	18.97	19.06	18.88	18.94	11046.0
2015-11-17	AFTY	ETF	17.12	17.13	16.93	17.02	99100.0
2015-11-17	AGG	ETF	108.49	108.78	108.42	108.72	2461300.0
2015-11-17	AGQ	ETF	29.17	29.17	28.5	28.87	231300.0
2015-11-17	AGZ	ETF	113.3	113.3	113.12	113.29	16789.0
2015-11-17	AGZD	ETF	24.04	24.05	24.04	24.05	1400.0
2015-11-17	AIA	ETF	44.49	44.55	44.3	44.45	37321.0
2015-11-17	AIQ	ETF	7.88	8.052	7.16	7.26	268292.0
2015-11-17	AIRR	ETF	16.97	17.04	16.92	16.92	4000.0
2015-11-17	AIVI	ETF	39.24	39.37	39.12	39.22	26700.0
2015-11-17	AMJ	ETF	31.97	32.2	31.56	31.7	3100458.0
2015-11-17	AMLP	ETF	64.35	64.6	63.2	63.4	2288940.0
2015-11-17	AMZA	ETF	135.1	135.1	132.4	132.4	140.0
2015-11-17	ANGL	ETF	25.71	25.71	25.63	25.67	16200.0
2015-11-17	AOA	ETF	45.5	45.71	45.43	45.51	53200.0
2015-11-17	AOK	ETF	31.84	31.96	31.84	31.91	47274.0
2015-11-17	AOM	ETF	34.36	34.4899	34.33	34.42	231873.0
2015-11-17	AOR	ETF	39.41	39.41	39.2599	39.3	377210.0
2015-11-17	ARGT	ETF	19.49	19.51	19.19	19.19	17000.0
2015-11-17	ARKG	ETF	19.72	19.72	19.72	19.72	100.0
2015-11-17	ARKK	ETF	20.11	20.11	19.948	19.948	200.0
2015-11-17	ARKQ	ETF	18.65	18.65	18.65	18.65	100.0
2015-11-17	ARKW	ETF	22.815	22.815	22.815	22.815	200.0
2015-11-17	ASEA	ETF	12.75	12.75	12.75	12.75	400.0
2015-11-17	ASHR	ETF	37.48	37.71	37.43	37.55	1407700.0
2015-11-17	ASHS	ETF	46.66	46.66	46.25	46.41	31500.0
2015-11-17	ASHX	ETF	26.43	26.54	26.41	26.41	1946.0
2015-11-17	ATMP	ETF	21.41	21.41	20.92	21.15	43900.0
2015-11-17	AWAY	ETF	35.39	35.47	34.55	34.81	3936409.0
2015-11-17	BAB	ETF	28.78	28.94	28.76	28.94	86288.0
2015-11-17	BAL	ETF	41.995	42.15	41.661	41.76	3402.0
2015-11-17	BBC	ETF	29.17	29.665	28.72	29.02	10345.0
2015-11-17	BBH	ETF	122.43	124.31	121.84	123.76	84400.0
2015-11-17	BBP	ETF	30.24	30.97	30.24	30.7	3700.0
2015-11-17	BCM	ETF	24.918	24.95	24.889	24.895	6434.0
2015-11-17	BDCZ	ETF	20.87	20.87	20.82	20.82	802.0
2015-11-17	BFOR	ETF	7.725	7.7925	7.695	7.715	54000.0

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

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