PREVIEW / etf_daily / 2014-04-04

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-04.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-04-04	SPY	ETF	189.66	189.7	186.1	186.4	169381000.0
2014-04-04	QQQ	ETF	89.29	89.41	86.14	86.37	131213229.0
2014-04-04	IWM	ETF	117.96	118.12	114.02	114.49	86345900.0
2014-04-04	DIA	ETF	166.01	166.06	163.58	163.88	10559700.0
2014-04-04	GLD	ETF	125.2	125.96	124.86	125.57	7278400.0
2014-04-04	TLT	ETF	107.87	108.69	107.85	108.46	8977500.0
2014-04-04	AADR	ETF	38.27	38.27	37.54	37.54	900.0
2014-04-04	AAXJ	ETF	60.21	60.7	59.62	59.65	322300.0
2014-04-04	ACWI	ETF	58.74	58.92	58.06	58.15	1196300.0
2014-04-04	ACWV	ETF	64.82	64.82	64.01	64.21	18900.0
2014-04-04	ACWX	ETF	47.02	47.19	46.66	46.69	131440.0
2014-04-04	ADRE	ETF	37.19	37.4096	36.7135	36.74	18704.0
2014-04-04	AFK	ETF	31.41	31.6975	31.4	31.4001	8235.0
2014-04-04	AGG	ETF	107.66	107.85	107.65	107.78	1043600.0
2014-04-04	AGQ	ETF	66.34	66.72	64.36	64.9	357400.0
2014-04-04	AGZ	ETF	111.45	111.96	111.45	111.5501	11475.0
2014-04-04	AIA	ETF	47.06	47.3465	46.6909	46.6909	26342.0
2014-04-04	AIQ	ETF	33.79	33.9	32.03	32.29	37385.0
2014-04-04	AIRR	ETF	20.01	20.01	19.37	19.41	31000.0
2014-04-04	AIVI	ETF	49.24	49.41	48.94	48.94	12300.0
2014-04-04	AMJ	ETF	47.37	47.72	47.21	47.34	271366.0
2014-04-04	AMLP	ETF	89.45	89.85	89.3	89.3	493780.0
2014-04-04	ANGL	ETF	27.54	27.62	27.54	27.62	900.0
2014-04-04	AOA	ETF	45.77	45.77	45.11	45.16	23300.0
2014-04-04	AOK	ETF	32.4	32.4567	32.3	32.33	16138.0
2014-04-04	AOM	ETF	34.93	34.93	34.6801	34.7	27130.0
2014-04-04	AOR	ETF	39.38	39.38	38.9399	38.94	14180.0
2014-04-04	ARGT	ETF	20.05	20.05	19.63	19.92	9700.0
2014-04-04	ASEA	ETF	16.19	16.32	16.14	16.14	16800.0
2014-04-04	ASHR	ETF	22.22	22.4	22.15	22.22	106200.0
2014-04-04	ATMP	ETF	28.21	28.47	27.94	27.94	10800.0
2014-04-04	AVIV	ETF	25.07	25.18	24.93	25.08	121571.0
2014-04-04	AWAY	ETF	36.62	36.83	33.77	34.28	6164535.0
2014-04-04	BAB	ETF	28.68	28.77	28.6401	28.7301	68040.0
2014-04-04	BAL	ETF	57.9	58.32	57.567	57.58	8848.0
2014-04-04	BALT	ETF	6.16	7.09	6.1575	6.49	5342549.0
2014-04-04	BBH	ETF	91.82	91.82	86.57	87.04	327900.0
2014-04-04	BCM	ETF	40.99	41.0124	40.94	41.0124	1566.0
2014-04-04	BFOR	ETF	7.695	7.705	7.515	7.5375	237600.0
2014-04-04	BIB	ETF	39.965	40.415	35.7	36.33	1900948.0
2014-04-04	BICK	ETF	24.99	24.99	24.67	24.68	611.0
2014-04-04	BIL	ETF	91.54	91.56	91.54	91.54	80750.0
2014-04-04	BIS	ETF	710.0	787.6	702.0	776.04	32347.0
2014-04-04	BIV	ETF	83.12	83.27	83.07	83.24	224300.0
2014-04-04	BIZD	ETF	20.6	20.6	20.28	20.36	17300.0
2014-04-04	BJK	ETF	52.79	52.8	51.58	51.6	25700.0
2014-04-04	BKF	ETF	36.85	37.15	36.36	36.39	114236.0
2014-04-04	BKLN	ETF	24.83	24.84	24.82	24.82	1256600.0
2014-04-04	BLV	ETF	85.95	86.48	85.95	86.23	68000.0
2014-04-04	BMVP	ETF	24.2033	24.2033	23.5971	23.5971	16521.0

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

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