PREVIEW / etf_daily / 2011-10-31

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-31.parquet
  size:    37 KB
  rows:    883

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-10-31	SPY	ETF	127.16	128.62	125.32	125.5	228146700.0
2011-10-31	QQQ	ETF	58.41	58.64	57.91	57.95	60520134.0
2011-10-31	IWM	ETF	74.85	75.44	73.93	74.01	66969200.0
2011-10-31	DIA	ETF	120.75	120.92	119.27	119.34	13398600.0
2011-10-31	GLD	ETF	167.76	168.16	166.91	167.34	8437200.0
2011-10-31	TLT	ETF	113.61	115.88	113.46	115.88	15242100.0
2011-10-31	AAXJ	ETF	54.54	54.62	53.56	53.56	659600.0
2011-10-31	ACTV	ETF	14.18	14.22	13.36	13.44	158323.0
2011-10-31	ACWI	ETF	44.24	44.38	43.55	43.55	327800.0
2011-10-31	ACWV	ETF	51.32	51.32	50.9	50.9	300.0
2011-10-31	ACWX	ETF	39.66	39.837	38.95	38.98	509897.0
2011-10-31	ADRE	ETF	41.73	41.73	40.89	40.89	49551.0
2011-10-31	AFK	ETF	28.92	29.088	28.52	28.55	8818.0
2011-10-31	AGEM	ETF	22.88	22.9	22.66	22.66	9233.0
2011-10-31	AGG	ETF	109.83	110.03	109.73	110.03	1747000.0
2011-10-31	AGQ	ETF	271.8	272.32	265.6	269.48	438300.0
2011-10-31	AGZ	ETF	112.2599	112.36	112.1802	112.29	67786.0
2011-10-31	AIA	ETF	42.1	42.1	41.3	41.3	39124.0
2011-10-31	AIQ	ETF	5.5	5.7	5.4	5.55	18886.0
2011-10-31	AIS	ETF	2.28	2.3	2.26	2.27	351656.0
2011-10-31	AIVI	ETF	42.79	42.8	41.77	41.77	78000.0
2011-10-31	AMJ	ETF	37.46	37.6	37.26	37.48	418653.0
2011-10-31	AMLP	ETF	80.5	80.9	80.35	80.9	145420.0
2011-10-31	AOA	ETF	33.82	33.85	33.54	33.54	11400.0
2011-10-31	AOK	ETF	29.39	29.43	29.36	29.37	42065.0
2011-10-31	AOM	ETF	30.24	30.24	30.09	30.09	36442.0
2011-10-31	AOR	ETF	31.62	31.63	31.36	31.36	25176.0
2011-10-31	ARB	ETF	40.06	40.95	39.71	39.73	85222.0
2011-10-31	ARGT	ETF	22.82	22.82	22.02	22.02	900.0
2011-10-31	ASEA	ETF	15.55	15.55	15.37	15.53	2100.0
2011-10-31	AWAY	ETF	33.14	34.16	32.55	33.05	247692.0
2011-10-31	BAB	ETF	27.99	28.3	27.956	28.3	171552.0
2011-10-31	BAL	ETF	63.5901	63.73	62.62	63.59	42143.0
2011-10-31	BALT	ETF	5.79	5.85	5.5199	5.56	213846.0
2011-10-31	BBH	ETF	36.03	36.1233	35.7033	35.7033	32100.0
2011-10-31	BCM	ETF	44.6599	44.68	44.6599	44.68	624.0
2011-10-31	BIB	ETF	7.85	7.8615	7.7337	7.8281	14280.0
2011-10-31	BICK	ETF	26.68	26.68	26.14	26.14	8895.0
2011-10-31	BIL	ETF	91.7	91.7	91.66	91.66	3112450.0
2011-10-31	BIS	ETF	6076.8	6081.6	6076.8	6081.6	1.875
2011-10-31	BITS	ETF	23.8	24.0	23.8	24.0	50.0
2011-10-31	BIV	ETF	87.33	87.69	87.06	87.69	150200.0
2011-10-31	BJK	ETF	32.86	33.0	32.64	32.64	18300.0
2011-10-31	BKF	ETF	40.51	40.62	39.78	39.78	164759.0
2011-10-31	BKLN	ETF	24.13	24.13	23.96	24.0	89800.0
2011-10-31	BLNG	ETF	52.85	52.85	52.85	52.85	1800.0
2011-10-31	BLV	ETF	90.21	91.32	89.93	91.27	56000.0
2011-10-31	BMVP	ETF	14.03	14.0467	13.917	13.917	2601.0
2011-10-31	BND	ETF	83.55	83.65	83.4	83.62	1457400.0
2011-10-31	BNO	ETF	37.315	37.695	37.175	37.5	156400.0

> showing 50 of 883 rows — these rows as CSV

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