PREVIEW / etf_daily / 2013-01-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-11.parquet
  size:    40 KB
  rows:    965

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-01-11	SPY	ETF	147.04	147.15	146.61	147.07	113917300.0
2013-01-11	QQQ	ETF	67.14	67.29	67.0	67.26	21160468.0
2013-01-11	IWM	ETF	87.4	87.54	87.0	87.34	27322400.0
2013-01-11	DIA	ETF	134.46	134.8	134.21	134.72	4508000.0
2013-01-11	GLD	ETF	161.86	161.9	160.11	161.06	13675600.0
2013-01-11	TLT	ETF	118.52	119.86	118.35	119.85	4770700.0
2013-01-11	AADR	ETF	32.3	32.3	32.3	32.3	200.0
2013-01-11	AAXJ	ETF	60.82	60.85	60.56	60.81	264000.0
2013-01-11	ACTV	ETF	5.66	5.78	5.5	5.78	535879.0
2013-01-11	ACWI	ETF	49.27	49.32	49.1	49.27	425700.0
2013-01-11	ACWV	ETF	56.75	56.93	56.75	56.93	32100.0
2013-01-11	ACWX	ETF	42.72	42.74	42.5123	42.7	219798.0
2013-01-11	ADRE	ETF	40.98	41.19	40.98	41.14	144340.0
2013-01-11	AFK	ETF	31.53	31.53	31.11	31.2	75517.0
2013-01-11	AGEM	ETF	23.75	23.75	23.4301	23.6125	3085.0
2013-01-11	AGG	ETF	110.64	110.91	110.62	110.85	1120000.0
2013-01-11	AGQ	ETF	179.84	179.92	173.28	176.96	376600.0
2013-01-11	AGZ	ETF	113.33	113.3899	113.18	113.33	12316.0
2013-01-11	AIA	ETF	48.26	48.274	48.1199	48.26	35288.0
2013-01-11	AIQ	ETF	6.72	6.72	6.68	6.68	4214.0
2013-01-11	AIVI	ETF	42.63	42.77	42.57	42.75	26200.0
2013-01-11	AMJ	ETF	41.39	41.39	41.07	41.28	1630619.0
2013-01-11	AMLP	ETF	83.6	83.65	83.25	83.65	798400.0
2013-01-11	ANGL	ETF	27.37	27.37	27.24	27.36	1200.0
2013-01-11	AOA	ETF	38.05	38.1	37.98	38.1	35000.0
2013-01-11	AOK	ETF	30.74	30.8	30.73	30.7701	24219.0
2013-01-11	AOM	ETF	32.06	32.0776	32.01	32.05	83726.0
2013-01-11	AOR	ETF	34.53	34.53	34.4558	34.518	26768.0
2013-01-11	ARB	ETF	46.85	46.85	46.81	46.84	438375.0
2013-01-11	ARGT	ETF	18.26	18.26	18.1	18.18	400.0
2013-01-11	ASEA	ETF	16.97	17.0	16.88	16.96	27600.0
2013-01-11	AWAY	ETF	22.41	22.54	21.7	22.16	447090.0
2013-01-11	BAB	ETF	30.0	30.1895	30.0	30.1201	422468.0
2013-01-11	BAL	ETF	49.49	49.82	48.57	49.4	77904.0
2013-01-11	BALT	ETF	3.39	3.42	3.33	3.38	19971.0
2013-01-11	BBH	ETF	57.18	57.18	56.4	56.79	44600.0
2013-01-11	BCM	ETF	44.41	44.41	43.629	43.93	1566.0
2013-01-11	BIB	ETF	16.4625	16.4625	16.1193	16.23	54000.0
2013-01-11	BICK	ETF	25.78	25.85	25.7401	25.85	5459.0
2013-01-11	BIL	ETF	91.62	91.62	91.6	91.6	58750.0
2013-01-11	BIS	ETF	2312.0	2356.8	2312.0	2356.8	12.5
2013-01-11	BIV	ETF	87.81	88.06	87.75	88.06	198600.0
2013-01-11	BJK	ETF	37.74	37.79	37.67	37.73	204400.0
2013-01-11	BKF	ETF	41.54	41.54	41.28	41.32	216552.0
2013-01-11	BKLN	ETF	25.19	25.2	25.16	25.2	1715100.0
2013-01-11	BLV	ETF	92.47	93.36	92.47	93.36	72600.0
2013-01-11	BMVP	ETF	16.8833	16.8867	16.8362	16.8867	2347.0
2013-01-11	BND	ETF	83.67	83.85	83.67	83.83	1385000.0
2013-01-11	BNO	ETF	40.835	40.93	40.58	40.91	42600.0
2013-01-11	BOIL	ETF	738800.0	768000.0	731600.0	762800.0	21.6

> showing 50 of 965 rows — these rows as CSV

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