PREVIEW / etf_daily / 2011-07-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-21.parquet
  size:    36 KB
  rows:    862

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-21	SPY	ETF	133.4	134.82	132.67	134.49	245246300.0
2011-07-21	QQQ	ETF	58.65	59.32	58.34	58.99	70148759.0
2011-07-21	IWM	ETF	83.44	84.3	83.24	83.94	63405500.0
2011-07-21	DIA	ETF	126.03	127.3	125.73	127.03	6881400.0
2011-07-21	GLD	ETF	155.91	156.04	154.33	154.83	18422800.0
2011-07-21	TLT	ETF	95.24	95.86	94.9	95.33	11099200.0
2011-07-21	AADR	ETF	31.13	31.27	31.13	31.22	1400.0
2011-07-21	AAXJ	ETF	62.0	62.78	61.96	62.65	484400.0
2011-07-21	ACTV	ETF	18.17	18.29	17.91	18.14	41793.0
2011-07-21	ACWI	ETF	48.32	48.78	48.13	48.67	991600.0
2011-07-21	ACWX	ETF	44.38	45.0	44.38	44.95	139847.0
2011-07-21	ADRE	ETF	45.95	46.27	45.75	46.17	59904.0
2011-07-21	AFK	ETF	31.77	32.08	31.77	32.0	35756.0
2011-07-21	AGEM	ETF	26.01	26.1	26.0	26.07	1193.0
2011-07-21	AGG	ETF	107.36	107.47	107.17	107.32	839200.0
2011-07-21	AGQ	ETF	428.24	430.2	404.68	414.76	985250.0
2011-07-21	AGZ	ETF	110.84	110.87	110.6765	110.7	8877.0
2011-07-21	AIA	ETF	46.57	47.09	46.52	47.09	22436.0
2011-07-21	AIQ	ETF	17.35	17.95	17.35	17.5	18653.0
2011-07-21	AIS	ETF	2.37	2.52	2.31	2.52	2313366.0
2011-07-21	AIVI	ETF	45.91	46.52	45.87	46.46	16200.0
2011-07-21	AMJ	ETF	37.5	37.55	37.27	37.29	461233.0
2011-07-21	AMLP	ETF	80.55	80.55	80.3	80.35	104360.0
2011-07-21	AOA	ETF	36.1	36.36	36.1	36.3	6800.0
2011-07-21	AOK	ETF	29.49	29.53	29.48	29.5124	30106.0
2011-07-21	AOM	ETF	30.8	30.89	30.77	30.879	11318.0
2011-07-21	AOR	ETF	32.75	32.9436	32.75	32.91	19007.0
2011-07-21	ARB	ETF	41.73	44.61	40.9	42.44	417072.0
2011-07-21	ARGT	ETF	29.96	29.96	29.82	29.9	1900.0
2011-07-21	ASEA	ETF	17.13	17.27	17.03	17.27	20900.0
2011-07-21	AWAY	ETF	40.72	41.41	40.57	41.01	73872.0
2011-07-21	BAB	ETF	26.43	26.56	26.4	26.51	111853.0
2011-07-21	BAL	ETF	61.39	61.86	61.0	61.29	78162.0
2011-07-21	BALT	ETF	5.24	5.47	5.205	5.45	127818.0
2011-07-21	BBH	ETF	34.9967	35.4933	34.9967	35.4467	25200.0
2011-07-21	BCM	ETF	48.47	48.53	48.4	48.42	6592.0
2011-07-21	BIB	ETF	9.7063	10.005	9.7063	9.9288	124400.0
2011-07-21	BICK	ETF	31.56	31.91	31.56	31.8872	14454.0
2011-07-21	BIL	ETF	91.72	91.72	91.7	91.7	790450.0
2011-07-21	BITS	ETF	22.44	22.52	21.72	22.08	150.0
2011-07-21	BIV	ETF	84.88	84.96	84.61	84.84	198600.0
2011-07-21	BJK	ETF	35.9	36.48	35.85	36.36	68700.0
2011-07-21	BKF	ETF	46.66	47.2471	46.637	47.16	64410.0
2011-07-21	BKLN	ETF	24.81	24.83	24.8	24.82	56600.0
2011-07-21	BLNG	ETF	51.31	51.31	51.3099	51.3099	620.0
2011-07-21	BLV	ETF	80.85	81.09	80.64	81.07	33500.0
2011-07-21	BMVP	ETF	15.69	15.863	15.69	15.835	5761.0
2011-07-21	BND	ETF	81.71	81.75	81.51	81.62	656800.0
2011-07-21	BNO	ETF	39.54	39.825	39.215	39.42	134800.0
2011-07-21	BOSS	ETF	73.03	73.97	73.03	73.97	100.0

> showing 50 of 862 rows — these rows as CSV

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