PREVIEW / etf_daily / 2010-10-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-08.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-10-08	SPY	ETF	116.05	116.86	115.61	116.54	177760100.0
2010-10-08	QQQ	ETF	49.45	49.87	49.08	49.75	83223822.0
2010-10-08	IWM	ETF	68.51	69.66	68.14	69.28	59953200.0
2010-10-08	DIA	ETF	109.66	110.41	109.38	110.16	4812900.0
2010-10-08	GLD	ETF	130.78	131.88	130.47	131.66	18693300.0
2010-10-08	TLT	ETF	104.87	105.46	104.22	104.22	6128700.0
2010-10-08	AADR	ETF	28.46	28.56	28.46	28.52	1100.0
2010-10-08	AAXJ	ETF	62.08	62.72	61.99	62.52	221200.0
2010-10-08	ACWI	ETF	44.29	44.63	44.17	44.53	77800.0
2010-10-08	ACWX	ETF	42.57	42.88	42.57	42.82	266557.0
2010-10-08	ADRE	ETF	45.74	46.49	45.72	46.3701	86719.0
2010-10-08	AFK	ETF	33.32	33.62	33.2301	33.2301	22229.0
2010-10-08	AGG	ETF	108.91	108.93	108.76	108.82	604500.0
2010-10-08	AGQ	ETF	181.08	189.64	180.2	188.26	374000.0
2010-10-08	AGZ	ETF	111.59	111.83	111.58	111.74	19939.0
2010-10-08	AIA	ETF	43.42	43.822	43.34	43.78	122763.0
2010-10-08	AIQ	ETF	24.4	24.65	23.6	23.75	41669.0
2010-10-08	AIS	ETF	1.5	1.5	1.47	1.5	264174.0
2010-10-08	AIVI	ETF	44.46	44.87	44.43	44.87	15300.0
2010-10-08	AMJ	ETF	34.67	34.71	34.46	34.695	717974.0
2010-10-08	AMLP	ETF	78.7	78.75	78.35	78.6	89600.0
2010-10-08	AOA	ETF	32.08	32.32	31.97	32.26	8900.0
2010-10-08	AOK	ETF	28.64	28.74	28.61	28.69	7956.0
2010-10-08	AOM	ETF	29.4199	29.52	29.4199	29.51	7166.0
2010-10-08	AOR	ETF	30.42	30.4969	30.42	30.4969	8976.0
2010-10-08	ARB	ETF	29.17	30.15	28.8499	29.85	122353.0
2010-10-08	BAB	ETF	26.81	26.85	26.67	26.71	235608.0
2010-10-08	BAL	ETF	53.6	55.7	51.8599	53.12	113533.0
2010-10-08	BALT	ETF	10.91	11.1	10.9	11.04	158203.0
2010-10-08	BBH	ETF	32.3733	32.7433	32.3733	32.6433	26400.0
2010-10-08	BIB	ETF	6.4662	6.6363	6.4662	6.61	13768.0
2010-10-08	BICK	ETF	32.52	32.69	32.33	32.67	26490.0
2010-10-08	BIL	ETF	91.7	91.72	91.7	91.7	115850.0
2010-10-08	BIS	ETF	9409.6	9475.2	9409.6	9475.2	2.5
2010-10-08	BITS	ETF	27.4404	27.96	27.44	27.76	593.0
2010-10-08	BIV	ETF	87.54	87.58	87.29	87.3	104500.0
2010-10-08	BJK	ETF	28.72	29.65	28.72	29.55	11000.0
2010-10-08	BKF	ETF	48.85	49.55	48.85	49.37	214680.0
2010-10-08	BLV	ETF	86.0	86.27	85.37	85.37	121400.0
2010-10-08	BMVP	ETF	13.22	13.34	13.19	13.32	13106.0
2010-10-08	BND	ETF	83.0	83.06	82.83	82.83	1220000.0
2010-10-08	BNE	ETF	11.3	11.3	11.27	11.28	418763.0
2010-10-08	BNO	ETF	27.905	28.12	27.905	28.12	6000.0
2010-10-08	BOSS	ETF	37.4	38.135	37.4	38.135	100.0
2010-10-08	BRF	ETF	58.02	59.7	58.02	59.59	404529.0
2010-10-08	BSCE	ETF	21.07	21.07	21.07	21.07	6716.0
2010-10-08	BSV	ETF	81.95	81.95	81.85	81.85	804500.0
2010-10-08	BTF	ETF	76.8	77.1	76.25	77.1	6725.0
2010-10-08	BWX	ETF	30.655	30.8075	30.475	30.775	133910.0
2010-10-08	BWZ	ETF	37.52	37.7999	37.5	37.76	49598.0

> showing 50 of 791 rows — these rows as CSV

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