PREVIEW / etf_daily / 2010-02-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-09.parquet
  size:    31 KB
  rows:    720

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-02-09	SPY	ETF	107.13	108.15	106.27	107.22	337820500.0
2010-02-09	QQQ	ETF	43.17	43.51	42.76	43.11	118955917.0
2010-02-09	IWM	ETF	59.38	59.93	58.75	59.49	91986700.0
2010-02-09	DIA	ETF	100.16	101.49	99.84	100.65	19228000.0
2010-02-09	GLD	ETF	105.18	106.15	104.87	105.41	25959200.0
2010-02-09	TLT	ETF	91.74	92.22	91.14	91.18	4790000.0
2010-02-09	AAXJ	ETF	51.07	51.7	50.79	51.31	657600.0
2010-02-09	ACWI	ETF	39.92	40.36	39.47	39.99	175800.0
2010-02-09	ACWX	ETF	37.82	38.61	37.59	38.24	85524.0
2010-02-09	ADRE	ETF	39.39	40.0301	39.166	39.65	134377.0
2010-02-09	AFK	ETF	28.72	29.07	28.644	28.65	10620.0
2010-02-09	AGG	ETF	104.41	104.64	104.35	104.41	707100.0
2010-02-09	AGQ	ETF	90.32	94.04	88.94	92.26	359900.0
2010-02-09	AGZ	ETF	108.59	108.59	108.25	108.39	19804.0
2010-02-09	AIA	ETF	37.34	37.85	37.25	37.55	21313.0
2010-02-09	AIQ	ETF	24.95	25.0	24.45	24.9	11309.0
2010-02-09	AIS	ETF	1.13	1.15	1.1	1.12	140268.0
2010-02-09	AIVI	ETF	40.05	40.83	39.7	40.55	37000.0
2010-02-09	AMJ	ETF	28.43	28.63	28.29	28.47	971075.0
2010-02-09	AOA	ETF	28.75	28.89	28.7	28.81	6100.0
2010-02-09	AOK	ETF	27.09	27.22	27.09	27.18	4384.0
2010-02-09	AOM	ETF	27.7	27.7208	27.6345	27.7099	5981.0
2010-02-09	AOR	ETF	28.1181	28.2299	28.08	28.18	8771.0
2010-02-09	ARB	ETF	24.44	24.69	24.09	24.51	97692.0
2010-02-09	BAB	ETF	24.94	25.0	24.87	24.87	116432.0
2010-02-09	BAL	ETF	35.0	35.44	34.812	35.16	11549.0
2010-02-09	BBH	ETF	33.61	33.8233	33.2533	33.3967	343200.0
2010-02-09	BIL	ETF	91.74	91.74	91.72	91.74	314850.0
2010-02-09	BITS	ETF	31.6	32.6	31.6	32.0	1825.0
2010-02-09	BIV	ETF	80.52	80.59	80.27	80.31	162200.0
2010-02-09	BJK	ETF	23.11	23.4	22.79	23.09	23000.0
2010-02-09	BKF	ETF	41.03	41.59	40.56	41.18	298028.0
2010-02-09	BLV	ETF	77.21	77.48	76.77	76.86	30000.0
2010-02-09	BMVP	ETF	12.12	12.25	12.07	12.18	18517.0
2010-02-09	BND	ETF	79.54	79.59	79.37	79.43	691600.0
2010-02-09	BNE	ETF	6.23	6.25	6.12	6.2	174232.0
2010-02-09	BOSS	ETF	18.65	18.975	18.65	18.975	400.0
2010-02-09	BRF	ETF	42.96	43.75	42.65	43.48	477003.0
2010-02-09	BSV	ETF	80.32	80.32	80.16	80.21	471100.0
2010-02-09	BTF	ETF	65.55	65.7495	64.62799999999999	65.44999999999999	8412.0
2010-02-09	BWX	ETF	27.815	27.985	27.685	27.875	662598.0
2010-02-09	BWZ	ETF	35.39	36.02	35.39	35.905	67962.0
2010-02-09	BZQ	ETF	4691.2	4756.8	4456.0	4636.8	1357.0
2010-02-09	CEF	ETF	12.89	13.08	12.84	13.06	1416300.0
2010-02-09	CEW	ETF	21.59	21.66	21.52	21.66	122409.0
2010-02-09	CGO	ETF	12.99	13.41	12.99	13.1	21117.0
2010-02-09	CGW	ETF	17.07	17.42	17.03	17.22	88948.0
2010-02-09	CHI	ETF	11.79	12.05	11.76	11.89	238536.0
2010-02-09	CHIE	ETF	13.41	13.51	13.3	13.4866	1678.0
2010-02-09	CHII	ETF	13.93	14.17	13.87	14.0525	27989.0

> showing 50 of 720 rows — these rows as CSV

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