PREVIEW / etf_daily / 2011-04-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-26.parquet
  size:    36 KB
  rows:    850

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-04-26	SPY	ETF	134.05	135.06	133.91	134.79	146600000.0
2011-04-26	QQQ	ETF	58.65	59.03	58.51	58.82	49392732.0
2011-04-26	IWM	ETF	84.53	85.67	84.35	85.18	53200000.0
2011-04-26	DIA	ETF	124.79	125.88	124.65	125.7	6200000.0
2011-04-26	GLD	ETF	146.47	146.62	145.48	146.38	16200000.0
2011-04-26	TLT	ETF	93.27	93.87	93.18	93.85	7506300.0
2011-04-26	AADR	ETF	31.53	31.53	31.53	31.53	400.0
2011-04-26	AAXJ	ETF	64.6	64.85	64.38	64.69	201000.0
2011-04-26	ACWI	ETF	49.55	49.91	49.45	49.86	787300.0
2011-04-26	ACWX	ETF	46.74	46.98	46.6	46.98	47309.0
2011-04-26	ADRE	ETF	48.54	48.85	48.42	48.76	49998.0
2011-04-26	AFK	ETF	33.5701	34.09	33.5701	33.9646	1566.0
2011-04-26	AGG	ETF	105.91	106.21	105.91	106.21	569700.0
2011-04-26	AGQ	ETF	656.26	656.98	623.6	636.88	1850000.0
2011-04-26	AGZ	ETF	109.8	109.83	109.7	109.75	37437.0
2011-04-26	AIA	ETF	48.97	49.33	48.85	49.15	30843.0
2011-04-26	AIQ	ETF	23.0	23.5	22.95	23.1	42792.0
2011-04-26	AIS	ETF	1.64	1.69	1.62	1.68	392235.0
2011-04-26	AIVI	ETF	48.87	49.35	48.87	49.29	16800.0
2011-04-26	AMJ	ETF	38.61	38.95	38.61	38.85	624224.0
2011-04-26	AMLP	ETF	83.35	83.35	83.1	83.35	131960.0
2011-04-26	AOA	ETF	36.53	36.76	36.5	36.72	8000.0
2011-04-26	AOK	ETF	29.4299	29.51	29.4299	29.47	36613.0
2011-04-26	AOM	ETF	30.89	30.98	30.88	30.94	71741.0
2011-04-26	AOR	ETF	32.94	33.15	32.94	33.129	45571.0
2011-04-26	ARB	ETF	36.42	37.62	35.81	36.87	239723.0
2011-04-26	ARGT	ETF	30.08	30.12	30.02	30.06	1600.0
2011-04-26	ASEA	ETF	16.57	16.57	16.54	16.54	1700.0
2011-04-26	BAB	ETF	25.68	25.84	25.68	25.84	147256.0
2011-04-26	BAL	ETF	90.92	91.028	87.452	88.0	295213.0
2011-04-26	BALT	ETF	8.09	8.29	8.09	8.18	157201.0
2011-04-26	BBH	ETF	34.17	34.7467	34.07	34.63	136800.0
2011-04-26	BCM	ETF	50.24	50.32	50.11	50.312	5100.0
2011-04-26	BIB	ETF	9.4825	9.6687	9.3451	9.5762	49952.0
2011-04-26	BICK	ETF	35.2	35.29	35.03	35.1917	39954.0
2011-04-26	BIL	ETF	91.72	91.72	91.7	91.7	41450.0
2011-04-26	BIS	ETF	6304.0	6304.0	6296.0	6296.0	5.0
2011-04-26	BITS	ETF	24.84	25.2	24.6	24.68	2459.0
2011-04-26	BIV	ETF	82.9	83.13	82.84	83.13	131500.0
2011-04-26	BJK	ETF	34.85	34.94	34.85	34.87	5000.0
2011-04-26	BKF	ETF	51.2	51.395	50.91	51.13	141377.0
2011-04-26	BKLN	ETF	25.27	25.28	25.22	25.26	117500.0
2011-04-26	BLNG	ETF	50.37	50.37	50.11	50.2	6300.0
2011-04-26	BLV	ETF	79.32	79.9	79.32	79.9	22300.0
2011-04-26	BMVP	ETF	15.9	16.0514	15.8933	16.0133	13843.0
2011-04-26	BND	ETF	80.58	80.75	80.56	80.74	538200.0
2011-04-26	BNO	ETF	41.19	41.26	41.025	41.19	46600.0
2011-04-26	BRF	ETF	59.6	60.1	59.45	59.45	288160.0
2011-04-26	BSCE	ETF	21.01	21.07	21.01	21.05	12827.0
2011-04-26	BSV	ETF	80.57	80.6	80.53	80.59	350600.0

> showing 50 of 850 rows — these rows as CSV

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