PREVIEW / etf_daily / 2011-03-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-07.parquet
  size:    35 KB
  rows:    835

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-07	SPY	ETF	132.86	133.16	130.74	131.43	216790400.0
2011-03-07	QQQ	ETF	58.21	58.2599	56.67	57.19	98469959.0
2011-03-07	IWM	ETF	82.76	82.82	80.41	81.09	90777900.0
2011-03-07	DIA	ETF	121.77	122.26	120.21	120.71	8355500.0
2011-03-07	GLD	ETF	140.29	140.61	139.28	139.72	14068900.0
2011-03-07	TLT	ETF	90.02	90.86	89.85	90.23	7522300.0
2011-03-07	AADR	ETF	30.91	30.91	30.91	30.91	200.0
2011-03-07	AAXJ	ETF	61.88	61.88	60.77	60.86	451200.0
2011-03-07	ACWI	ETF	49.04	49.04	48.05	48.2	484300.0
2011-03-07	ACWX	ETF	46.05	46.05	45.14	45.24	46203.0
2011-03-07	ADRE	ETF	47.58	47.79	46.86	47.01	92365.0
2011-03-07	AFK	ETF	33.2	33.6	32.71	32.7401	16284.0
2011-03-07	AGG	ETF	104.94	105.22	104.81	105.07	621200.0
2011-03-07	AGQ	ETF	428.32	433.26	413.88	420.54	1319550.0
2011-03-07	AGZ	ETF	108.77	109.275	108.77	109.21	10425.0
2011-03-07	AIA	ETF	46.26	46.5	45.86	45.9648	37287.0
2011-03-07	AIQ	ETF	20.3	20.45	19.5	20.2	33900.0
2011-03-07	AIS	ETF	1.6	1.6	1.54	1.54	302823.0
2011-03-07	AIVI	ETF	46.89	46.93	46.12	46.19	5900.0
2011-03-07	AMJ	ETF	38.26	38.29	37.68	37.88	563560.0
2011-03-07	AMLP	ETF	82.5	82.55	81.8	82.05	204460.0
2011-03-07	AOA	ETF	36.05	36.05	35.32	35.51	29600.0
2011-03-07	AOK	ETF	29.41	29.41	29.0501	29.11	38444.0
2011-03-07	AOM	ETF	30.84	30.84	30.4199	30.46	24742.0
2011-03-07	AOR	ETF	32.81	32.81	32.24	32.33	12818.0
2011-03-07	ARB	ETF	40.26	41.73	40.09	40.12	647718.0
2011-03-07	ARGT	ETF	30.12	30.4	30.12	30.36	11150.0
2011-03-07	ASEA	ETF	15.53	15.58	15.23	15.25	4700.0
2011-03-07	BAB	ETF	25.28	25.28	25.0	25.05	205195.0
2011-03-07	BAL	ETF	115.01	117.33	110.01	110.54	201550.0
2011-03-07	BALT	ETF	9.27	9.27	8.81	9.07	119404.0
2011-03-07	BBH	ETF	34.6333	34.73	34.2667	34.43	39300.0
2011-03-07	BIB	ETF	7.6363	7.8113	7.6363	7.8113	11400.0
2011-03-07	BICK	ETF	31.84	31.84	31.34	31.59	68718.0
2011-03-07	BIL	ETF	91.72	91.72	91.7	91.7	95850.0
2011-03-07	BIS	ETF	7761.6	7780.8	7699.2	7699.2	38.75
2011-03-07	BITS	ETF	25.96	26.36	25.6	25.8	2075.0
2011-03-07	BIV	ETF	82.08	82.38	81.92	82.16	66600.0
2011-03-07	BJK	ETF	31.88	31.88	31.09	31.22	9100.0
2011-03-07	BKF	ETF	48.91	49.16	48.16	48.38	112492.0
2011-03-07	BKLN	ETF	25.23	25.23	25.01	25.06	58100.0
2011-03-07	BLV	ETF	77.46	77.89	77.34	77.57	18000.0
2011-03-07	BMVP	ETF	15.4533	15.6448	15.3067	15.41	5869.0
2011-03-07	BND	ETF	79.81	80.02	79.78	79.88	443900.0
2011-03-07	BNO	ETF	39.0	39.0	38.08	38.08	232200.0
2011-03-07	BOSS	ETF	46.99	48.27	46.99	48.27	200.0
2011-03-07	BRF	ETF	53.08	53.49	51.8319	52.04	253695.0
2011-03-07	BSCE	ETF	22.27	22.27	20.8732	20.94	14542.0
2011-03-07	BSV	ETF	80.27	80.36	80.22	80.29	316200.0
2011-03-07	BTF	ETF	84.45	84.94999999999999	83.94999999999999	84.04999999999998	2001.4

> showing 50 of 835 rows — these rows as CSV

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