PREVIEW / etf_daily / 2011-03-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-02.parquet
  size:    35 KB
  rows:    830

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-03-02	SPY	ETF	130.75	131.82	130.35	131.21	200277400.0
2011-03-02	QQQ	ETF	56.82	57.511	56.79	57.14	61552875.0
2011-03-02	IWM	ETF	80.53	81.37	80.24	80.96	61072300.0
2011-03-02	DIA	ETF	120.25	120.98	120.0	120.45	8298400.0
2011-03-02	GLD	ETF	140.24	140.55	139.48	139.92	15719800.0
2011-03-02	TLT	ETF	91.84	91.99	90.94	90.95	8526400.0
2011-03-02	AADR	ETF	30.34	30.34	30.34	30.34	10000.0
2011-03-02	AAXJ	ETF	60.28	60.67	60.15	60.5	368800.0
2011-03-02	ACWI	ETF	48.26	48.55	47.89	48.33	715900.0
2011-03-02	ACWX	ETF	45.32	45.599	45.32	45.48	151795.0
2011-03-02	ADRE	ETF	46.4	47.0	46.4	46.94	56962.0
2011-03-02	AFK	ETF	32.67	32.98	32.54	32.83	24388.0
2011-03-02	AGG	ETF	105.31	105.39	105.09	105.11	506200.0
2011-03-02	AGQ	ETF	393.94	396.46	379.5	388.5	818200.0
2011-03-02	AGZ	ETF	109.54	109.54	109.102	109.2	22825.0
2011-03-02	AIA	ETF	45.48	45.8	45.48	45.69	30649.0
2011-03-02	AIQ	ETF	20.45	20.55	20.2	20.3	18848.0
2011-03-02	AIS	ETF	1.53	1.53	1.5	1.51	516941.0
2011-03-02	AIVI	ETF	46.26	46.55	46.22	46.46	22800.0
2011-03-02	AMJ	ETF	38.03	38.11	37.82	37.97	1372479.0
2011-03-02	AMLP	ETF	82.45	82.6	82.05	82.25	98300.0
2011-03-02	AOA	ETF	35.36	35.55	35.36	35.49	11100.0
2011-03-02	AOK	ETF	29.04	29.12	29.04	29.07	32259.0
2011-03-02	AOM	ETF	30.42	30.51	30.414	30.45	11780.0
2011-03-02	AOR	ETF	32.25	32.39	32.25	32.27	53572.0
2011-03-02	ARB	ETF	38.67	39.24	38.4	39.22	188919.0
2011-03-02	ASEA	ETF	15.2	15.24	15.12	15.21	4900.0
2011-03-02	BAB	ETF	25.28	25.28	25.11	25.11	84249.0
2011-03-02	BAL	ETF	103.71	106.49	102.58	106.29	89227.0
2011-03-02	BALT	ETF	9.17	9.44	9.12	9.24	81565.0
2011-03-02	BBH	ETF	33.6533	33.96	33.5533	33.76	183000.0
2011-03-02	BIB	ETF	7.67	7.67	7.67	7.67	1200.0
2011-03-02	BICK	ETF	30.73	31.14	30.73	31.11	17657.0
2011-03-02	BIL	ETF	91.72	91.72	91.7	91.72	128000.0
2011-03-02	BIS	ETF	8107.2	8107.2	7849.6	7849.6	2.475
2011-03-02	BITS	ETF	26.76	26.84	25.1604	26.16	1542.0
2011-03-02	BIV	ETF	82.36	82.64	82.27	82.29	75200.0
2011-03-02	BJK	ETF	31.5	31.83	31.47	31.73	14100.0
2011-03-02	BKF	ETF	47.82	48.384	47.72	48.22	679818.0
2011-03-02	BLV	ETF	78.39	78.47	78.03	78.07	149100.0
2011-03-02	BMVP	ETF	15.31	15.42	15.31	15.39	3362.0
2011-03-02	BND	ETF	80.07	80.18	79.92	79.94	595200.0
2011-03-02	BNO	ETF	38.485	39.09	38.225	38.68	206800.0
2011-03-02	BRF	ETF	51.88	53.01	51.88	52.72	301724.0
2011-03-02	BSCE	ETF	20.87	20.88	20.85	20.86	17870.0
2011-03-02	BSV	ETF	80.39	80.44	79.75	80.35	469100.0
2011-03-02	BTF	ETF	84.94999999999999	85.8	84.12499999999999	84.12499999999999	10656.400000000001
2011-03-02	BWX	ETF	29.745	29.865	29.745	29.85	301840.0
2011-03-02	BWZ	ETF	37.79	37.86	37.66	37.8	41368.0
2011-03-02	BZQ	ETF	2632.0	2632.0	2510.4	2545.6	442.0

> showing 50 of 830 rows — these rows as CSV

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