PREVIEW / etf_daily / 2015-02-18

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-18.parquet
  size:    47 KB
  rows:    1,162

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-02-18	SPY	ETF	209.66	210.22	209.34	210.13	80652900.0
2015-02-18	QQQ	ETF	106.88	107.2199	106.74	107.16	15149619.0
2015-02-18	IWM	ETF	121.56	122.05	121.13	122.04	20450200.0
2015-02-18	DIA	ETF	180.18	180.68	179.97	180.47	2724800.0
2015-02-18	GLD	ETF	115.99	116.53	114.99	116.34	8336000.0
2015-02-18	TLT	ETF	126.82	127.74	126.47	127.01	14009200.0
2015-02-18	AADR	ETF	38.39	38.39	38.39	38.39	300.0
2015-02-18	AAXJ	ETF	63.43	63.61	63.16	63.52	365500.0
2015-02-18	ACWI	ETF	60.51	60.68	60.37	60.61	646200.0
2015-02-18	ACWV	ETF	70.93	71.54	70.93	71.52	47200.0
2015-02-18	ACWX	ETF	44.72	44.985	44.68	44.92	1009896.0
2015-02-18	ADRE	ETF	36.85	36.949	36.705	36.86	6835.0
2015-02-18	AFK	ETF	25.4	25.734	25.3705	25.72	19475.0
2015-02-18	AGG	ETF	110.39	110.75	110.31	110.62	1442400.0
2015-02-18	AGQ	ETF	41.09	41.86	40.28	41.17	366300.0
2015-02-18	AGZ	ETF	113.85	114.0099	113.4501	113.5001	17241.0
2015-02-18	AGZD	ETF	24.53	24.6	24.5	24.55	12200.0
2015-02-18	AIA	ETF	49.01	49.269	48.9701	49.1752	19324.0
2015-02-18	AIQ	ETF	24.7	24.99	24.49	24.79	11061.0
2015-02-18	AIRR	ETF	18.05	18.27	18.05	18.21	24300.0
2015-02-18	AIVI	ETF	45.03	45.24	44.85	45.13	34200.0
2015-02-18	AMJ	ETF	45.84	46.135	45.3601	45.58	676877.0
2015-02-18	AMLP	ETF	85.6	85.7	85.1	85.45	667260.0
2015-02-18	AMZA	ETF	222.0	222.3	221.2	221.4	160.0
2015-02-18	ANGL	ETF	27.36	27.58	27.32	27.36	12900.0
2015-02-18	AOA	ETF	47.22	47.52	47.22	47.48	21900.0
2015-02-18	AOK	ETF	32.71	32.793	32.63	32.72	12644.0
2015-02-18	AOM	ETF	35.26	35.49	35.26	35.49	108690.0
2015-02-18	AOR	ETF	40.64	40.83	40.6128	40.83	25725.0
2015-02-18	ARGT	ETF	20.08	20.26	20.06	20.06	4800.0
2015-02-18	ARKG	ETF	23.18	23.18	23.038	23.11	2600.0
2015-02-18	ARKK	ETF	21.338	21.37	21.338	21.37	800.0
2015-02-18	ARKQ	ETF	20.17	20.17	20.009	20.031	900.0
2015-02-18	ARKW	ETF	21.984	21.984	21.984	21.984	300.0
2015-02-18	ASEA	ETF	15.78	15.8	15.71	15.8	8200.0
2015-02-18	ASHR	ETF	36.05	36.18	35.99	36.04	564300.0
2015-02-18	ASHS	ETF	38.38	38.48	38.38	38.47	500.0
2015-02-18	ATMP	ETF	30.43	30.52	30.33	30.43	23700.0
2015-02-18	AVIV	ETF	36.24	36.815	35.82	36.8	167996.0
2015-02-18	AWAY	ETF	30.08	31.095	30.0	30.7	2777099.0
2015-02-18	BAB	ETF	30.22	30.31	30.05	30.18	319530.0
2015-02-18	BAL	ETF	44.54	44.69	43.89	44.5	16115.0
2015-02-18	BALT	ETF	1.68	1.75	1.62	1.64	423330.0
2015-02-18	BAR	ETF	2.875	2.875	2.753	2.838	52160.0
2015-02-18	BBC	ETF	30.19	30.24	29.71	30.2399	7257.0
2015-02-18	BBH	ETF	123.45	124.64	122.77	124.64	75300.0
2015-02-18	BBP	ETF	29.69	29.69	28.98	29.36	16800.0
2015-02-18	BCHP	ETF	19.11	19.262	19.11	19.225	3259.0
2015-02-18	BCM	ETF	31.84	31.8988	31.81	31.87	19069.0
2015-02-18	BFOR	ETF	8.1125	8.125	8.0975	8.115	84000.0

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

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