PREVIEW / etf_daily / 2011-05-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-24.parquet
  size:    36 KB
  rows:    846

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-05-24	SPY	ETF	132.44	132.73	131.7	131.95	147199600.0
2011-05-24	QQQ	ETF	57.07	57.07	56.56	56.57	39314212.0
2011-05-24	IWM	ETF	81.59	81.96	80.83	80.98	60223400.0
2011-05-24	DIA	ETF	123.81	123.96	123.21	123.3	4244400.0
2011-05-24	GLD	ETF	148.48	149.05	148.18	148.59	14948000.0
2011-05-24	TLT	ETF	95.64	96.14	95.46	96.14	5549100.0
2011-05-24	AADR	ETF	30.53	30.94	30.53	30.78	10200.0
2011-05-24	AAXJ	ETF	61.82	61.82	61.33	61.44	174000.0
2011-05-24	ACWI	ETF	48.13	48.18	47.84	47.9	163000.0
2011-05-24	ACWX	ETF	44.5	44.71	44.35	44.49	45801.0
2011-05-24	ADRE	ETF	45.38	45.6095	45.31	45.416	73299.0
2011-05-24	AFK	ETF	32.44	32.45	32.18	32.2401	19278.0
2011-05-24	AGG	ETF	107.03	107.17	106.98	107.12	579400.0
2011-05-24	AGQ	ETF	361.8	377.9	358.44	376.24	1579200.0
2011-05-24	AGZ	ETF	110.3204	110.3993	110.28	110.3712	7790.0
2011-05-24	AIA	ETF	46.73	46.79	46.5609	46.65	22962.0
2011-05-24	AIQ	ETF	20.35	20.65	19.95	20.55	24700.0
2011-05-24	AIS	ETF	1.73	1.78	1.71	1.75	780212.0
2011-05-24	AIVI	ETF	47.16	47.31	46.95	47.1	32500.0
2011-05-24	AMJ	ETF	36.97	37.2395	36.6312	36.73	1693503.0
2011-05-24	AMLP	ETF	79.3	79.8	78.8	79.1	147400.0
2011-05-24	AOA	ETF	35.76	35.76	35.6	35.66	3800.0
2011-05-24	AOK	ETF	29.37	29.38	29.31	29.357	10803.0
2011-05-24	AOM	ETF	30.69	30.69	30.6	30.62	18940.0
2011-05-24	AOR	ETF	32.57	32.6199	32.48	32.557	26784.0
2011-05-24	ARB	ETF	41.15	41.43	40.43	40.67	140418.0
2011-05-24	ARGT	ETF	29.22	29.3	28.94	29.1	1100.0
2011-05-24	ASEA	ETF	16.18	16.18	16.03	16.08	9300.0
2011-05-24	BAB	ETF	26.46	26.49	26.35	26.49	198032.0
2011-05-24	BAL	ETF	86.71	87.2299	85.09	86.21	36278.0
2011-05-24	BALT	ETF	6.54	6.54	6.26	6.31	140678.0
2011-05-24	BBH	ETF	35.0	35.0367	34.82	34.8467	72000.0
2011-05-24	BCM	ETF	46.3	47.84	46.3	46.89	1780.0
2011-05-24	BIB	ETF	9.6687	9.7093	9.5938	9.5938	30728.0
2011-05-24	BICK	ETF	31.75	31.92	31.68	31.75	12136.0
2011-05-24	BIL	ETF	91.7	91.72	91.7	91.72	68000.0
2011-05-24	BIS	ETF	6113.6	6113.6	6048.0	6070.4	8.35
2011-05-24	BITS	ETF	22.2	23.4	22.0	22.44	2838.0
2011-05-24	BIV	ETF	84.04	84.24	83.98	84.22	133300.0
2011-05-24	BJK	ETF	33.49	33.58	33.34	33.58	3500.0
2011-05-24	BKF	ETF	46.72	47.09	46.5947	46.85	122488.0
2011-05-24	BKLN	ETF	25.1	25.13	25.09	25.13	189900.0
2011-05-24	BLNG	ETF	48.4868	48.73	48.4868	48.73	300.0
2011-05-24	BLV	ETF	81.76	81.82	81.35	81.69	22200.0
2011-05-24	BMVP	ETF	15.64	15.66	15.57	15.6	1297.0
2011-05-24	BND	ETF	81.37	81.45	81.31	81.42	1002500.0
2011-05-24	BNO	ETF	37.37	37.475	36.905	37.395	70600.0
2011-05-24	BRF	ETF	54.46	54.86	54.29	54.71	77529.0
2011-05-24	BSCE	ETF	21.16	21.16	21.13	21.1399	13680.0
2011-05-24	BSV	ETF	80.9	80.93	80.86	80.92	612700.0

> showing 50 of 846 rows — these rows as CSV

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