PREVIEW / etf_daily / 2014-12-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-16.parquet
  size:    47 KB
  rows:    1,160

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
2014-12-16	SPY	ETF	198.58	202.4	197.86	197.91	259543800.0
2014-12-16	QQQ	ETF	100.97	102.47	99.96	99.98	65348626.0
2014-12-16	IWM	ETF	113.32	115.34	113.03	113.39	62849700.0
2014-12-16	DIA	ETF	171.27	174.39	170.74	170.85	12257600.0
2014-12-16	GLD	ETF	116.28	116.5	114.07	114.95	9174000.0
2014-12-16	TLT	ETF	127.36	127.72	126.36	127.6	7426400.0
2014-12-16	AADR	ETF	36.3	36.5	36.17	36.25	2100.0
2014-12-16	AAXJ	ETF	59.11	60.02	58.97	59.26	1988000.0
2014-12-16	ACWI	ETF	57.03	58.0	56.87	56.99	8379200.0
2014-12-16	ACWV	ETF	67.73	68.67	67.58	67.82	345900.0
2014-12-16	ACWX	ETF	42.03	42.8678	42.0	42.38	1178497.0
2014-12-16	ADRE	ETF	34.05	34.66	33.81	34.16	15509.0
2014-12-16	AFK	ETF	24.91	25.1575	24.56	24.89	38042.0
2014-12-16	AGG	ETF	110.6	110.6	110.32	110.53	1411700.0
2014-12-16	AGQ	ETF	40.99	41.18	37.25	38.25	518200.0
2014-12-16	AGZ	ETF	113.73	113.73	113.1	113.3899	20441.0
2014-12-16	AGZD	ETF	24.54	24.64	24.525	24.62	20000.0
2014-12-16	AIA	ETF	45.71	46.43	45.71	45.87	117824.0
2014-12-16	AIQ	ETF	19.88	20.16	18.92	19.14	49475.0
2014-12-16	AIRR	ETF	16.91	17.32	16.04	16.97	41900.0
2014-12-16	AIVI	ETF	42.57	43.36	42.47	42.91	43100.0
2014-12-16	AMJ	ETF	41.71	43.95	40.73	43.14	5672613.0
2014-12-16	AMLP	ETF	81.8	84.85	80.05	83.6	2352380.0
2014-12-16	AMZA	ETF	197.9	212.7	196.8	208.9	620.0
2014-12-16	ANGL	ETF	26.38	26.6	26.2	26.52	6100.0
2014-12-16	AOA	ETF	45.17	45.67	44.87	45.0	59700.0
2014-12-16	AOK	ETF	32.24	32.42	32.22	32.28	67275.0
2014-12-16	AOM	ETF	34.68	34.92	34.57	34.67	169017.0
2014-12-16	AOR	ETF	39.3	39.6399	39.2	39.22	688674.0
2014-12-16	ARGT	ETF	18.09	18.24	17.82	18.01	13500.0
2014-12-16	ARKG	ETF	19.95	20.26	19.95	20.06	3300.0
2014-12-16	ARKK	ETF	19.06	19.24	18.95	18.95	1500.0
2014-12-16	ARKQ	ETF	18.9	19.009	18.85	18.85	1600.0
2014-12-16	ARKW	ETF	19.63	19.63	19.28	19.28	1100.0
2014-12-16	ASEA	ETF	15.43	15.62	15.31	15.44	21200.0
2014-12-16	ASHR	ETF	34.7	34.99	34.3	34.79	1904000.0
2014-12-16	ASHS	ETF	37.33	38.09	37.33	37.76	27700.0
2014-12-16	ATMP	ETF	27.8	28.99	27.3	28.48	28100.0
2014-12-16	AVIV	ETF	33.49	33.92	33.2	33.52	270277.0
2014-12-16	AWAY	ETF	29.08	29.1	28.26	28.28	983989.0
2014-12-16	BAB	ETF	30.53	30.63	30.381	30.57	175682.0
2014-12-16	BAL	ETF	41.15	41.15	40.72	40.85	28609.0
2014-12-16	BALT	ETF	2.43	2.51	2.34	2.36	603155.0
2014-12-16	BAR	ETF	2.8021	2.8021	2.801	2.801	3920.0
2014-12-16	BBH	ETF	114.19	116.51	113.24	113.25	345300.0
2014-12-16	BCHP	ETF	17.47	17.74	17.47	17.57	1800.0
2014-12-16	BCM	ETF	32.63	32.63	32.46	32.57	34971.0
2014-12-16	BFOR	ETF	7.58	7.685	7.5775	7.5775	76800.0
2014-12-16	BIB	ETF	59.75	62.7	58.82	59.155	626940.0
2014-12-16	BICK	ETF	22.98	22.98	22.801	22.801	2049.0

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

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