PREVIEW / etf_daily / 2010-02-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-10.parquet
  size:    31 KB
  rows:    712

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-10	SPY	ETF	107.05	107.6	106.11	107.01	240511500.0
2010-02-10	QQQ	ETF	43.1	43.31	42.75	43.02	94102839.0
2010-02-10	IWM	ETF	59.31	59.78	58.69	59.63	55715500.0
2010-02-10	DIA	ETF	100.55	100.97	99.75	100.52	11212100.0
2010-02-10	GLD	ETF	105.13	105.5	104.11	105.12	16215200.0
2010-02-10	TLT	ETF	91.32	91.6	90.2	90.31	5068000.0
2010-02-10	AAXJ	ETF	51.66	51.8	51.02	51.46	350300.0
2010-02-10	ACWI	ETF	40.07	40.07	39.57	39.98	88400.0
2010-02-10	ACWX	ETF	38.04	38.23	37.7319	38.11	43456.0
2010-02-10	ADRE	ETF	39.75	39.84	39.15	39.69	83924.0
2010-02-10	AFK	ETF	28.64	28.64	28.48	28.6	2645.0
2010-02-10	AGG	ETF	104.42	104.47	104.04	104.17	458300.0
2010-02-10	AGQ	ETF	91.3	91.5	87.92	89.94	316200.0
2010-02-10	AGZ	ETF	108.43	108.6	108.1501	108.25	17708.0
2010-02-10	AIA	ETF	37.64	37.65	37.09	37.45	25977.0
2010-02-10	AIQ	ETF	24.9	24.95	23.75	24.3	34827.0
2010-02-10	AIS	ETF	1.14	1.14	1.08	1.11	219919.0
2010-02-10	AIVI	ETF	40.21	40.37	39.85	40.16	42200.0
2010-02-10	AMJ	ETF	28.68	28.68	28.1	28.16	172947.0
2010-02-10	AOA	ETF	28.73	28.83	28.57	28.75	8800.0
2010-02-10	AOK	ETF	27.18	27.18	27.06	27.11	4058.0
2010-02-10	AOM	ETF	27.69	27.69	27.566	27.5949	1333.0
2010-02-10	AOR	ETF	28.19	28.19	28.0193	28.13	25629.0
2010-02-10	ARB	ETF	24.39	24.71	24.15	24.68	111563.0
2010-02-10	BAB	ETF	24.91	24.93	24.74	24.79	235143.0
2010-02-10	BAL	ETF	35.43	35.9	34.95	35.59	11581.0
2010-02-10	BBH	ETF	33.5	33.5067	33.0667	33.26	134400.0
2010-02-10	BIL	ETF	91.72	91.74	91.7	91.74	233950.0
2010-02-10	BITS	ETF	32.08	32.24	31.72	32.0	369.0
2010-02-10	BIV	ETF	80.34	80.4	79.95	80.06	151200.0
2010-02-10	BJK	ETF	22.97	23.26	22.92	23.02	10800.0
2010-02-10	BKF	ETF	41.47	41.6	40.74	41.21	258917.0
2010-02-10	BLV	ETF	76.88	77.09	76.07	76.19	19300.0
2010-02-10	BMVP	ETF	12.183	12.206	12.05	12.157	50189.0
2010-02-10	BND	ETF	79.45	79.46	79.18	79.25	453700.0
2010-02-10	BNE	ETF	6.18	6.22	6.07	6.2	85790.0
2010-02-10	BOSS	ETF	18.3	18.48	18.3	18.48	300.0
2010-02-10	BRF	ETF	43.84	43.94	42.96	43.24	436935.0
2010-02-10	BSV	ETF	80.22	80.24	80.09	80.12	352200.0
2010-02-10	BTF	ETF	65.85	65.85	65.14999999999999	65.55	5438.8
2010-02-10	BWX	ETF	27.955	27.967	27.7225	27.865	271844.0
2010-02-10	BWZ	ETF	35.68	35.6999	35.47	35.53	24553.0
2010-02-10	BZQ	ETF	4580.8	4756.8	4553.6	4641.6	599.0
2010-02-10	CEF	ETF	13.0	13.04	12.85	13.0	987200.0
2010-02-10	CEW	ETF	21.58	21.78	21.57	21.618	218875.0
2010-02-10	CGO	ETF	13.12	13.37	13.11	13.37	24110.0
2010-02-10	CGW	ETF	17.15	17.36	17.1	17.27	80142.0
2010-02-10	CHI	ETF	12.03	12.09	11.88	11.99	152105.0
2010-02-10	CHIE	ETF	13.67	13.73	13.44	13.63	31200.0
2010-02-10	CHII	ETF	14.26	14.42	14.18	14.36	6647.0

> showing 50 of 712 rows — these rows as CSV

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