PREVIEW / etf_daily / 2011-11-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-15.parquet
  size:    37 KB
  rows:    877

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-11-15	SPY	ETF	125.17	126.75	124.72	126.08	184709400.0
2011-11-15	QQQ	ETF	57.34	58.36	57.26	58.13	52203873.0
2011-11-15	IWM	ETF	72.92	74.64	72.43	74.24	65795300.0
2011-11-15	DIA	ETF	120.38	121.58	119.93	120.87	6467700.0
2011-11-15	GLD	ETF	173.35	173.81	171.9	173.36	9167900.0
2011-11-15	TLT	ETF	117.7	118.46	116.72	117.35	7587500.0
2011-11-15	AADR	ETF	28.49	28.54	28.49	28.54	700.0
2011-11-15	AAXJ	ETF	53.01	53.51	52.65	53.27	417500.0
2011-11-15	ACTV	ETF	14.34	14.76	13.77	14.69	61697.0
2011-11-15	ACWI	ETF	42.88	43.39	42.67	43.18	404100.0
2011-11-15	ACWX	ETF	37.92	38.23	37.71	38.0	420327.0
2011-11-15	ADRE	ETF	40.6	41.06	40.45	40.95	18918.0
2011-11-15	AFK	ETF	27.99	28.2	27.9	28.13	18103.0
2011-11-15	AGEM	ETF	22.53	22.53	22.47	22.47	325.0
2011-11-15	AGG	ETF	109.86	109.93	109.59	109.74	787800.0
2011-11-15	AGQ	ETF	270.72	274.88	263.28	270.6	355350.0
2011-11-15	AGZ	ETF	112.31	112.4	112.16	112.17	84173.0
2011-11-15	AIA	ETF	41.62	41.93	41.45	41.74	13345.0
2011-11-15	AIQ	ETF	6.25	6.534	6.25	6.45	9332.0
2011-11-15	AIS	ETF	2.31	2.41	2.3	2.39	606201.0
2011-11-15	AIVI	ETF	40.53	40.83	40.27	40.63	65900.0
2011-11-15	AMJ	ETF	37.38	37.581	37.11	37.21	1078595.0
2011-11-15	AMLP	ETF	79.35	79.45	78.95	79.15	377020.0
2011-11-15	AOA	ETF	33.05	33.48	32.98	33.45	26900.0
2011-11-15	AOK	ETF	29.33	29.36	29.264	29.34	10876.0
2011-11-15	AOM	ETF	30.0	30.05	29.904	30.03	11269.0
2011-11-15	AOR	ETF	31.2	31.38	31.1	31.32	15284.0
2011-11-15	ARB	ETF	40.5	42.12	40.23	41.82	125128.0
2011-11-15	ARGT	ETF	23.14	23.14	23.04	23.04	1200.0
2011-11-15	ASEA	ETF	15.09	15.21	14.91	15.07	16800.0
2011-11-15	AWAY	ETF	32.67	33.09	32.13	32.8	147706.0
2011-11-15	BAB	ETF	28.34	28.49	28.2804	28.409	141897.0
2011-11-15	BAL	ETF	60.35	62.5458	60.35	62.27	34044.0
2011-11-15	BALT	ETF	5.4	5.49	5.305	5.46	82004.0
2011-11-15	BBH	ETF	35.09	35.12	34.9333	34.9967	29400.0
2011-11-15	BCM	ETF	45.27	45.27	45.16	45.2501	26055.0
2011-11-15	BIB	ETF	7.1013	7.2865	7.1013	7.2865	18216.0
2011-11-15	BICK	ETF	25.45	25.45	25.315	25.315	400.0
2011-11-15	BIL	ETF	91.7	91.7	91.68	91.68	232900.0
2011-11-15	BIS	ETF	6572.8	6596.8	6572.8	6584.0	3.19
2011-11-15	BITS	ETF	21.92	21.92	20.16	21.4	7917.0
2011-11-15	BIV	ETF	87.76	87.91	87.55	87.66	244300.0
2011-11-15	BJK	ETF	31.35	31.72	31.14	31.6	9400.0
2011-11-15	BKF	ETF	39.61	40.33	39.5	40.05	56773.0
2011-11-15	BKLN	ETF	24.13	24.3	23.99	23.99	64300.0
2011-11-15	BLV	ETF	91.25	91.78	90.72	91.07	104200.0
2011-11-15	BMVP	ETF	13.76	13.9566	13.7367	13.9133	5143.0
2011-11-15	BND	ETF	83.64	83.72	83.5	83.55	1323200.0
2011-11-15	BNO	ETF	38.685	39.01	38.49	38.985	108000.0
2011-11-15	BOIL	ETF	3030000.0	3040000.0	2929000.0	2948000.0	0.2

> showing 50 of 877 rows — these rows as CSV

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