PREVIEW / etf_daily / 2013-09-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-26.parquet
  size:    41 KB
  rows:    1,001

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-09-26	SPY	ETF	169.32	170.17	169.05	169.69	77146900.0
2013-09-26	QQQ	ETF	78.87	79.36	78.85	79.17	22421656.0
2013-09-26	IWM	ETF	106.75	107.47	106.36	107.06	29490600.0
2013-09-26	DIA	ETF	152.7	153.54	152.47	152.95	5026300.0
2013-09-26	GLD	ETF	128.61	128.99	127.32	127.79	9491300.0
2013-09-26	TLT	ETF	106.48	106.62	106.19	106.3	5117100.0
2013-09-26	AADR	ETF	35.72	35.72	35.66	35.66	500.0
2013-09-26	AAXJ	ETF	59.35	59.46	59.05	59.39	637400.0
2013-09-26	ACTV	ETF	11.15	11.37	11.07	11.33	469222.0
2013-09-26	ACWI	ETF	54.37	54.67	54.35	54.53	680900.0
2013-09-26	ACWV	ETF	62.45	62.45	62.16	62.36	14400.0
2013-09-26	ACWX	ETF	45.46	45.51	45.23	45.3903	250353.0
2013-09-26	ADRE	ETF	37.57	37.65	37.4	37.49	48169.0
2013-09-26	AFK	ETF	30.05	30.42	29.8938	29.99	18404.0
2013-09-26	AGEM	ETF	22.63	22.63	22.62	22.63	500.0
2013-09-26	AGG	ETF	107.2	107.23	107.1	107.23	588100.0
2013-09-26	AGQ	ETF	81.28	81.84	80.04	80.48	238900.0
2013-09-26	AGZ	ETF	111.15	111.23	111.09	111.096	19068.0
2013-09-26	AIA	ETF	47.05	47.21	47.05	47.13	37982.0
2013-09-26	AIQ	ETF	24.38	24.955	24.26	24.5	46055.0
2013-09-26	AIVI	ETF	45.7	45.95	45.66	45.8	41700.0
2013-09-26	ALTL	ETF	30.4146	30.4146	30.4146	30.4146	150.0
2013-09-26	AMJ	ETF	44.47	44.829	44.17	44.67	624435.0
2013-09-26	AMLP	ETF	87.6	88.15	87.35	88.1	882440.0
2013-09-26	ANGL	ETF	26.55	26.61	26.55	26.61	2100.0
2013-09-26	AOA	ETF	42.38	42.38	42.19	42.29	34900.0
2013-09-26	AOK	ETF	31.42	31.49	31.42	31.45	19433.0
2013-09-26	AOM	ETF	33.41	33.49	33.41	33.49	11832.0
2013-09-26	AOR	ETF	37.0879	37.096	36.9901	37.03	28869.0
2013-09-26	ARB	ETF	47.99	48.0	47.98	48.0	164514.0
2013-09-26	ARGT	ETF	19.94	20.02	19.94	20.0	1500.0
2013-09-26	ASEA	ETF	16.75	16.81	16.71	16.81	94700.0
2013-09-26	ATMP	ETF	26.08	26.22	26.08	26.22	15800.0
2013-09-26	AVIV	ETF	23.21	23.49	23.14	23.26	163908.0
2013-09-26	AWAY	ETF	29.47	29.7	28.68	28.99	3469245.0
2013-09-26	BAB	ETF	27.31	27.33	27.22	27.255	135792.0
2013-09-26	BAL	ETF	54.33	54.7999	54.33	54.7601	3500.0
2013-09-26	BALT	ETF	5.35	5.54	5.1	5.39	1810929.0
2013-09-26	BBH	ETF	81.69	83.25	81.69	82.87	57500.0
2013-09-26	BFOR	ETF	6.8225	6.865	6.8125	6.845	225600.0
2013-09-26	BIB	ETF	31.935	33.15	31.935	32.925	99536.0
2013-09-26	BICK	ETF	23.84	23.92	23.84	23.84	1104.0
2013-09-26	BIL	ETF	91.6	91.6	91.58	91.58	102050.0
2013-09-26	BIS	ETF	1018.168	1023.6	1010.8	1020.0	129.0
2013-09-26	BIV	ETF	83.42	83.44	83.29	83.35	184100.0
2013-09-26	BIZD	ETF	20.58	20.58	20.45	20.51	9600.0
2013-09-26	BJK	ETF	47.89	47.98	47.69	47.74	10100.0
2013-09-26	BKF	ETF	37.9	38.1	37.7	37.92	118398.0
2013-09-26	BKLN	ETF	24.74	24.75	24.69	24.7	2230800.0
2013-09-26	BLV	ETF	83.32	83.35	83.07	83.2	50700.0

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

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