PREVIEW / etf_daily / 2011-09-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-16.parquet
  size:    36 KB
  rows:    854

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-09-16	SPY	ETF	121.29	121.97	120.32	121.52	284528300.0
2011-09-16	QQQ	ETF	56.25	56.65	56.09	56.59	91901954.0
2011-09-16	IWM	ETF	71.65	72.03	70.88	71.52	75773300.0
2011-09-16	DIA	ETF	114.61	115.13	113.81	114.86	12330800.0
2011-09-16	GLD	ETF	173.72	177.4	173.71	176.03	20693700.0
2011-09-16	TLT	ETF	111.31	112.59	111.25	112.24	10053500.0
2011-09-16	AADR	ETF	28.36	28.36	28.31	28.36	1800.0
2011-09-16	AAXJ	ETF	53.58	53.81	53.14	53.7	1315700.0
2011-09-16	ACTV	ETF	15.63	16.06	15.54	16.03	143185.0
2011-09-16	ACWI	ETF	42.5	42.72	42.16	42.5	308000.0
2011-09-16	ACWX	ETF	38.17	38.17	37.7	38.05	168542.0
2011-09-16	ADRE	ETF	40.78	40.78	40.04	40.27	99120.0
2011-09-16	AFK	ETF	28.67	29.06	28.45	28.95	4224.0
2011-09-16	AGEM	ETF	22.65	22.66	22.357	22.52	6283.0
2011-09-16	AGG	ETF	109.67	109.84	109.54	109.84	885700.0
2011-09-16	AGQ	ETF	415.6	433.54	414.82	423.2	367500.0
2011-09-16	AGZ	ETF	112.46	112.69	112.41	112.69	7814.0
2011-09-16	AIA	ETF	41.09	41.1	40.61	40.9	42399.0
2011-09-16	AIQ	ETF	6.85	6.9	6.7	6.8	24607.0
2011-09-16	AIS	ETF	2.25	2.39	2.2	2.34	1142012.0
2011-09-16	AIVI	ETF	40.59	40.66	40.08	40.49	51700.0
2011-09-16	AMJ	ETF	35.58	35.582	34.71	34.77	1863054.0
2011-09-16	AMLP	ETF	78.5	78.5	76.75	77.0	126340.0
2011-09-16	AOA	ETF	32.68	32.7	32.44	32.59	14100.0
2011-09-16	AOK	ETF	29.08	29.1	29.08	29.1	37986.0
2011-09-16	AOM	ETF	29.8	29.82	29.705	29.79	19959.0
2011-09-16	AOR	ETF	30.81	30.93	30.74	30.85	10669.0
2011-09-16	ARB	ETF	36.43	36.7399	36.2	36.45	111388.0
2011-09-16	ARGT	ETF	23.52	23.54	23.38	23.4	3800.0
2011-09-16	ASEA	ETF	15.28	15.29	15.18	15.23	5500.0
2011-09-16	AWAY	ETF	42.07	42.53	41.08	42.34	87722.0
2011-09-16	BAB	ETF	28.12	28.34	28.0	28.34	252436.0
2011-09-16	BAL	ETF	68.2	69.26	67.84	68.95	95824.0
2011-09-16	BALT	ETF	5.42	5.42	5.2	5.27	152756.0
2011-09-16	BBH	ETF	34.0033	34.0033	33.8967	33.9467	13800.0
2011-09-16	BIB	ETF	7.885	7.885	7.7389	7.7592	76400.0
2011-09-16	BICK	ETF	25.81	25.949	25.8	25.9	23583.0
2011-09-16	BIL	ETF	91.7	91.7	91.68	91.68	276450.0
2011-09-16	BITS	ETF	20.84	20.96	19.88	19.88	1189.0
2011-09-16	BIV	ETF	87.47	87.93	87.33	87.81	93200.0
2011-09-16	BJK	ETF	32.31	32.4	31.92	32.19	89800.0
2011-09-16	BKF	ETF	39.69	39.76	39.13	39.33	139510.0
2011-09-16	BKLN	ETF	23.52	23.53	23.36	23.36	121400.0
2011-09-16	BLNG	ETF	56.84	57.12	56.8	56.8	400.0
2011-09-16	BLV	ETF	88.27	88.89	88.05	88.75	14100.0
2011-09-16	BMVP	ETF	13.59	13.63	13.46	13.54	4317.0
2011-09-16	BND	ETF	83.36	83.6	83.34	83.53	1211300.0
2011-09-16	BNO	ETF	38.365	38.48	37.585	37.785	182600.0
2011-09-16	BRF	ETF	47.37	47.4012	46.66	46.87	138399.0
2011-09-16	BSCE	ETF	20.98	21.06	20.98	21.05	25917.0

> showing 50 of 854 rows — these rows as CSV

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