PREVIEW / etf_daily / 2011-05-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-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-05-09	SPY	ETF	134.19	135.11	133.98	134.72	114104500.0
2011-05-09	QQQ	ETF	58.56	58.92	58.34	58.69	40028981.0
2011-05-09	IWM	ETF	83.17	84.33	83.04	84.24	45806800.0
2011-05-09	DIA	ETF	126.24	127.07	126.04	126.71	5464900.0
2011-05-09	GLD	ETF	146.67	147.58	146.34	147.38	13854800.0
2011-05-09	TLT	ETF	94.9	95.2	94.84	94.97	3731200.0
2011-05-09	AADR	ETF	31.36	31.4	31.36	31.4	500.0
2011-05-09	AAXJ	ETF	63.7	63.9	63.37	63.71	468400.0
2011-05-09	ACWI	ETF	49.35	49.67	49.1	49.58	309000.0
2011-05-09	ACWX	ETF	46.01	46.3	45.796	46.25	247049.0
2011-05-09	ADRE	ETF	46.59	46.851	46.41	46.76	59165.0
2011-05-09	AFK	ETF	32.8	33.15	32.8	33.05	7134.0
2011-05-09	AGG	ETF	106.69	106.82	106.69	106.78	502200.0
2011-05-09	AGQ	ETF	409.0	429.1	400.52	428.68	2339550.0
2011-05-09	AGZ	ETF	110.25	110.33	110.07	110.12	8513.0
2011-05-09	AIA	ETF	48.11	48.2671	47.89	48.21	16279.0
2011-05-09	AIQ	ETF	20.4	21.3	20.2	21.2	22960.0
2011-05-09	AIS	ETF	1.74	1.8	1.69	1.73	587510.0
2011-05-09	AIVI	ETF	48.19	48.5	48.0	48.47	28000.0
2011-05-09	AMJ	ETF	37.67	37.94	37.49	37.68	668788.0
2011-05-09	AMLP	ETF	80.5	80.95	80.1	80.45	173080.0
2011-05-09	AOA	ETF	36.38	36.6	36.32	36.58	11000.0
2011-05-09	AOK	ETF	29.43	29.53	29.43	29.5291	14430.0
2011-05-09	AOM	ETF	30.9	31.01	30.9	30.9925	8567.0
2011-05-09	AOR	ETF	32.93	33.12	32.93	33.1099	13340.0
2011-05-09	ARB	ETF	39.63	42.162	39.49	41.49	263243.0
2011-05-09	ARGT	ETF	29.48	29.62	29.44	29.62	500.0
2011-05-09	ASEA	ETF	16.09	16.37	16.09	16.37	7400.0
2011-05-09	BAB	ETF	26.29	26.36	26.264	26.31	210802.0
2011-05-09	BAL	ETF	80.57	80.94	80.1	80.5	48657.0
2011-05-09	BALT	ETF	7.38	7.4491	7.15	7.2	110970.0
2011-05-09	BBH	ETF	34.6667	35.15	34.6233	34.9933	108600.0
2011-05-09	BIB	ETF	9.8287	9.9763	9.7012	9.9313	193040.0
2011-05-09	BICK	ETF	33.35	33.35	33.1601	33.338	16764.0
2011-05-09	BIL	ETF	91.72	91.74	91.72	91.74	808500.0
2011-05-09	BIS	ETF	6080.0	6080.0	5910.24	5910.24	5.0
2011-05-09	BITS	ETF	23.16	23.16	22.6	22.8	638.0
2011-05-09	BIV	ETF	83.87	83.98	83.75	83.91	76000.0
2011-05-09	BJK	ETF	34.46	34.49	34.26	34.46	4400.0
2011-05-09	BKF	ETF	48.07	48.46	47.82	48.345	93470.0
2011-05-09	BKLN	ETF	25.31	25.31	25.25	25.28	72000.0
2011-05-09	BLV	ETF	80.55	80.96	80.55	80.82	28000.0
2011-05-09	BMVP	ETF	15.813	15.951	15.793	15.917	5339.0
2011-05-09	BND	ETF	81.24	81.3	81.19	81.26	544300.0
2011-05-09	BNO	ETF	37.055	38.595	37.025	38.55	210000.0
2011-05-09	BOSS	ETF	60.82	62.11	60.82	61.72	300.0
2011-05-09	BRF	ETF	56.52	57.3	56.5	57.2	242222.0
2011-05-09	BSCE	ETF	21.12	21.15	21.1092	21.15	36956.0
2011-05-09	BSV	ETF	80.86	80.87	80.81	80.85	288000.0
2011-05-09	BTF	ETF	82.85	83.3	82.55	83.05	4055.4

> showing 50 of 854 rows — these rows as CSV

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