PREVIEW / etf_daily / 2009-05-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-15.parquet
  size:    28 KB
  rows:    646

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-05-15	SPY	ETF	89.37	90.0	88.15	88.71	271502700.0
2009-05-15	QQQ	ETF	33.36	33.82	33.23	33.37	121326308.0
2009-05-15	IWM	ETF	47.88	48.42	47.28	47.76	53885500.0
2009-05-15	DIA	ETF	83.15	83.95	82.28	82.78	23137600.0
2009-05-15	GLD	ETF	91.15	91.81	91.1	91.55	11705800.0
2009-05-15	TLT	ETF	98.0	98.05	97.46	98.04	2306600.0
2009-05-15	AAXJ	ETF	41.27	41.37	40.5	40.82	132000.0
2009-05-15	ACWI	ETF	33.38	33.49	32.86	32.98	268700.0
2009-05-15	ACWX	ETF	32.01	32.06	31.48	31.55	412914.0
2009-05-15	ADRE	ETF	33.0	33.141	32.35	32.56	106493.0
2009-05-15	AFK	ETF	26.5	26.5	23.86	23.9	4700.0
2009-05-15	AGG	ETF	101.84	102.19	101.84	102.19	616200.0
2009-05-15	AGQ	ETF	87.04	90.86	86.98	88.5	126150.0
2009-05-15	AGZ	ETF	108.08	108.1	107.6	107.99	4792.0
2009-05-15	AIA	ETF	31.59	31.59	30.52	30.66	131090.0
2009-05-15	AIQ	ETF	35.75	37.0	35.25	35.4	53197.0
2009-05-15	AIS	ETF	0.6	0.6	0.52	0.56	133336.0
2009-05-15	AIVI	ETF	33.72	34.12	33.32	33.51	5700.0
2009-05-15	AMJ	ETF	21.56	21.56	21.2794	21.37	15519.0
2009-05-15	AOA	ETF	24.36	24.36	24.08	24.17	1000.0
2009-05-15	AOK	ETF	25.5068	25.57	25.5068	25.52	1539.0
2009-05-15	AOM	ETF	25.2799	25.45	25.1039	25.1039	3029.0
2009-05-15	AOR	ETF	24.64	24.94	24.64	24.75	2236.0
2009-05-15	ARB	ETF	19.04	19.24	18.52	18.79	165994.0
2009-05-15	BAL	ETF	32.96	32.96	31.5101	31.5101	11812.0
2009-05-15	BBH	ETF	29.4667	29.62	29.1933	29.49	316200.0
2009-05-15	BIL	ETF	91.74	91.74	91.68	91.7	107200.0
2009-05-15	BITS	ETF	17.4	18.24	17.2	18.24	250.0
2009-05-15	BIV	ETF	77.44	77.44	77.11	77.3	90200.0
2009-05-15	BJK	ETF	21.86	21.86	19.58	19.81	90100.0
2009-05-15	BKF	ETF	32.4	32.4	31.31	31.73	54165.0
2009-05-15	BLV	ETF	73.89	73.9	73.31	73.67	18200.0
2009-05-15	BMVP	ETF	10.42	10.51	10.36	10.39	17026.0
2009-05-15	BND	ETF	77.58	77.69	77.51	77.6	535900.0
2009-05-15	BNE	ETF	5.0	5.16	4.61	5.13	238854.0
2009-05-15	BOSS	ETF	16.18	16.84	16.18	16.84	100.0
2009-05-15	BRF	ETF	24.67	24.84	24.25	24.35	28504.0
2009-05-15	BSV	ETF	79.02	79.24	79.01	79.1	286900.0
2009-05-15	BTF	ETF	47.300000000000004	47.599999999999994	46.65	47.0	5179.400000000001
2009-05-15	BWX	ETF	26.55	26.55	26.3	26.33	124336.0
2009-05-15	BWZ	ETF	34.33	34.34	34.08	34.08	16358.0
2009-05-15	CBON	ETF	1.45	1.47	1.21	1.21	20818.0
2009-05-15	CEF	ETF	11.36	11.6	11.36	11.5	855300.0
2009-05-15	CEW	ETF	20.2	20.36	20.07	20.1	13302.0
2009-05-15	CGO	ETF	10.18	10.22	10.0	10.07	48180.0
2009-05-15	CGW	ETF	14.41	14.5	14.2078	14.276	38709.0
2009-05-15	CHB	ETF	0.5	0.51	0.46	0.47	381737.0
2009-05-15	CHI	ETF	10.04	10.14	10.01	10.09	167620.0
2009-05-15	CHIC	ETF	10.79	11.0075	10.4	10.5	161957.0
2009-05-15	CHW	ETF	6.39	6.47	6.32	6.38	282244.0

> showing 50 of 646 rows — these rows as CSV

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