PREVIEW / etf_daily / 2013-06-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-07.parquet
  size:    41 KB
  rows:    1,002

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-06-07	SPY	ETF	163.85	164.95	163.14	164.8	188337800.0
2013-06-07	QQQ	ETF	72.73	73.47	72.52	73.39	31971148.0
2013-06-07	IWM	ETF	97.9	98.45	97.27	98.2	44757500.0
2013-06-07	DIA	ETF	151.16	152.44	150.7	152.32	8087900.0
2013-06-07	GLD	ETF	134.11	134.62	133.18	133.28	11054400.0
2013-06-07	TLT	ETF	114.22	114.83	113.16	113.16	10459300.0
2013-06-07	AADR	ETF	33.62	33.93	33.62	33.72	25300.0
2013-06-07	AAXJ	ETF	57.49	57.78	57.22	57.49	754600.0
2013-06-07	ACTV	ETF	7.4	7.505	7.32	7.5	550683.0
2013-06-07	ACWI	ETF	51.72	52.12	51.52	52.1	814700.0
2013-06-07	ACWV	ETF	60.75	61.12	60.55	61.06	23600.0
2013-06-07	ACWX	ETF	42.62	42.9401	42.45	42.92	129543.0
2013-06-07	ADRE	ETF	36.7	37.0016	36.35	36.75	37438.0
2013-06-07	AFK	ETF	29.89	29.94	29.6	29.82	62689.0
2013-06-07	AGEM	ETF	21.22	21.4721	21.22	21.3	2671.0
2013-06-07	AGG	ETF	108.67	108.91	108.54	108.61	1337400.0
2013-06-07	AGQ	ETF	86.88	88.44	83.4	83.48	956350.0
2013-06-07	AGZ	ETF	112.6	112.6	112.2501	112.2608	14838.0
2013-06-07	AIA	ETF	44.62	44.85	44.37	44.65	23425.0
2013-06-07	AIQ	ETF	16.14	16.23	15.77	16.02	42808.0
2013-06-07	AIVI	ETF	42.51	42.92	42.43	42.9	34200.0
2013-06-07	AMJ	ETF	45.35	45.99	45.15	45.9	769013.0
2013-06-07	AMLP	ETF	87.1	87.95	87.05	87.95	383180.0
2013-06-07	ANGL	ETF	27.23	27.23	27.07	27.21	1000.0
2013-06-07	AOA	ETF	40.49	40.72	40.37	40.72	7800.0
2013-06-07	AOK	ETF	31.14	31.1936	31.131	31.18	4540.0
2013-06-07	AOM	ETF	32.89	32.96	32.84	32.9	11613.0
2013-06-07	AOR	ETF	36.03	36.15	35.94	36.15	11742.0
2013-06-07	ARB	ETF	46.84	47.02	46.78	46.99	196420.0
2013-06-07	ASEA	ETF	17.34	17.46	17.29	17.41	375600.0
2013-06-07	ATMP	ETF	25.34	25.55	25.34	25.54	15300.0
2013-06-07	AVIV	ETF	26.5	26.76	26.11	26.7	306974.0
2013-06-07	AWAY	ETF	29.71	30.0	29.24	29.65	304443.0
2013-06-07	BAB	ETF	29.81	29.86	29.6	29.6832	271228.0
2013-06-07	BAL	ETF	53.45	54.09	53.15	53.3	13754.0
2013-06-07	BALT	ETF	3.54	3.54	3.45	3.53	114802.0
2013-06-07	BBH	ETF	69.8	70.98	69.8	70.87	145800.0
2013-06-07	BFOR	ETF	6.33	6.33	6.22	6.265	105200.0
2013-06-07	BIB	ETF	23.6725	24.25	23.6725	24.2153	231328.0
2013-06-07	BICK	ETF	22.89	22.9117	22.753	22.77	2173.0
2013-06-07	BIL	ETF	91.58	91.62	91.58	91.62	275000.0
2013-06-07	BIS	ETF	1502.8	1502.8	1451.2	1451.2	234.0
2013-06-07	BIV	ETF	85.83	85.95	85.59	85.68	459300.0
2013-06-07	BIZD	ETF	19.87	19.92	19.74	19.86	6900.0
2013-06-07	BJK	ETF	41.73	42.12	41.65	41.94	7600.0
2013-06-07	BKF	ETF	36.91	37.27	36.79	36.99	181110.0
2013-06-07	BKLN	ETF	24.93	24.96	24.88	24.96	5139600.0
2013-06-07	BLV	ETF	88.69	89.09	88.39	88.42	52200.0
2013-06-07	BMVP	ETF	19.18	19.33	19.15	19.33	4075.0
2013-06-07	BND	ETF	82.1	82.26	81.96	82.0	1194600.0

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

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