PREVIEW / etf_daily / 2011-05-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-02.parquet
  size:    36 KB
  rows:    847

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-02	SPY	ETF	137.07	137.18	135.95	136.22	126278700.0
2011-05-02	QQQ	ETF	59.19	59.34	58.82	58.97	48149385.0
2011-05-02	IWM	ETF	86.78	86.81	85.28	85.38	48962400.0
2011-05-02	DIA	ETF	128.6	128.63	127.62	127.84	10518700.0
2011-05-02	GLD	ETF	151.46	153.61	150.36	150.41	24094100.0
2011-05-02	TLT	ETF	93.32	93.68	93.17	93.64	5285100.0
2011-05-02	AADR	ETF	32.13	32.19	32.12	32.19	500.0
2011-05-02	AAXJ	ETF	65.0	65.31	64.81	64.96	206400.0
2011-05-02	ACWI	ETF	50.98	50.99	50.53	50.62	211100.0
2011-05-02	ACWX	ETF	47.89	47.946	47.54	47.61	94355.0
2011-05-02	ADRE	ETF	48.98	48.98	48.31	48.41	68789.0
2011-05-02	AFK	ETF	34.37	34.5	34.02	34.043	12251.0
2011-05-02	AGG	ETF	106.21	106.24	106.04	106.2	613500.0
2011-05-02	AGQ	ETF	632.6	698.42	581.6	593.0	2568000.0
2011-05-02	AGZ	ETF	110.16	110.16	109.75	109.87	24673.0
2011-05-02	AIA	ETF	49.92	49.92	49.55	49.65	21597.0
2011-05-02	AIQ	ETF	22.1	22.25	21.25	21.35	35842.0
2011-05-02	AIS	ETF	1.94	1.94	1.74	1.77	1191818.0
2011-05-02	AIVI	ETF	50.44	50.6	50.2	50.2	6500.0
2011-05-02	AMJ	ETF	39.42	39.42	38.6	38.65	1427467.0
2011-05-02	AMLP	ETF	83.85	83.85	82.65	82.7	108200.0
2011-05-02	AOA	ETF	37.25	37.28	37.06	37.06	16000.0
2011-05-02	AOK	ETF	29.61	29.63	29.6	29.63	22020.0
2011-05-02	AOM	ETF	31.23	31.23	31.12	31.159	31594.0
2011-05-02	AOR	ETF	33.5	33.52	33.348	33.39	35427.0
2011-05-02	ARB	ETF	38.93	39.78	38.71	39.75	305562.0
2011-05-02	ARGT	ETF	30.82	30.82	30.42	30.42	300.0
2011-05-02	ASEA	ETF	16.82	16.85	16.71	16.72	70000.0
2011-05-02	BAB	ETF	25.9	25.93	25.83	25.92	93155.0
2011-05-02	BAL	ETF	87.24	87.34	83.73	85.48	143403.0
2011-05-02	BALT	ETF	8.04	8.18	8.002	8.08	127200.0
2011-05-02	BBH	ETF	34.2967	34.9133	34.0	34.9133	45000.0
2011-05-02	BCM	ETF	50.79	50.79	50.28	50.28	3525.0
2011-05-02	BIB	ETF	10.1062	10.1188	9.6662	9.9501	100248.0
2011-05-02	BICK	ETF	34.86	35.067	34.8	34.86	22563.0
2011-05-02	BIL	ETF	91.72	91.72	91.7	91.7	76000.0
2011-05-02	BIS	ETF	5824.0	5905.6	5824.0	5904.0	2.5
2011-05-02	BITS	ETF	25.2	25.2	21.48	24.12	9929.0
2011-05-02	BIV	ETF	82.87	83.3	82.87	83.2	184000.0
2011-05-02	BJK	ETF	35.49	35.61	35.23	35.23	5000.0
2011-05-02	BKF	ETF	50.15	50.58	50.0	50.07	55794.0
2011-05-02	BKLN	ETF	25.26	25.29	25.25	25.28	103000.0
2011-05-02	BLV	ETF	79.6	79.82	79.57	79.78	22000.0
2011-05-02	BMVP	ETF	16.16	16.17	15.96	15.96	5093.0
2011-05-02	BND	ETF	80.86	80.86	80.69	80.76	820700.0
2011-05-02	BNO	ETF	41.505	42.0	41.47	41.48	38000.0
2011-05-02	BRF	ETF	58.62	58.77	57.9	57.92	134876.0
2011-05-02	BSCE	ETF	21.25	21.25	21.07	21.1	44802.0
2011-05-02	BSV	ETF	80.66	80.68	80.58	80.65	404400.0
2011-05-02	BTF	ETF	84.89999999999999	84.89999999999999	83.90499999999999	84.21099999999998	4103.2

> showing 50 of 847 rows — these rows as CSV

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