PREVIEW / etf_daily / 2009-12-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-09.parquet
  size:    30 KB
  rows:    699

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-09	SPY	ETF	109.58	110.18	109.02	110.02	155063400.0
2009-12-09	QQQ	ETF	43.61	44.12	43.32	44.08	78820459.0
2009-12-09	IWM	ETF	59.94	60.1	59.3	59.85	55537000.0
2009-12-09	DIA	ETF	102.96	103.56	102.48	103.45	8583800.0
2009-12-09	GLD	ETF	111.6	112.48	109.38	110.84	37125900.0
2009-12-09	TLT	ETF	93.69	94.05	92.68	93.17	3494300.0
2009-12-09	AAXJ	ETF	55.19	55.55	54.97	55.55	162900.0
2009-12-09	ACWI	ETF	41.74	41.97	41.55	41.82	1097800.0
2009-12-09	ACWX	ETF	40.66	40.6845	40.226	40.673	32165.0
2009-12-09	ADRE	ETF	43.8	43.95	43.37	43.95	236025.0
2009-12-09	AFK	ETF	28.07	28.07	27.58	27.79	14726.0
2009-12-09	AGG	ETF	105.1	105.2	104.9	104.95	455200.0
2009-12-09	AGQ	ETF	125.0	127.5	116.72	121.3	468300.0
2009-12-09	AGZ	ETF	108.97	108.97	108.59	108.59	16408.0
2009-12-09	AIA	ETF	39.42	39.7	39.3648	39.51	41951.0
2009-12-09	AIQ	ETF	30.0	30.0	29.5	29.95	13060.0
2009-12-09	AIS	ETF	1.1	1.1	1.07	1.08	130062.0
2009-12-09	AIVI	ETF	43.51	43.51	42.82	43.42	29800.0
2009-12-09	AMJ	ETF	27.34	27.48	26.924	27.055	298389.0
2009-12-09	AOA	ETF	29.39	29.54	29.33	29.54	7000.0
2009-12-09	AOK	ETF	27.41	27.43	27.36	27.3682	6632.0
2009-12-09	AOM	ETF	28.23	28.23	28.0745	28.14	12104.0
2009-12-09	AOR	ETF	28.84	28.84	28.62	28.82	11256.0
2009-12-09	ARB	ETF	21.98	22.02	20.96	21.5	335604.0
2009-12-09	BAB	ETF	24.8	24.85	24.7	24.71	132146.0
2009-12-09	BAL	ETF	36.36	36.628	36.1	36.5	5828.0
2009-12-09	BBH	ETF	32.1733	32.3633	31.9733	32.3467	166200.0
2009-12-09	BIL	ETF	91.7	91.74	91.7	91.74	181550.0
2009-12-09	BITS	ETF	27.0	27.2	26.8	27.2	6562.0
2009-12-09	BIV	ETF	81.13	81.13	80.61	80.68	130800.0
2009-12-09	BJK	ETF	24.06	24.17	23.76	24.05	13500.0
2009-12-09	BKF	ETF	45.79	45.92	45.24	45.88	132349.0
2009-12-09	BLV	ETF	78.24	78.24	77.42	77.85	21300.0
2009-12-09	BMVP	ETF	12.1967	12.27	12.1645	12.27	47651.0
2009-12-09	BND	ETF	79.82	79.82	79.57	79.63	580600.0
2009-12-09	BNE	ETF	6.63	6.63	6.401	6.46	173089.0
2009-12-09	BRF	ETF	47.94	48.2399	47.37	48.2	352211.0
2009-12-09	BSV	ETF	80.42	80.45	80.26	80.34	341400.0
2009-12-09	BTF	ETF	62.9	63.149499999999996	62.64999999999999	62.8	4599.6
2009-12-09	BWX	ETF	29.605	29.82	29.5004	29.64	552484.0
2009-12-09	BWZ	ETF	37.51	37.51	37.4	37.4881	21298.0
2009-12-09	BZQ	ETF	3902.4	3956.8	3801.6	3801.6	235.0
2009-12-09	CEF	ETF	14.13	14.35	13.9	13.98	1996000.0
2009-12-09	CEW	ETF	21.99	22.1	21.99	22.03	14058.0
2009-12-09	CGO	ETF	14.12	14.2375	13.87	13.91	32134.0
2009-12-09	CGW	ETF	18.3	18.32	18.0504	18.32	115395.0
2009-12-09	CHI	ETF	12.23	12.31	12.21	12.24	144862.0
2009-12-09	CHII	ETF	15.94	16.14	15.89	16.02	390007.0
2009-12-09	CHIQ	ETF	16.4	16.45	16.34	16.44	32724.0
2009-12-09	CHW	ETF	7.64	7.69	7.58	7.67	253084.0

> showing 50 of 699 rows — these rows as CSV

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