PREVIEW / etf_daily / 2010-06-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-02.parquet
  size:    33 KB
  rows:    757

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
2010-06-02	SPY	ETF	108.08	110.34	107.51	110.33	240243700.0
2010-06-02	QQQ	ETF	45.45	46.28	45.13	46.25	97249295.0
2010-06-02	IWM	ETF	64.63	66.1	64.02	66.07	61553800.0
2010-06-02	DIA	ETF	100.86	102.65	100.41	102.61	14879500.0
2010-06-02	GLD	ETF	119.35	119.88	118.72	119.78	10339300.0
2010-06-02	TLT	ETF	96.99	97.19	95.82	95.93	5656400.0
2010-06-02	AAXJ	ETF	50.75	52.6	50.75	52.54	552300.0
2010-06-02	ACWI	ETF	38.92	40.0	38.86	40.0	1481300.0
2010-06-02	ACWX	ETF	36.31	37.15	36.15	37.15	67323.0
2010-06-02	ADRE	ETF	39.75	40.56	39.44	40.56	128824.0
2010-06-02	AFK	ETF	29.13	29.5799	29.13	29.57	4679.0
2010-06-02	AGG	ETF	105.59	105.63	105.44	105.45	1241600.0
2010-06-02	AGQ	ETF	121.98	123.74	120.1	123.64	122600.0
2010-06-02	AGZ	ETF	108.91	109.29	108.91	109.1	24136.0
2010-06-02	AIA	ETF	36.5	37.23	36.3799	37.23	27419.0
2010-06-02	AIQ	ETF	26.75	27.4	26.45	27.35	17891.0
2010-06-02	AIS	ETF	1.64	1.67	1.61	1.65	396764.0
2010-06-02	AIVI	ETF	37.27	38.18	37.27	38.18	22200.0
2010-06-02	AMJ	ETF	28.59	29.19	28.34	29.19	321717.0
2010-06-02	AOA	ETF	29.05	29.6	28.97	29.6	4800.0
2010-06-02	AOK	ETF	27.44	27.51	27.36	27.51	8309.0
2010-06-02	AOM	ETF	27.7813	28.05	27.7813	28.05	3733.0
2010-06-02	AOR	ETF	28.2501	28.68	28.2501	28.68	3256.0
2010-06-02	ARB	ETF	29.16	29.96	28.85	29.96	275079.0
2010-06-02	BAB	ETF	26.06	26.07	25.9	25.94	380836.0
2010-06-02	BAL	ETF	37.0	37.44	36.9	37.1	4423.0
2010-06-02	BALT	ETF	12.26	12.54	12.25	12.45	101150.0
2010-06-02	BBH	ETF	29.4333	30.4733	29.4333	30.4733	441300.0
2010-06-02	BIB	ETF	5.75	5.9325	5.75	5.9325	4800.0
2010-06-02	BICK	ETF	26.99	27.36	26.89	27.36	11598.0
2010-06-02	BIL	ETF	91.7	91.74	91.7	91.74	959800.0
2010-06-02	BIS	ETF	12112.0	12112.0	11480.0	11480.0	18.1
2010-06-02	BITS	ETF	28.8	28.8	27.4	28.68	824.0
2010-06-02	BIV	ETF	81.87	81.92	81.53	81.6	553400.0
2010-06-02	BJK	ETF	23.72	24.34	23.72	24.27	15300.0
2010-06-02	BKF	ETF	40.84	41.94	40.75	41.835	217151.0
2010-06-02	BLV	ETF	79.45	79.66	78.91	79.08	43800.0
2010-06-02	BMVP	ETF	12.2	12.45	12.16	12.45	13814.0
2010-06-02	BND	ETF	80.25	80.32	80.14	80.21	2665400.0
2010-06-02	BNE	ETF	11.02	11.09	11.01	11.08	288197.0
2010-06-02	BNO	ETF	25.485	25.615	25.32	25.59	30800.0
2010-06-02	BRF	ETF	42.06	43.13	41.96	43.13	134754.0
2010-06-02	BSV	ETF	80.29	80.37	80.27	80.32	317900.0
2010-06-02	BTF	ETF	64.3	65.961	64.25	65.961	3286.6000000000004
2010-06-02	BWX	ETF	26.57	26.66	26.385	26.4437	242326.0
2010-06-02	BWZ	ETF	33.38	33.44	33.23	33.41	19870.0
2010-06-02	BZQ	ETF	4398.4	4460.8	4184.0	4204.8	1092.0
2010-06-02	CEF	ETF	15.03	15.1	14.92	15.07	1238500.0
2010-06-02	CEW	ETF	21.28	21.28	21.15	21.21	6407179.0
2010-06-02	CGO	ETF	12.93	13.38	12.93	13.26	21057.0

> showing 50 of 757 rows — these rows as CSV

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