PREVIEW / etf_daily / 2014-03-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-07.parquet
  size:    43 KB
  rows:    1,067

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-07	SPY	ETF	188.96	188.96	187.43	188.26	114513500.0
2014-03-07	QQQ	ETF	91.27	91.36	90.071	90.53	31174837.0
2014-03-07	IWM	ETF	120.41	120.47	119.03	119.7	36931800.0
2014-03-07	DIA	ETF	164.76	164.89	163.81	164.34	7381900.0
2014-03-07	GLD	ETF	128.25	129.23	128.21	129.09	7575000.0
2014-03-07	TLT	ETF	105.64	106.17	105.6	105.89	8270300.0
2014-03-07	AAXJ	ETF	58.72	58.72	58.01	58.37	706600.0
2014-03-07	ACWI	ETF	58.48	58.48	57.89	58.1	743300.0
2014-03-07	ACWV	ETF	63.93	63.93	63.7	63.89	8700.0
2014-03-07	ACWX	ETF	46.71	46.71	46.24	46.44	72852.0
2014-03-07	ADRE	ETF	35.65	35.65	35.16	35.3	10104.0
2014-03-07	AFK	ETF	31.9	31.9	31.5	31.5085	9880.0
2014-03-07	AGG	ETF	107.46	107.56	107.42	107.47	701700.0
2014-03-07	AGQ	ETF	71.0	72.68	70.81	71.7	898700.0
2014-03-07	AGZ	ETF	111.274	111.48	111.274	111.32	19942.0
2014-03-07	AIA	ETF	45.56	45.6365	45.2704	45.51	3842.0
2014-03-07	AIQ	ETF	31.2	31.2689	29.5	29.76	35737.0
2014-03-07	AIVI	ETF	49.62	49.75	49.18	49.22	25400.0
2014-03-07	AMJ	ETF	46.39	46.39	46.05	46.2	1846284.0
2014-03-07	AMLP	ETF	87.7	87.8	87.2	87.6	796900.0
2014-03-07	ANGL	ETF	27.55	27.55	27.41	27.41	1100.0
2014-03-07	AOA	ETF	45.58	45.58	45.21	45.31	28500.0
2014-03-07	AOK	ETF	32.45	32.45	32.318	32.44	41794.0
2014-03-07	AOM	ETF	34.89	34.89	34.7	34.89	117924.0
2014-03-07	AOR	ETF	39.15	39.15	39.0	39.13	35876.0
2014-03-07	ARGT	ETF	19.2	19.43	19.2	19.34	4200.0
2014-03-07	ASEA	ETF	15.76	15.76	15.57	15.57	7000.0
2014-03-07	ASHR	ETF	22.32	22.33	22.17	22.25	91100.0
2014-03-07	ATMP	ETF	27.52	27.52	27.35	27.42	11600.0
2014-03-07	AVIV	ETF	25.27	25.285	24.57	25.09	162411.0
2014-03-07	AWAY	ETF	47.12	47.37	46.26	46.64	915200.0
2014-03-07	BAB	ETF	28.36	28.5099	28.35	28.42	94072.0
2014-03-07	BAL	ETF	58.03	58.05	56.7701	56.8207	30764.0
2014-03-07	BALT	ETF	7.64	7.64	7.44	7.48	1003998.0
2014-03-07	BBH	ETF	101.88	101.99	98.17	99.88	371200.0
2014-03-07	BCM	ETF	41.32	41.35	41.28	41.29	83000.0
2014-03-07	BFOR	ETF	7.7375	7.75	7.6775	7.7125	204400.0
2014-03-07	BIB	ETF	50.33	50.365	46.655	48.525	1179218.0
2014-03-07	BICK	ETF	23.67	23.74	23.67	23.74	1338.0
2014-03-07	BIL	ETF	91.54	91.56	91.54	91.54	90550.0
2014-03-07	BIS	ETF	588.4	629.2	581.6	604.0	21254.0
2014-03-07	BIV	ETF	83.05	83.14	82.99	83.03	282000.0
2014-03-07	BIZD	ETF	20.99	20.99	20.73	20.79	21900.0
2014-03-07	BJK	ETF	55.89	55.89	55.08	55.48	13300.0
2014-03-07	BKF	ETF	34.77	34.81	34.35	34.54	43956.0
2014-03-07	BKLN	ETF	24.87	24.87	24.84	24.86	8082400.0
2014-03-07	BLV	ETF	84.31	84.58	84.22	84.42	81900.0
2014-03-07	BMVP	ETF	23.66	23.6967	23.5767	23.6193	6339.0
2014-03-07	BND	ETF	80.9	80.95	80.86	80.89	1926100.0
2014-03-07	BNDX	ETF	50.35	50.44	50.31	50.39	98000.0

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

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