PREVIEW / etf_daily / 2013-07-09

all etf daily files

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

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-09	SPY	ETF	164.98	165.33	164.27	165.13	119298000.0
2013-07-09	QQQ	ETF	72.98	73.25	72.65	73.09	26115187.0
2013-07-09	IWM	ETF	100.7	101.2	100.3	101.0	36010700.0
2013-07-09	DIA	ETF	152.71	152.99	152.22	152.79	5200200.0
2013-07-09	GLD	ETF	120.84	121.51	120.05	120.62	8201400.0
2013-07-09	TLT	ETF	107.49	107.62	107.07	107.4	4700400.0
2013-07-09	AADR	ETF	32.81	32.91	32.81	32.87	500.0
2013-07-09	AAXJ	ETF	54.26	54.39	53.97	54.29	313100.0
2013-07-09	ACTV	ETF	8.32	8.33	8.06	8.08	250726.0
2013-07-09	ACWI	ETF	51.06	51.07	50.74	51.03	578800.0
2013-07-09	ACWV	ETF	60.65	60.65	60.35	60.6	20600.0
2013-07-09	ACWX	ETF	41.28	41.37	41.071	41.33	334022.0
2013-07-09	ADRE	ETF	33.72	33.84	33.6	33.751	34941.0
2013-07-09	AFK	ETF	27.9	28.01	27.64	27.96	52311.0
2013-07-09	AGEM	ETF	20.31	20.38	20.31	20.38	576.0
2013-07-09	AGG	ETF	106.57	106.57	106.43	106.5	1726000.0
2013-07-09	AGQ	ETF	65.32	66.24	64.8	65.36	379350.0
2013-07-09	AGZ	ETF	110.52	110.77	110.52	110.53	16776.0
2013-07-09	AIA	ETF	42.04	42.3575	42.03	42.26	24434.0
2013-07-09	AIQ	ETF	16.36	16.9	16.26	16.6	94885.0
2013-07-09	AIVI	ETF	40.52	40.6	40.34	40.49	17100.0
2013-07-09	AMJ	ETF	47.64	47.85	47.185	47.8	831102.0
2013-07-09	AMLP	ETF	90.75	90.75	89.55	89.9	691760.0
2013-07-09	ANGL	ETF	26.37	26.38	26.33	26.38	2300.0
2013-07-09	AOA	ETF	40.5	40.5	40.19	40.4	13100.0
2013-07-09	AOK	ETF	30.77	30.82	30.75	30.82	16298.0
2013-07-09	AOM	ETF	32.58	32.58	32.4201	32.52	27595.0
2013-07-09	AOR	ETF	35.87	35.87	35.648	35.77	23310.0
2013-07-09	ARB	ETF	46.39	46.39	46.27	46.35	221074.0
2013-07-09	ARGT	ETF	16.48	16.5	16.47	16.5	2300.0
2013-07-09	ASEA	ETF	16.56	16.6	16.43	16.5	30300.0
2013-07-09	ATMP	ETF	26.35	26.4	26.34	26.4	22800.0
2013-07-09	AVIV	ETF	24.93	25.1	24.7	25.01	167848.0
2013-07-09	AWAY	ETF	32.5	34.0	32.475	33.47	2296143.0
2013-07-09	BAB	ETF	27.9	27.9	27.67	27.7	488901.0
2013-07-09	BAL	ETF	54.88	55.25	54.81	54.97	16787.0
2013-07-09	BALT	ETF	3.8	3.85	3.73	3.8	134577.0
2013-07-09	BBH	ETF	72.88	73.11	72.25	73.02	65800.0
2013-07-09	BCM	ETF	39.27	39.4306	39.27	39.38	14038.0
2013-07-09	BFOR	ETF	6.4	6.425	6.37	6.4225	152800.0
2013-07-09	BIB	ETF	25.16	25.16	24.625	25.0585	62884.0
2013-07-09	BICK	ETF	20.66	20.7121	20.66	20.7121	1214.0
2013-07-09	BIL	ETF	91.58	91.62	91.58	91.58	631600.0
2013-07-09	BIS	ETF	1391.2	1406.4	1379.2	1379.2	33.75
2013-07-09	BIV	ETF	82.84	82.95	82.82	82.87	284400.0
2013-07-09	BIZD	ETF	19.87	20.01	19.84	19.91	5000.0
2013-07-09	BJK	ETF	40.4	40.45	40.2	40.32	19600.0
2013-07-09	BKF	ETF	33.4	33.5905	33.33	33.48	82940.0
2013-07-09	BKLN	ETF	24.75	24.82	24.73	24.8	6175700.0
2013-07-09	BLV	ETF	83.95	84.13	83.63	83.87	110900.0

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

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