PREVIEW / etf_daily / 2012-02-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-08.parquet
  size:    38 KB
  rows:    918

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-08	SPY	ETF	134.86	135.22	134.31	135.19	139361400.0
2012-02-08	QQQ	ETF	62.14	62.46	61.91	62.46	41171074.0
2012-02-08	IWM	ETF	82.8	83.21	81.93	82.81	46697400.0
2012-02-08	DIA	ETF	128.62	128.8	128.03	128.71	4884400.0
2012-02-08	GLD	ETF	169.26	169.96	167.5	168.5	10655500.0
2012-02-08	TLT	ETF	116.2	116.79	115.98	116.36	7613400.0
2012-02-08	AADR	ETF	29.88	30.03	29.76	29.8	10600.0
2012-02-08	AAXJ	ETF	57.19	57.44	57.05	57.28	398100.0
2012-02-08	ACTV	ETF	15.17	15.21	15.07	15.15	78580.0
2012-02-08	ACWI	ETF	45.97	46.15	45.78	46.01	1253100.0
2012-02-08	ACWV	ETF	52.86	52.86	52.86	52.86	100.0
2012-02-08	ACWX	ETF	40.6	40.73	40.4	40.65	92630.0
2012-02-08	ADRE	ETF	43.91	44.192	43.79	43.95	25259.0
2012-02-08	AFK	ETF	28.86	29.09	28.75	28.91	12519.0
2012-02-08	AGEM	ETF	24.09	24.09	23.97	24.08	1041.0
2012-02-08	AGG	ETF	110.47	110.55	110.33	110.44	1479600.0
2012-02-08	AGQ	ETF	250.12	252.96	241.96	246.84	630125.0
2012-02-08	AGZ	ETF	112.83	112.83	112.71	112.83	4792.0
2012-02-08	AIA	ETF	44.1745	44.28	44.01	44.19	22726.0
2012-02-08	AIQ	ETF	6.65	6.85	6.45	6.7	93005.0
2012-02-08	AIS	ETF	2.79	2.79	2.71	2.71	1257660.0
2012-02-08	AIVI	ETF	41.83	41.95	41.59	41.85	125200.0
2012-02-08	AMJ	ETF	40.26	40.43	40.01	40.23	528156.0
2012-02-08	AMLP	ETF	83.9	84.15	83.5	83.75	703420.0
2012-02-08	AOA	ETF	35.64	35.68	35.5	35.65	17200.0
2012-02-08	AOK	ETF	29.98	30.0248	29.9552	30.01	30710.0
2012-02-08	AOM	ETF	30.96	30.979	30.88	30.94	18127.0
2012-02-08	AOR	ETF	32.76	32.8378	32.7	32.82	42103.0
2012-02-08	ARB	ETF	34.06	34.29	33.89	34.25	225042.0
2012-02-08	ARGT	ETF	23.1	23.1	22.9	23.1	2800.0
2012-02-08	ASEA	ETF	15.93	16.09	15.93	15.96	4800.0
2012-02-08	AWAY	ETF	27.09	27.5	26.09	26.26	184425.0
2012-02-08	BAB	ETF	29.08	29.1	28.95	29.07	215634.0
2012-02-08	BAL	ETF	58.87	59.118	58.0	58.07	15648.0
2012-02-08	BALT	ETF	4.25	4.31	4.1399	4.28	166671.0
2012-02-08	BBH	ETF	43.8733	43.8733	42.97	43.3133	31800.0
2012-02-08	BCM	ETF	45.83	45.87	45.83	45.87	1800.0
2012-02-08	BIB	ETF	11.6125	11.6125	11.1425	11.3637	140472.0
2012-02-08	BICK	ETF	27.79	28.01	27.67	27.81	12185.0
2012-02-08	BIL	ETF	91.64	91.66	91.64	91.66	450500.0
2012-02-08	BIS	ETF	3865.6	4001.92	3865.6	3928.0	76.0
2012-02-08	BITS	ETF	22.08	22.52	22.08	22.2	106.0
2012-02-08	BIV	ETF	87.62	87.67	87.3	87.35	408300.0
2012-02-08	BJK	ETF	33.64	33.87	33.6	33.78	22400.0
2012-02-08	BKF	ETF	43.08	43.36	43.01	43.16	233268.0
2012-02-08	BKLN	ETF	24.53	24.6	24.51	24.59	70000.0
2012-02-08	BLV	ETF	90.71	90.82	90.42	90.75	172800.0
2012-02-08	BMVP	ETF	14.9933	15.03	14.9433	15.0068	9625.0
2012-02-08	BND	ETF	83.72	83.75	83.6	83.63	1088200.0
2012-02-08	BNO	ETF	40.525	40.905	40.295	40.845	85600.0

> showing 50 of 918 rows — these rows as CSV

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