PREVIEW / etf_daily / 2015-11-12

all etf daily files

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

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-12	SPY	ETF	206.5	207.06	204.82	204.84	121315200.0
2015-11-12	QQQ	ETF	112.65	113.23	111.96	112.04	31196876.0
2015-11-12	IWM	ETF	116.33	116.49	114.73	114.9	39916100.0
2015-11-12	DIA	ETF	176.09	176.35	174.59	174.67	6164400.0
2015-11-12	GLD	ETF	103.09	104.32	103.04	103.85	6300500.0
2015-11-12	TLT	ETF	118.75	119.44	118.7	119.0	6805700.0
2015-11-12	AADR	ETF	38.45	38.45	38.45	38.45	1200.0
2015-11-12	AAXJ	ETF	55.63	55.82	55.26	55.3	574000.0
2015-11-12	ACTX	ETF	5.9001	5.9001	4.13	5.31	6679.0
2015-11-12	ACWF	ETF	23.57	23.6085	23.57	23.6085	358.0
2015-11-12	ACWI	ETF	57.39	57.54	56.98	57.0	1254500.0
2015-11-12	ACWV	ETF	69.56	69.75	69.2	69.27	293700.0
2015-11-12	ACWX	ETF	40.79	40.9772	40.64	40.645	1504808.0
2015-11-12	ADRE	ETF	30.48	30.73	30.36	30.36	6495.0
2015-11-12	AFK	ETF	19.28	19.35	19.1	19.12	28273.0
2015-11-12	AFTY	ETF	17.04	17.04	16.77	16.77	14200.0
2015-11-12	AGG	ETF	108.35	108.45	108.21	108.34	3448700.0
2015-11-12	AGQ	ETF	29.01	30.1	28.84	29.25	244800.0
2015-11-12	AGZ	ETF	113.2	113.32	113.01	113.05	10095.0
2015-11-12	AGZD	ETF	24.035	24.08	24.015	24.035	22200.0
2015-11-12	AIA	ETF	45.23	45.23	44.82	44.83	18914.0
2015-11-12	AIQ	ETF	9.24	9.24	8.56	8.69	41666.0
2015-11-12	AIRR	ETF	16.905	16.905	16.72	16.74	4300.0
2015-11-12	AIVI	ETF	38.91	39.05	38.8	38.82	26600.0
2015-11-12	AMJ	ETF	31.32	31.61	30.94	31.01	2583979.0
2015-11-12	AMLP	ETF	63.3	63.55	62.1	62.25	2476460.0
2015-11-12	AMZA	ETF	130.1	132.0	128.0	129.9	2800.0
2015-11-12	ANGL	ETF	25.78	25.78	25.62	25.67	27100.0
2015-11-12	AOA	ETF	45.66	45.66	45.33	45.33	102900.0
2015-11-12	AOK	ETF	31.8001	31.91	31.8001	31.8468	105664.0
2015-11-12	AOM	ETF	34.36	34.46	34.3101	34.33	209140.0
2015-11-12	AOR	ETF	39.36	39.41	39.17	39.1711	230028.0
2015-11-12	ARGT	ETF	19.19	19.36	19.19	19.24	28500.0
2015-11-12	ARKG	ETF	19.77	19.77	19.77	19.77	100.0
2015-11-12	ARKK	ETF	20.225	20.225	20.04	20.04	2100.0
2015-11-12	ARKQ	ETF	18.84	18.84	18.84	18.84	100.0
2015-11-12	ARKW	ETF	23.46	23.46	23.032	23.032	800.0
2015-11-12	ASEA	ETF	12.69	12.71	12.69	12.71	700.0
2015-11-12	ASHR	ETF	37.85	37.89	37.42	37.42	1774700.0
2015-11-12	ASHS	ETF	46.83	46.87	46.5	46.54	41600.0
2015-11-12	ASHX	ETF	26.59	26.59	26.49	26.52	1565.0
2015-11-12	ATMP	ETF	20.96	20.96	20.44	20.48	155800.0
2015-11-12	AWAY	ETF	36.32	36.74	36.31	36.39	1653071.0
2015-11-12	BAB	ETF	28.76	28.7999	28.68	28.7	107377.0
2015-11-12	BAL	ETF	41.48	41.58	41.316	41.316	1730.0
2015-11-12	BBC	ETF	29.96	30.08	29.25	29.25	8992.0
2015-11-12	BBH	ETF	122.5	122.97	120.49	120.49	194900.0
2015-11-12	BBP	ETF	30.38	30.632	30.05	30.05	11000.0
2015-11-12	BCM	ETF	25.385	25.389	25.385	25.389	1175.0
2015-11-12	BFOR	ETF	7.825	7.83	7.735	7.735	59600.0

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

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