PREVIEW / etf_daily / 2013-10-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-25.parquet
  size:    42 KB
  rows:    1,042

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-10-25	SPY	ETF	175.51	176.0	175.17	175.95	93625000.0
2013-10-25	QQQ	ETF	83.1	83.28	82.5	82.9	35832381.0
2013-10-25	IWM	ETF	111.24	111.45	110.57	111.08	21321900.0
2013-10-25	DIA	ETF	154.91	155.45	154.79	155.45	4565000.0
2013-10-25	GLD	ETF	129.53	130.92	129.46	130.46	8767900.0
2013-10-25	TLT	ETF	108.13	108.45	108.08	108.29	4429500.0
2013-10-25	AADR	ETF	36.87	36.87	36.87	36.87	100.0
2013-10-25	AAXJ	ETF	59.92	60.25	59.9	60.21	418900.0
2013-10-25	ACTV	ETF	14.41	14.41	14.38	14.4	1302581.0
2013-10-25	ACWI	ETF	56.3	56.33	56.12	56.33	1269400.0
2013-10-25	ACWV	ETF	64.0	64.12	63.86	64.12	17900.0
2013-10-25	ACWX	ETF	46.61	46.72	46.5601	46.69	173555.0
2013-10-25	ADRE	ETF	38.34	38.41	38.18	38.36	16877.0
2013-10-25	AFK	ETF	31.6434	32.02	31.6434	31.9499	5476.0
2013-10-25	AGG	ETF	108.01	108.1	107.96	108.01	484300.0
2013-10-25	AGQ	ETF	84.4	87.08	84.24	85.88	268100.0
2013-10-25	AGZ	ETF	112.58	112.59	111.77	111.86	26196.0
2013-10-25	AIA	ETF	47.6	47.6	47.4811	47.56	87515.0
2013-10-25	AIQ	ETF	31.69	31.69	25.016	25.57	123035.0
2013-10-25	AIVI	ETF	47.71	47.73	47.53	47.65	56000.0
2013-10-25	AMJ	ETF	46.0	46.38	46.0	46.16	713666.0
2013-10-25	AMLP	ETF	89.8	90.1	89.65	89.9	418680.0
2013-10-25	ANGL	ETF	26.85	27.0	26.82	26.99	5000.0
2013-10-25	AOA	ETF	43.44	43.49	43.36	43.49	18800.0
2013-10-25	AOK	ETF	31.92	31.92	31.87	31.91	22548.0
2013-10-25	AOM	ETF	34.02	34.04	33.96	34.01	39831.0
2013-10-25	AOR	ETF	37.85	37.88	37.7801	37.88	50702.0
2013-10-25	ARGT	ETF	21.72	21.72	21.12	21.17	5600.0
2013-10-25	ASEA	ETF	17.29	17.36	17.29	17.35	5500.0
2013-10-25	ATMP	ETF	27.0	27.15	27.0	27.15	36800.0
2013-10-25	AVIV	ETF	25.35	25.76	25.3	25.68	83756.0
2013-10-25	AWAY	ETF	29.65	30.23	29.455	30.01	719861.0
2013-10-25	BAB	ETF	27.81	27.8989	27.77	27.8	139375.0
2013-10-25	BAL	ETF	50.45	51.03	50.28	50.282	11074.0
2013-10-25	BALT	ETF	5.04	5.04	4.82	4.82	704578.0
2013-10-25	BBH	ETF	83.44	83.74	82.73	83.74	70000.0
2013-10-25	BCM	ETF	40.15	40.15	40.1	40.1	340.0
2013-10-25	BFOR	ETF	7.17	7.17	7.085	7.115	326400.0
2013-10-25	BIB	ETF	33.2275	33.3375	32.3575	33.085	158384.0
2013-10-25	BICK	ETF	24.65	24.79	24.641	24.79	1150.0
2013-10-25	BIL	ETF	91.56	91.58	91.56	91.58	69650.0
2013-10-25	BIS	ETF	980.0	997.6	980.0	984.0	585.0
2013-10-25	BIV	ETF	84.51	84.63	84.48	84.55	239100.0
2013-10-25	BIZD	ETF	20.82	20.83	20.8	20.8	600.0
2013-10-25	BJK	ETF	50.82	50.82	50.5	50.76	23400.0
2013-10-25	BKF	ETF	38.17	38.37	38.14	38.3	61570.0
2013-10-25	BKLN	ETF	24.76	24.79	24.75	24.78	4692400.0
2013-10-25	BLV	ETF	84.8	84.93	84.73	84.91	38900.0
2013-10-25	BMVP	ETF	21.5233	21.5233	21.4261	21.4767	1787.0
2013-10-25	BND	ETF	81.46	81.51	81.42	81.5	703100.0

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

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