PREVIEW / etf_daily / 2011-09-09

all etf daily files

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

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-09	SPY	ETF	117.68	119.06	115.28	115.92	380195100.0
2011-09-09	QQQ	ETF	54.01	54.2399	52.85	53.18	63663481.0
2011-09-09	IWM	ETF	68.7	69.13	66.75	67.5	99453600.0
2011-09-09	DIA	ETF	111.64	111.7	109.22	109.82	11877700.0
2011-09-09	GLD	ETF	179.76	181.95	179.17	180.7	25429600.0
2011-09-09	TLT	ETF	112.54	114.18	112.21	113.71	11492700.0
2011-09-09	AADR	ETF	28.34	28.52	28.17	28.17	8800.0
2011-09-09	AAXJ	ETF	54.31	54.35	53.17	53.41	368600.0
2011-09-09	ACTV	ETF	15.19	15.19	14.23	14.4	66843.0
2011-09-09	ACWI	ETF	41.6	41.6	40.69	40.9	502200.0
2011-09-09	ACWX	ETF	37.55	37.55	36.69	36.88	93065.0
2011-09-09	ADRE	ETF	40.56	40.72	39.91	39.98	58231.0
2011-09-09	AFK	ETF	29.4	29.4	28.92	28.93	10415.0
2011-09-09	AGEM	ETF	22.81	22.81	22.18	22.24	2587.0
2011-09-09	AGG	ETF	110.06	110.27	109.98	110.16	809700.0
2011-09-09	AGQ	ETF	450.24	465.44	440.02	450.16	478050.0
2011-09-09	AGZ	ETF	112.568	112.94	112.56	112.76	7231.0
2011-09-09	AIA	ETF	40.97	40.97	39.9672	40.03	104368.0
2011-09-09	AIQ	ETF	6.35	6.5	6.25	6.3	23200.0
2011-09-09	AIS	ETF	2.3	2.32	2.24	2.24	656389.0
2011-09-09	AIVI	ETF	39.78	39.84	38.83	39.02	75100.0
2011-09-09	AMJ	ETF	34.98	35.15	34.67	34.84	781800.0
2011-09-09	AMLP	ETF	77.35	77.45	76.9	77.1	139940.0
2011-09-09	AOA	ETF	31.63	31.79	31.1	31.31	10800.0
2011-09-09	AOK	ETF	28.97	29.001	28.868	28.9	12823.0
2011-09-09	AOM	ETF	29.55	29.55	29.32	29.38	25648.0
2011-09-09	AOR	ETF	30.31	30.4	29.998	30.091	39055.0
2011-09-09	ARB	ETF	34.61	34.88	33.05	33.54	168293.0
2011-09-09	ARGT	ETF	23.78	23.82	23.38	23.48	4650.0
2011-09-09	ASEA	ETF	15.85	15.85	15.49	15.57	23300.0
2011-09-09	AWAY	ETF	41.39	41.94	40.16	40.46	94668.0
2011-09-09	BAB	ETF	28.08	28.4	28.08	28.33	122640.0
2011-09-09	BAL	ETF	69.56	69.83	68.52	69.26	203101.0
2011-09-09	BALT	ETF	5.01	5.14	4.95	5.03	227127.0
2011-09-09	BBH	ETF	32.1767	32.1767	31.7567	31.7933	26400.0
2011-09-09	BCM	ETF	47.7	47.79	47.61	47.65	5660.0
2011-09-09	BIB	ETF	7.5	7.5	7.0762	7.1813	53600.0
2011-09-09	BICK	ETF	26.02	26.05	25.5	25.54	3425.0
2011-09-09	BIL	ETF	91.68	91.72	91.68	91.7	731050.0
2011-09-09	BIS	ETF	7018.528	7018.528	6948.8	6948.8	2.81
2011-09-09	BITS	ETF	21.36	21.6	20.12	20.56	4890.0
2011-09-09	BIV	ETF	88.21	88.68	88.21	88.52	109800.0
2011-09-09	BJK	ETF	32.45	32.52	31.73	31.89	21000.0
2011-09-09	BKF	ETF	40.31	40.38	39.17	39.32	392658.0
2011-09-09	BKLN	ETF	23.37	23.39	23.25	23.34	23500.0
2011-09-09	BLNG	ETF	58.34	58.52	57.99	58.1599	2025.0
2011-09-09	BLV	ETF	89.41	90.0	89.07	89.75	35700.0
2011-09-09	BMVP	ETF	13.2667	13.2667	12.9167	12.9452	2351.0
2011-09-09	BND	ETF	83.77	84.0	83.75	83.88	909700.0
2011-09-09	BNO	ETF	37.45	37.53	37.115	37.34	172400.0

> showing 50 of 870 rows — these rows as CSV

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