PREVIEW / etf_daily / 2014-03-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-24.parquet
  size:    44 KB
  rows:    1,080

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-03-24	SPY	ETF	186.84	187.07	184.62	185.43	121411000.0
2014-03-24	QQQ	ETF	89.32	89.39	87.41	88.22	77735313.0
2014-03-24	IWM	ETF	119.07	119.23	116.19	117.26	66747000.0
2014-03-24	DIA	ETF	163.13	163.46	161.78	162.44	6336000.0
2014-03-24	GLD	ETF	126.87	127.14	126.03	126.18	13076500.0
2014-03-24	TLT	ETF	108.05	109.09	107.95	109.0	7536400.0
2014-03-24	AADR	ETF	37.4	37.4	37.4	37.4	1300.0
2014-03-24	AAXJ	ETF	57.26	57.49	57.07	57.35	299900.0
2014-03-24	ACWI	ETF	57.12	57.28	56.67	56.91	1835200.0
2014-03-24	ACWV	ETF	63.2	63.31	62.76	63.09	31200.0
2014-03-24	ACWX	ETF	45.26	45.325	44.9	45.14	365308.0
2014-03-24	ADRE	ETF	35.03	35.0614	34.79	34.99	14082.0
2014-03-24	AFK	ETF	31.38	31.38	30.925	31.2	19877.0
2014-03-24	AGG	ETF	107.58	107.77	107.5	107.75	712800.0
2014-03-24	AGQ	ETF	66.66	66.78	65.04	65.35	416100.0
2014-03-24	AGZ	ETF	111.22	111.52	111.22	111.4601	12209.0
2014-03-24	AIA	ETF	44.21	44.35	44.19	44.22	8233.0
2014-03-24	AIQ	ETF	31.45	31.45	29.99	30.06	17170.0
2014-03-24	AIRR	ETF	20.1	20.11	19.57	19.68	60500.0
2014-03-24	AIVI	ETF	48.0	48.0	47.55	47.84	14300.0
2014-03-24	AMJ	ETF	46.09	46.13	45.4801	45.74	566611.0
2014-03-24	AMLP	ETF	87.5	87.65	86.75	87.1	594500.0
2014-03-24	ANGL	ETF	27.58	27.59	27.45	27.47	4600.0
2014-03-24	AOA	ETF	45.03	45.03	44.52	44.72	21200.0
2014-03-24	AOK	ETF	32.26	32.2999	32.12	32.1545	18595.0
2014-03-24	AOM	ETF	34.64	34.64	34.42	34.54	40316.0
2014-03-24	AOR	ETF	38.86	38.91	38.596	38.76	20345.0
2014-03-24	ARGT	ETF	19.27	19.27	18.88	19.0	2500.0
2014-03-24	ASEA	ETF	15.5	15.52	15.49	15.5	3500.0
2014-03-24	ASHR	ETF	22.11	22.15	22.09	22.12	200500.0
2014-03-24	ATMP	ETF	27.13	27.24	27.08	27.19	25000.0
2014-03-24	AVIV	ETF	24.69	24.81	24.0	24.13	590253.0
2014-03-24	AWAY	ETF	41.13	41.33	39.35	39.54	1360384.0
2014-03-24	BAB	ETF	28.53	28.6799	28.52	28.63	66310.0
2014-03-24	BAL	ETF	57.92	58.01	56.1	56.83	24528.0
2014-03-24	BALT	ETF	6.62	6.65	6.161	6.36	554911.0
2014-03-24	BBH	ETF	94.41	94.55	89.3	92.18	721100.0
2014-03-24	BCM	ETF	40.53	40.5999	39.9	40.42	7983.0
2014-03-24	BFOR	ETF	7.6675	7.685	7.52	7.5775	189200.0
2014-03-24	BIB	ETF	43.585	44.0	38.75	40.995	2112874.0
2014-03-24	BICK	ETF	23.42	23.55	23.4	23.55	2090.0
2014-03-24	BIL	ETF	91.54	91.56	91.54	91.56	254350.0
2014-03-24	BIS	ETF	665.6	738.0	656.4	702.8	45020.0
2014-03-24	BIV	ETF	83.06	83.22	83.0	83.17	213000.0
2014-03-24	BIZD	ETF	20.6	20.63	20.55	20.63	2500.0
2014-03-24	BJK	ETF	52.01	52.09	51.31	51.72	82400.0
2014-03-24	BKF	ETF	34.58	34.64	34.37	34.58	132985.0
2014-03-24	BKLN	ETF	24.8	24.82	24.79	24.81	1842900.0
2014-03-24	BLV	ETF	85.85	86.42	85.8	86.37	63500.0
2014-03-24	BMVP	ETF	23.79	23.8267	23.3971	23.54	8421.0

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

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