PREVIEW / etf_daily / 2009-12-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-23.parquet
  size:    31 KB
  rows:    703

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-12-23	SPY	ETF	112.0	112.11	111.5	111.95	111783100.0
2009-12-23	QQQ	ETF	45.34	45.57	45.21	45.56	73932195.0
2009-12-23	IWM	ETF	62.7	63.16	62.28	63.12	49503600.0
2009-12-23	DIA	ETF	104.65	104.72	104.17	104.45	4867200.0
2009-12-23	GLD	ETF	106.65	107.45	106.3	106.55	16941900.0
2009-12-23	TLT	ETF	90.96	91.39	90.5	90.65	2336000.0
2009-12-23	AAXJ	ETF	55.07	55.07	54.56	54.62	152500.0
2009-12-23	ACWI	ETF	42.39	42.39	42.0	42.32	176600.0
2009-12-23	ACWX	ETF	40.56	40.82	40.47	40.76	146594.0
2009-12-23	ADRE	ETF	43.14	43.61	43.05	43.41	342807.0
2009-12-23	AFK	ETF	27.68	27.8599	27.5	27.8	3235.0
2009-12-23	AGG	ETF	104.08	104.2	104.0	104.05	589100.0
2009-12-23	AGQ	ETF	115.78	117.6	115.38	116.04	206100.0
2009-12-23	AGZ	ETF	108.24	108.261	108.151	108.19	21255.0
2009-12-23	AIA	ETF	39.11	39.11	38.71	39.05	56060.0
2009-12-23	AIQ	ETF	28.3	28.65	27.95	28.35	27987.0
2009-12-23	AIS	ETF	1.06	1.1	1.06	1.09	89163.0
2009-12-23	AIVI	ETF	43.62	43.81	43.41	43.7	24900.0
2009-12-23	AMJ	ETF	28.45	28.52	28.2968	28.5	424397.0
2009-12-23	AOA	ETF	30.13	30.32	30.1	30.32	17200.0
2009-12-23	AOK	ETF	27.4954	27.4954	27.4954	27.4954	101.0
2009-12-23	AOM	ETF	28.4054	28.49	28.4054	28.49	10695.0
2009-12-23	AOR	ETF	29.2098	29.27	29.18	29.27	7419.0
2009-12-23	ARB	ETF	24.0	24.524	23.94	24.47	85959.0
2009-12-23	BAB	ETF	24.42	24.46	24.31	24.3586	110794.0
2009-12-23	BAL	ETF	36.24	36.25	36.0262	36.195	7386.0
2009-12-23	BBH	ETF	32.4567	32.6233	32.3933	32.4767	88200.0
2009-12-23	BIL	ETF	91.7	91.72	91.7	91.7	179750.0
2009-12-23	BITS	ETF	29.24	30.64	29.24	30.32	3889.0
2009-12-23	BIV	ETF	79.87	79.93	79.66	79.78	109300.0
2009-12-23	BJK	ETF	23.5	23.74	23.17	23.5	13900.0
2009-12-23	BKF	ETF	45.0	45.4	44.735	44.91	578077.0
2009-12-23	BLV	ETF	76.56	76.78	76.39	76.49	49000.0
2009-12-23	BMVP	ETF	12.69	12.79	12.69	12.78	18284.0
2009-12-23	BND	ETF	79.0	79.08	78.93	78.98	680000.0
2009-12-23	BNE	ETF	7.27	7.27	6.99	6.99	209233.0
2009-12-23	BOSS	ETF	19.8	19.88	19.78	19.88	100.0
2009-12-23	BRF	ETF	47.14	47.8	46.59	47.42	355203.0
2009-12-23	BSV	ETF	80.0	80.04	79.88	80.0	987000.0
2009-12-23	BTF	ETF	63.05	63.662	63.05	63.349999999999994	2597.6000000000004
2009-12-23	BWX	ETF	28.675	28.675	28.515	28.665	400796.0
2009-12-23	BWZ	ETF	36.31	36.642	36.25	36.61	20623.0
2009-12-23	BZQ	ETF	3960.0	4038.4	3854.4	3908.8	449.0
2009-12-23	CEF	ETF	13.43	13.79	13.43	13.78	910400.0
2009-12-23	CEW	ETF	21.75	21.78	21.7	21.77	200746.0
2009-12-23	CGO	ETF	14.26	14.26	14.03	14.19	22099.0
2009-12-23	CGW	ETF	18.68	18.68	18.4	18.61	134632.0
2009-12-23	CHI	ETF	12.44	12.5397	12.419	12.49	208325.0
2009-12-23	CHIE	ETF	14.84	14.84	14.71	14.79	11240.0
2009-12-23	CHII	ETF	15.17	15.2125	15.115	15.165	7561.0

> showing 50 of 703 rows — these rows as CSV

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