PREVIEW / etf_daily / 2011-07-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-07.parquet
  size:    36 KB
  rows:    866

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
2011-07-07	SPY	ETF	135.16	135.7	134.88	135.36	170464200.0
2011-07-07	QQQ	ETF	58.82	59.36	58.74	59.19	54799767.0
2011-07-07	IWM	ETF	85.21	85.97	84.94	85.65	68556600.0
2011-07-07	DIA	ETF	126.83	127.37	126.6	127.1	4400700.0
2011-07-07	GLD	ETF	148.97	149.35	148.29	149.15	9520900.0
2011-07-07	TLT	ETF	93.83	94.14	93.55	94.04	6823700.0
2011-07-07	AADR	ETF	31.91	31.91	31.87	31.87	1000.0
2011-07-07	AAXJ	ETF	63.12	63.48	62.97	63.33	689400.0
2011-07-07	ACTV	ETF	18.96	19.99	18.8	18.9	226070.0
2011-07-07	ACWI	ETF	49.05	49.18	48.9	49.05	151200.0
2011-07-07	ACWX	ETF	45.4	45.54	45.26	45.4	164803.0
2011-07-07	ADRE	ETF	46.99	47.26	46.99	47.08	56938.0
2011-07-07	AFK	ETF	32.71	32.95	32.7	32.882	9116.0
2011-07-07	AGEM	ETF	26.8	26.96	26.7	26.7	23544.0
2011-07-07	AGG	ETF	106.63	106.67	106.45	106.57	1291600.0
2011-07-07	AGQ	ETF	360.24	366.22	357.1	361.82	656600.0
2011-07-07	AGZ	ETF	110.37	110.487	110.34	110.35	6338.0
2011-07-07	AIA	ETF	47.29	47.65	47.29	47.5361	60250.0
2011-07-07	AIQ	ETF	18.6	18.95	18.45	18.85	8443.0
2011-07-07	AIS	ETF	2.3	2.44	2.3	2.4	2099383.0
2011-07-07	AIVI	ETF	46.87	47.15	46.85	47.09	16900.0
2011-07-07	AMJ	ETF	37.42	37.718	37.42	37.6	380375.0
2011-07-07	AMLP	ETF	80.5	81.0	80.5	80.85	130680.0
2011-07-07	AOA	ETF	36.64	36.76	36.64	36.7	7000.0
2011-07-07	AOK	ETF	29.44	29.49	29.43	29.48	50708.0
2011-07-07	AOM	ETF	30.89	30.92	30.81	30.9	21959.0
2011-07-07	AOR	ETF	33.004	33.12	33.004	33.09	45340.0
2011-07-07	ARB	ETF	42.01	42.99	41.87	42.57	129109.0
2011-07-07	ARGT	ETF	30.86	30.88	30.74	30.88	3950.0
2011-07-07	ASEA	ETF	16.82	16.94	16.79	16.93	79600.0
2011-07-07	AWAY	ETF	39.5	43.25	39.36	41.01	395073.0
2011-07-07	BAB	ETF	26.06	26.21	26.06	26.18	437197.0
2011-07-07	BAL	ETF	70.95	71.11	69.73	70.12	61550.0
2011-07-07	BALT	ETF	5.53	5.65	5.51	5.64	111305.0
2011-07-07	BBH	ETF	36.1667	36.1667	35.7767	35.88	36600.0
2011-07-07	BCM	ETF	47.25	47.4	47.1798	47.3	3066.0
2011-07-07	BIB	ETF	10.1625	10.1625	9.9563	10.0825	312896.0
2011-07-07	BICK	ETF	32.85	32.89	32.65	32.78	4582.0
2011-07-07	BIL	ETF	91.7	91.72	91.7	91.7	158850.0
2011-07-07	BIS	ETF	5747.2	5747.2	5687.36	5697.6	23.8
2011-07-07	BITS	ETF	21.4	21.52	20.96	21.24	17250.0
2011-07-07	BIV	ETF	83.99	84.01	83.78	83.99	151700.0
2011-07-07	BJK	ETF	35.52	35.93	35.52	35.85	105000.0
2011-07-07	BKF	ETF	48.37	48.6905	48.37	48.53	189896.0
2011-07-07	BKLN	ETF	24.93	24.96	24.85	24.85	206400.0
2011-07-07	BLNG	ETF	48.47	48.47	48.47	48.47	1000.0
2011-07-07	BLV	ETF	79.76	80.07	79.63	80.0	43100.0
2011-07-07	BMVP	ETF	16.1737	16.2367	16.1737	16.2133	7026.0
2011-07-07	BND	ETF	81.11	81.15	80.98	81.13	915900.0
2011-07-07	BNO	ETF	38.8	39.505	38.72	39.345	163200.0

> showing 50 of 866 rows — these rows as CSV

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