PREVIEW / etf_daily / 2011-09-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-21.parquet
  size:    36 KB
  rows:    871

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-09-21	SPY	ETF	120.23	120.6	116.44	116.63	316251300.0
2011-09-21	QQQ	ETF	56.65	56.93	55.37	55.38	79937994.0
2011-09-21	IWM	ETF	69.04	69.63	66.54	66.59	81413800.0
2011-09-21	DIA	ETF	113.93	114.23	110.88	110.95	14933100.0
2011-09-21	GLD	ETF	174.79	176.73	173.14	173.59	16431300.0
2011-09-21	TLT	ETF	114.63	118.79	114.2	118.66	18687100.0
2011-09-21	AAXJ	ETF	51.63	51.69	50.14	50.14	453600.0
2011-09-21	ACTV	ETF	15.52	15.94	14.18	14.25	81454.0
2011-09-21	ACWI	ETF	41.73	41.79	40.5	40.51	1029100.0
2011-09-21	ACWX	ETF	37.0	37.09	36.0	36.0	141635.0
2011-09-21	ADRE	ETF	39.16	39.23	37.92	37.92	64009.0
2011-09-21	AFK	ETF	28.05	28.09	27.36	27.36	10965.0
2011-09-21	AGEM	ETF	21.61	21.66	21.21	21.26	2900.0
2011-09-21	AGG	ETF	110.27	110.53	110.08	110.48	1242900.0
2011-09-21	AGQ	ETF	416.26	428.44	400.52	404.78	400100.0
2011-09-21	AGZ	ETF	113.02	113.28	112.8088	112.812	11429.0
2011-09-21	AIA	ETF	39.55	39.55	38.27	38.27	35349.0
2011-09-21	AIQ	ETF	6.05	6.25	6.0	6.0	31034.0
2011-09-21	AIS	ETF	2.35	2.38	2.25	2.25	586178.0
2011-09-21	AIVI	ETF	39.77	39.83	38.55	38.55	254700.0
2011-09-21	AMJ	ETF	35.98	36.1	35.2408	35.39	2108196.0
2011-09-21	AMLP	ETF	78.05	78.95	77.7	77.9	87840.0
2011-09-21	AOA	ETF	32.09	32.11	31.23	31.24	8700.0
2011-09-21	AOK	ETF	29.11	29.14	28.93	28.93	14125.0
2011-09-21	AOM	ETF	29.62	29.66	29.36	29.36	17042.0
2011-09-21	AOR	ETF	30.61	30.61	30.07	30.07	24914.0
2011-09-21	ARB	ETF	35.81	36.3	34.64	34.73	132915.0
2011-09-21	ASEA	ETF	14.76	14.76	14.38	14.38	10800.0
2011-09-21	AWAY	ETF	39.24	39.7	35.66	36.95	144534.0
2011-09-21	BAB	ETF	28.32	28.65	28.2201	28.5	536476.0
2011-09-21	BAL	ETF	64.59	64.65	62.67	62.67	89340.0
2011-09-21	BALT	ETF	4.91	5.019	4.75	4.77	129293.0
2011-09-21	BBH	ETF	34.0767	34.0767	33.29	33.34	11400.0
2011-09-21	BCM	ETF	46.31	46.31	46.31	46.31	8598.0
2011-09-21	BIB	ETF	7.9325	8.0328	7.62	7.62	19000.0
2011-09-21	BICK	ETF	24.79	24.83	24.15	24.15	26453.0
2011-09-21	BIL	ETF	91.7	91.7	91.68	91.7	314150.0
2011-09-21	BIS	ETF	6528.0	6528.0	6528.0	6528.0	0.625
2011-09-21	BITS	ETF	22.48	23.2	20.92	22.56	2830.0
2011-09-21	BIV	ETF	88.42	88.54	88.14	88.46	192100.0
2011-09-21	BJK	ETF	32.0	32.14	30.99	30.99	24300.0
2011-09-21	BKF	ETF	37.94	38.0	36.7	36.73	255181.0
2011-09-21	BKLN	ETF	23.45	23.5	23.31	23.31	138000.0
2011-09-21	BLNG	ETF	55.86	55.86	55.86	55.86	200.0
2011-09-21	BLV	ETF	90.15	92.11	89.59	91.93	59800.0
2011-09-21	BMVP	ETF	13.27	13.27	12.79	12.79	3394.0
2011-09-21	BND	ETF	83.92	84.17	83.86	84.13	1434000.0
2011-09-21	BNO	ETF	37.4	37.865	36.87	36.87	111600.0
2011-09-21	BOSS	ETF	69.1	69.1	68.64	68.64	100.0
2011-09-21	BRF	ETF	43.53	43.98	42.04	42.13	199653.0

> showing 50 of 871 rows — these rows as CSV

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