PREVIEW / etf_daily / 2011-08-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-26.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-08-26	SPY	ETF	115.69	118.51	113.85	117.97	314495900.0
2011-08-26	QQQ	ETF	51.68	53.31	51.15	53.13	91573238.0
2011-08-26	IWM	ETF	67.26	69.32	66.06	69.11	84468500.0
2011-08-26	DIA	ETF	110.72	113.07	109.09	112.7	13140300.0
2011-08-26	GLD	ETF	173.57	177.55	171.75	177.47	38673000.0
2011-08-26	TLT	ETF	108.69	109.27	107.33	108.49	11504800.0
2011-08-26	AAXJ	ETF	52.84	53.66	52.12	53.64	235800.0
2011-08-26	ACTV	ETF	15.99	16.34	15.4	16.16	33157.0
2011-08-26	ACWI	ETF	41.34	42.25	40.82	42.07	649700.0
2011-08-26	ACWX	ETF	37.84	38.58	37.44	38.46	130303.0
2011-08-26	ADRE	ETF	39.53	40.26	38.92	40.26	140588.0
2011-08-26	AFK	ETF	28.16	28.78	27.96	28.78	5763.0
2011-08-26	AGEM	ETF	21.91	22.36	21.91	22.34	1240.0
2011-08-26	AGG	ETF	109.52	109.58	109.19	109.38	674700.0
2011-08-26	AGQ	ETF	440.26	449.2	420.0	448.6	758450.0
2011-08-26	AGZ	ETF	112.23	112.44	112.19	112.4155	6366.0
2011-08-26	AIA	ETF	39.76	40.35	39.3	40.28	48017.0
2011-08-26	AIQ	ETF	6.8	7.15	6.65	7.15	35949.0
2011-08-26	AIS	ETF	2.3	2.38	2.23	2.34	860173.0
2011-08-26	AIVI	ETF	40.4	41.31	40.0	41.0	60600.0
2011-08-26	AMJ	ETF	33.82	34.4699	33.45	34.24	619141.0
2011-08-26	AMLP	ETF	74.75	76.35	74.5	76.05	105120.0
2011-08-26	AOA	ETF	31.27	31.99	30.94	31.86	12000.0
2011-08-26	AOK	ETF	28.77	28.895	28.6801	28.8401	27397.0
2011-08-26	AOM	ETF	29.29	29.525	29.17	29.49	21959.0
2011-08-26	AOR	ETF	30.04	30.44	30.04	30.36	16926.0
2011-08-26	ARB	ETF	33.03	34.94	32.48	34.89	176333.0
2011-08-26	ARGT	ETF	24.24	24.66	24.24	24.66	150.0
2011-08-26	ASEA	ETF	15.44	15.76	15.44	15.62	3000.0
2011-08-26	AWAY	ETF	36.9	38.89	36.84	37.26	52077.0
2011-08-26	BAB	ETF	27.61	27.67	27.5001	27.61	97078.0
2011-08-26	BAL	ETF	63.9196	65.01	63.44	64.65	30608.0
2011-08-26	BALT	ETF	4.4	4.54	4.39	4.44	113412.0
2011-08-26	BBH	ETF	32.17	32.2967	32.0933	32.1833	8400.0
2011-08-26	BIB	ETF	6.48	6.9325	6.42	6.9325	73200.0
2011-08-26	BICK	ETF	25.48	25.81	25.06	25.714	17135.0
2011-08-26	BIL	ETF	91.72	91.72	91.7	91.72	247950.0
2011-08-26	BITS	ETF	22.04	22.8	22.0	22.104	2730.0
2011-08-26	BIV	ETF	87.79	87.79	87.26	87.57	110600.0
2011-08-26	BJK	ETF	30.84	31.48	30.84	31.47	6900.0
2011-08-26	BKF	ETF	39.25	39.92	38.55	39.91	120642.0
2011-08-26	BKLN	ETF	22.75	22.89	22.73	22.8	67400.0
2011-08-26	BLV	ETF	87.17	87.45	86.56	87.03	92600.0
2011-08-26	BMVP	ETF	12.82	13.24	12.717	13.238	2886.0
2011-08-26	BND	ETF	83.47	83.54	83.22	83.4	971100.0
2011-08-26	BNO	ETF	36.82	37.32	36.615	37.125	109200.0
2011-08-26	BRF	ETF	47.02	47.8	46.47	47.61	94819.0
2011-08-26	BSCE	ETF	20.87	21.09	20.87	21.0	16679.0
2011-08-26	BSV	ETF	81.79	81.79	81.68	81.68	323500.0
2011-08-26	BTF	ETF	69.05	70.94999999999999	69.0	70.1	3232.0

> showing 50 of 860 rows — these rows as CSV

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