PREVIEW / etf_daily / 2012-02-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-14.parquet
  size:    38 KB
  rows:    911

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
2012-02-14	SPY	ETF	135.0	135.27	134.25	135.19	165329500.0
2012-02-14	QQQ	ETF	62.9	63.22	62.69	63.21	51685261.0
2012-02-14	IWM	ETF	81.91	82.12	81.36	81.95	49375200.0
2012-02-14	DIA	ETF	128.38	128.69	127.78	128.66	5608500.0
2012-02-14	GLD	ETF	167.65	167.93	166.42	167.12	7862500.0
2012-02-14	TLT	ETF	117.44	118.28	117.23	117.76	8271200.0
2012-02-14	AAXJ	ETF	56.76	56.78	56.38	56.77	210800.0
2012-02-14	ACTV	ETF	15.47	15.5	15.3	15.5	48811.0
2012-02-14	ACWI	ETF	45.78	45.81	45.37	45.72	541000.0
2012-02-14	ACWV	ETF	52.4	52.4	52.4	52.4	300.0
2012-02-14	ACWX	ETF	40.08	40.14	39.75	40.0	181705.0
2012-02-14	ADRE	ETF	43.41	43.41	42.92	43.19	16604.0
2012-02-14	AFK	ETF	29.25	29.32	29.04	29.12	25459.0
2012-02-14	AGEM	ETF	23.63	23.63	23.501	23.501	652.0
2012-02-14	AGG	ETF	110.56	110.72	110.52	110.54	876200.0
2012-02-14	AGQ	ETF	242.92	244.2	236.0	239.44	347975.0
2012-02-14	AGZ	ETF	112.83	113.12	112.76	113.04	26826.0
2012-02-14	AIA	ETF	43.8181	43.8285	43.66	43.7204	2819.0
2012-02-14	AIQ	ETF	7.05	7.1	6.75	6.85	10087.0
2012-02-14	AIS	ETF	2.58	2.6	2.54	2.55	630942.0
2012-02-14	AIVI	ETF	41.35	41.38	41.0	41.31	70400.0
2012-02-14	AMJ	ETF	40.52	40.88	40.41	40.56	913654.0
2012-02-14	AMLP	ETF	84.15	84.5	84.0	84.25	351600.0
2012-02-14	AOA	ETF	35.55	35.56	35.37	35.56	7200.0
2012-02-14	AOK	ETF	30.0	30.0	29.96	29.96	33672.0
2012-02-14	AOM	ETF	30.88	30.9385	30.849	30.93	16377.0
2012-02-14	AOR	ETF	32.76	32.76	32.6375	32.75	69077.0
2012-02-14	ARB	ETF	36.0	38.0	36.0	37.21	453794.0
2012-02-14	ARGT	ETF	22.94	23.04	22.8	22.8	21050.0
2012-02-14	ASEA	ETF	15.77	15.84	15.71	15.83	3500.0
2012-02-14	AWAY	ETF	26.39	26.9	26.315	26.78	216030.0
2012-02-14	BAB	ETF	29.39	29.52	29.3365	29.45	166193.0
2012-02-14	BAL	ETF	56.15	56.65	56.0	56.65	9663.0
2012-02-14	BALT	ETF	4.33	4.7	4.33	4.58	738526.0
2012-02-14	BBH	ETF	43.5	43.91	43.41	43.55	20200.0
2012-02-14	BIB	ETF	11.6825	11.9238	11.4275	11.5124	96976.0
2012-02-14	BICK	ETF	27.53	27.71	27.52	27.66	10039.0
2012-02-14	BIL	ETF	91.64	91.66	91.64	91.66	173950.0
2012-02-14	BIS	ETF	3833.6	3880.96	3833.6	3880.0	4.06
2012-02-14	BITS	ETF	21.88	22.28	21.6	22.2	258.0
2012-02-14	BIV	ETF	87.84	87.99	87.76	87.9	228900.0
2012-02-14	BJK	ETF	33.71	33.71	33.33	33.47	9300.0
2012-02-14	BKF	ETF	42.67	42.78	42.2601	42.52	111274.0
2012-02-14	BKLN	ETF	24.52	24.56	24.45	24.56	88800.0
2012-02-14	BLV	ETF	90.99	91.62	90.99	91.29	82600.0
2012-02-14	BMVP	ETF	15.03	15.09	14.99	15.07	5892.0
2012-02-14	BND	ETF	83.77	83.93	83.75	83.8	953400.0
2012-02-14	BNO	ETF	40.9	41.095	40.83	41.04	107800.0
2012-02-14	BOIL	ETF	1352000.0	1375000.0	1333000.0	1360000.0	4.2
2012-02-14	BOSS	ETF	68.14	69.17	68.14	69.17	100.0

> showing 50 of 911 rows — these rows as CSV

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