PREVIEW / etf_daily / 2013-02-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-26.parquet
  size:    40 KB
  rows:    981

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-02-26	SPY	ETF	149.72	150.2	148.73	150.02	186596200.0
2013-02-26	QQQ	ETF	66.42	66.68	65.96	66.56	42088741.0
2013-02-26	IWM	ETF	89.41	89.78	88.79	89.37	47522800.0
2013-02-26	DIA	ETF	138.35	138.96	137.98	138.78	9236100.0
2013-02-26	GLD	ETF	154.39	156.8	153.32	156.22	18182300.0
2013-02-26	TLT	ETF	118.73	119.67	118.59	118.64	9822100.0
2013-02-26	AADR	ETF	32.3	32.3	32.3	32.3	1000.0
2013-02-26	AAXJ	ETF	59.5	59.55	59.13	59.37	268200.0
2013-02-26	ACTV	ETF	4.8	5.02	4.7	4.76	599550.0
2013-02-26	ACWI	ETF	49.29	49.44	48.97	49.32	591800.0
2013-02-26	ACWV	ETF	58.72	58.88	58.59	58.83	42300.0
2013-02-26	ACWX	ETF	42.21	42.28	41.88	42.07	347761.0
2013-02-26	ADRE	ETF	38.9	39.03	38.6032	39.03	47386.0
2013-02-26	AFK	ETF	30.52	30.62	30.42	30.62	23436.0
2013-02-26	AGEM	ETF	22.51	22.6899	22.48	22.6899	1931.0
2013-02-26	AGG	ETF	110.64	110.83	110.64	110.7	801300.0
2013-02-26	AGQ	ETF	158.04	164.0	154.4	163.04	486025.0
2013-02-26	AGZ	ETF	113.185	113.4599	113.17	113.37	16195.0
2013-02-26	AIA	ETF	46.76	46.86	46.601	46.84	28313.0
2013-02-26	AIQ	ETF	6.89	6.97	6.76	6.97	6076.0
2013-02-26	AIVI	ETF	41.6	41.72	41.27	41.5	20300.0
2013-02-26	AMJ	ETF	43.1	43.22	42.71	42.95	2576204.0
2013-02-26	AMLP	ETF	84.85	84.95	84.15	84.9	603740.0
2013-02-26	ANGL	ETF	27.15	27.15	26.92	26.95	800.0
2013-02-26	AOA	ETF	38.42	38.49	38.22	38.44	9800.0
2013-02-26	AOK	ETF	30.7701	30.86	30.7701	30.85	15603.0
2013-02-26	AOM	ETF	32.22	32.26	32.13	32.18	24042.0
2013-02-26	AOR	ETF	34.73	34.79	34.64	34.78	137769.0
2013-02-26	ARB	ETF	46.85	46.91	46.73	46.73	449723.0
2013-02-26	ARGT	ETF	17.12	17.12	17.12	17.12	650.0
2013-02-26	ASEA	ETF	17.06	17.11	16.99	17.08	31300.0
2013-02-26	AWAY	ETF	27.85	28.1	27.75	28.0	812136.0
2013-02-26	BAB	ETF	30.32	30.5	30.32	30.45	221545.0
2013-02-26	BAL	ETF	53.04	53.28	52.7	52.88	38414.0
2013-02-26	BALT	ETF	3.45	3.49	3.33	3.46	67012.0
2013-02-26	BBH	ETF	58.15	58.38	57.74	58.07	23300.0
2013-02-26	BCM	ETF	43.4083	43.4083	43.4083	43.4083	18000.0
2013-02-26	BIB	ETF	16.0025	16.1125	15.77	15.937	38040.0
2013-02-26	BICK	ETF	24.7	24.81	24.68	24.81	5187.0
2013-02-26	BIL	ETF	91.6	91.62	91.6	91.6	145250.0
2013-02-26	BIV	ETF	87.86	88.03	87.75	87.87	183200.0
2013-02-26	BIZD	ETF	20.13	20.13	19.99	20.1	11500.0
2013-02-26	BJK	ETF	37.79	37.91	37.49	37.82	12800.0
2013-02-26	BKF	ETF	39.56	39.6805	39.209	39.61	89885.0
2013-02-26	BKLN	ETF	24.99	25.0	24.96	25.0	1103700.0
2013-02-26	BLNG	ETF	47.48	47.48	47.48	47.48	200.0
2013-02-26	BLV	ETF	92.45	93.07	92.45	92.65	84400.0
2013-02-26	BMVP	ETF	17.4067	17.44	17.3534	17.44	3350.0
2013-02-26	BND	ETF	83.62	83.8	83.62	83.71	1070500.0
2013-02-26	BNO	ETF	42.76	42.885	42.205	42.295	88400.0

> showing 50 of 981 rows — these rows as CSV

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