PREVIEW / etf_daily / 2013-11-26

all etf daily files

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

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-26	SPY	ETF	180.72	181.22	180.41	180.68	86994000.0
2013-11-26	QQQ	ETF	84.22	84.84	84.025	84.63	26629288.0
2013-11-26	IWM	ETF	111.99	113.02	111.9	112.82	30760700.0
2013-11-26	DIA	ETF	160.54	160.97	160.46	160.5	5231300.0
2013-11-26	GLD	ETF	119.84	120.4	119.59	119.82	9053300.0
2013-11-26	TLT	ETF	104.49	104.93	104.48	104.6	6659200.0
2013-11-26	AADR	ETF	36.92	36.92	36.92	36.92	100.0
2013-11-26	AAXJ	ETF	60.08	60.18	59.74	60.04	447600.0
2013-11-26	ACWI	ETF	56.76	56.81	56.59	56.66	1442500.0
2013-11-26	ACWV	ETF	64.42	64.47	64.21	64.23	23300.0
2013-11-26	ACWX	ETF	46.26	46.26	46.09	46.2	167185.0
2013-11-26	ADRE	ETF	37.55	37.66	37.34	37.55	24502.0
2013-11-26	AFK	ETF	31.24	31.24	30.75	30.9	33877.0
2013-11-26	AGG	ETF	107.34	107.52	107.33	107.35	1625600.0
2013-11-26	AGQ	ETF	66.68	67.24	65.96	66.24	279575.0
2013-11-26	AGZ	ETF	111.77	111.77	111.53	111.54	11653.0
2013-11-26	AIA	ETF	48.47	48.75	48.47	48.68	16765.0
2013-11-26	AIQ	ETF	25.66	28.1	25.5	27.99	33825.0
2013-11-26	AIVI	ETF	47.01	47.1	46.85	46.99	11400.0
2013-11-26	AMJ	ETF	45.44	45.7	45.305	45.45	1539989.0
2013-11-26	AMLP	ETF	88.55	88.7	88.25	88.3	461800.0
2013-11-26	ANGL	ETF	27.05	27.1	27.05	27.1	400.0
2013-11-26	AOA	ETF	43.88	43.97	43.83	43.9	72700.0
2013-11-26	AOK	ETF	31.93	31.98	31.911	31.96	19911.0
2013-11-26	AOM	ETF	34.11	34.21	34.11	34.17	20948.0
2013-11-26	AOR	ETF	38.14	38.21	38.121	38.17	13780.0
2013-11-26	ARGT	ETF	20.41	20.52	20.29	20.43	5100.0
2013-11-26	ASEA	ETF	16.29	16.32	16.13	16.32	23500.0
2013-11-26	ASHR	ETF	25.13	25.17	25.04	25.1	230200.0
2013-11-26	ATMP	ETF	26.86	26.86	26.81	26.81	4600.0
2013-11-26	AVIV	ETF	25.55	25.62	25.15	25.31	1484641.0
2013-11-26	AWAY	ETF	35.64	36.3	34.69	36.08	1753147.0
2013-11-26	BAB	ETF	27.61	27.64	27.571	27.6	104227.0
2013-11-26	BAL	ETF	49.86	49.88	49.31	49.64	8332.0
2013-11-26	BALT	ETF	4.71	4.75	4.65	4.66	248878.0
2013-11-26	BBH	ETF	87.82	87.82	87.06	87.27	117000.0
2013-11-26	BCM	ETF	39.25	39.25	39.25	39.25	200.0
2013-11-26	BFOR	ETF	7.28	7.325	7.2575	7.315	390400.0
2013-11-26	BIB	ETF	36.8925	36.8925	36.036	36.3925	163440.0
2013-11-26	BICK	ETF	24.35	24.5299	24.35	24.5299	1125.0
2013-11-26	BIL	ETF	91.56	91.58	91.56	91.56	62550.0
2013-11-26	BIS	ETF	880.8	880.8	853.2	866.88	165.0
2013-11-26	BIV	ETF	83.74	83.95	83.74	83.85	122600.0
2013-11-26	BIZD	ETF	21.3	21.42	21.26	21.42	15600.0
2013-11-26	BJK	ETF	49.27	49.46	49.17	49.31	27600.0
2013-11-26	BKF	ETF	38.12	38.26	38.02	38.24	41096.0
2013-11-26	BKLN	ETF	24.85	24.85	24.83	24.85	2022900.0
2013-11-26	BLV	ETF	82.81	83.11	82.81	82.98	100400.0
2013-11-26	BMVP	ETF	22.2767	22.37	22.2767	22.3534	1170.0
2013-11-26	BND	ETF	80.98	81.06	80.97	80.97	1177800.0

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

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