PREVIEW / etf_daily / 2013-09-27

all etf daily files

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

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-27	SPY	ETF	168.84	169.14	168.47	168.91	99141800.0
2013-09-27	QQQ	ETF	78.74	79.21	78.59	79.07	25151521.0
2013-09-27	IWM	ETF	106.39	107.05	106.21	106.58	30296400.0
2013-09-27	DIA	ETF	152.3	152.44	151.76	152.21	6634800.0
2013-09-27	GLD	ETF	128.86	129.58	128.84	128.97	7430200.0
2013-09-27	TLT	ETF	106.29	106.82	106.25	106.56	6460000.0
2013-09-27	AAXJ	ETF	59.14	59.14	58.73	58.9	293100.0
2013-09-27	ACTV	ETF	11.25	11.52	11.22	11.4	534760.0
2013-09-27	ACWI	ETF	54.33	54.4	54.2	54.3	576000.0
2013-09-27	ACWV	ETF	62.26	62.26	62.0	62.07	41800.0
2013-09-27	ACWX	ETF	45.08	45.2984	45.08	45.2	165985.0
2013-09-27	ADRE	ETF	37.3	37.394	37.19	37.23	29447.0
2013-09-27	AFK	ETF	30.0	30.1	29.9	29.91	37898.0
2013-09-27	AGEM	ETF	22.4501	22.4939	22.4501	22.4939	2128.0
2013-09-27	AGG	ETF	107.2	107.36	107.17	107.29	427900.0
2013-09-27	AGQ	ETF	80.8	81.92	80.6	80.72	325350.0
2013-09-27	AGZ	ETF	111.11	111.22	111.093	111.11	17392.0
2013-09-27	AIA	ETF	47.06	47.12	47.01	47.1	18299.0
2013-09-27	AIQ	ETF	24.48	24.9	24.3	24.47	26605.0
2013-09-27	AIVI	ETF	45.85	45.85	45.68	45.8	23200.0
2013-09-27	AMJ	ETF	44.42	44.63	44.28	44.47	1720133.0
2013-09-27	AMLP	ETF	88.0	88.1	87.4	87.9	403800.0
2013-09-27	ANGL	ETF	26.55	26.55	26.55	26.55	200.0
2013-09-27	AOA	ETF	42.12	42.23	42.12	42.21	5600.0
2013-09-27	AOK	ETF	31.39	31.46	31.39	31.44	26477.0
2013-09-27	AOM	ETF	33.41	33.45	33.4001	33.44	18268.0
2013-09-27	AOR	ETF	36.93	37.022	36.9202	36.96	6445.0
2013-09-27	ARB	ETF	47.99	48.01	47.99	48.0	1301469.0
2013-09-27	ARGT	ETF	20.0	20.03	20.0	20.03	1000.0
2013-09-27	ASEA	ETF	16.7	16.7	16.59	16.6	10700.0
2013-09-27	ATMP	ETF	26.07	26.17	26.03	26.11	19500.0
2013-09-27	AVIV	ETF	23.25	23.54	23.09	23.19	111633.0
2013-09-27	AWAY	ETF	29.02	29.5949	28.7	29.1	2084383.0
2013-09-27	BAB	ETF	27.28	27.339	27.23	27.26	63458.0
2013-09-27	BAL	ETF	55.569	55.69	55.43	55.5599	7904.0
2013-09-27	BALT	ETF	5.33	5.35	5.17	5.23	1076276.0
2013-09-27	BBH	ETF	82.52	83.57	82.35	83.27	38700.0
2013-09-27	BFOR	ETF	6.8225	6.8375	6.8	6.83	273200.0
2013-09-27	BIB	ETF	32.5275	33.4275	32.184	33.155	107940.0
2013-09-27	BICK	ETF	23.705	23.705	23.69	23.69	1300.0
2013-09-27	BIL	ETF	91.58	91.6	91.58	91.58	247300.0
2013-09-27	BIS	ETF	1026.0	1026.0	997.2	1009.2	196.5
2013-09-27	BIV	ETF	83.35	83.6	83.35	83.44	223500.0
2013-09-27	BIZD	ETF	20.46	20.54	20.46	20.54	7900.0
2013-09-27	BJK	ETF	47.67	47.67	47.44	47.46	8900.0
2013-09-27	BKF	ETF	37.56	37.67	37.4101	37.49	42627.0
2013-09-27	BKLN	ETF	24.72	24.73	24.68	24.72	1405900.0
2013-09-27	BLNG	ETF	38.23	38.23	38.18	38.18	300.0
2013-09-27	BLV	ETF	83.0	83.28	83.0	83.17	80900.0
2013-09-27	BMVP	ETF	20.273	20.3133	20.2491	20.2491	701.0

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

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