PREVIEW / etf_daily / 2011-06-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-09.parquet
  size:    36 KB
  rows:    854

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-09	SPY	ETF	128.77	129.93	128.46	129.4	160964400.0
2011-06-09	QQQ	ETF	55.37	55.76	55.23	55.485	45307498.0
2011-06-09	IWM	ETF	79.08	79.71	78.73	79.27	58469700.0
2011-06-09	DIA	ETF	120.59	121.68	120.43	121.12	4024900.0
2011-06-09	GLD	ETF	150.01	151.02	149.75	150.56	7643200.0
2011-06-09	TLT	ETF	97.1	97.33	95.93	96.4	9963000.0
2011-06-09	AADR	ETF	31.21	31.21	31.21	31.21	600.0
2011-06-09	AAXJ	ETF	61.82	62.5	61.82	62.39	482300.0
2011-06-09	ACTV	ETF	19.2	19.5	19.0	19.29	252228.0
2011-06-09	ACWI	ETF	47.69	48.27	47.64	48.12	648400.0
2011-06-09	ACWX	ETF	44.85	45.27	44.7501	45.14	48084.0
2011-06-09	ADRE	ETF	45.73	46.0936	45.57	45.99	36006.0
2011-06-09	AFK	ETF	33.07	33.11	32.9	33.0924	16122.0
2011-06-09	AGG	ETF	107.6	107.66	107.39	107.49	646500.0
2011-06-09	AGQ	ETF	383.64	391.32	380.02	390.78	715950.0
2011-06-09	AGZ	ETF	111.03	111.03	110.82	110.83	18674.0
2011-06-09	AIA	ETF	47.29	47.659	47.122	47.659	13922.0
2011-06-09	AIQ	ETF	19.3	19.3	19.2	19.2	14703.0
2011-06-09	AIS	ETF	1.96	2.11	1.96	2.08	2923388.0
2011-06-09	AIVI	ETF	47.5	48.06	47.46	47.98	17300.0
2011-06-09	AMJ	ETF	35.62	36.09	35.54	36.06	731417.0
2011-06-09	AMLP	ETF	78.3	78.95	78.15	78.9	97940.0
2011-06-09	AOA	ETF	35.17	35.38	35.14	35.3	4000.0
2011-06-09	AOK	ETF	29.24	29.28	29.2064	29.279	10044.0
2011-06-09	AOM	ETF	30.6075	30.6675	30.575	30.61	14954.0
2011-06-09	AOR	ETF	32.32	32.42	32.27	32.4068	7831.0
2011-06-09	ARB	ETF	37.68	39.79	37.53	39.5	223627.0
2011-06-09	ARGT	ETF	28.28	28.7	28.28	28.68	3200.0
2011-06-09	ASEA	ETF	16.26	16.32	16.17	16.28	5100.0
2011-06-09	BAB	ETF	26.76	26.8	26.6	26.65	163434.0
2011-06-09	BAL	ETF	81.44	84.04	81.44	83.65	41655.0
2011-06-09	BALT	ETF	6.28	6.35	6.18	6.27	118950.0
2011-06-09	BBH	ETF	34.52	34.8933	34.3733	34.54	37500.0
2011-06-09	BCM	ETF	48.39	48.4844	48.39	48.4844	1050.0
2011-06-09	BIB	ETF	9.375	9.5337	9.2538	9.3737	44800.0
2011-06-09	BICK	ETF	31.88	31.9815	31.58	31.88	35633.0
2011-06-09	BIL	ETF	91.72	91.72	91.7	91.7	376350.0
2011-06-09	BIS	ETF	6214.4	6232.144	6080.0	6153.6	8.95
2011-06-09	BITS	ETF	21.16	21.84	20.64	21.44	3802.0
2011-06-09	BIV	ETF	84.92	85.0	84.57	84.64	241500.0
2011-06-09	BJK	ETF	32.94	33.05	32.94	33.05	3600.0
2011-06-09	BKF	ETF	47.52	48.066	47.43	47.9399	81430.0
2011-06-09	BKLN	ETF	24.95	24.98	24.92	24.97	54300.0
2011-06-09	BLNG	ETF	49.19	49.51	49.16	49.46	12800.0
2011-06-09	BLV	ETF	82.09	82.25	81.43	81.71	40800.0
2011-06-09	BMVP	ETF	15.08	15.21	15.07	15.21	5949.0
2011-06-09	BND	ETF	81.87	81.89	81.63	81.69	1069900.0
2011-06-09	BNO	ETF	39.3	39.835	39.13	39.79	81000.0
2011-06-09	BRF	ETF	57.33	57.69	57.2	57.429	95309.0
2011-06-09	BSCE	ETF	21.2	21.26	21.2	21.2	13605.0

> showing 50 of 854 rows — these rows as CSV

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