PREVIEW / etf_daily / 2013-08-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-09.parquet
  size:    41 KB
  rows:    1,003

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-08-09	SPY	ETF	169.58	170.1	168.72	169.31	91757700.0
2013-08-09	QQQ	ETF	76.7	76.94	76.27	76.49	18569820.0
2013-08-09	IWM	ETF	103.93	104.57	103.52	104.04	27686900.0
2013-08-09	DIA	ETF	154.49	154.95	153.33	154.11	4550300.0
2013-08-09	GLD	ETF	126.51	127.27	126.3	126.86	6192000.0
2013-08-09	TLT	ETF	106.6	107.27	106.48	107.26	3623400.0
2013-08-09	AADR	ETF	34.12	34.12	34.12	34.12	1000.0
2013-08-09	AAXJ	ETF	55.8	55.99	55.71	55.73	179900.0
2013-08-09	ACTV	ETF	9.98	10.09	9.81	9.82	567489.0
2013-08-09	ACWI	ETF	52.84	53.09	52.78	52.98	729700.0
2013-08-09	ACWV	ETF	62.09	62.1	61.74	62.0	14200.0
2013-08-09	ACWX	ETF	43.28	43.53	43.28	43.43	227830.0
2013-08-09	ADRE	ETF	35.61	36.0	35.61	35.95	14080.0
2013-08-09	AFK	ETF	29.77	29.86	29.58	29.83	46043.0
2013-08-09	AGG	ETF	107.06	107.19	106.97	107.15	389800.0
2013-08-09	AGQ	ETF	72.28	74.24	71.92	73.44	465700.0
2013-08-09	AGZ	ETF	111.15	111.26	111.09	111.23	10370.0
2013-08-09	AIA	ETF	43.74	43.8346	43.66	43.71	6973.0
2013-08-09	AIQ	ETF	22.33	23.73	21.91	23.6	116997.0
2013-08-09	AIVI	ETF	43.24	43.45	43.23	43.35	28400.0
2013-08-09	AMJ	ETF	46.44	47.11	46.44	47.05	190234.0
2013-08-09	AMLP	ETF	87.75	88.2	87.6	87.75	459420.0
2013-08-09	ANGL	ETF	26.41	26.41	26.4	26.4	700.0
2013-08-09	AOA	ETF	41.61	41.7	41.51	41.63	31400.0
2013-08-09	AOK	ETF	31.24	31.25	31.2	31.2235	19064.0
2013-08-09	AOM	ETF	33.14	33.18	33.081	33.16	57300.0
2013-08-09	AOR	ETF	36.61	36.68	36.56	36.62	34913.0
2013-08-09	ARB	ETF	46.06	46.17	46.06	46.15	87549.0
2013-08-09	ARGT	ETF	18.23	18.28	18.23	18.28	9800.0
2013-08-09	ASEA	ETF	17.0	17.12	16.97	17.07	17600.0
2013-08-09	ATMP	ETF	26.65	26.77	26.57	26.57	28300.0
2013-08-09	AVIV	ETF	24.69	24.86	24.39	24.45	98111.0
2013-08-09	AWAY	ETF	29.74	30.57	29.25	30.37	1047762.0
2013-08-09	BAB	ETF	27.61	27.79	27.61	27.72	193676.0
2013-08-09	BAL	ETF	56.79	57.12	56.79	57.0	6173.0
2013-08-09	BALT	ETF	4.0	4.06	3.87	3.92	80742.0
2013-08-09	BBH	ETF	78.34	78.98	77.92	78.13	47000.0
2013-08-09	BCM	ETF	39.6801	39.82	39.6801	39.756	2467.0
2013-08-09	BFOR	ETF	6.6525	6.675	6.63	6.6525	158400.0
2013-08-09	BIB	ETF	28.535	28.9277	28.3525	28.6125	69364.0
2013-08-09	BICK	ETF	21.9	21.9542	21.83	21.9542	2397.0
2013-08-09	BIL	ETF	91.58	91.6	91.58	91.6	172650.0
2013-08-09	BIS	ETF	1182.28	1188.8	1180.0	1188.8	24.8
2013-08-09	BIV	ETF	83.5	83.64	83.47	83.62	136300.0
2013-08-09	BIZD	ETF	20.3	20.32	20.02	20.26	31100.0
2013-08-09	BJK	ETF	42.7	42.87	42.57	42.66	2200.0
2013-08-09	BKF	ETF	34.88	35.17	34.8	35.0	42818.0
2013-08-09	BKLN	ETF	24.88	24.9	24.86	24.9	2037500.0
2013-08-09	BLV	ETF	83.65	83.87	83.45	83.77	58200.0
2013-08-09	BMVP	ETF	20.14	20.164	20.08	20.123	2330.0

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

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