PREVIEW / etf_daily / 2011-06-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-02.parquet
  size:    36 KB
  rows:    852

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-02	SPY	ETF	131.96	132.24	130.96	131.73	200466800.0
2011-06-02	QQQ	ETF	57.21	57.41	56.89	57.21	50198045.0
2011-06-02	IWM	ETF	82.32	82.66	81.6	82.08	64666600.0
2011-06-02	DIA	ETF	122.76	122.87	121.72	122.3	8832200.0
2011-06-02	GLD	ETF	150.15	150.38	148.07	149.5	13552700.0
2011-06-02	TLT	ETF	96.49	96.91	95.78	95.78	15738700.0
2011-06-02	AADR	ETF	31.67	31.67	31.67	31.67	100.0
2011-06-02	AAXJ	ETF	63.21	63.45	62.83	63.25	155300.0
2011-06-02	ACTV	ETF	18.09	18.71	17.413	18.25	177443.0
2011-06-02	ACWI	ETF	48.78	48.79	48.28	48.73	1343800.0
2011-06-02	ACWX	ETF	45.39	45.556	45.01	45.5	165716.0
2011-06-02	ADRE	ETF	46.56	46.702	46.14	46.64	31611.0
2011-06-02	AFK	ETF	33.18	33.46	32.85	33.19	22626.0
2011-06-02	AGG	ETF	107.31	107.47	107.17	107.18	666600.0
2011-06-02	AGQ	ETF	383.62	385.8	352.02	364.02	1442550.0
2011-06-02	AGZ	ETF	110.625	110.71	110.57	110.64	21862.0
2011-06-02	AIA	ETF	48.41	48.41	48.05	48.24	46755.0
2011-06-02	AIQ	ETF	20.75	20.85	20.55	20.65	18445.0
2011-06-02	AIS	ETF	1.82	1.86	1.81	1.81	338251.0
2011-06-02	AIVI	ETF	48.23	48.27	47.63	48.2	7900.0
2011-06-02	AMJ	ETF	36.45	36.5	36.0	36.27	840882.0
2011-06-02	AMLP	ETF	79.15	79.4	78.55	78.95	110320.0
2011-06-02	AOA	ETF	35.99	36.0	35.75	35.9	9600.0
2011-06-02	AOK	ETF	29.32	29.41	29.32	29.35	13953.0
2011-06-02	AOM	ETF	30.86	30.86	30.742	30.829	60564.0
2011-06-02	AOR	ETF	32.77	32.77	32.63	32.69	11522.0
2011-06-02	ARB	ETF	41.34	41.64	40.75	41.4	99413.0
2011-06-02	ARGT	ETF	28.98	29.06	28.8	29.06	1650.0
2011-06-02	ASEA	ETF	16.34	16.45	16.27	16.37	8800.0
2011-06-02	BAB	ETF	26.73	26.73	26.53	26.56	200025.0
2011-06-02	BAL	ETF	90.21	92.36	90.1024	91.5	176349.0
2011-06-02	BALT	ETF	6.26	6.37	6.13	6.24	159577.0
2011-06-02	BBH	ETF	34.6833	34.9033	34.6833	34.8933	33900.0
2011-06-02	BIB	ETF	9.8763	9.8975	9.6775	9.8362	58128.0
2011-06-02	BICK	ETF	32.46	32.7	32.3356	32.59	117049.0
2011-06-02	BIL	ETF	91.7	91.72	91.7	91.7	69000.0
2011-06-02	BIS	ETF	5980.8	5980.8	5907.2	5916.8	17.5
2011-06-02	BITS	ETF	22.8	23.6	22.32	22.44	1401.0
2011-06-02	BIV	ETF	84.71	84.82	84.43	84.5	313300.0
2011-06-02	BJK	ETF	34.31	34.43	34.09	34.33	23800.0
2011-06-02	BKF	ETF	48.18	48.5375	47.9068	48.36	109414.0
2011-06-02	BKLN	ETF	25.08	25.09	25.06	25.09	107000.0
2011-06-02	BLNG	ETF	48.63	48.63	48.63	48.63	1000.0
2011-06-02	BLV	ETF	81.94	82.11	81.29	81.43	51400.0
2011-06-02	BMVP	ETF	15.62	15.67	15.54	15.63	3842.0
2011-06-02	BND	ETF	81.68	81.74	81.53	81.53	892100.0
2011-06-02	BNO	ETF	38.025	38.975	37.14	38.475	54200.0
2011-06-02	BOSS	ETF	56.8	56.8	56.58	56.58	100.0
2011-06-02	BRF	ETF	56.97	57.49	56.731	57.37	131464.0
2011-06-02	BSCE	ETF	21.17	21.2	21.1662	21.17	23378.0

> showing 50 of 852 rows — these rows as CSV

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