PREVIEW / etf_daily / 2014-02-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-28.parquet
  size:    44 KB
  rows:    1,074

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-02-28	SPY	ETF	185.79	187.15	185.05	186.29	150842000.0
2014-02-28	QQQ	ETF	90.41	90.96	89.54	90.34	48623159.0
2014-02-28	IWM	ETF	117.96	118.71	116.8	117.52	47362700.0
2014-02-28	DIA	ETF	162.56	163.77	162.01	163.02	10010400.0
2014-02-28	GLD	ETF	128.27	128.35	127.15	127.62	10584100.0
2014-02-28	TLT	ETF	108.28	108.74	107.78	108.57	8462600.0
2014-02-28	AADR	ETF	38.36	38.46	37.94	38.46	700.0
2014-02-28	AAXJ	ETF	58.58	58.58	57.85	58.15	534400.0
2014-02-28	ACWI	ETF	57.69	58.09	57.52	57.81	1432900.0
2014-02-28	ACWV	ETF	63.28	63.84	63.26	63.55	43400.0
2014-02-28	ACWX	ETF	46.31	46.54	46.18	46.33	340258.0
2014-02-28	ADRE	ETF	35.3	35.37	34.9	35.14	193073.0
2014-02-28	AFK	ETF	31.33	31.486	31.16	31.36	19664.0
2014-02-28	AGG	ETF	108.24	108.32	108.12	108.27	1589500.0
2014-02-28	AGQ	ETF	75.15	75.15	73.12	73.63	649000.0
2014-02-28	AGZ	ETF	111.89	111.998	111.82	111.95	17134.0
2014-02-28	AIA	ETF	45.68	45.81	45.39	45.39	15128.0
2014-02-28	AIQ	ETF	30.77	31.48	30.13	30.14	13666.0
2014-02-28	AIVI	ETF	48.92	49.29	48.85	48.95	17500.0
2014-02-28	ALTL	ETF	33.7274	33.7274	33.7274	33.7274	100.0
2014-02-28	AMJ	ETF	46.09	46.11	45.75	45.84	503114.0
2014-02-28	AMLP	ETF	87.4	87.5	86.9	87.05	780540.0
2014-02-28	ANGL	ETF	27.68	27.68	27.68	27.68	500.0
2014-02-28	AOA	ETF	45.07	45.26	44.91	45.09	27100.0
2014-02-28	AOK	ETF	32.38	32.43	32.32	32.36	24014.0
2014-02-28	AOM	ETF	34.73	34.8	34.689	34.69	87952.0
2014-02-28	AOR	ETF	38.87	39.08	38.87	38.93	17383.0
2014-02-28	ARGT	ETF	18.71	19.07	18.71	18.97	800.0
2014-02-28	ASEA	ETF	15.61	15.63	15.48	15.5	4000.0
2014-02-28	ASHR	ETF	22.47	22.55	22.38	22.38	118800.0
2014-02-28	ATMP	ETF	27.09	27.24	27.02	27.19	15000.0
2014-02-28	AVIV	ETF	25.0	25.46	24.98	25.36	90733.0
2014-02-28	AWAY	ETF	46.88	47.04	45.33	45.87	1489672.0
2014-02-28	BAB	ETF	28.58	28.6399	28.4984	28.605	118910.0
2014-02-28	BAL	ETF	54.2	54.46	53.98	54.46	7502.0
2014-02-28	BALT	ETF	6.46	6.92	6.44	6.85	1480744.0
2014-02-28	BBH	ETF	104.88	105.11	100.87	102.3	209800.0
2014-02-28	BCM	ETF	40.88	41.02	40.81	40.9	45671.0
2014-02-28	BFOR	ETF	7.6025	7.65	7.5575	7.605	190800.0
2014-02-28	BIB	ETF	53.815	54.0	49.025	50.425	1284782.0
2014-02-28	BICK	ETF	23.7633	23.7633	23.56	23.56	516.0
2014-02-28	BIL	ETF	91.54	91.56	91.54	91.56	167350.0
2014-02-28	BIS	ETF	553.6	600.0	548.4	585.6	11340.5
2014-02-28	BIV	ETF	83.85	83.94	83.71	83.91	262400.0
2014-02-28	BIZD	ETF	21.27	21.27	21.2	21.21	7300.0
2014-02-28	BJK	ETF	54.94	55.1	54.71	54.93	30800.0
2014-02-28	BKF	ETF	35.24	35.39	34.83	35.0	223561.0
2014-02-28	BKLN	ETF	24.86	24.87	24.85	24.87	2831400.0
2014-02-28	BLV	ETF	86.3	86.37	86.03	86.24	381300.0
2014-02-28	BMVP	ETF	23.21	23.283	23.205	23.233	3607.0

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

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