PREVIEW / etf_daily / 2010-08-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-02.parquet
  size:    33 KB
  rows:    771

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-08-02	SPY	ETF	111.99	112.94	111.54	112.76	188263200.0
2010-08-02	QQQ	ETF	46.38	46.79	46.2101	46.67	68706704.0
2010-08-02	IWM	ETF	66.17	66.54	65.59	66.15	49896600.0
2010-08-02	DIA	ETF	106.08	106.99	105.88	106.73	6852300.0
2010-08-02	GLD	ETF	116.12	116.39	115.2	115.54	8473400.0
2010-08-02	TLT	ETF	99.24	99.33	98.75	98.75	5769200.0
2010-08-02	AADR	ETF	25.7	25.71	25.44	25.62	7000.0
2010-08-02	AAXJ	ETF	57.24	57.59	57.04	57.45	2418800.0
2010-08-02	ACWI	ETF	41.8	42.27	41.6	42.27	298900.0
2010-08-02	ACWX	ETF	39.81	40.17	39.71	40.08	61809.0
2010-08-02	ADRE	ETF	43.09	43.68	43.09	43.61	458359.0
2010-08-02	AFK	ETF	30.85	31.4	30.85	31.03	45288.0
2010-08-02	AGG	ETF	107.49	107.56	107.32	107.41	1532400.0
2010-08-02	AGQ	ETF	121.08	123.36	120.1	120.5	191050.0
2010-08-02	AGZ	ETF	110.57	110.57	110.4107	110.47	12516.0
2010-08-02	AIA	ETF	40.35	40.799	40.35	40.74	11817.0
2010-08-02	AIQ	ETF	21.65	21.75	21.05	21.3	61890.0
2010-08-02	AIS	ETF	1.55	1.61	1.55	1.59	612095.0
2010-08-02	AIVI	ETF	41.32	41.97	41.32	41.84	22600.0
2010-08-02	AMJ	ETF	33.65	33.65	33.08	33.44	1690817.0
2010-08-02	AOA	ETF	30.55	30.77	30.55	30.77	55700.0
2010-08-02	AOK	ETF	28.0	28.07	27.96	28.07	15738.0
2010-08-02	AOM	ETF	28.602	28.74	28.602	28.7086	6713.0
2010-08-02	AOR	ETF	29.45	29.5	29.44	29.5	14403.0
2010-08-02	ARB	ETF	29.3	29.98	29.15	29.59	258932.0
2010-08-02	BAB	ETF	25.92	25.97	25.89	25.94	225260.0
2010-08-02	BAL	ETF	38.76	38.85	38.32	38.69	9680.0
2010-08-02	BALT	ETF	11.63	11.78	11.47	11.73	73411.0
2010-08-02	BBH	ETF	31.31	31.63	31.31	31.5767	91200.0
2010-08-02	BIB	ETF	5.7462	5.8863	5.7462	5.86	37600.0
2010-08-02	BICK	ETF	29.73	29.97	29.73	29.97	4602.0
2010-08-02	BIL	ETF	91.68	91.7	91.68	91.68	794600.0
2010-08-02	BIS	ETF	11296.0	11296.0	11296.0	11296.0	0.625
2010-08-02	BITS	ETF	27.92	28.36	27.92	28.04	334.0
2010-08-02	BIV	ETF	84.51	84.51	84.18	84.28	568400.0
2010-08-02	BJK	ETF	25.69	26.15	25.69	26.01	8400.0
2010-08-02	BKF	ETF	45.53	46.22	45.53	46.17	255110.0
2010-08-02	BLV	ETF	82.49	82.53	82.1	82.25	57200.0
2010-08-02	BMVP	ETF	12.63	12.71	12.6	12.71	15806.0
2010-08-02	BND	ETF	81.61	81.63	81.51	81.6	2218700.0
2010-08-02	BNE	ETF	11.35	11.35	11.17	11.24	1216619.0
2010-08-02	BNO	ETF	27.135	27.37	27.135	27.33	11600.0
2010-08-02	BRF	ETF	50.4	50.87	50.15	50.4	439105.0
2010-08-02	BSCE	ETF	20.8	20.8	20.75	20.75	6346.0
2010-08-02	BSV	ETF	81.29	81.29	81.2	81.26	854900.0
2010-08-02	BTF	ETF	70.6	71.505	70.6	71.214	2802.8
2010-08-02	BWX	ETF	28.635	28.7	28.535	28.6	296462.0
2010-08-02	BWZ	ETF	35.39	35.576	35.39	35.576	44310.0
2010-08-02	BZQ	ETF	3241.6	3265.6	3177.6	3193.6	874.0
2010-08-02	CEF	ETF	14.62	14.74	14.5	14.52	669800.0

> showing 50 of 771 rows — these rows as CSV

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