PREVIEW / etf_daily / 2014-12-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-03.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-03	SPY	ETF	207.3	208.15	207.1	207.89	68952000.0
2014-12-03	QQQ	ETF	105.39	105.565	104.7626	105.42	32974322.0
2014-12-03	IWM	ETF	116.28	117.71	116.02	117.37	29148000.0
2014-12-03	DIA	ETF	178.59	179.14	178.41	178.96	11006600.0
2014-12-03	GLD	ETF	115.68	116.76	115.56	116.33	5758800.0
2014-12-03	TLT	ETF	120.3	120.8	120.13	120.79	4868600.0
2014-12-03	AAXJ	ETF	62.2	62.36	62.1	62.3	1450500.0
2014-12-03	ACWI	ETF	60.32	60.5	60.24	60.47	908200.0
2014-12-03	ACWV	ETF	70.01	70.15	69.9	70.12	89300.0
2014-12-03	ACWX	ETF	45.16	45.27	45.05	45.24	769378.0
2014-12-03	ADRE	ETF	37.55	37.8645	37.55	37.74	7228.0
2014-12-03	AFK	ETF	27.61	27.7	27.5724	27.7	20774.0
2014-12-03	AGG	ETF	109.83	109.87	109.73	109.76	1998000.0
2014-12-03	AGQ	ETF	42.09	42.71	41.37	41.94	110500.0
2014-12-03	AGZ	ETF	112.9	113.065	112.86	112.9501	6789.0
2014-12-03	AGZD	ETF	24.755	24.81	24.75	24.75	9000.0
2014-12-03	AIA	ETF	47.37	47.4101	47.25	47.36	41806.0
2014-12-03	AIQ	ETF	21.182	22.25	21.182	22.13	10344.0
2014-12-03	AIRR	ETF	17.92	18.44	17.92	18.37	77300.0
2014-12-03	AIVI	ETF	45.73	45.88	45.7	45.77	22100.0
2014-12-03	AMJ	ETF	47.74	49.01	47.53	48.69	2318354.0
2014-12-03	AMLP	ETF	89.4	90.8	89.4	90.2	851000.0
2014-12-03	AMZA	ETF	239.4	240.5	239.4	240.4	220.0
2014-12-03	ANGL	ETF	27.19	27.41	27.14	27.14	2200.0
2014-12-03	AOA	ETF	46.86	47.03	46.86	47.01	36000.0
2014-12-03	AOK	ETF	32.74	32.8414	32.74	32.83	7495.0
2014-12-03	AOM	ETF	35.43	35.53	35.43	35.51	110092.0
2014-12-03	AOR	ETF	40.38	40.56	40.38	40.52	56788.0
2014-12-03	ARGT	ETF	20.22	20.45	20.22	20.42	1100.0
2014-12-03	ARKG	ETF	20.23	20.33	20.23	20.33	1300.0
2014-12-03	ARKK	ETF	20.09	20.09	20.09	20.09	600.0
2014-12-03	ARKQ	ETF	20.17	20.17	20.17	20.17	300.0
2014-12-03	ARKW	ETF	20.23	20.23	20.23	20.23	300.0
2014-12-03	ASEA	ETF	16.39	16.42	16.34	16.34	3400.0
2014-12-03	ASHR	ETF	31.39	32.38	31.3	32.21	1761600.0
2014-12-03	ASHS	ETF	36.09	36.64	36.09	36.59	81400.0
2014-12-03	ATMP	ETF	30.7	31.31	30.67	31.28	243100.0
2014-12-03	AVIV	ETF	33.99	34.18	33.88	34.17	153457.0
2014-12-03	AWAY	ETF	31.7	32.28	31.581	31.88	898407.0
2014-12-03	BAB	ETF	29.86	29.88	29.77	29.88	121159.0
2014-12-03	BAL	ETF	40.71	41.069	40.521	40.6544	4647.0
2014-12-03	BALT	ETF	2.75	2.84	2.7	2.76	1262297.0
2014-12-03	BAR	ETF	2.917	2.9515	2.917	2.9211	16750.0
2014-12-03	BBH	ETF	119.09	119.09	117.22	118.69	145000.0
2014-12-03	BCHP	ETF	18.6102	18.66	18.6102	18.6102	724.0
2014-12-03	BCM	ETF	34.05	34.056	33.99	33.996	2053.0
2014-12-03	BFOR	ETF	7.8425	7.93	7.8425	7.92	42000.0
2014-12-03	BIB	ETF	65.31	65.375	63.5	65.375	430342.0
2014-12-03	BICK	ETF	24.7216	24.73	24.7216	24.73	462.0
2014-12-03	BIL	ETF	91.48	91.5	91.48	91.48	685850.0

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

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