PREVIEW / etf_daily / 2010-09-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-22.parquet
  size:    34 KB
  rows:    791

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
2010-09-22	SPY	ETF	113.8	114.44	113.1	113.42	191322400.0
2010-09-22	QQQ	ETF	48.61	49.021	48.42	48.69	88315896.0
2010-09-22	IWM	ETF	66.45	66.9	65.33	65.84	65225800.0
2010-09-22	DIA	ETF	107.56	108.04	107.08	107.4	5593500.0
2010-09-22	GLD	ETF	126.58	126.63	125.7	126.2	11046900.0
2010-09-22	TLT	ETF	104.55	105.07	103.85	104.61	8229400.0
2010-09-22	AADR	ETF	27.63	27.71	27.53	27.58	30700.0
2010-09-22	AAXJ	ETF	59.17	59.47	59.0	59.17	189400.0
2010-09-22	ACWI	ETF	42.92	43.04	42.55	42.7	755000.0
2010-09-22	ACWX	ETF	41.0	41.19	40.71	40.83	45103.0
2010-09-22	ADRE	ETF	43.64	43.91	43.442	43.52	53726.0
2010-09-22	AFK	ETF	31.83	31.93	31.531	31.78	13476.0
2010-09-22	AGG	ETF	108.47	108.62	108.36	108.42	652900.0
2010-09-22	AGQ	ETF	157.3	157.84	154.46	157.78	245050.0
2010-09-22	AGZ	ETF	111.41	111.41	111.2148	111.3	34619.0
2010-09-22	AIA	ETF	41.57	41.8	41.57	41.696	14689.0
2010-09-22	AIQ	ETF	22.15	22.7	22.0	22.6	17113.0
2010-09-22	AIS	ETF	1.44	1.45	1.32	1.38	1369418.0
2010-09-22	AIVI	ETF	42.84	42.97	42.54	42.66	8000.0
2010-09-22	AMJ	ETF	33.14	33.38	33.14	33.3	729007.0
2010-09-22	AMLP	ETF	76.45	76.75	76.4	76.65	107500.0
2010-09-22	AOA	ETF	31.33	31.36	31.07	31.17	6100.0
2010-09-22	AOK	ETF	28.4	28.41	28.31	28.3395	7000.0
2010-09-22	AOM	ETF	29.16	29.16	29.049	29.06	10615.0
2010-09-22	AOR	ETF	29.95	30.0188	29.8364	29.837	2419.0
2010-09-22	ARB	ETF	27.48	27.77	26.6	26.73	199527.0
2010-09-22	BAB	ETF	26.7	26.73	26.5601	26.61	185653.0
2010-09-22	BAL	ETF	50.1	50.49	48.74	48.86	49554.0
2010-09-22	BALT	ETF	11.17	11.41	11.05	11.14	251035.0
2010-09-22	BBH	ETF	32.08	32.5533	32.08	32.2267	17100.0
2010-09-22	BIB	ETF	6.4275	6.4275	6.385	6.385	6400.0
2010-09-22	BICK	ETF	31.06	31.28	30.93	31.26	42622.0
2010-09-22	BIL	ETF	91.72	91.72	91.7	91.7	521300.0
2010-09-22	BITS	ETF	26.64	27.0	25.48	26.48	7358.0
2010-09-22	BIV	ETF	86.44	86.54	86.24	86.31	163100.0
2010-09-22	BJK	ETF	27.78	27.78	27.48	27.63	9500.0
2010-09-22	BKF	ETF	46.74	47.02	46.41	46.55	550880.0
2010-09-22	BLV	ETF	85.41	85.51	84.97	85.27	53000.0
2010-09-22	BMVP	ETF	12.9	12.96	12.8	12.83	17505.0
2010-09-22	BND	ETF	82.45	82.57	82.39	82.43	497700.0
2010-09-22	BNE	ETF	11.09	11.09	10.92	10.97	401786.0
2010-09-22	BRF	ETF	55.48	55.78	54.75	55.31	374517.0
2010-09-22	BSCE	ETF	20.9	20.96	20.9	20.95	19628.0
2010-09-22	BSV	ETF	81.68	81.73	81.64	81.69	523500.0
2010-09-22	BTF	ETF	75.0	75.3	74.5	75.1	3439.0
2010-09-22	BWX	ETF	29.375	29.5541	29.36	29.42	198500.0
2010-09-22	BWZ	ETF	36.5	36.63	36.43	36.4988	19216.0
2010-09-22	BZQ	ETF	3024.0	3059.2	2961.6	2998.4	911.0
2010-09-22	CEF	ETF	16.51	16.53	16.35	16.45	1070100.0
2010-09-22	CEW	ETF	22.63	22.68	22.6	22.67	123156.0

> showing 50 of 791 rows — these rows as CSV

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