PREVIEW / etf_daily / 2012-02-17

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-17.parquet
  size:    38 KB
  rows:    913

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-17	SPY	ETF	136.52	136.63	135.96	136.41	129869400.0
2012-02-17	QQQ	ETF	63.64	63.69	63.15	63.43	76112276.0
2012-02-17	IWM	ETF	83.29	83.31	82.63	82.79	33292000.0
2012-02-17	DIA	ETF	129.31	129.39	128.86	129.23	5765200.0
2012-02-17	GLD	ETF	168.29	168.33	166.87	167.35	7286900.0
2012-02-17	TLT	ETF	115.86	116.61	115.76	116.58	6338000.0
2012-02-17	AADR	ETF	30.4	30.4	30.33	30.33	800.0
2012-02-17	AAXJ	ETF	57.88	57.99	57.61	57.81	161100.0
2012-02-17	ACTV	ETF	15.82	16.17	15.77	16.16	158551.0
2012-02-17	ACWI	ETF	46.28	46.42	46.16	46.3	644500.0
2012-02-17	ACWV	ETF	52.9	52.94	52.82	52.94	1200.0
2012-02-17	ACWX	ETF	40.85	40.85	40.57	40.76	92876.0
2012-02-17	ADRE	ETF	43.99	43.99	43.6	43.83	26242.0
2012-02-17	AFK	ETF	29.36	29.37	29.16	29.253	14211.0
2012-02-17	AGEM	ETF	24.16	24.16	23.9	23.936	2507.0
2012-02-17	AGG	ETF	110.32	110.37	110.2	110.34	853700.0
2012-02-17	AGQ	ETF	240.56	240.6	233.04	235.08	355025.0
2012-02-17	AGZ	ETF	112.88	112.92	112.68	112.788	9924.0
2012-02-17	AIA	ETF	45.16	45.16	45.0	45.08	6236.0
2012-02-17	AIQ	ETF	7.25	7.25	6.8	7.15	16381.0
2012-02-17	AIS	ETF	2.5	2.59	2.48	2.58	1075588.0
2012-02-17	AIVI	ETF	41.97	41.98	41.73	41.93	59500.0
2012-02-17	AMJ	ETF	41.34	41.49	41.24	41.34	2558257.0
2012-02-17	AMLP	ETF	85.25	85.5	85.1	85.5	229760.0
2012-02-17	AOA	ETF	35.93	35.93	35.78	35.91	9800.0
2012-02-17	AOK	ETF	30.05	30.07	30.01	30.062	43054.0
2012-02-17	AOM	ETF	31.05	31.07	31.001	31.06	11716.0
2012-02-17	AOR	ETF	32.95	32.97	32.89	32.95	41165.0
2012-02-17	ARB	ETF	35.26	35.6	35.14	35.41	124142.0
2012-02-17	ASEA	ETF	16.0	16.03	15.93	16.03	3700.0
2012-02-17	AWAY	ETF	26.96	27.0	25.91	26.02	188688.0
2012-02-17	BAB	ETF	29.1	29.19	28.98	29.19	147636.0
2012-02-17	BAL	ETF	57.33	57.41	56.2448	56.43	12113.0
2012-02-17	BALT	ETF	4.52	4.54	4.4	4.48	126963.0
2012-02-17	BBH	ETF	43.41	43.41	42.46	42.46	36400.0
2012-02-17	BCM	ETF	45.55	45.64	45.55	45.64	1000.0
2012-02-17	BIB	ETF	11.5712	11.5712	11.1725	11.1805	63408.0
2012-02-17	BICK	ETF	28.21	28.26	28.11	28.2216	8341.0
2012-02-17	BIL	ETF	91.64	91.66	91.64	91.64	81400.0
2012-02-17	BIS	ETF	3889.6	3987.2	3889.6	3984.0	11.55
2012-02-17	BITS	ETF	22.08	22.08	22.08	22.08	25.0
2012-02-17	BIV	ETF	87.4	87.58	87.3	87.57	210000.0
2012-02-17	BJK	ETF	34.28	34.41	34.15	34.22	18300.0
2012-02-17	BKF	ETF	43.48	43.5	43.205	43.49	62076.0
2012-02-17	BKLN	ETF	24.44	24.45	24.38	24.45	79200.0
2012-02-17	BLV	ETF	90.38	90.73	90.27	90.72	32200.0
2012-02-17	BMVP	ETF	15.27	15.28	15.22	15.27	3337.0
2012-02-17	BND	ETF	83.55	83.58	83.42	83.51	1172700.0
2012-02-17	BNO	ETF	41.79	41.795	41.485	41.72	128400.0
2012-02-17	BOIL	ETF	1415000.0	1485000.0	1393000.0	1459000.0	7.6

> showing 50 of 913 rows — these rows as CSV

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