PREVIEW / etf_daily / 2009-02-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-04.parquet
  size:    28 KB
  rows:    633

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
2009-02-04	SPY	ETF	84.3	85.37	83.04	83.33	322989300.0
2009-02-04	QQQ	ETF	29.93	30.8667	29.79	29.91	175780814.0
2009-02-04	IWM	ETF	45.21	46.12	44.53	44.83	65080500.0
2009-02-04	DIA	ETF	80.8	81.71	79.34	79.69	27506400.0
2009-02-04	GLD	ETF	88.89	89.5	88.52	89.18	14271100.0
2009-02-04	TLT	ETF	102.75	102.87	101.62	102.52	2305400.0
2009-02-04	AAXJ	ETF	31.11	31.94	31.11	31.27	30600.0
2009-02-04	ACWI	ETF	29.26	29.84	29.14	29.34	181000.0
2009-02-04	ACWX	ETF	27.2	27.62	26.84	27.07	435598.0
2009-02-04	ADRE	ETF	26.57	27.17	26.39	26.57	222045.0
2009-02-04	AFK	ETF	18.01	18.01	17.81	17.81	500.0
2009-02-04	AGG	ETF	101.3	101.46	100.87	101.0	673400.0
2009-02-04	AGQ	ETF	74.72	76.06	74.36	75.26	23050.0
2009-02-04	AGZ	ETF	107.18	107.18	106.725	106.95	2105.0
2009-02-04	AIA	ETF	23.69	24.49	23.69	24.22	12250.0
2009-02-04	AIQ	ETF	46.0	46.6	44.75	45.85	37124.0
2009-02-04	AIS	ETF	0.46	0.46	0.38	0.42	1051800.0
2009-02-04	AIVI	ETF	29.01	29.71	28.83	28.83	11300.0
2009-02-04	AOA	ETF	23.0	23.0	22.2	22.21	6600.0
2009-02-04	AOK	ETF	25.0	25.05	25.0	25.05	870.0
2009-02-04	AOM	ETF	24.58	24.58	24.32	24.32	3388.0
2009-02-04	AOR	ETF	23.875	23.94	23.28	23.28	4994.0
2009-02-04	ARB	ETF	13.62	14.07	13.34	13.65	272695.0
2009-02-04	BAL	ETF	28.78	29.23	28.72	29.21	9400.0
2009-02-04	BBH	ETF	58.66	58.8433	57.86	58.1967	327900.0
2009-02-04	BIL	ETF	91.72	91.78	91.68	91.78	67700.0
2009-02-04	BITS	ETF	19.6004	19.9892	19.58	19.8	1125.0
2009-02-04	BIV	ETF	75.93	76.59	75.93	76.39	142900.0
2009-02-04	BKF	ETF	22.82	23.764	22.81	23.1	31568.0
2009-02-04	BLV	ETF	74.75	74.85	74.13	74.78	13500.0
2009-02-04	BMVP	ETF	10.3167	10.4755	10.2367	10.27	45094.0
2009-02-04	BND	ETF	76.35	76.8	76.2	76.64	337800.0
2009-02-04	BNE	ETF	2.96	3.02	2.72	2.91	218886.0
2009-02-04	BSV	ETF	79.45	79.46	79.0	79.23	236600.0
2009-02-04	BTF	ETF	48.550000000000004	49.5	48.4	48.6005	13216.0
2009-02-04	BWX	ETF	25.235	25.44	24.995	25.35	1425918.0
2009-02-04	BWZ	ETF	32.85	32.85	32.65	32.65	15400.0
2009-02-04	CBON	ETF	2.12	2.14	2.04	2.04	7371.0
2009-02-04	CDL	ETF	0.2	0.2069	0.162	0.17	529232.0
2009-02-04	CEF	ETF	11.07	11.2	10.93	11.17	735400.0
2009-02-04	CGO	ETF	9.99	10.0999	9.9	10.0299	16985.0
2009-02-04	CGW	ETF	13.07	13.34	13.0	13.09	96055.0
2009-02-04	CHB	ETF	0.51	0.52	0.43	0.44	529053.0
2009-02-04	CHI	ETF	9.08	9.09	8.9	9.0	371767.0
2009-02-04	CHIC	ETF	5.0	5.11	4.87	4.93	258848.0
2009-02-04	CHW	ETF	6.26	6.31	6.1232	6.26	220511.0
2009-02-04	CHY	ETF	9.0	9.0	8.85	8.93	126325.0
2009-02-04	CMF	ETF	51.5	51.5	51.035	51.035	9604.0
2009-02-04	CNXT	ETF	0.61	0.62	0.6	0.61	132628.0
2009-02-04	COW	ETF	31.65	31.67	31.476	31.476	9826.0

> showing 50 of 633 rows — these rows as CSV

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