PREVIEW / etf_daily / 2011-12-05

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-05.parquet
  size:    37 KB
  rows:    895

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-12-05	SPY	ETF	126.84	127.18	125.44	126.22	225263900.0
2011-12-05	QQQ	ETF	57.49	57.62	56.915	57.24	40501885.0
2011-12-05	IWM	ETF	74.94	75.39	74.13	74.76	58429900.0
2011-12-05	DIA	ETF	121.77	121.85	120.21	120.95	6285400.0
2011-12-05	GLD	ETF	169.06	169.95	167.06	167.32	10246700.0
2011-12-05	TLT	ETF	117.0	118.83	116.88	118.4	7862800.0
2011-12-05	AADR	ETF	28.75	28.75	28.75	28.75	400.0
2011-12-05	AAXJ	ETF	53.06	53.19	52.55	52.81	276000.0
2011-12-05	ACTV	ETF	12.95	13.55	12.66	13.32	884127.0
2011-12-05	ACWI	ETF	43.7	43.7	43.09	43.31	472500.0
2011-12-05	ACWV	ETF	51.0	51.0	50.69	50.69	300.0
2011-12-05	ACWX	ETF	38.64	38.7192	38.24	38.38	481661.0
2011-12-05	ADRE	ETF	40.63	40.86	40.46	40.69	70511.0
2011-12-05	AFK	ETF	27.63	27.68	27.2	27.391	17394.0
2011-12-05	AGEM	ETF	22.53	22.6428	22.42	22.42	1573.0
2011-12-05	AGG	ETF	108.99	109.24	108.9	109.24	1063700.0
2011-12-05	AGQ	ETF	241.56	243.52	226.92	227.64	365700.0
2011-12-05	AGZ	ETF	112.51	112.54	112.02	112.48	17950.0
2011-12-05	AIA	ETF	41.67	41.802	41.4	41.59	19603.0
2011-12-05	AIQ	ETF	5.85	5.9	5.6	5.75	26270.0
2011-12-05	AIS	ETF	2.81	2.88	2.76	2.82	3554818.0
2011-12-05	AIVI	ETF	41.19	41.19	40.49	40.71	87500.0
2011-12-05	AMJ	ETF	37.87	37.87	37.44	37.53	544495.0
2011-12-05	AMLP	ETF	81.1	81.4	80.7	80.9	317560.0
2011-12-05	AOA	ETF	33.56	33.71	33.4	33.4	6100.0
2011-12-05	AOK	ETF	29.26	29.57	29.26	29.39	105037.0
2011-12-05	AOM	ETF	30.14	30.14	30.0	30.06	58357.0
2011-12-05	AOR	ETF	31.47	31.55	31.3	31.43	13844.0
2011-12-05	ARB	ETF	38.15	38.36	37.49	37.86	178494.0
2011-12-05	ARGT	ETF	23.26	23.4	23.26	23.4	2450.0
2011-12-05	ASEA	ETF	15.13	15.23	15.03	15.04	48600.0
2011-12-05	AWAY	ETF	26.34	26.56	24.87	25.19	555059.0
2011-12-05	BAB	ETF	28.27	28.5	28.2	28.47	119615.0
2011-12-05	BAL	ETF	57.21	57.41	56.7	56.72	29424.0
2011-12-05	BALT	ETF	5.14	5.14	4.87	5.0	91388.0
2011-12-05	BBH	ETF	35.0	35.2267	34.2967	34.9267	93600.0
2011-12-05	BIB	ETF	8.3763	8.3763	8.2037	8.2037	84640.0
2011-12-05	BICK	ETF	25.21	25.35	25.01	25.21	6006.0
2011-12-05	BIL	ETF	91.68	91.68	91.66	91.68	2240550.0
2011-12-05	BIS	ETF	5488.0	5488.0	5484.8	5488.0	2.5
2011-12-05	BITS	ETF	21.6	21.6	21.2	21.6	5540.0
2011-12-05	BIV	ETF	87.08	87.3	86.96	87.28	221600.0
2011-12-05	BJK	ETF	31.88	31.96	31.45	31.61	9500.0
2011-12-05	BKF	ETF	39.21	39.36	38.93	39.19	179833.0
2011-12-05	BKLN	ETF	23.81	23.93	23.81	23.92	127000.0
2011-12-05	BLNG	ETF	52.7	52.7	52.7	52.7	200.0
2011-12-05	BLV	ETF	90.05	91.0	89.91	90.74	57800.0
2011-12-05	BMVP	ETF	13.8233	13.8868	13.7033	13.7567	2757.0
2011-12-05	BND	ETF	83.22	83.43	83.1	83.41	2386300.0
2011-12-05	BNO	ETF	38.55	38.575	37.87	38.0	41400.0

> showing 50 of 895 rows — these rows as CSV

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