PREVIEW / etf_daily / 2014-04-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-14.parquet
  size:    44 KB
  rows:    1,078

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-04-14	SPY	ETF	182.93	183.37	181.44	182.94	132382000.0
2014-04-14	QQQ	ETF	84.85	85.22	83.99	84.77	46500747.0
2014-04-14	IWM	ETF	111.55	111.97	109.65	110.72	62657700.0
2014-04-14	DIA	ETF	161.08	161.62	160.27	161.45	6270600.0
2014-04-14	GLD	ETF	127.8	128.25	127.62	127.85	6677400.0
2014-04-14	TLT	ETF	110.48	110.7	110.3	110.44	4142600.0
2014-04-14	AADR	ETF	36.93	37.15	36.92	37.12	4700.0
2014-04-14	AAXJ	ETF	60.87	60.99	60.58	60.84	417300.0
2014-04-14	ACWI	ETF	57.32	57.52	57.04	57.43	764100.0
2014-04-14	ACWV	ETF	64.05	64.07	63.74	64.07	61600.0
2014-04-14	ACWX	ETF	46.59	46.5999	46.271	46.51	419239.0
2014-04-14	ADRE	ETF	37.64	37.8199	37.54	37.65	30453.0
2014-04-14	AFK	ETF	31.83	31.87	31.47	31.66	45468.0
2014-04-14	AGG	ETF	108.43	108.5	108.4	108.47	1002800.0
2014-04-14	AGQ	ETF	65.39	65.78	64.99	65.23	112300.0
2014-04-14	AGZ	ETF	112.38	113.41	112.1301	112.18	11033.0
2014-04-14	AGZD	ETF	25.5	25.5	24.97	25.005	6200.0
2014-04-14	AIA	ETF	47.68	47.76	47.532	47.634	21839.0
2014-04-14	AIQ	ETF	29.55	30.21	28.68	29.0	37329.0
2014-04-14	AIRR	ETF	19.25	19.25	18.75	18.89	12400.0
2014-04-14	AIVI	ETF	48.89	49.0	48.67	48.85	24200.0
2014-04-14	AMJ	ETF	47.61	48.16	47.48	47.78	501447.0
2014-04-14	AMLP	ETF	89.8	90.4	89.65	89.7	646800.0
2014-04-14	ANGL	ETF	27.52	27.67	27.51	27.65	1500.0
2014-04-14	AOA	ETF	44.65	44.73	44.3	44.53	49600.0
2014-04-14	AOK	ETF	32.36	32.36	32.12	32.19	19995.0
2014-04-14	AOM	ETF	34.55	34.55	34.3704	34.51	54893.0
2014-04-14	AOR	ETF	38.59	38.69	38.4304	38.64	53416.0
2014-04-14	ARGT	ETF	19.85	19.85	19.76	19.76	3200.0
2014-04-14	ASEA	ETF	16.33	16.33	16.21	16.26	3200.0
2014-04-14	ASHR	ETF	23.26	23.26	23.06	23.14	65900.0
2014-04-14	ATMP	ETF	28.63	28.68	28.4	28.45	32500.0
2014-04-14	AVIV	ETF	25.1	25.155	24.51	24.78	420283.0
2014-04-14	AWAY	ETF	33.24	34.42	32.88	33.27	1505435.0
2014-04-14	BAB	ETF	29.01	29.042	28.94	28.97	138815.0
2014-04-14	BAL	ETF	57.18	57.33	56.63	56.94	4311.0
2014-04-14	BALT	ETF	6.21	6.25	5.99	6.05	770934.0
2014-04-14	BBH	ETF	83.4	84.9	81.38	82.89	867000.0
2014-04-14	BCM	ETF	41.68	41.68	41.62	41.63	1070.0
2014-04-14	BFOR	ETF	7.3375	7.375	7.275	7.3275	151200.0
2014-04-14	BIB	ETF	33.79	34.735	31.63	32.935	1518290.0
2014-04-14	BICK	ETF	25.0811	25.1101	24.96	24.9621	879.0
2014-04-14	BIL	ETF	91.54	91.56	91.54	91.54	299600.0
2014-04-14	BIS	ETF	808.4	868.0	788.4	837.6	24506.0
2014-04-14	BIV	ETF	83.82	83.87	83.73	83.78	168600.0
2014-04-14	BIZD	ETF	19.85	19.95	19.84	19.84	7800.0
2014-04-14	BJK	ETF	50.81	51.14	50.41	50.71	23200.0
2014-04-14	BKF	ETF	37.04	37.04	36.68	36.84	53195.0
2014-04-14	BKLN	ETF	24.79	24.79	24.73	24.74	2850000.0
2014-04-14	BLV	ETF	87.65	87.77	87.6	87.75	50400.0

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

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