PREVIEW / etf_daily / 2014-04-25

all etf daily files

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

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-25	SPY	ETF	187.22	187.33	185.87	186.29	100380000.0
2014-04-25	QQQ	ETF	87.08	87.17	85.98	86.19	44341588.0
2014-04-25	IWM	ETF	113.17	113.21	111.21	111.61	58386300.0
2014-04-25	DIA	ETF	164.08	164.19	163.0	163.35	5102700.0
2014-04-25	GLD	ETF	125.17	125.71	125.07	125.43	7023700.0
2014-04-25	TLT	ETF	111.49	111.99	111.32	111.33	5976500.0
2014-04-25	AADR	ETF	37.64	37.81	37.64	37.74	3700.0
2014-04-25	AAXJ	ETF	59.48	59.48	59.11	59.44	1149200.0
2014-04-25	ACWI	ETF	58.26	58.36	57.97	58.09	661700.0
2014-04-25	ACWV	ETF	64.43	64.55	64.18	64.47	21100.0
2014-04-25	ACWX	ETF	46.91	46.91	46.59	46.75	288309.0
2014-04-25	ADRE	ETF	37.1	37.1	36.78	36.94	28480.0
2014-04-25	AFK	ETF	32.67	32.67	32.0825	32.56	47532.0
2014-04-25	AGG	ETF	108.43	108.55	108.38	108.39	489700.0
2014-04-25	AGQ	ETF	63.53	63.82	62.71	63.34	154100.0
2014-04-25	AGZ	ETF	112.026	112.1299	111.92	111.9901	9432.0
2014-04-25	AIA	ETF	46.54	46.54	46.208	46.34	10077.0
2014-04-25	AIQ	ETF	30.23	30.82	29.22	29.6	33158.0
2014-04-25	AIRR	ETF	19.31	19.35	19.15	19.2	19800.0
2014-04-25	AIVI	ETF	49.51	49.51	49.31	49.36	25300.0
2014-04-25	AMJ	ETF	48.2	48.29	47.56	47.75	661485.0
2014-04-25	AMLP	ETF	90.2	90.65	89.5	89.8	444460.0
2014-04-25	ANGL	ETF	27.81	27.81	27.56	27.56	39200.0
2014-04-25	AOA	ETF	45.25	45.25	44.92	45.01	19700.0
2014-04-25	AOK	ETF	32.3948	32.41	32.33	32.33	8211.0
2014-04-25	AOM	ETF	34.79	34.79	34.649	34.72	25204.0
2014-04-25	AOR	ETF	39.01	39.0599	38.89	38.89	26825.0
2014-04-25	ARGT	ETF	19.86	19.86	19.86	19.86	500.0
2014-04-25	ASEA	ETF	16.33	16.34	16.25	16.29	97600.0
2014-04-25	ASHR	ETF	22.0	22.0	21.88	21.99	55400.0
2014-04-25	ATMP	ETF	28.54	28.64	28.49	28.64	29900.0
2014-04-25	AVIV	ETF	26.29	26.5	26.02	26.31	264390.0
2014-04-25	AWAY	ETF	34.87	35.58	33.26	33.32	8222252.0
2014-04-25	BAB	ETF	28.96	29.0399	28.91	28.9799	38415.0
2014-04-25	BAL	ETF	57.4	57.73	57.11	57.61	2705.0
2014-04-25	BALT	ETF	6.3	6.4	6.22	6.35	435607.0
2014-04-25	BBH	ETF	86.94	87.18	84.96	85.1	149600.0
2014-04-25	BCHP	ETF	19.9	19.9	19.87	19.87	1948.0
2014-04-25	BCM	ETF	41.699	41.699	41.699	41.699	294.0
2014-04-25	BFOR	ETF	7.5075	7.5075	7.4125	7.4275	97200.0
2014-04-25	BIB	ETF	36.31	37.175	35.27	35.44	904204.0
2014-04-25	BICK	ETF	24.57	24.57	24.35	24.36	13413.0
2014-04-25	BIL	ETF	91.52	91.54	91.52	91.54	110900.0
2014-04-25	BIS	ETF	749.6	769.6	733.2	765.2	20552.5
2014-04-25	BIV	ETF	83.78	83.86	83.68	83.71	163300.0
2014-04-25	BIZD	ETF	20.1	20.1	19.97	19.98	26500.0
2014-04-25	BJK	ETF	50.73	50.73	50.23	50.35	78500.0
2014-04-25	BKF	ETF	35.78	35.78	35.54	35.78	47709.0
2014-04-25	BKLN	ETF	24.67	24.67	24.63	24.65	2187000.0
2014-04-25	BLNG	ETF	36.28	36.28	36.14	36.17	81900.0

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

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