PREVIEW / etf_daily / 2012-11-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-02.parquet
  size:    39 KB
  rows:    947

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-11-02	SPY	ETF	143.68	143.72	141.41	141.56	137702200.0
2012-11-02	QQQ	ETF	66.21	66.21	65.11	65.17	44082997.0
2012-11-02	IWM	ETF	82.89	82.95	81.17	81.19	39322100.0
2012-11-02	DIA	ETF	132.56	132.61	130.47	130.67	5141300.0
2012-11-02	GLD	ETF	164.45	164.47	162.3	162.6	14763100.0
2012-11-02	TLT	ETF	121.28	122.31	121.24	122.26	3527800.0
2012-11-02	AAXJ	ETF	57.59	57.59	56.85	56.94	179200.0
2012-11-02	ACTV	ETF	6.39	6.39	5.02	5.42	16221493.0
2012-11-02	ACWI	ETF	47.22	47.22	46.61	46.68	1203300.0
2012-11-02	ACWV	ETF	56.72	56.72	56.2	56.22	8200.0
2012-11-02	ACWX	ETF	40.14	40.14	39.69	39.75	95586.0
2012-11-02	ADRE	ETF	39.48	39.66	39.18	39.2	31561.0
2012-11-02	AFK	ETF	31.75	31.78	31.39	31.4108	14752.0
2012-11-02	AGEM	ETF	22.68	22.68	22.68	22.68	400.0
2012-11-02	AGG	ETF	111.83	111.92	111.67	111.87	961700.0
2012-11-02	AGQ	ETF	197.24	197.64	184.44	185.72	577725.0
2012-11-02	AGZ	ETF	113.62	113.75	113.61	113.74	17611.0
2012-11-02	AIA	ETF	45.39	45.39	44.873	44.91	14446.0
2012-11-02	AIQ	ETF	7.25	7.75	7.15	7.45	90846.0
2012-11-02	AIVI	ETF	40.48	40.48	40.08	40.09	21600.0
2012-11-02	AMJ	ETF	40.76	40.94	40.68	40.71	323275.0
2012-11-02	AMLP	ETF	83.45	83.45	83.0	83.0	334240.0
2012-11-02	ANGL	ETF	26.78	26.91	26.78	26.88	600.0
2012-11-02	AOA	ETF	36.67	36.69	36.45	36.45	11000.0
2012-11-02	AOK	ETF	30.5	30.5	30.4	30.4	12285.0
2012-11-02	AOM	ETF	31.61	31.61	31.47	31.5	14617.0
2012-11-02	AOR	ETF	33.82	33.82	33.53	33.53	16945.0
2012-11-02	ARB	ETF	37.52	37.575	36.61	36.95	158550.0
2012-11-02	ASEA	ETF	16.74	16.76	16.68	16.68	7500.0
2012-11-02	AWAY	ETF	26.05	26.05	22.565	22.97	1941839.0
2012-11-02	BAB	ETF	30.25	30.25	30.0	30.1	125264.0
2012-11-02	BAL	ETF	45.9892	46.29	45.9	46.27	3697.0
2012-11-02	BALT	ETF	3.38	3.45	3.38	3.42	27443.0
2012-11-02	BBH	ETF	52.12	52.12	50.84	50.89	27500.0
2012-11-02	BCM	ETF	44.3	44.3	43.7656	43.7899	4159.0
2012-11-02	BIB	ETF	13.97	13.97	12.965	13.31	64480.0
2012-11-02	BICK	ETF	24.24	24.24	23.94	23.94	6308.0
2012-11-02	BIL	ETF	91.64	91.64	91.62	91.64	378400.0
2012-11-02	BIS	ETF	2917.6	2956.32	2917.6	2956.32	166.0
2012-11-02	BIV	ETF	89.89	90.07	89.81	90.07	235500.0
2012-11-02	BJK	ETF	35.58	35.58	35.14	35.14	6000.0
2012-11-02	BKF	ETF	39.27	39.28	38.81	38.87	61195.0
2012-11-02	BKLN	ETF	24.83	24.84	24.81	24.83	1763900.0
2012-11-02	BLV	ETF	95.59	96.23	95.57	96.2	25200.0
2012-11-02	BMVP	ETF	15.93	15.93	15.71	15.71	14441.0
2012-11-02	BND	ETF	84.69	84.8	84.58	84.79	1107500.0
2012-11-02	BNO	ETF	39.455	39.465	38.375	38.455	49000.0
2012-11-02	BOIL	ETF	1009400.0	1023400.0	966000.0	971400.0	12.2
2012-11-02	BOND	ETF	109.37	109.44	109.3	109.44	616057.0
2012-11-02	BRF	ETF	41.76	41.91	41.0	41.11	92182.0

> showing 50 of 947 rows — these rows as CSV

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