PREVIEW / etf_daily / 2014-11-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-18.parquet
  size:    46 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-11-18	SPY	ETF	204.44	205.92	204.44	205.55	76068100.0
2014-11-18	QQQ	ETF	103.0	103.82	102.991	103.68	26336812.0
2014-11-18	IWM	ETF	116.16	117.12	115.75	116.39	33717200.0
2014-11-18	DIA	ETF	176.53	177.38	176.45	176.96	4721700.0
2014-11-18	GLD	ETF	114.86	115.17	114.55	115.05	5586700.0
2014-11-18	TLT	ETF	119.32	119.58	119.16	119.52	4471200.0
2014-11-18	AAXJ	ETF	61.9	62.16	61.89	62.1	265400.0
2014-11-18	ACWI	ETF	59.83	60.17	59.79	60.06	796900.0
2014-11-18	ACWV	ETF	69.55	69.73	69.42	69.69	224500.0
2014-11-18	ACWX	ETF	44.99	45.29	44.99	45.19	364523.0
2014-11-18	ADRE	ETF	38.02	38.26	37.98	38.22	48075.0
2014-11-18	AFK	ETF	29.38	29.42	29.11	29.42	13522.0
2014-11-18	AGG	ETF	109.82	109.88	109.77	109.83	1318400.0
2014-11-18	AGQ	ETF	41.21	41.27	40.7	41.0	210600.0
2014-11-18	AGZ	ETF	113.0421	113.066	112.77	112.787	26966.0
2014-11-18	AGZD	ETF	24.83	24.83	24.745	24.78	10800.0
2014-11-18	AIA	ETF	47.424	47.465	47.3901	47.43	8940.0
2014-11-18	AIQ	ETF	22.43	23.4	22.43	23.39	10720.0
2014-11-18	AIRR	ETF	18.78	18.86	18.73	18.75	20000.0
2014-11-18	AIVI	ETF	45.86	46.14	45.86	46.14	47900.0
2014-11-18	AMJ	ETF	51.21	51.84	50.935	51.54	974250.0
2014-11-18	AMLP	ETF	93.2	93.7	92.85	93.5	1029360.0
2014-11-18	AMZA	ETF	246.4	247.9	246.4	247.8	460.0
2014-11-18	ANGL	ETF	27.6	27.81	27.19	27.52	21200.0
2014-11-18	AOA	ETF	46.33	46.78	46.33	46.68	75200.0
2014-11-18	AOK	ETF	32.8	32.81	32.71	32.8	31935.0
2014-11-18	AOM	ETF	35.34	35.4032	35.3154	35.38	69523.0
2014-11-18	AOR	ETF	40.28	40.34	40.188	40.27	40669.0
2014-11-18	ARGT	ETF	21.0	21.05	20.85	21.0	16600.0
2014-11-18	ARKG	ETF	20.06	20.08	20.01	20.06	2000.0
2014-11-18	ARKK	ETF	20.6	20.6	20.6	20.6	1000.0
2014-11-18	ARKQ	ETF	20.39	20.39	20.31	20.31	400.0
2014-11-18	ARKW	ETF	20.63	20.63	20.56	20.56	500.0
2014-11-18	ASEA	ETF	16.88	16.88	16.8	16.82	9600.0
2014-11-18	ASHR	ETF	27.25	27.26	27.12	27.18	635900.0
2014-11-18	ASHS	ETF	34.02	34.03	33.95	34.01	7600.0
2014-11-18	ATMP	ETF	32.05	32.35	32.05	32.21	24300.0
2014-11-18	AVIV	ETF	33.16	33.2	32.89	33.06	447333.0
2014-11-18	AWAY	ETF	30.37	31.03	30.1	30.42	972760.0
2014-11-18	BAB	ETF	29.76	29.82	29.7401	29.82	77028.0
2014-11-18	BAL	ETF	40.57	40.8601	40.3	40.8601	1214.0
2014-11-18	BALT	ETF	3.35	3.4683	3.27	3.28	527418.0
2014-11-18	BAR	ETF	2.865	2.8887	2.847	2.873	36380.0
2014-11-18	BBH	ETF	112.79	114.85	112.52	114.67	47100.0
2014-11-18	BCM	ETF	35.171	35.192	35.15	35.158	13788.0
2014-11-18	BFOR	ETF	7.875	7.935	7.875	7.92	114000.0
2014-11-18	BIB	ETF	58.0	60.09	57.745	59.855	370998.0
2014-11-18	BICK	ETF	24.59	24.6999	24.59	24.6999	853.0
2014-11-18	BIL	ETF	91.48	91.5	91.48	91.48	794700.0
2014-11-18	BIS	ETF	418.48	418.48	400.08	401.92	15457.5

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

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