PREVIEW / etf_daily / 2011-01-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-27.parquet
  size:    35 KB
  rows:    822

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-01-27	SPY	ETF	129.7	130.21	129.47	129.99	123302700.0
2011-01-27	QQQ	ETF	57.01	57.35	56.92	57.18	53656077.0
2011-01-27	IWM	ETF	79.12	79.67	78.73	79.35	48174800.0
2011-01-27	DIA	ETF	119.62	119.93	119.45	119.64	7393200.0
2011-01-27	GLD	ETF	130.29	130.49	127.8	127.93	33047000.0
2011-01-27	TLT	ETF	91.07	91.65	90.67	91.44	10868700.0
2011-01-27	AADR	ETF	30.05	30.2	30.05	30.2	400.0
2011-01-27	AAXJ	ETF	62.99	63.1	62.78	62.92	190100.0
2011-01-27	ACWI	ETF	47.93	48.04	47.73	47.95	559000.0
2011-01-27	ACWX	ETF	44.95	45.121	44.82	44.97	92315.0
2011-01-27	ADRE	ETF	47.34	47.48	46.9628	47.02	73460.0
2011-01-27	AFK	ETF	34.19	34.5	33.8	33.825	124481.0
2011-01-27	AGG	ETF	105.64	105.75	105.52	105.71	598500.0
2011-01-27	AGQ	ETF	250.22	252.84	235.32	237.68	856000.0
2011-01-27	AGZ	ETF	109.81	109.859	109.65	109.82	21306.0
2011-01-27	AIA	ETF	48.4	48.6	48.33	48.48	46094.0
2011-01-27	AIQ	ETF	21.7	21.85	21.25	21.75	15907.0
2011-01-27	AIS	ETF	1.61	1.64	1.58	1.61	244862.0
2011-01-27	AIVI	ETF	46.15	46.17	45.91	46.17	32300.0
2011-01-27	AMJ	ETF	37.07	37.35	37.07	37.35	1715623.0
2011-01-27	AMLP	ETF	81.4	81.6	81.15	81.5	110660.0
2011-01-27	AOA	ETF	35.12	35.2	35.02	35.13	20900.0
2011-01-27	AOK	ETF	28.96	29.03	28.96	29.03	15241.0
2011-01-27	AOM	ETF	30.27	30.31	30.23	30.31	12412.0
2011-01-27	AOR	ETF	32.03	32.1	31.978	32.09	7606.0
2011-01-27	ARB	ETF	41.54	41.54	40.66	41.27	106773.0
2011-01-27	BAB	ETF	25.03	25.06	24.79	25.01	415158.0
2011-01-27	BAL	ETF	86.74	87.44	84.435	86.3879	95668.0
2011-01-27	BALT	ETF	9.08	9.12	8.75	8.81	373175.0
2011-01-27	BBH	ETF	34.4133	34.47	34.3033	34.3367	18000.0
2011-01-27	BIB	ETF	7.8762	7.8762	7.8225	7.8342	8144.0
2011-01-27	BICK	ETF	32.33	32.46	32.25	32.28	19755.0
2011-01-27	BIL	ETF	91.7	91.72	91.7	91.72	89000.0
2011-01-27	BITS	ETF	28.16	28.56	28.12	28.36	725.0
2011-01-27	BIV	ETF	82.84	82.99	82.61	82.85	100700.0
2011-01-27	BJK	ETF	32.38	32.5	32.25	32.44	8800.0
2011-01-27	BKF	ETF	48.53	48.85	48.18	48.2192	232024.0
2011-01-27	BLV	ETF	77.84	78.19	77.59	78.05	31200.0
2011-01-27	BMVP	ETF	15.0933	15.1563	15.05	15.1367	8890.0
2011-01-27	BND	ETF	80.19	80.35	80.12	80.28	441100.0
2011-01-27	BNO	ETF	32.7	32.73	32.44	32.44	18800.0
2011-01-27	BRF	ETF	55.42	55.42	53.43	53.54	791653.0
2011-01-27	BSCE	ETF	20.84	20.89	20.83	20.85	5897.0
2011-01-27	BSV	ETF	80.63	80.65	80.55	80.61	447300.0
2011-01-27	BTF	ETF	80.95	81.19999999999999	80.70499999999998	81.05	4124.8
2011-01-27	BWX	ETF	29.335	29.375	29.225	29.35	229038.0
2011-01-27	BWZ	ETF	37.72	39.081	37.61	37.7	25901.0
2011-01-27	BZQ	ETF	2523.2	2612.8	2510.4	2598.4	781.0
2011-01-27	CEF	ETF	18.58	18.58	17.95	18.06	1233400.0
2011-01-27	CEW	ETF	22.44	22.44	22.376	22.395	126157.0

> showing 50 of 822 rows — these rows as CSV

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