PREVIEW / etf_daily / 2011-07-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-22.parquet
  size:    36 KB
  rows:    866

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-07-22	SPY	ETF	134.52	134.72	133.76	134.58	126019400.0
2011-07-22	QQQ	ETF	58.97	59.7	58.92	59.6	43620359.0
2011-07-22	IWM	ETF	83.85	84.26	83.4	84.05	34540200.0
2011-07-22	DIA	ETF	126.88	127.02	126.22	126.6	5848500.0
2011-07-22	GLD	ETF	156.0	156.56	155.68	156.12	11378700.0
2011-07-22	TLT	ETF	95.69	96.09	95.53	96.05	4974500.0
2011-07-22	AADR	ETF	31.34	31.5	31.34	31.5	800.0
2011-07-22	AAXJ	ETF	62.8	62.97	62.52	62.85	203700.0
2011-07-22	ACTV	ETF	18.18	18.18	17.8	18.11	48954.0
2011-07-22	ACWI	ETF	48.78	48.81	48.4	48.76	720300.0
2011-07-22	ACWX	ETF	44.99	45.047	44.6628	45.04	33010.0
2011-07-22	ADRE	ETF	46.2	46.45	46.051	46.37	59074.0
2011-07-22	AFK	ETF	32.15	32.16	31.91	32.0	75937.0
2011-07-22	AGEM	ETF	25.92	26.252	25.92	26.08	8418.0
2011-07-22	AGG	ETF	107.41	107.57	107.39	107.55	458000.0
2011-07-22	AGQ	ETF	426.0	435.08	424.58	430.74	792250.0
2011-07-22	AGZ	ETF	110.78	110.943	110.78	110.83	8062.0
2011-07-22	AIA	ETF	47.1	47.229	46.94	47.135	18519.0
2011-07-22	AIQ	ETF	17.55	17.6	17.3	17.5	4977.0
2011-07-22	AIS	ETF	2.55	2.65	2.5	2.57	3089319.0
2011-07-22	AIVI	ETF	46.54	46.69	46.37	46.58	15800.0
2011-07-22	AMJ	ETF	37.17	37.47	37.17	37.38	743404.0
2011-07-22	AMLP	ETF	80.4	80.6	80.35	80.5	81280.0
2011-07-22	AOA	ETF	36.33	36.37	36.3	36.35	4500.0
2011-07-22	AOK	ETF	29.55	29.57	29.5	29.57	10836.0
2011-07-22	AOM	ETF	30.82	30.93	30.82	30.93	6452.0
2011-07-22	AOR	ETF	32.97	32.99	32.864	32.96	15264.0
2011-07-22	ARB	ETF	42.56	43.14	42.38	42.46	237740.0
2011-07-22	ARGT	ETF	29.82	30.1	29.82	30.06	1250.0
2011-07-22	ASEA	ETF	17.24	17.27	17.17	17.2	13700.0
2011-07-22	AWAY	ETF	41.09	41.17	40.5	40.7	115790.0
2011-07-22	BAB	ETF	26.6	26.719	26.57	26.69	177230.0
2011-07-22	BAL	ETF	60.98	61.4	59.8908	61.24	51401.0
2011-07-22	BALT	ETF	5.43	5.47	5.15	5.18	169578.0
2011-07-22	BBH	ETF	35.4567	35.4733	35.2533	35.3967	26400.0
2011-07-22	BCM	ETF	48.37	48.552	48.37	48.5	3728.0
2011-07-22	BIB	ETF	9.9087	10.08	9.9	10.0375	111944.0
2011-07-22	BICK	ETF	31.88	32.09	31.88	31.9943	7708.0
2011-07-22	BIL	ETF	91.7	91.72	91.7	91.72	162550.0
2011-07-22	BIS	ETF	5718.4	5736.0	5668.8	5681.472	12.9
2011-07-22	BITS	ETF	21.76	22.248	21.2	22.12	3179.0
2011-07-22	BIV	ETF	84.98	85.07	84.83	85.06	145100.0
2011-07-22	BJK	ETF	36.35	36.82	36.35	36.74	38600.0
2011-07-22	BKF	ETF	47.26	47.53	47.15	47.43	81137.0
2011-07-22	BKLN	ETF	24.85	24.85	24.77	24.83	32400.0
2011-07-22	BLNG	ETF	51.42	51.42	51.41	51.41	9278.0
2011-07-22	BLV	ETF	81.3	81.5	81.12	81.39	10300.0
2011-07-22	BMVP	ETF	15.84	15.89	15.76	15.84	8996.0
2011-07-22	BND	ETF	81.71	81.84	81.69	81.84	926000.0
2011-07-22	BNO	ETF	39.4	39.695	39.315	39.655	104600.0

> showing 50 of 866 rows — these rows as CSV

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