PREVIEW / etf_daily / 2014-12-30

all etf daily files

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

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-30	SPY	ETF	208.21	208.37	207.51	207.6	73540800.0
2014-12-30	QQQ	ETF	104.72	104.96	104.175	104.32	18603989.0
2014-12-30	IWM	ETF	120.79	121.24	120.27	120.34	23996000.0
2014-12-30	DIA	ETF	179.63	179.87	179.24	179.46	2953300.0
2014-12-30	GLD	ETF	114.99	116.26	114.9	115.2	7987300.0
2014-12-30	TLT	ETF	125.98	126.21	125.53	125.68	4372600.0
2014-12-30	AADR	ETF	37.5	37.51	37.13	37.13	29900.0
2014-12-30	AAXJ	ETF	60.7	60.79	60.57	60.67	1019600.0
2014-12-30	ACWI	ETF	59.27	59.27	59.02	59.03	1773300.0
2014-12-30	ACWV	ETF	69.34	69.4	69.17	69.25	33200.0
2014-12-30	ACWX	ETF	43.38	43.38	43.22	43.23	1355758.0
2014-12-30	ADRE	ETF	35.73	35.73	35.47	35.542	27507.0
2014-12-30	AFK	ETF	26.22	26.3585	26.04	26.24	36978.0
2014-12-30	AGG	ETF	110.2	110.26	110.01	110.09	2069600.0
2014-12-30	AGQ	ETF	39.65	41.77	39.48	40.82	281200.0
2014-12-30	AGZ	ETF	113.39	113.41	113.0103	113.22	57085.0
2014-12-30	AGZD	ETF	24.59	24.67	24.59	24.59	16800.0
2014-12-30	AIA	ETF	46.86	46.92	46.72	46.86	15150.0
2014-12-30	AIQ	ETF	21.69	22.29	21.615	21.96	11493.0
2014-12-30	AIRR	ETF	18.46	18.57	18.46	18.49	241000.0
2014-12-30	AIVI	ETF	43.65	43.65	43.42	43.49	22300.0
2014-12-30	ALTL	ETF	38.1121	38.1121	38.1121	38.1121	342.0
2014-12-30	AMJ	ETF	46.0	46.62	45.9	46.32	1460770.0
2014-12-30	AMLP	ETF	88.0	88.55	87.6	88.15	837840.0
2014-12-30	AMZA	ETF	230.0	232.3	230.0	231.8	240.0
2014-12-30	ANGL	ETF	26.18	26.66	26.17	26.19	2000.0
2014-12-30	AOA	ETF	46.78	46.78	46.6	46.65	65600.0
2014-12-30	AOK	ETF	32.7	32.74	32.7	32.72	46091.0
2014-12-30	AOM	ETF	35.39	35.39	35.27	35.29	196168.0
2014-12-30	AOR	ETF	40.34	40.43	40.28	40.33	206886.0
2014-12-30	ARGT	ETF	18.92	18.99	18.77	18.77	2000.0
2014-12-30	ARKG	ETF	21.49	21.49	21.26	21.26	2600.0
2014-12-30	ARKK	ETF	20.58	20.58	20.28	20.3	1000.0
2014-12-30	ARKQ	ETF	19.97	19.97	19.791	19.791	800.0
2014-12-30	ARKW	ETF	20.65	20.65	20.55	20.55	1700.0
2014-12-30	ASEA	ETF	15.84	15.93	15.83	15.86	26200.0
2014-12-30	ASHR	ETF	36.21	36.5	35.97	36.23	918300.0
2014-12-30	ASHS	ETF	35.0	35.02	34.67	34.7	17000.0
2014-12-30	ATMP	ETF	30.9	31.24	30.63	30.7	138600.0
2014-12-30	AVIV	ETF	35.35	35.76	35.22	35.57	375544.0
2014-12-30	AWAY	ETF	28.94	29.71	28.72	28.99	689946.0
2014-12-30	BAB	ETF	30.41	30.4299	30.23	30.37	263146.0
2014-12-30	BAL	ETF	42.37	42.5	42.35	42.37	1563.0
2014-12-30	BALT	ETF	2.44	2.44	2.32	2.38	661411.0
2014-12-30	BAR	ETF	2.81	2.89	2.81	2.832	125510.0
2014-12-30	BBC	ETF	27.63	27.87	27.35	27.49	12986.0
2014-12-30	BBH	ETF	117.12	117.51	115.94	115.94	96800.0
2014-12-30	BBP	ETF	26.5	26.5	26.05	26.18	6700.0
2014-12-30	BCHP	ETF	18.18	18.19	18.11	18.19	9070.0
2014-12-30	BCM	ETF	32.23	32.39	32.19	32.2247	158020.0

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

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