PREVIEW / etf_daily / 2011-09-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-06.parquet
  size:    36 KB
  rows:    869

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-09-06	SPY	ETF	114.39	117.16	114.38	116.99	285130500.0
2011-09-06	QQQ	ETF	52.04	53.366	51.91	53.29	52992174.0
2011-09-06	IWM	ETF	65.93	68.31	65.93	68.27	71493900.0
2011-09-06	DIA	ETF	109.4	111.46	109.18	111.21	10881100.0
2011-09-06	GLD	ETF	184.58	185.85	181.31	182.9	30254500.0
2011-09-06	TLT	ETF	114.42	114.93	113.39	113.68	14016200.0
2011-09-06	AADR	ETF	28.06	29.33	27.98	28.26	56900.0
2011-09-06	AAXJ	ETF	53.3	54.88	53.29	54.81	2229900.0
2011-09-06	ACTV	ETF	14.59	15.13	14.47	15.03	43414.0
2011-09-06	ACWI	ETF	40.86	41.63	40.7	41.61	494500.0
2011-09-06	ACWX	ETF	37.06	37.79	37.06	37.74	107599.0
2011-09-06	ADRE	ETF	39.7	40.72	39.7	40.68	73230.0
2011-09-06	AFK	ETF	28.75	29.09	28.5	29.09	17233.0
2011-09-06	AGEM	ETF	22.32	22.73	22.32	22.73	1770.0
2011-09-06	AGG	ETF	110.41	110.41	110.19	110.24	1104100.0
2011-09-06	AGQ	ETF	464.0	474.42	449.58	462.16	657450.0
2011-09-06	AGZ	ETF	112.81	112.94	112.35	112.5022	36305.0
2011-09-06	AIA	ETF	40.03	40.95	39.97	40.94	77114.0
2011-09-06	AIQ	ETF	6.6	6.6	6.25	6.45	32264.0
2011-09-06	AIS	ETF	2.22	2.3	2.22	2.29	859716.0
2011-09-06	AIVI	ETF	39.68	40.17	39.4	40.15	61400.0
2011-09-06	AMJ	ETF	34.49	34.75	34.021	34.59	554058.0
2011-09-06	AMLP	ETF	76.65	77.2	75.55	76.55	119360.0
2011-09-06	AOA	ETF	30.96	31.53	30.96	31.46	45900.0
2011-09-06	AOK	ETF	28.9	28.96	28.83	28.95	61970.0
2011-09-06	AOM	ETF	29.27	29.5	29.27	29.5	35705.0
2011-09-06	AOR	ETF	30.11	30.28	29.94	30.28	27929.0
2011-09-06	ARB	ETF	33.12	34.32	32.741	34.19	154940.0
2011-09-06	ARGT	ETF	24.0	24.1	23.88	24.02	1350.0
2011-09-06	ASEA	ETF	15.53	15.92	15.53	15.84	1600.0
2011-09-06	AWAY	ETF	39.15	40.4	39.15	40.04	83016.0
2011-09-06	BAB	ETF	28.22	28.49	28.22	28.35	167696.0
2011-09-06	BAL	ETF	65.15	66.24	65.06	66.0366	28355.0
2011-09-06	BALT	ETF	4.6	5.05	4.54	4.98	210084.0
2011-09-06	BBH	ETF	31.2733	32.2933	31.2733	32.28	128400.0
2011-09-06	BCM	ETF	47.86	48.03	47.86	48.03	600.0
2011-09-06	BIB	ETF	6.6125	7.2263	6.5438	7.22	131760.0
2011-09-06	BICK	ETF	25.53	26.17	25.53	26.15	44000.0
2011-09-06	BIL	ETF	91.7	91.72	91.68	91.7	8617200.0
2011-09-06	BIS	ETF	7553.6	7553.6	6969.6	6969.6	17.15
2011-09-06	BITS	ETF	21.48	22.08	21.24	22.0	825.0
2011-09-06	BIV	ETF	88.52	88.55	88.1	88.39	136400.0
2011-09-06	BJK	ETF	31.66	32.46	31.63	32.46	10200.0
2011-09-06	BKF	ETF	39.46	40.6	39.46	40.53	107063.0
2011-09-06	BKLN	ETF	23.4	23.4	23.15	23.15	38200.0
2011-09-06	BLV	ETF	90.59	90.79	89.97	90.13	58300.0
2011-09-06	BMVP	ETF	12.77	13.09	12.7	13.07	5583.0
2011-09-06	BND	ETF	83.93	83.96	83.78	83.89	1240900.0
2011-09-06	BNO	ETF	36.985	37.865	36.985	37.865	66000.0
2011-09-06	BRF	ETF	48.98	50.09	48.14	50.01	195809.0

> showing 50 of 869 rows — these rows as CSV

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