PREVIEW / etf_daily / 2013-07-23

all etf daily files

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

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-07-23	SPY	ETF	169.8	169.83	169.05	169.14	80829700.0
2013-07-23	QQQ	ETF	74.95	74.96	74.2	74.26	24748780.0
2013-07-23	IWM	ETF	104.91	104.95	104.25	104.46	26309700.0
2013-07-23	DIA	ETF	155.57	155.67	155.08	155.36	3394100.0
2013-07-23	GLD	ETF	128.7	130.14	128.35	129.71	8820100.0
2013-07-23	TLT	ETF	108.67	109.0	108.32	108.9	5015500.0
2013-07-23	AADR	ETF	33.95	33.95	33.62	33.62	1000.0
2013-07-23	AAXJ	ETF	57.04	57.22	56.75	57.0	825100.0
2013-07-23	ACTV	ETF	8.95	8.95	8.67	8.7	298107.0
2013-07-23	ACWI	ETF	52.98	52.98	52.75	52.82	1538100.0
2013-07-23	ACWV	ETF	62.35	62.67	62.17	62.32	25900.0
2013-07-23	ACWX	ETF	43.22	43.419	43.19	43.32	566604.0
2013-07-23	ADRE	ETF	35.62	35.888	35.62	35.84	11469.0
2013-07-23	AFK	ETF	29.33	29.33	29.02	29.27	16414.0
2013-07-23	AGEM	ETF	21.65	21.66	21.65	21.66	515.0
2013-07-23	AGG	ETF	107.51	107.62	107.43	107.6	502200.0
2013-07-23	AGQ	ETF	72.32	74.16	71.96	73.8	470600.0
2013-07-23	AGZ	ETF	111.5	111.54	111.18	111.29	13009.0
2013-07-23	AIA	ETF	44.26	44.4674	44.18	44.2556	14338.0
2013-07-23	AIQ	ETF	18.4	18.95	18.4	18.64	44296.0
2013-07-23	AIVI	ETF	42.8	42.84	42.64	42.75	60500.0
2013-07-23	ALTL	ETF	29.96	29.96	29.96	29.96	200.0
2013-07-23	AMJ	ETF	48.48	48.574	47.64	47.69	577995.0
2013-07-23	AMLP	ETF	90.85	90.85	89.9	90.1	551700.0
2013-07-23	ANGL	ETF	27.0	27.08	27.0	27.08	4400.0
2013-07-23	AOA	ETF	41.67	41.67	41.53	41.55	32100.0
2013-07-23	AOK	ETF	31.3	31.33	31.2901	31.32	16204.0
2013-07-23	AOM	ETF	33.2	33.2599	33.08	33.08	34552.0
2013-07-23	AOR	ETF	36.68	36.683	36.55	36.58	142162.0
2013-07-23	ARB	ETF	46.44	46.44	46.38	46.43	60551.0
2013-07-23	ARGT	ETF	17.52	17.52	17.52	17.52	100.0
2013-07-23	ASEA	ETF	17.43	17.53	17.42	17.53	9400.0
2013-07-23	ATMP	ETF	26.71	26.71	26.5	26.5	10500.0
2013-07-23	AVIV	ETF	25.76	26.29	25.6401	26.16	78093.0
2013-07-23	AWAY	ETF	31.58	32.0	31.51	31.61	1691953.0
2013-07-23	BAB	ETF	27.95	28.0399	27.86	27.94	330408.0
2013-07-23	BAL	ETF	55.4	55.4	54.15	55.06	10178.0
2013-07-23	BALT	ETF	3.8	3.92	3.723	3.8	193297.0
2013-07-23	BBH	ETF	78.8	78.8	77.03	77.12	68300.0
2013-07-23	BCM	ETF	40.43	40.43	40.43	40.43	5063.0
2013-07-23	BFOR	ETF	6.5925	6.6225	6.55	6.5525	244400.0
2013-07-23	BIB	ETF	29.1725	29.1725	27.68	27.7175	262564.0
2013-07-23	BICK	ETF	22.08	22.15	22.08	22.15	1203.0
2013-07-23	BIL	ETF	91.58	91.6	91.58	91.6	92900.0
2013-07-23	BIS	ETF	1189.2	1231.196	1189.2	1224.8	115.5
2013-07-23	BIV	ETF	83.98	84.1	83.92	84.07	390200.0
2013-07-23	BIZD	ETF	20.45	20.69	20.45	20.69	15500.0
2013-07-23	BJK	ETF	42.41	42.41	42.2	42.25	7800.0
2013-07-23	BKF	ETF	35.85	35.87	35.63	35.77	95062.0
2013-07-23	BKLN	ETF	24.96	24.99	24.96	24.99	1819200.0

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

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