PREVIEW / etf_daily / 2010-06-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-08.parquet
  size:    33 KB
  rows:    757

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-06-08	SPY	ETF	105.57	106.83	104.65	106.62	357774300.0
2010-06-08	QQQ	ETF	44.37	44.48	43.59	44.19	133990029.0
2010-06-08	IWM	ETF	62.11	62.6	60.7	61.89	129072000.0
2010-06-08	DIA	ETF	98.36	99.67	97.7	99.44	25086600.0
2010-06-08	GLD	ETF	121.61	122.45	120.66	121.0	23404800.0
2010-06-08	TLT	ETF	97.93	98.51	97.76	98.05	5510800.0
2010-06-08	AAXJ	ETF	50.54	51.52	50.47	51.48	309900.0
2010-06-08	ACWI	ETF	38.25	38.48	37.7	38.48	463600.0
2010-06-08	ACWX	ETF	35.16	35.69	35.02	35.69	36011.0
2010-06-08	ADRE	ETF	38.82	39.41	38.54	39.34	123371.0
2010-06-08	AFK	ETF	27.65	28.6299	27.45	28.246	5197.0
2010-06-08	AGG	ETF	105.96	106.04	105.86	105.86	636400.0
2010-06-08	AGQ	ETF	123.12	124.78	121.52	122.04	168950.0
2010-06-08	AGZ	ETF	109.3	109.799	109.3	109.55	23029.0
2010-06-08	AIA	ETF	35.96	36.5	35.838	36.4841	5590.0
2010-06-08	AIQ	ETF	25.05	25.15	24.0	24.2	30608.0
2010-06-08	AIS	ETF	1.68	1.75	1.65	1.73	822938.0
2010-06-08	AIVI	ETF	36.21	36.49	35.92	36.43	8000.0
2010-06-08	AMJ	ETF	29.28	29.3	28.57	29.12	1868415.0
2010-06-08	AOA	ETF	28.3	28.49	28.1	28.42	15300.0
2010-06-08	AOK	ETF	27.26	27.31	27.15	27.3099	9181.0
2010-06-08	AOM	ETF	27.55	27.602	27.413	27.6001	15263.0
2010-06-08	AOR	ETF	27.83	27.9905	27.7125	27.9905	2854.0
2010-06-08	ARB	ETF	28.3	28.58	27.08	27.53	228921.0
2010-06-08	BAB	ETF	25.99	26.09	25.9401	26.024	158752.0
2010-06-08	BAL	ETF	36.45	37.1	36.45	36.88	1826.0
2010-06-08	BALT	ETF	11.88	11.97	11.45	11.8	104181.0
2010-06-08	BBH	ETF	29.1667	29.17	28.56	28.9767	176100.0
2010-06-08	BIB	ETF	5.46	5.4713	5.235	5.3125	57600.0
2010-06-08	BICK	ETF	26.3	26.4101	26.2901	26.4101	833.0
2010-06-08	BIL	ETF	91.72	91.74	91.7	91.74	306150.0
2010-06-08	BIS	ETF	12609.6	12870.4	12350.4	12744.0	9.4
2010-06-08	BITS	ETF	27.6	27.8	26.88	27.52	2096.0
2010-06-08	BIV	ETF	82.26	82.44	82.22	82.27	141100.0
2010-06-08	BJK	ETF	22.93	23.46	22.75	23.46	21900.0
2010-06-08	BKF	ETF	40.02	40.72	39.75	40.696	91438.0
2010-06-08	BLV	ETF	80.11	80.46	80.0	80.22	72200.0
2010-06-08	BMVP	ETF	11.87	11.96	11.74	11.95	13804.0
2010-06-08	BND	ETF	80.5	80.64	80.5	80.56	538700.0
2010-06-08	BNE	ETF	11.05	11.05	11.0	11.0	545574.0
2010-06-08	BNO	ETF	24.695	24.85	24.595	24.69	65400.0
2010-06-08	BRF	ETF	41.17	42.29	41.13	42.09	608260.0
2010-06-08	BSCE	ETF	20.2	20.2	20.1999	20.2	2000.0
2010-06-08	BSV	ETF	80.52	80.54	80.44	80.5	958000.0
2010-06-08	BTF	ETF	62.99999999999999	64.19999999999999	62.35	64.19999999999999	6418.6
2010-06-08	BWX	ETF	26.14	26.295	26.14	26.245	223626.0
2010-06-08	BWZ	ETF	32.82	32.9999	32.82	32.954	12649.0
2010-06-08	BZQ	ETF	4648.0	4732.8	4446.4	4488.0	1313.0
2010-06-08	CEF	ETF	15.08	15.15	14.91	14.96	1252000.0
2010-06-08	CEW	ETF	21.02	21.08	20.91	21.0416	348116.0

> showing 50 of 757 rows — these rows as CSV

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