PREVIEW / etf_daily / 2013-10-07

all etf daily files

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

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-07	SPY	ETF	167.42	168.45	167.25	167.43	96295000.0
2013-10-07	QQQ	ETF	78.72	79.35	78.67	78.74	20234683.0
2013-10-07	IWM	ETF	105.99	106.66	105.72	105.77	32924200.0
2013-10-07	DIA	ETF	149.12	149.85	148.91	149.0	6081100.0
2013-10-07	GLD	ETF	127.25	128.33	127.12	127.64	6732800.0
2013-10-07	TLT	ETF	106.2	106.36	105.98	106.14	5761100.0
2013-10-07	AADR	ETF	35.45	35.49	35.23	35.26	15900.0
2013-10-07	AAXJ	ETF	59.38	59.8	59.22	59.48	2055100.0
2013-10-07	ACTV	ETF	14.35	14.38	14.35	14.37	1274556.0
2013-10-07	ACWI	ETF	53.55	54.05	53.55	53.79	858300.0
2013-10-07	ACWV	ETF	61.5	61.72	61.44	61.5	24000.0
2013-10-07	ACWX	ETF	44.46	44.91	44.46	44.7	264178.0
2013-10-07	ADRE	ETF	37.34	37.649	37.34	37.54	8815.0
2013-10-07	AFK	ETF	30.14	30.2999	30.14	30.272	12500.0
2013-10-07	AGG	ETF	107.23	107.25	107.02	107.04	559600.0
2013-10-07	AGQ	ETF	82.16	85.84	81.84	84.96	546000.0
2013-10-07	AGZ	ETF	111.082	111.185	111.0601	111.185	13335.0
2013-10-07	AIA	ETF	47.34	47.4434	47.241	47.34	7350.0
2013-10-07	AIQ	ETF	29.97	31.93	29.2056	30.61	40055.0
2013-10-07	AIVI	ETF	45.27	45.52	45.27	45.39	16900.0
2013-10-07	AMJ	ETF	44.22	44.55	44.21	44.21	478654.0
2013-10-07	AMLP	ETF	87.7	87.85	87.3	87.3	399280.0
2013-10-07	ANGL	ETF	26.31	26.34	26.31	26.34	900.0
2013-10-07	AOA	ETF	41.75	41.92	41.71	41.78	23500.0
2013-10-07	AOK	ETF	31.31	31.35	31.286	31.31	18315.0
2013-10-07	AOM	ETF	33.18	33.25	33.17	33.17	14086.0
2013-10-07	AOR	ETF	36.66	36.78	36.66	36.721	55153.0
2013-10-07	ARGT	ETF	19.76	19.94	19.72	19.91	3900.0
2013-10-07	ASEA	ETF	16.69	16.74	16.68	16.72	7700.0
2013-10-07	ATMP	ETF	26.08	26.08	25.95	26.02	31200.0
2013-10-07	AVIV	ETF	23.14	23.27	22.95	23.17	80653.0
2013-10-07	AWAY	ETF	29.63	29.86	29.21	29.26	691455.0
2013-10-07	BAB	ETF	27.41	27.453	27.32	27.3699	188701.0
2013-10-07	BAL	ETF	55.24	55.24	53.504	53.6684	16193.0
2013-10-07	BALT	ETF	5.15	5.2899	5.04	5.15	585055.0
2013-10-07	BBH	ETF	82.97	82.97	81.26	81.26	59900.0
2013-10-07	BCM	ETF	40.45	40.466	40.45	40.466	374.0
2013-10-07	BFOR	ETF	6.8575	6.8575	6.8	6.8075	168800.0
2013-10-07	BIB	ETF	33.02	33.165	32.1625	32.1715	177288.0
2013-10-07	BICK	ETF	24.0199	24.0199	24.0	24.0	323.0
2013-10-07	BIL	ETF	91.6	91.6	91.58	91.6	203000.0
2013-10-07	BIS	ETF	1004.4	1036.4	1004.4	1034.0	160.0
2013-10-07	BIV	ETF	83.43	83.5	83.3	83.33	154000.0
2013-10-07	BIZD	ETF	20.15	20.15	19.96	19.97	6600.0
2013-10-07	BJK	ETF	48.27	48.51	48.12	48.2	9400.0
2013-10-07	BKF	ETF	37.75	38.09	37.75	37.95	52608.0
2013-10-07	BKLN	ETF	24.72	24.74	24.71	24.73	1093000.0
2013-10-07	BLNG	ETF	37.97	37.97	37.97	37.97	600.0
2013-10-07	BLV	ETF	83.0	83.05	82.8	82.89	38600.0
2013-10-07	BMVP	ETF	20.38	20.38	20.3	20.3	1112.0

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

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