PREVIEW / etf_daily / 2014-09-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-25.parquet
  size:    46 KB
  rows:    1,123

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-09-25	SPY	ETF	199.04	199.05	196.27	196.34	150300000.0
2014-09-25	QQQ	ETF	99.53	99.65	97.7	97.74	68642547.0
2014-09-25	IWM	ETF	111.73	111.83	109.75	110.13	49733600.0
2014-09-25	DIA	ETF	171.5	171.53	169.09	169.17	8910500.0
2014-09-25	GLD	ETF	116.3	117.76	116.2	117.39	7631700.0
2014-09-25	TLT	ETF	115.31	116.18	115.31	116.17	8947800.0
2014-09-25	AADR	ETF	37.47	37.47	37.2	37.2	2500.0
2014-09-25	AAXJ	ETF	62.69	62.69	62.17	62.28	756500.0
2014-09-25	ACWI	ETF	59.72	59.72	58.98	58.98	817100.0
2014-09-25	ACWV	ETF	67.11	67.16	66.53	66.66	20100.0
2014-09-25	ACWX	ETF	46.28	46.28	45.76	45.82	135899.0
2014-09-25	ADRE	ETF	40.59	40.61	39.97	40.03	22293.0
2014-09-25	AFK	ETF	31.62	31.62	31.13	31.26	42878.0
2014-09-25	AGG	ETF	108.98	109.1	108.98	109.07	1161900.0
2014-09-25	AGQ	ETF	48.47	49.45	47.65	48.79	312400.0
2014-09-25	AGZ	ETF	112.28	112.39	112.15	112.261	5706.0
2014-09-25	AGZD	ETF	24.9	24.9	24.855	24.89	18200.0
2014-09-25	AIA	ETF	47.77	47.77	47.33	47.41	32668.0
2014-09-25	AIQ	ETF	24.49	25.09	24.44	24.75	20248.0
2014-09-25	AIRR	ETF	18.82	18.82	18.53	18.53	28300.0
2014-09-25	AIVI	ETF	47.46	47.46	46.96	46.96	38200.0
2014-09-25	AMJ	ETF	52.44	52.65	51.73	51.97	1362040.0
2014-09-25	AMLP	ETF	94.8	95.05	93.8	94.35	874120.0
2014-09-25	ANGL	ETF	27.85	27.85	27.49	27.8	4600.0
2014-09-25	AOA	ETF	46.14	46.14	45.62	45.71	32500.0
2014-09-25	AOK	ETF	32.63	32.63	32.46	32.49	19546.0
2014-09-25	AOM	ETF	35.16	35.16	34.91	34.94	298051.0
2014-09-25	AOR	ETF	39.73	39.75	39.47	39.52	40506.0
2014-09-25	ARGT	ETF	21.38	21.38	21.06	21.06	132300.0
2014-09-25	ASEA	ETF	16.96	16.96	16.82	16.84	2500.0
2014-09-25	ASHR	ETF	25.57	25.58	25.4	25.47	342400.0
2014-09-25	ASHS	ETF	32.93	33.08	32.93	33.05	9900.0
2014-09-25	ATMP	ETF	32.0	32.06	31.54	31.67	29100.0
2014-09-25	AVIV	ETF	26.96	26.96	26.54	26.76	129441.0
2014-09-25	AWAY	ETF	33.41	33.61	32.7	33.06	812808.0
2014-09-25	BAB	ETF	29.56	29.72	29.46	29.67	214787.0
2014-09-25	BAL	ETF	40.8301	41.0633	40.66	40.938	18257.0
2014-09-25	BALT	ETF	4.37	4.37	4.13	4.21	861231.0
2014-09-25	BAR	ETF	3.051	3.145	3.051	3.145	34140.0
2014-09-25	BBH	ETF	108.29	109.06	106.1	106.3	89300.0
2014-09-25	BCHP	ETF	19.46	19.46	19.23	19.2504	857.0
2014-09-25	BCM	ETF	37.006	37.104	36.971	37.043	3055.0
2014-09-25	BFOR	ETF	7.66	7.66	7.555	7.5625	150800.0
2014-09-25	BIB	ETF	53.86	54.5	51.66	52.0949	512048.0
2014-09-25	BICK	ETF	25.46	25.72	25.3201	25.3201	1051.0
2014-09-25	BIL	ETF	91.5	91.52	91.5	91.52	109700.0
2014-09-25	BIS	ETF	464.0	485.196	460.8	481.6	24276.5
2014-09-25	BIV	ETF	84.09	84.27	84.08	84.27	163100.0
2014-09-25	BIZD	ETF	19.88	19.9	19.71	19.72	13600.0
2014-09-25	BJK	ETF	43.93	43.93	43.33	43.44	10600.0

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

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