PREVIEW / etf_daily / 2011-11-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-16.parquet
  size:    37 KB
  rows:    889

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-11-16	SPY	ETF	124.81	126.34	123.9	124.08	235782500.0
2011-11-16	QQQ	ETF	57.73	58.1574	57.06	57.17	68342577.0
2011-11-16	IWM	ETF	73.47	74.88	72.91	73.04	56938700.0
2011-11-16	DIA	ETF	119.87	121.14	118.91	119.1	7142200.0
2011-11-16	GLD	ETF	171.63	172.96	170.57	171.51	15093300.0
2011-11-16	TLT	ETF	117.96	118.43	117.18	118.42	7470000.0
2011-11-16	AAXJ	ETF	52.08	52.59	51.67	51.68	328200.0
2011-11-16	ACTV	ETF	14.61	16.2	14.6	15.48	259867.0
2011-11-16	ACWI	ETF	42.72	43.12	42.35	42.45	218700.0
2011-11-16	ACWX	ETF	37.58	37.965	37.3	37.31	222511.0
2011-11-16	ADRE	ETF	40.35	40.8219	40.2002	40.24	41539.0
2011-11-16	AFK	ETF	27.87	28.129	27.739	27.739	11114.0
2011-11-16	AGEM	ETF	22.02	22.49	22.02	22.49	10271.0
2011-11-16	AGG	ETF	109.98	109.99	109.6	109.7	1213100.0
2011-11-16	AGQ	ETF	262.72	266.4	254.88	257.48	471575.0
2011-11-16	AGZ	ETF	112.36	112.58	112.13	112.28	59290.0
2011-11-16	AIA	ETF	40.83	41.193	40.53	40.53	25449.0
2011-11-16	AIQ	ETF	6.35	6.45	6.0	6.05	36916.0
2011-11-16	AIS	ETF	2.39	2.62	2.35	2.56	3348853.0
2011-11-16	AIVI	ETF	40.33	40.62	39.91	39.91	60400.0
2011-11-16	AMJ	ETF	37.1	37.35	36.92	37.14	394603.0
2011-11-16	AMLP	ETF	79.25	79.5	78.95	79.25	162340.0
2011-11-16	AOA	ETF	33.02	33.36	32.87	32.9	14800.0
2011-11-16	AOK	ETF	29.2828	29.32	29.22	29.259	54792.0
2011-11-16	AOM	ETF	29.94	29.9988	29.84	29.84	20875.0
2011-11-16	AOR	ETF	31.15	31.31	30.98	31.0	20483.0
2011-11-16	ARB	ETF	41.29	42.23	40.47	40.68	110662.0
2011-11-16	ARGT	ETF	23.04	23.04	23.04	23.04	50.0
2011-11-16	ASEA	ETF	15.01	15.13	14.9	14.9	4900.0
2011-11-16	AWAY	ETF	32.39	33.01	32.14	32.17	35839.0
2011-11-16	BAB	ETF	28.37	28.65	28.341	28.53	178884.0
2011-11-16	BAL	ETF	62.0	62.63	61.722	62.16	32442.0
2011-11-16	BALT	ETF	5.37	5.42	5.25	5.28	50456.0
2011-11-16	BBH	ETF	34.6333	34.8533	34.4067	34.4967	24000.0
2011-11-16	BIB	ETF	7.1338	7.25	7.0137	7.0137	18000.0
2011-11-16	BICK	ETF	24.94	25.105	24.638	24.73	13292.0
2011-11-16	BIL	ETF	91.68	91.7	91.68	91.7	341300.0
2011-11-16	BIS	ETF	6544.0	6712.0	6544.0	6712.0	10.45
2011-11-16	BITS	ETF	21.6	21.6	21.16	21.44	4322.0
2011-11-16	BIV	ETF	87.81	87.86	87.57	87.84	176700.0
2011-11-16	BJK	ETF	31.17	31.49	30.96	30.96	15300.0
2011-11-16	BKF	ETF	39.37	39.85	38.95	39.17	106858.0
2011-11-16	BKLN	ETF	24.1	24.1	23.75	24.05	52600.0
2011-11-16	BLV	ETF	91.4	91.5	90.84	91.44	52300.0
2011-11-16	BMVP	ETF	13.7233	13.8181	13.58	13.58	6996.0
2011-11-16	BND	ETF	83.71	83.71	83.59	83.71	1705400.0
2011-11-16	BNO	ETF	38.26	38.955	38.215	38.415	630000.0
2011-11-16	BRF	ETF	44.1	44.76	43.971	44.21	96377.0
2011-11-16	BSCE	ETF	20.89	21.01	20.89	20.97	12840.0
2011-11-16	BSV	ETF	81.41	81.42	81.34	81.4	736400.0

> showing 50 of 889 rows — these rows as CSV

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