PREVIEW / etf_daily / 2013-08-26

all etf daily files

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

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-26	SPY	ETF	166.79	167.3	165.89	166.0	89702100.0
2013-08-26	QQQ	ETF	76.72	77.28	76.55	76.71	27525409.0
2013-08-26	IWM	ETF	103.36	103.82	102.77	103.18	23376100.0
2013-08-26	DIA	ETF	149.83	150.27	149.19	149.21	5770200.0
2013-08-26	GLD	ETF	134.88	135.6	134.15	135.45	7692100.0
2013-08-26	TLT	ETF	104.56	104.89	104.33	104.81	5879100.0
2013-08-26	AADR	ETF	33.71	33.86	33.69	33.82	17900.0
2013-08-26	AAXJ	ETF	55.07	55.07	54.42	54.51	561100.0
2013-08-26	ACTV	ETF	9.62	10.275	9.57	10.18	639577.0
2013-08-26	ACWI	ETF	52.33	52.43	52.05	52.1	796400.0
2013-08-26	ACWV	ETF	60.56	60.84	60.43	60.5	48700.0
2013-08-26	ACWX	ETF	42.98	43.109	42.86	42.86	227524.0
2013-08-26	ADRE	ETF	35.62	35.62	35.09	35.09	10011.0
2013-08-26	AFK	ETF	29.5	29.6	29.33	29.41	60811.0
2013-08-26	AGEM	ETF	21.16	21.16	20.98	20.98	696.0
2013-08-26	AGG	ETF	106.11	106.11	106.0	106.09	922400.0
2013-08-26	AGQ	ETF	101.84	103.6	99.52	102.88	816575.0
2013-08-26	AGZ	ETF	110.5	110.61	110.391	110.53	21544.0
2013-08-26	AIA	ETF	44.1	44.2199	43.83	43.88	17644.0
2013-08-26	AIQ	ETF	23.91	24.8099	23.41	24.26	102670.0
2013-08-26	AIVI	ETF	43.15	43.22	43.1	43.1	13800.0
2013-08-26	AMJ	ETF	45.85	46.05	45.04	45.13	702369.0
2013-08-26	AMLP	ETF	87.95	88.05	86.85	87.15	670340.0
2013-08-26	ANGL	ETF	26.38	26.39	26.24	26.38	4900.0
2013-08-26	AOA	ETF	41.07	41.23	41.05	41.05	11300.0
2013-08-26	AOK	ETF	30.96	31.01	30.93	30.93	20063.0
2013-08-26	AOM	ETF	32.83	32.8304	32.72	32.77	15351.0
2013-08-26	AOR	ETF	36.18	36.2477	36.07	36.07	28359.0
2013-08-26	ARB	ETF	46.74	46.85	46.73	46.75	217127.0
2013-08-26	ARGT	ETF	19.11	19.13	19.1	19.13	5500.0
2013-08-26	ASEA	ETF	15.51	15.55	15.38	15.38	8900.0
2013-08-26	ATMP	ETF	26.2	26.2	25.83	25.89	19500.0
2013-08-26	AVIV	ETF	23.34	23.63	23.3	23.47	69336.0
2013-08-26	AWAY	ETF	29.95	30.78	29.924	30.75	904604.0
2013-08-26	BAB	ETF	27.08	27.2	27.02	27.2	98720.0
2013-08-26	BAL	ETF	54.41	54.8035	54.2101	54.27	12955.0
2013-08-26	BALT	ETF	4.78	5.04	4.7401	4.87	354495.0
2013-08-26	BBH	ETF	77.93	79.63	77.93	79.2	129300.0
2013-08-26	BCM	ETF	41.671	41.671	41.671	41.671	1351.0
2013-08-26	BFOR	ETF	6.625	6.64	6.58	6.6	250800.0
2013-08-26	BIB	ETF	28.645	29.46	28.1752	29.0748	171472.0
2013-08-26	BICK	ETF	21.67	21.85	21.67	21.67	1924.0
2013-08-26	BIL	ETF	91.58	91.6	91.58	91.58	249800.0
2013-08-26	BIS	ETF	1206.0	1206.0	1154.0	1170.7	287.0
2013-08-26	BIV	ETF	82.42	82.42	82.23	82.31	141300.0
2013-08-26	BIZD	ETF	20.15	20.16	20.11	20.11	16100.0
2013-08-26	BJK	ETF	43.44	43.46	43.1	43.1	4100.0
2013-08-26	BKF	ETF	34.94	35.0	34.5	34.5999	89923.0
2013-08-26	BKLN	ETF	24.69	24.7	24.64	24.65	1712400.0
2013-08-26	BLV	ETF	81.99	82.15	81.8	82.07	35300.0

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

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