PREVIEW / etf_daily / 2014-03-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-10.parquet
  size:    43 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-03-10	SPY	ETF	187.97	188.23	187.08	188.16	74939200.0
2014-03-10	QQQ	ETF	90.48	90.655	90.03	90.61	18138198.0
2014-03-10	IWM	ETF	119.36	119.58	118.49	119.3	32089000.0
2014-03-10	DIA	ETF	164.05	164.16	163.18	163.99	3995400.0
2014-03-10	GLD	ETF	128.88	129.61	128.78	129.13	4169900.0
2014-03-10	TLT	ETF	105.94	106.11	105.78	106.04	3744300.0
2014-03-10	AADR	ETF	38.32	38.32	37.83	37.83	600.0
2014-03-10	AAXJ	ETF	57.86	57.99	57.58	57.97	515200.0
2014-03-10	ACWI	ETF	57.8	57.94	57.58	57.9	960800.0
2014-03-10	ACWV	ETF	63.5	63.74	63.48	63.65	28900.0
2014-03-10	ACWX	ETF	46.15	46.16	45.86	46.12	363253.0
2014-03-10	ADRE	ETF	35.0	35.0	34.62	34.85	12843.0
2014-03-10	AFK	ETF	31.42	31.6	31.22	31.54	12076.0
2014-03-10	AGG	ETF	107.5	107.56	107.46	107.47	877800.0
2014-03-10	AGQ	ETF	71.45	72.27	71.03	71.2	350600.0
2014-03-10	AGZ	ETF	110.78	111.41	110.78	111.4	31043.0
2014-03-10	AIA	ETF	45.0	45.06	44.79	45.0431	24110.0
2014-03-10	AIQ	ETF	29.62	31.16	29.59	30.2	21420.0
2014-03-10	AIVI	ETF	49.16	49.16	48.78	49.04	30800.0
2014-03-10	AMJ	ETF	46.19	46.38	45.91	45.99	839542.0
2014-03-10	AMLP	ETF	87.5	87.7	87.1	87.15	384680.0
2014-03-10	ANGL	ETF	27.53	27.54	27.5	27.53	6500.0
2014-03-10	AOA	ETF	45.28	45.28	45.02	45.18	12200.0
2014-03-10	AOK	ETF	32.35	32.35	32.27	32.34	23949.0
2014-03-10	AOM	ETF	34.76	34.76	34.63	34.74	27920.0
2014-03-10	AOR	ETF	39.11	39.11	38.924	39.04	26703.0
2014-03-10	ARGT	ETF	19.21	19.21	18.8	18.81	4000.0
2014-03-10	ASEA	ETF	15.6	15.6	15.49	15.49	3000.0
2014-03-10	ASHR	ETF	21.66	21.67	21.07	21.49	358800.0
2014-03-10	ATMP	ETF	27.28	27.31	27.22	27.22	35200.0
2014-03-10	AVIV	ETF	25.14	25.37	24.75	24.92	82124.0
2014-03-10	AWAY	ETF	46.3	46.37	44.76	45.74	1611632.0
2014-03-10	BAB	ETF	28.44	28.464	28.4	28.4	75233.0
2014-03-10	BAL	ETF	57.23	57.942	56.9	57.33	10369.0
2014-03-10	BALT	ETF	7.47	7.5	7.251	7.33	576243.0
2014-03-10	BBH	ETF	99.9	100.64	98.8	100.58	97400.0
2014-03-10	BCM	ETF	41.08	41.26	40.99	40.99	85215.0
2014-03-10	BFOR	ETF	7.715	7.715	7.6525	7.7	130000.0
2014-03-10	BIB	ETF	48.425	49.0	47.175	48.985	560504.0
2014-03-10	BICK	ETF	23.51	23.51	23.49	23.49	1643.0
2014-03-10	BIL	ETF	91.54	91.56	91.54	91.54	293450.0
2014-03-10	BIS	ETF	611.6	623.196	597.6	600.8	6852.5
2014-03-10	BIV	ETF	82.95	83.1	82.95	83.1	179300.0
2014-03-10	BIZD	ETF	20.9	20.92	20.75	20.92	17500.0
2014-03-10	BJK	ETF	55.04	55.04	54.23	54.42	10500.0
2014-03-10	BKF	ETF	34.22	34.22	33.95	34.19	49035.0
2014-03-10	BKLN	ETF	24.87	24.88	24.85	24.85	1544900.0
2014-03-10	BLV	ETF	84.39	84.52	84.37	84.45	49500.0
2014-03-10	BMVP	ETF	23.6167	23.6627	23.4884	23.5633	6122.0
2014-03-10	BND	ETF	80.9	80.95	80.88	80.94	2006400.0

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

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