PREVIEW / etf_daily / 2011-07-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-06.parquet
  size:    36 KB
  rows:    860

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-06	SPY	ETF	133.49	134.14	133.11	133.97	143331600.0
2011-07-06	QQQ	ETF	58.14	58.49	57.94	58.39	49282636.0
2011-07-06	IWM	ETF	83.91	84.51	83.61	84.38	57094100.0
2011-07-06	DIA	ETF	125.38	126.26	125.23	126.09	9795100.0
2011-07-06	GLD	ETF	148.7	149.44	148.58	148.91	14502500.0
2011-07-06	TLT	ETF	94.19	94.45	93.84	94.32	5652700.0
2011-07-06	AADR	ETF	31.71	31.81	31.71	31.75	6200.0
2011-07-06	AAXJ	ETF	62.55	62.59	62.18	62.54	349800.0
2011-07-06	ACTV	ETF	18.48	19.05	18.41	18.84	398126.0
2011-07-06	ACWI	ETF	48.59	48.7	48.28	48.61	281700.0
2011-07-06	ACWX	ETF	44.86	45.03	44.7	44.99	341257.0
2011-07-06	ADRE	ETF	46.77	46.84	46.5	46.7	110717.0
2011-07-06	AFK	ETF	32.38	32.55	32.28	32.426	25197.0
2011-07-06	AGEM	ETF	26.49	26.5059	26.42	26.4602	2597.0
2011-07-06	AGG	ETF	106.79	106.93	106.76	106.87	774600.0
2011-07-06	AGQ	ETF	348.66	359.0	347.42	353.92	746750.0
2011-07-06	AGZ	ETF	110.6	110.6775	110.5	110.5	5440.0
2011-07-06	AIA	ETF	47.22	47.22	46.9635	47.147	31367.0
2011-07-06	AIQ	ETF	18.2	18.6	18.15	18.5	6468.0
2011-07-06	AIS	ETF	2.28	2.31	2.25	2.3	836678.0
2011-07-06	AIVI	ETF	46.51	46.7	46.36	46.56	15000.0
2011-07-06	AMJ	ETF	37.32	37.4	37.18	37.389	773128.0
2011-07-06	AMLP	ETF	80.5	80.6	80.2	80.55	92200.0
2011-07-06	AOA	ETF	36.25	36.39	36.2	36.32	15400.0
2011-07-06	AOK	ETF	29.37	29.44	29.37	29.4254	12136.0
2011-07-06	AOM	ETF	30.7156	30.78	30.7156	30.78	4936.0
2011-07-06	AOR	ETF	32.8	32.88	32.764	32.862	16390.0
2011-07-06	ARB	ETF	41.26	41.57	41.0	41.52	100771.0
2011-07-06	ARGT	ETF	30.44	30.6	30.28	30.5	9150.0
2011-07-06	ASEA	ETF	16.66	16.73	16.59	16.59	803600.0
2011-07-06	AWAY	ETF	37.5	39.61	37.5	38.99	355654.0
2011-07-06	BAB	ETF	26.16	26.2	26.091	26.11	374620.0
2011-07-06	BAL	ETF	72.32	72.4	69.989	70.22	62058.0
2011-07-06	BALT	ETF	5.5	5.7	5.45	5.53	190200.0
2011-07-06	BBH	ETF	35.6633	35.9167	35.6633	35.9133	34500.0
2011-07-06	BCM	ETF	46.27	46.62	46.27	46.46	2500.0
2011-07-06	BIB	ETF	10.02	10.0625	9.8825	9.9825	430152.0
2011-07-06	BICK	ETF	32.46	32.46	32.15	32.36	26726.0
2011-07-06	BIL	ETF	91.7	91.72	91.7	91.72	222350.0
2011-07-06	BIS	ETF	5912.0	5912.0	5756.8	5779.2	21.8
2011-07-06	BITS	ETF	20.88	21.44	20.64	21.2	18376.0
2011-07-06	BIV	ETF	84.25	84.3	84.08	84.17	135900.0
2011-07-06	BJK	ETF	35.1	35.37	35.03	35.24	31000.0
2011-07-06	BKF	ETF	48.04	48.06	47.684	47.93	167147.0
2011-07-06	BKLN	ETF	24.92	24.93	24.86	24.93	33800.0
2011-07-06	BLV	ETF	80.04	80.17	79.8	80.08	32400.0
2011-07-06	BMVP	ETF	15.9233	16.0433	15.9233	16.0169	8955.0
2011-07-06	BND	ETF	81.26	81.37	81.21	81.3	1144400.0
2011-07-06	BNO	ETF	37.705	37.95	37.405	37.855	35600.0
2011-07-06	BRF	ETF	56.78	57.1	55.94	55.94	872625.0

> showing 50 of 860 rows — these rows as CSV

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