PREVIEW / etf_daily / 2014-12-09

all etf daily files

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

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-09	SPY	ETF	204.37	206.6	203.91	206.47	125180100.0
2014-12-09	QQQ	ETF	103.41	105.04	103.0401	104.96	46035139.0
2014-12-09	IWM	ETF	114.96	118.27	114.74	118.17	52645900.0
2014-12-09	DIA	ETF	176.78	178.03	176.22	177.96	7945400.0
2014-12-09	GLD	ETF	117.04	118.99	116.98	118.19	10467200.0
2014-12-09	TLT	ETF	123.6	123.97	122.96	123.2	6639700.0
2014-12-09	AAXJ	ETF	61.48	61.5	61.19	61.44	2055200.0
2014-12-09	ACWI	ETF	59.34	59.69	59.15	59.64	4709300.0
2014-12-09	ACWV	ETF	69.19	69.53	69.1	69.49	236200.0
2014-12-09	ACWX	ETF	44.27	44.36	44.05	44.36	716076.0
2014-12-09	ADRE	ETF	36.16	36.61	36.15	36.58	40849.0
2014-12-09	AFK	ETF	26.87	26.89	26.71	26.84	34738.0
2014-12-09	AGG	ETF	110.14	110.23	109.95	110.06	1203000.0
2014-12-09	AGQ	ETF	43.38	45.85	43.38	45.03	494000.0
2014-12-09	AGZ	ETF	112.99	112.99	112.6051	112.7501	6823.0
2014-12-09	AGZD	ETF	24.84	24.84	24.705	24.71	38800.0
2014-12-09	AIA	ETF	47.18	47.38	47.13	47.375	188545.0
2014-12-09	AIQ	ETF	21.88	21.88	20.88	21.45	41652.0
2014-12-09	AIRR	ETF	17.84	18.3	17.74	18.3	30700.0
2014-12-09	AIVI	ETF	44.65	44.84	44.47	44.71	12200.0
2014-12-09	ALTL	ETF	37.1639	37.1639	37.1639	37.1639	106.0
2014-12-09	AMJ	ETF	45.26	46.14	44.45	45.95	5049505.0
2014-12-09	AMLP	ETF	86.05	87.25	85.45	87.2	2068640.0
2014-12-09	AMZA	ETF	220.0	225.7	219.8	225.7	260.0
2014-12-09	ANGL	ETF	26.79	26.96	26.78	26.96	106200.0
2014-12-09	AOA	ETF	46.36	46.7	46.25	46.7	58400.0
2014-12-09	AOK	ETF	32.66	32.76	32.62	32.76	71102.0
2014-12-09	AOM	ETF	35.24	35.4	35.2	35.4	137243.0
2014-12-09	AOR	ETF	40.01	40.33	40.0	40.33	106580.0
2014-12-09	ARGT	ETF	19.98	19.98	19.76	19.91	16400.0
2014-12-09	ARKG	ETF	20.57	20.88	20.57	20.86	1200.0
2014-12-09	ARKK	ETF	19.58	19.78	19.5	19.78	1400.0
2014-12-09	ARKQ	ETF	19.56	19.817	19.53	19.817	1000.0
2014-12-09	ARKW	ETF	19.72	20.021	19.72	20.021	600.0
2014-12-09	ASEA	ETF	16.0	16.1	16.0	16.09	4600.0
2014-12-09	ASHR	ETF	32.55	32.95	31.93	32.57	2724200.0
2014-12-09	ASHS	ETF	35.0	35.0	34.4	34.6	24200.0
2014-12-09	ATMP	ETF	29.78	30.12	29.63	30.05	49100.0
2014-12-09	AVIV	ETF	33.7	34.2	33.7	34.18	156248.0
2014-12-09	AWAY	ETF	30.87	31.01	30.42	30.54	2174949.0
2014-12-09	BAB	ETF	30.2	30.2024	30.0401	30.05	146282.0
2014-12-09	BAL	ETF	40.93	41.18	40.69	40.74	5436.0
2014-12-09	BALT	ETF	2.44	2.627	2.4201	2.61	711397.0
2014-12-09	BAR	ETF	3.009	3.012	2.979	2.979	15450.0
2014-12-09	BBH	ETF	119.79	121.68	118.81	121.44	74200.0
2014-12-09	BCHP	ETF	18.33	18.33	18.33	18.33	380.0
2014-12-09	BCM	ETF	33.977	34.03	33.967	33.967	13593.0
2014-12-09	BFOR	ETF	7.7725	7.9	7.5525	7.8975	100800.0
2014-12-09	BIB	ETF	66.485	68.415	64.6	68.045	529834.0
2014-12-09	BICK	ETF	24.0705	24.25	24.07	24.2499	2952.0

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

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