PREVIEW / etf_daily / 2011-06-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-22.parquet
  size:    36 KB
  rows:    853

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-06-22	SPY	ETF	129.05	129.81	128.59	128.67	176703000.0
2011-06-22	QQQ	ETF	55.0	55.32	54.82	54.831	36833212.0
2011-06-22	IWM	ETF	80.22	81.11	80.01	80.04	55839700.0
2011-06-22	DIA	ETF	121.15	121.81	120.79	120.81	4702500.0
2011-06-22	GLD	ETF	151.01	151.86	150.56	150.99	14109700.0
2011-06-22	TLT	ETF	96.96	97.06	96.41	96.65	5503700.0
2011-06-22	AADR	ETF	30.58	30.6	30.58	30.6	600.0
2011-06-22	AAXJ	ETF	60.15	60.2	59.73	59.73	319600.0
2011-06-22	ACTV	ETF	18.35	18.96	17.93	18.01	308798.0
2011-06-22	ACWI	ETF	47.12	47.31	46.82	46.82	453600.0
2011-06-22	ACWX	ETF	43.74	43.92	43.5	43.5	663375.0
2011-06-22	ADRE	ETF	44.8	45.07	44.67	44.67	44636.0
2011-06-22	AFK	ETF	31.88	32.07	31.8176	31.8296	16187.0
2011-06-22	AGG	ETF	107.5	107.56	107.24	107.38	897800.0
2011-06-22	AGQ	ETF	365.84	371.58	362.26	364.28	620550.0
2011-06-22	AGZ	ETF	111.01	111.11	110.8	110.89	4719.0
2011-06-22	AIA	ETF	45.53	45.67	45.26	45.26	45481.0
2011-06-22	AIQ	ETF	18.8	19.05	18.6	18.65	10622.0
2011-06-22	AIS	ETF	2.0	2.02	1.9699	1.98	857387.0
2011-06-22	AIVI	ETF	46.07	46.34	45.82	45.86	471400.0
2011-06-22	AMJ	ETF	36.18	36.44	36.09	36.24	1917777.0
2011-06-22	AMLP	ETF	78.9	79.1	78.8	78.95	226640.0
2011-06-22	AOA	ETF	35.32	35.5	35.23	35.23	13400.0
2011-06-22	AOK	ETF	29.2	29.28	29.2	29.24	10231.0
2011-06-22	AOM	ETF	30.6045	30.6499	30.53	30.54	19944.0
2011-06-22	AOR	ETF	32.46	32.47	32.31	32.31	13688.0
2011-06-22	ARB	ETF	38.78	39.44	38.64	38.67	58570.0
2011-06-22	ARGT	ETF	29.02	29.02	29.02	29.02	550.0
2011-06-22	ASEA	ETF	16.13	16.24	16.13	16.24	400.0
2011-06-22	BAB	ETF	26.59	26.669	26.52	26.5518	88049.0
2011-06-22	BAL	ETF	76.66	77.49	74.41	75.48	61364.0
2011-06-22	BALT	ETF	6.09	6.183	5.94	5.94	84216.0
2011-06-22	BBH	ETF	34.62	34.87	34.55	34.6633	82200.0
2011-06-22	BIB	ETF	9.0587	9.1941	9.0587	9.08	43088.0
2011-06-22	BICK	ETF	30.54	30.54	30.272	30.272	78479.0
2011-06-22	BIL	ETF	91.7	91.72	91.7	91.72	158700.0
2011-06-22	BIS	ETF	6302.4	6342.4	6302.4	6342.4	5.75
2011-06-22	BITS	ETF	21.4	21.4	20.8	21.32	286.0
2011-06-22	BIV	ETF	85.06	85.06	84.66	84.78	119500.0
2011-06-22	BJK	ETF	33.02	33.05	32.81	32.86	4600.0
2011-06-22	BKF	ETF	45.99	46.22	45.806	45.82	153022.0
2011-06-22	BKLN	ETF	24.71	24.76	24.69	24.74	99800.0
2011-06-22	BLNG	ETF	49.37	49.37	49.3505	49.3505	1665.0
2011-06-22	BLV	ETF	81.62	81.89	81.38	81.52	15500.0
2011-06-22	BMVP	ETF	15.2633	15.3627	15.22	15.22	7032.0
2011-06-22	BND	ETF	81.82	81.91	81.68	81.77	681100.0
2011-06-22	BNO	ETF	37.33	38.165	37.28	37.905	256400.0
2011-06-22	BRF	ETF	55.71	56.17	55.59	55.68	94376.0
2011-06-22	BSCE	ETF	21.19	21.31	21.19	21.21	19757.0
2011-06-22	BSV	ETF	81.25	81.31	81.22	81.25	325000.0

> showing 50 of 853 rows — these rows as CSV

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