PREVIEW / etf_daily / 2013-04-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-17.parquet
  size:    41 KB
  rows:    988

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-04-17	SPY	ETF	156.29	156.32	154.28	155.11	226834800.0
2013-04-17	QQQ	ETF	68.84	68.889	67.71	68.115	60204793.0
2013-04-17	IWM	ETF	90.92	91.02	89.23	90.08	77710600.0
2013-04-17	DIA	ETF	146.55	146.6	145.37	145.95	10757100.0
2013-04-17	GLD	ETF	133.81	134.95	132.32	132.87	25444100.0
2013-04-17	TLT	ETF	122.3	123.53	122.3	122.79	9020900.0
2013-04-17	AAXJ	ETF	57.38	57.44	56.83	57.18	511400.0
2013-04-17	ACTV	ETF	4.39	4.85	4.34	4.78	407113.0
2013-04-17	ACWI	ETF	50.6	50.6	49.89	50.12	566100.0
2013-04-17	ACWV	ETF	62.31	62.31	61.74	62.0	76400.0
2013-04-17	ACWX	ETF	42.53	42.53	41.905	42.13	265737.0
2013-04-17	ADRE	ETF	37.37	37.37	36.651	36.83	29143.0
2013-04-17	AFK	ETF	28.87	28.87	28.17	28.26	318428.0
2013-04-17	AGEM	ETF	21.6328	21.6328	21.4876	21.4876	811.0
2013-04-17	AGG	ETF	111.2	111.44	111.2	111.25	1078500.0
2013-04-17	AGQ	ETF	99.6	102.2	96.84	98.04	807000.0
2013-04-17	AGZ	ETF	113.75	113.778	113.54	113.74	14401.0
2013-04-17	AIA	ETF	44.63	44.63	44.19	44.364	36869.0
2013-04-17	AIQ	ETF	9.27	9.58	9.27	9.47	9349.0
2013-04-17	AIVI	ETF	42.28	42.28	41.72	41.89	27700.0
2013-04-17	AMJ	ETF	45.15	45.2	44.69	45.16	935736.0
2013-04-17	AMLP	ETF	87.7	88.05	87.4	87.7	549620.0
2013-04-17	ANGL	ETF	27.01	27.26	27.01	27.23	2700.0
2013-04-17	AOA	ETF	39.48	39.48	39.05	39.2	48500.0
2013-04-17	AOK	ETF	31.23	31.23	31.12	31.13	19792.0
2013-04-17	AOM	ETF	32.73	32.73	32.541	32.62	22514.0
2013-04-17	AOR	ETF	35.54	35.54	35.24	35.31	38807.0
2013-04-17	ARB	ETF	46.7	46.73	46.68	46.71	438350.0
2013-04-17	ARGT	ETF	16.26	16.26	16.1	16.1	400.0
2013-04-17	ASEA	ETF	17.78	17.83	17.73	17.75	8000.0
2013-04-17	ATMP	ETF	26.19	26.19	25.6	25.6	18900.0
2013-04-17	AVIV	ETF	24.08	24.45	24.01	24.32	126990.0
2013-04-17	AWAY	ETF	33.32	33.55	31.81	32.4	1649330.0
2013-04-17	BAB	ETF	30.73	30.88	30.73	30.83	176388.0
2013-04-17	BAL	ETF	53.75	55.1	53.55	54.45	74610.0
2013-04-17	BALT	ETF	3.58	3.58	3.3524	3.48	53903.0
2013-04-17	BBH	ETF	68.48	68.48	67.08	68.12	157600.0
2013-04-17	BCM	ETF	39.71	39.71	39.626	39.626	514.0
2013-04-17	BIB	ETF	21.5825	21.5825	20.5	21.405	215036.0
2013-04-17	BICK	ETF	22.99	23.0	22.76	22.8243	3442.0
2013-04-17	BIL	ETF	91.6	91.62	91.6	91.62	73450.0
2013-04-17	BIS	ETF	1727.2	1780.0	1727.2	1743.6	139.0
2013-04-17	BIV	ETF	88.39	88.57	88.39	88.46	184200.0
2013-04-17	BIZD	ETF	19.6	19.6	19.17	19.27	7100.0
2013-04-17	BJK	ETF	39.33	39.33	39.02	39.14	4800.0
2013-04-17	BKF	ETF	37.41	37.43	36.871	37.07	110338.0
2013-04-17	BKLN	ETF	25.11	25.11	25.07	25.1	7269600.0
2013-04-17	BLNG	ETF	40.22	40.22	40.22	40.22	100.0
2013-04-17	BLV	ETF	94.18	94.6	94.07	94.34	41100.0
2013-04-17	BMVP	ETF	18.298	18.298	18.0833	18.1234	3117.0

> showing 50 of 988 rows — these rows as CSV

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