PREVIEW / etf_daily / 2011-08-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-01.parquet
  size:    36 KB
  rows:    867

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-08-01	SPY	ETF	130.84	130.96	127.53	128.78	325790900.0
2011-08-01	QQQ	ETF	58.67	58.82	57.03	57.73	85421008.0
2011-08-01	IWM	ETF	80.69	80.99	78.47	79.22	93483200.0
2011-08-01	DIA	ETF	122.74	122.96	119.77	121.11	11630000.0
2011-08-01	GLD	ETF	157.47	158.97	156.78	157.72	14825700.0
2011-08-01	TLT	ETF	97.39	98.94	97.35	98.58	14348200.0
2011-08-01	AAXJ	ETF	63.15	63.15	62.01	62.66	396600.0
2011-08-01	ACTV	ETF	18.32	18.34	17.98	18.06	252305.0
2011-08-01	ACWI	ETF	47.76	47.8	46.46	46.73	1280900.0
2011-08-01	ACWX	ETF	44.36	44.36	43.12	43.51	71614.0
2011-08-01	ADRE	ETF	46.21	46.21	45.36	45.781	65244.0
2011-08-01	AFK	ETF	31.64	31.738	31.2	31.5059	18112.0
2011-08-01	AGEM	ETF	26.06	26.06	25.5498	25.76	922.0
2011-08-01	AGG	ETF	107.84	108.23	107.82	108.12	1300600.0
2011-08-01	AGQ	ETF	412.8	428.74	407.4	412.6	691000.0
2011-08-01	AGZ	ETF	111.35	111.39	111.088	111.1354	7447.0
2011-08-01	AIA	ETF	47.13	47.13	46.19	46.67	58211.0
2011-08-01	AIQ	ETF	18.0	18.05	16.85	16.95	21870.0
2011-08-01	AIS	ETF	2.38	2.43	2.36	2.42	823110.0
2011-08-01	AIVI	ETF	45.93	45.93	44.28	44.8	27400.0
2011-08-01	AMJ	ETF	36.62	37.17	36.545	36.68	1984571.0
2011-08-01	AMLP	ETF	79.75	80.25	79.5	79.55	164520.0
2011-08-01	AOA	ETF	35.55	35.55	34.67	34.92	12700.0
2011-08-01	AOK	ETF	29.76	29.76	29.3	29.4388	15868.0
2011-08-01	AOM	ETF	30.8	30.8	30.46	30.57	46043.0
2011-08-01	AOR	ETF	32.6	32.95	32.05	32.17	35744.0
2011-08-01	ARB	ETF	39.5	39.62	37.93	38.58	246990.0
2011-08-01	ARGT	ETF	29.22	29.22	28.76	28.76	2250.0
2011-08-01	ASEA	ETF	17.5	17.5	17.3	17.48	5000.0
2011-08-01	AWAY	ETF	41.89	41.89	37.39	37.96	193782.0
2011-08-01	BAB	ETF	26.97	27.13	26.86	27.07	162211.0
2011-08-01	BAL	ETF	63.37	65.33	62.35	65.24	131894.0
2011-08-01	BALT	ETF	5.57	5.686	5.05	5.1	254286.0
2011-08-01	BBH	ETF	35.0967	35.15	33.9667	34.1667	45300.0
2011-08-01	BCM	ETF	48.5	48.5	47.78	47.78	3046.0
2011-08-01	BIB	ETF	9.3625	9.3625	8.6687	8.8265	196352.0
2011-08-01	BICK	ETF	31.19	31.49	30.996	31.149	7385.0
2011-08-01	BIL	ETF	91.7	91.72	91.68	91.72	290250.0
2011-08-01	BIS	ETF	6126.4	6492.928	6083.2	6424.0	45.45
2011-08-01	BITS	ETF	21.28	21.88	20.8	21.48	12603.0
2011-08-01	BIV	ETF	85.6	86.08	85.52	85.91	161000.0
2011-08-01	BJK	ETF	37.13	37.2	36.3	36.65	34500.0
2011-08-01	BKF	ETF	47.2	47.22	46.29	46.7	78621.0
2011-08-01	BKLN	ETF	24.74	24.78	24.64	24.7	75300.0
2011-08-01	BLV	ETF	82.85	83.74	82.76	83.59	51700.0
2011-08-01	BMVP	ETF	15.1467	15.1467	14.7528	14.8233	2860.0
2011-08-01	BND	ETF	82.05	82.37	82.02	82.3	1305200.0
2011-08-01	BNO	ETF	39.98	40.0	38.44	39.075	337200.0
2011-08-01	BRF	ETF	54.31	54.31	52.58	52.73	167621.0
2011-08-01	BSCE	ETF	21.2	21.2699	21.1546	21.248	8584.0

> showing 50 of 867 rows — these rows as CSV

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