PREVIEW / etf_daily / 2014-12-02

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-02.parquet
  size:    46 KB
  rows:    1,146

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-02	SPY	ETF	205.81	207.34	205.78	207.09	74507200.0
2014-12-02	QQQ	ETF	104.92	105.4168	104.7	105.23	26031291.0
2014-12-02	IWM	ETF	114.99	116.64	114.98	116.25	31812100.0
2014-12-02	DIA	ETF	177.68	178.77	177.67	178.56	3920500.0
2014-12-02	GLD	ETF	115.13	115.71	114.72	115.14	6378100.0
2014-12-02	TLT	ETF	120.84	120.85	120.29	120.32	5757200.0
2014-12-02	AADR	ETF	38.22	38.23	38.22	38.23	1300.0
2014-12-02	AAXJ	ETF	62.17	62.31	62.11	62.27	2239400.0
2014-12-02	ACWI	ETF	60.12	60.34	60.04	60.31	2527200.0
2014-12-02	ACWV	ETF	69.92	70.06	69.87	70.04	73900.0
2014-12-02	ACWX	ETF	45.26	45.26	45.09	45.18	858317.0
2014-12-02	ADRE	ETF	37.89	37.9157	37.617	37.68	17735.0
2014-12-02	AFK	ETF	27.57	27.75	27.37	27.64	217263.0
2014-12-02	AGG	ETF	109.99	109.99	109.81	109.86	1469400.0
2014-12-02	AGQ	ETF	41.44	42.41	40.78	42.04	239200.0
2014-12-02	AGZ	ETF	113.1	113.2654	112.95	112.99	6233.0
2014-12-02	AGZD	ETF	24.695	24.865	24.695	24.75	7600.0
2014-12-02	AIA	ETF	47.37	47.54	47.37	47.46	99861.0
2014-12-02	AIQ	ETF	21.32	22.24	21.14	22.21	16348.0
2014-12-02	AIRR	ETF	17.58	18.1	17.57	18.0	72100.0
2014-12-02	AIVI	ETF	45.82	45.96	45.73	45.84	18900.0
2014-12-02	AMJ	ETF	45.92	48.29	45.9	47.75	4551593.0
2014-12-02	AMLP	ETF	87.75	89.95	87.25	89.25	1256640.0
2014-12-02	AMZA	ETF	230.0	238.3	230.0	235.73	220.0
2014-12-02	ANGL	ETF	27.45	27.54	27.45	27.54	1000.0
2014-12-02	AOA	ETF	46.7	46.89	46.69	46.86	35500.0
2014-12-02	AOK	ETF	32.77	32.81	32.74	32.81	41386.0
2014-12-02	AOM	ETF	35.34	35.45	35.34	35.45	44369.0
2014-12-02	AOR	ETF	40.36	40.45	40.31	40.43	60133.0
2014-12-02	ARGT	ETF	20.67	20.67	20.21	20.22	13400.0
2014-12-02	ARKG	ETF	20.22	20.23	20.14	20.23	2400.0
2014-12-02	ARKK	ETF	20.05	20.05	20.05	20.05	900.0
2014-12-02	ARKQ	ETF	19.946	20.05	19.946	20.022	1100.0
2014-12-02	ARKW	ETF	20.119	20.199	20.119	20.199	400.0
2014-12-02	ASEA	ETF	16.47	16.58	16.4	16.41	452900.0
2014-12-02	ASHR	ETF	30.6	30.92	30.6	30.91	963900.0
2014-12-02	ASHS	ETF	35.51	35.94	35.51	35.87	152400.0
2014-12-02	ATMP	ETF	29.86	30.97	29.86	30.7	354400.0
2014-12-02	AVIV	ETF	33.81	34.22	33.65	34.08	202839.0
2014-12-02	AWAY	ETF	31.45	32.36	31.24	31.74	1438125.0
2014-12-02	BAB	ETF	29.98	29.98	29.81	29.81	59408.0
2014-12-02	BAL	ETF	40.29	40.77	40.17	40.44	10131.0
2014-12-02	BALT	ETF	2.85	2.88	2.69	2.77	1452400.0
2014-12-02	BAR	ETF	2.881	2.884	2.83	2.835	48180.0
2014-12-02	BBH	ETF	117.77	119.36	117.02	118.76	116300.0
2014-12-02	BCHP	ETF	18.47	18.51	18.47	18.5	2150.0
2014-12-02	BCM	ETF	34.048	34.048	33.941	33.948	1453.0
2014-12-02	BFOR	ETF	7.7825	7.8525	7.7825	7.845	118800.0
2014-12-02	BIB	ETF	62.93	65.0	62.93	64.715	455592.0
2014-12-02	BICK	ETF	24.683	24.683	24.56	24.6101	2378.0

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

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