PREVIEW / etf_daily / 2013-11-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-15.parquet
  size:    42 KB
  rows:    1,048

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
2013-11-15	SPY	ETF	179.56	180.12	179.33	180.05	102818000.0
2013-11-15	QQQ	ETF	83.83	83.96	83.61	83.96	20515761.0
2013-11-15	IWM	ETF	110.6	110.99	110.16	110.83	27518500.0
2013-11-15	DIA	ETF	158.57	159.3	158.48	159.3	6529100.0
2013-11-15	GLD	ETF	124.16	124.52	124.07	124.32	4660700.0
2013-11-15	TLT	ETF	104.66	104.74	104.31	104.73	6344800.0
2013-11-15	AADR	ETF	36.66	36.71	36.58	36.67	2200.0
2013-11-15	AAXJ	ETF	59.7	60.59	59.68	60.29	455200.0
2013-11-15	ACTV	ETF	14.49	14.5	14.49	14.49	539550.0
2013-11-15	ACWI	ETF	56.6	56.84	56.6	56.83	523500.0
2013-11-15	ACWV	ETF	64.84	64.84	64.59	64.83	18900.0
2013-11-15	ACWX	ETF	46.28	46.51	46.28	46.47	235235.0
2013-11-15	ADRE	ETF	37.91	38.379	37.8	38.24	23316.0
2013-11-15	AFK	ETF	31.25	31.37	31.2499	31.37	19119.0
2013-11-15	AGG	ETF	107.37	107.39	107.28	107.36	1853400.0
2013-11-15	AGQ	ETF	72.44	72.8	72.32	72.6	197925.0
2013-11-15	AGZ	ETF	111.5	111.74	111.45	111.72	11806.0
2013-11-15	AIA	ETF	48.0	48.57	48.0	48.33	48095.0
2013-11-15	AIQ	ETF	23.67	25.359	23.38	24.96	33355.0
2013-11-15	AIVI	ETF	46.96	47.15	46.95	47.15	17900.0
2013-11-15	ALTL	ETF	31.9729	31.9729	31.9729	31.9729	125.0
2013-11-15	AMJ	ETF	45.38	46.019	45.38	45.97	361801.0
2013-11-15	AMLP	ETF	86.95	88.05	86.9	88.05	741540.0
2013-11-15	ANGL	ETF	26.7	26.85	26.7	26.75	2300.0
2013-11-15	AOA	ETF	43.8	43.9	43.73	43.88	19400.0
2013-11-15	AOK	ETF	31.89	31.95	31.8601	31.95	20649.0
2013-11-15	AOM	ETF	34.13	34.18	34.09	34.18	63656.0
2013-11-15	AOR	ETF	38.08	38.15	38.05	38.15	22279.0
2013-11-15	ARGT	ETF	19.92	20.11	19.84	20.11	3700.0
2013-11-15	ASEA	ETF	16.64	16.88	16.64	16.88	5200.0
2013-11-15	ASHR	ETF	25.02	25.54	24.97	25.37	472100.0
2013-11-15	ATMP	ETF	26.95	26.95	26.79	26.88	43500.0
2013-11-15	AVIV	ETF	25.41	25.91	25.3933	25.86	151280.0
2013-11-15	AWAY	ETF	36.34	39.22	36.3	38.25	5502110.0
2013-11-15	BAB	ETF	27.49	27.5	27.41	27.49	143583.0
2013-11-15	BAL	ETF	48.76	49.14	48.7	48.956	3126.0
2013-11-15	BALT	ETF	4.89	4.99	4.79	4.79	484864.0
2013-11-15	BBH	ETF	82.5	83.41	81.84	83.3	49900.0
2013-11-15	BCM	ETF	39.15	39.166	39.15	39.166	742.0
2013-11-15	BFOR	ETF	7.23	7.24	7.2	7.235	278400.0
2013-11-15	BIB	ETF	32.4975	33.115	32.2225	33.0575	228212.0
2013-11-15	BICK	ETF	24.43	24.72	24.39	24.67	5054.0
2013-11-15	BIL	ETF	91.58	91.58	91.56	91.56	91950.0
2013-11-15	BIS	ETF	975.2	996.36	960.0	967.56	402.5
2013-11-15	BIV	ETF	83.9	83.9	83.62	83.84	201300.0
2013-11-15	BIZD	ETF	20.88	21.03	20.88	21.03	3700.0
2013-11-15	BJK	ETF	50.02	50.25	49.91	49.98	16000.0
2013-11-15	BKF	ETF	38.3	38.75	38.15	38.5	218589.0
2013-11-15	BKLN	ETF	24.81	24.83	24.8	24.83	2786800.0
2013-11-15	BLV	ETF	82.78	82.82	82.5	82.78	31700.0

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

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