PREVIEW / etf_daily / 2013-10-09

all etf daily files

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

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-09	SPY	ETF	165.8	166.2	164.53	165.6	168973000.0
2013-10-09	QQQ	ETF	77.4	77.44	76.35	76.98	64526694.0
2013-10-09	IWM	ETF	104.3	104.36	103.0	103.64	52604900.0
2013-10-09	DIA	ETF	147.69	148.32	146.96	147.78	11075200.0
2013-10-09	GLD	ETF	126.21	126.89	124.97	126.11	10705100.0
2013-10-09	TLT	ETF	105.87	105.94	105.3	105.32	8439000.0
2013-10-09	AADR	ETF	34.8	35.0	34.78	34.92	17000.0
2013-10-09	AAXJ	ETF	59.48	59.81	59.17	59.61	313700.0
2013-10-09	ACTV	ETF	14.4	14.41	14.355	14.37	3315667.0
2013-10-09	ACWI	ETF	53.45	53.52	53.03	53.34	867000.0
2013-10-09	ACWV	ETF	61.43	61.43	61.01	61.25	44200.0
2013-10-09	ACWX	ETF	44.47	44.65	44.26	44.56	110729.0
2013-10-09	ADRE	ETF	37.17	37.1855	36.79	37.04	74343.0
2013-10-09	AFK	ETF	30.1	30.21	29.968	30.2099	18912.0
2013-10-09	AGG	ETF	107.1	107.1	106.88	106.91	771500.0
2013-10-09	AGQ	ETF	82.0	82.76	80.6	81.44	531200.0
2013-10-09	AGZ	ETF	110.88	111.1	110.88	111.0092	4854.0
2013-10-09	AIA	ETF	47.33	47.45	47.0606	47.29	59751.0
2013-10-09	AIQ	ETF	29.48	29.59	26.44	26.7	82621.0
2013-10-09	AIVI	ETF	45.11	45.28	44.99	45.16	44400.0
2013-10-09	AMJ	ETF	43.92	44.01	43.46	43.96	994050.0
2013-10-09	AMLP	ETF	88.25	88.25	86.35	87.0	567160.0
2013-10-09	ANGL	ETF	26.5	26.5	26.27	26.27	1700.0
2013-10-09	AOA	ETF	41.43	41.49	41.22	41.41	14000.0
2013-10-09	AOK	ETF	31.192	31.2	31.1201	31.2	13647.0
2013-10-09	AOM	ETF	33.0	33.06	32.93	33.02	29091.0
2013-10-09	AOR	ETF	36.47	36.49	36.291	36.43	15941.0
2013-10-09	ARGT	ETF	19.33	19.59	19.14	19.48	3500.0
2013-10-09	ASEA	ETF	16.6	16.69	16.55	16.69	5500.0
2013-10-09	ATMP	ETF	25.71	25.72	25.57	25.71	9400.0
2013-10-09	AVIV	ETF	22.93	23.24	22.83	22.85	50550.0
2013-10-09	AWAY	ETF	28.82	28.82	27.74	28.41	923319.0
2013-10-09	BAB	ETF	27.38	27.47	27.33	27.37	107312.0
2013-10-09	BAL	ETF	53.46	53.48	53.11	53.3	4998.0
2013-10-09	BALT	ETF	4.95	4.98	4.62	4.72	1359586.0
2013-10-09	BBH	ETF	77.35	77.35	74.27	75.76	303900.0
2013-10-09	BFOR	ETF	6.6825	6.6925	6.615	6.67	232800.0
2013-10-09	BIB	ETF	29.24	29.25	27.02	28.025	891912.0
2013-10-09	BICK	ETF	24.045	24.045	24.045	24.045	250.0
2013-10-09	BIL	ETF	91.56	91.58	91.56	91.58	325100.0
2013-10-09	BIS	ETF	1124.0	1212.6	1124.0	1169.6	2829.5
2013-10-09	BIV	ETF	83.34	83.42	83.21	83.28	494200.0
2013-10-09	BIZD	ETF	19.8	19.9	19.8	19.9	400.0
2013-10-09	BJK	ETF	48.03	48.09	47.48	47.85	21900.0
2013-10-09	BKF	ETF	38.11	38.18	37.831	38.09	25127.0
2013-10-09	BKLN	ETF	24.73	24.73	24.69	24.71	2045000.0
2013-10-09	BLNG	ETF	37.38	37.38	37.38	37.38	400.0
2013-10-09	BLV	ETF	82.8	82.87	82.64	82.7	20900.0
2013-10-09	BMVP	ETF	19.9233	20.06	19.8553	20.06	3588.0
2013-10-09	BND	ETF	80.7	80.72	80.58	80.63	1117400.0

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

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