PREVIEW / etf_daily / 2011-07-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-08.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-08	SPY	ETF	133.83	135.36	133.39	134.4	194100500.0
2011-07-08	QQQ	ETF	58.7	59.04	58.37	59.03	69533593.0
2011-07-08	IWM	ETF	84.62	85.21	84.32	85.13	61977400.0
2011-07-08	DIA	ETF	126.03	126.42	125.5	126.39	5987200.0
2011-07-08	GLD	ETF	150.32	150.5	149.99	150.25	13662300.0
2011-07-08	TLT	ETF	94.84	95.61	94.83	95.37	12129300.0
2011-07-08	AADR	ETF	31.7	31.73	31.7	31.73	600.0
2011-07-08	AAXJ	ETF	62.78	62.85	62.31	62.83	335300.0
2011-07-08	ACTV	ETF	18.81	19.26	18.75	18.89	124057.0
2011-07-08	ACWI	ETF	48.53	48.68	48.27	48.62	409400.0
2011-07-08	ACWX	ETF	44.91	45.06	44.65	44.91	60184.0
2011-07-08	ADRE	ETF	46.69	46.69	46.33	46.62	41619.0
2011-07-08	AFK	ETF	32.49	32.59	32.2	32.2	119510.0
2011-07-08	AGEM	ETF	26.5	26.5	26.25	26.37	2666.0
2011-07-08	AGG	ETF	106.98	107.2	106.93	107.12	682800.0
2011-07-08	AGQ	ETF	369.08	370.0	357.56	367.0	674700.0
2011-07-08	AGZ	ETF	110.61	110.82	110.51	110.69	9974.0
2011-07-08	AIA	ETF	47.24	47.24	46.92	47.18	35785.0
2011-07-08	AIQ	ETF	18.55	18.9	18.55	18.7	10679.0
2011-07-08	AIS	ETF	2.38	2.41	2.33	2.39	940139.0
2011-07-08	AIVI	ETF	46.53	46.53	46.21	46.46	17800.0
2011-07-08	AMJ	ETF	37.41	37.59	37.3916	37.56	693103.0
2011-07-08	AMLP	ETF	80.45	80.75	80.0	80.75	62000.0
2011-07-08	AOA	ETF	36.34	36.46	36.19	36.46	12100.0
2011-07-08	AOK	ETF	29.48	29.5	29.405	29.5	6430.0
2011-07-08	AOM	ETF	30.79	30.8328	30.75	30.8328	4088.0
2011-07-08	AOR	ETF	32.91	32.95	32.804	32.93	50894.0
2011-07-08	ARB	ETF	42.0	42.49	41.53	41.84	71152.0
2011-07-08	ARGT	ETF	30.34	30.38	30.22	30.22	400.0
2011-07-08	ASEA	ETF	16.86	16.92	16.8	16.88	17100.0
2011-07-08	AWAY	ETF	41.24	42.64	40.82	42.12	419626.0
2011-07-08	BAB	ETF	26.3	26.464	26.283	26.4	259765.0
2011-07-08	BAL	ETF	71.55	71.91	70.38	70.734	46748.0
2011-07-08	BALT	ETF	5.5	5.54	5.38	5.44	320136.0
2011-07-08	BBH	ETF	35.7767	35.9933	35.7067	35.86	24600.0
2011-07-08	BCM	ETF	47.4	47.47	47.05	47.29	20905.0
2011-07-08	BIB	ETF	10.0862	10.1687	9.9425	10.1687	342664.0
2011-07-08	BICK	ETF	32.23	32.38	32.17	32.38	4038.0
2011-07-08	BIL	ETF	91.7	91.72	91.7	91.7	70650.0
2011-07-08	BIS	ETF	5830.4	5830.4	5676.8	5676.8	12.4
2011-07-08	BITS	ETF	21.2	22.0	21.2	21.6	720.0
2011-07-08	BIV	ETF	84.5	84.71	84.38	84.64	97800.0
2011-07-08	BJK	ETF	35.64	35.97	35.42	35.96	39400.0
2011-07-08	BKF	ETF	47.87	48.0428	47.5458	47.82	76426.0
2011-07-08	BKLN	ETF	24.86	24.94	24.86	24.9	86200.0
2011-07-08	BLNG	ETF	49.09	49.09	49.09	49.09	385.0
2011-07-08	BLV	ETF	80.57	81.01	80.57	80.88	56200.0
2011-07-08	BMVP	ETF	16.0	16.11	15.95	16.11	9019.0
2011-07-08	BND	ETF	81.44	81.63	81.42	81.55	1066800.0
2011-07-08	BNO	ETF	39.3	39.44	38.95	39.335	239400.0

> showing 50 of 866 rows — these rows as CSV

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