PREVIEW / etf_daily / 2014-02-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-05.parquet
  size:    43 KB
  rows:    1,071

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-05	SPY	ETF	174.78	175.56	173.71	175.17	164230500.0
2014-02-05	QQQ	ETF	84.64	84.9901	83.74	84.69	41969204.0
2014-02-05	IWM	ETF	108.81	109.15	107.27	108.65	60644600.0
2014-02-05	DIA	ETF	153.72	154.51	153.12	154.18	11603200.0
2014-02-05	GLD	ETF	121.76	121.88	120.73	121.29	6800000.0
2014-02-05	TLT	ETF	107.69	107.78	107.01	107.16	10312200.0
2014-02-05	AADR	ETF	35.83	35.88	35.51	35.6	23800.0
2014-02-05	AAXJ	ETF	54.94	55.35	54.74	55.07	473500.0
2014-02-05	ACWI	ETF	54.09	54.35	53.89	54.25	1216200.0
2014-02-05	ACWV	ETF	60.31	60.36	59.92	60.28	52300.0
2014-02-05	ACWX	ETF	43.42	43.53	43.21	43.47	182963.0
2014-02-05	ADRE	ETF	33.29	33.29	32.886	33.12	10636.0
2014-02-05	AFK	ETF	29.815	29.8799	29.5	29.83	6871.0
2014-02-05	AGG	ETF	107.88	107.92	107.69	107.7	1162000.0
2014-02-05	AGQ	ETF	65.76	65.95	64.58	65.11	577200.0
2014-02-05	AGZ	ETF	111.73	111.85	111.65	111.77	30834.0
2014-02-05	AGZD	ETF	24.96	24.96	24.95	24.95	12000.0
2014-02-05	AIA	ETF	42.81	43.122	42.7788	43.01	36256.0
2014-02-05	AIQ	ETF	27.7	29.48	27.65	27.68	22942.0
2014-02-05	AIVI	ETF	45.1	45.35	45.05	45.25	57300.0
2014-02-05	ALTL	ETF	31.43	31.43	31.43	31.43	385.0
2014-02-05	AMJ	ETF	45.87	46.21	45.7	46.14	399086.0
2014-02-05	AMLP	ETF	88.15	88.6	87.85	88.45	426620.0
2014-02-05	ANGL	ETF	26.9	26.9	26.9	26.9	900.0
2014-02-05	AOA	ETF	42.53	42.71	42.43	42.65	18400.0
2014-02-05	AOK	ETF	31.57	31.63	31.4964	31.58	199334.0
2014-02-05	AOM	ETF	33.61	33.64	33.5262	33.62	13389.0
2014-02-05	AOR	ETF	37.22	37.37	37.14	37.33	338661.0
2014-02-05	ARGT	ETF	16.97	17.09	16.75	16.94	5500.0
2014-02-05	ASEA	ETF	14.7	14.74	14.62	14.73	6900.0
2014-02-05	ASHR	ETF	22.76	22.77	22.55	22.66	82100.0
2014-02-05	ATMP	ETF	27.01	27.12	26.97	27.05	9400.0
2014-02-05	AVIV	ETF	23.96	24.05	23.56	23.63	108632.0
2014-02-05	AWAY	ETF	38.81	39.6	38.0	38.49	1244523.0
2014-02-05	BAB	ETF	28.25	28.2599	28.12	28.13	159027.0
2014-02-05	BAL	ETF	53.74	53.82	53.53	53.82	4907.0
2014-02-05	BALT	ETF	5.6	5.89	5.54	5.83	870527.0
2014-02-05	BBH	ETF	95.68	95.68	92.6	94.03	115300.0
2014-02-05	BCM	ETF	39.1	39.14	39.1	39.14	38574.0
2014-02-05	BFOR	ETF	6.985	6.9925	6.8825	6.965	574000.0
2014-02-05	BIB	ETF	42.025	42.24	39.33	40.755	750902.0
2014-02-05	BICK	ETF	22.19	22.256	22.05	22.23	3825.0
2014-02-05	BIL	ETF	91.54	91.56	91.54	91.54	157650.0
2014-02-05	BIS	ETF	721.2	763.12	715.6	740.4	3659.0
2014-02-05	BIV	ETF	83.57	83.57	83.39	83.44	119800.0
2014-02-05	BIZD	ETF	20.56	20.56	20.4	20.5	14800.0
2014-02-05	BJK	ETF	49.27	49.7	48.54	49.33	66700.0
2014-02-05	BKF	ETF	33.9	33.98	33.5425	33.77	93522.0
2014-02-05	BKLN	ETF	24.86	24.89	24.84	24.89	3436200.0
2014-02-05	BLV	ETF	85.43	85.6	85.05	85.09	222300.0

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

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