PREVIEW / etf_daily / 2009-07-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-09.parquet
  size:    29 KB
  rows:    663

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-07-09	SPY	ETF	88.61	88.9	87.91	88.17	163777600.0
2009-07-09	QQQ	ETF	34.84	35.01	34.65	34.77	97851468.0
2009-07-09	IWM	ETF	48.29	48.42	47.79	47.87	41678300.0
2009-07-09	DIA	ETF	82.24	82.41	81.53	81.77	11452000.0
2009-07-09	GLD	ETF	89.63	90.26	89.33	89.51	13688100.0
2009-07-09	TLT	ETF	95.35	95.73	94.45	95.35	5241400.0
2009-07-09	AAXJ	ETF	43.32	43.83	43.21	43.6	158800.0
2009-07-09	ACWI	ETF	33.42	33.56	33.2	33.39	117000.0
2009-07-09	ACWX	ETF	32.21	32.36	31.9801	32.19	40530.0
2009-07-09	ADRE	ETF	33.25	33.55	33.0201	33.23	89585.0
2009-07-09	AFK	ETF	25.16	25.2499	24.98	25.12	6752.0
2009-07-09	AGG	ETF	102.46	102.69	102.31	102.53	600100.0
2009-07-09	AGQ	ETF	72.0	73.76	71.44	72.26	130700.0
2009-07-09	AGZ	ETF	107.9	108.095	107.6183	107.84	16385.0
2009-07-09	AIA	ETF	31.84	32.32	31.84	32.2	9078.0
2009-07-09	AIQ	ETF	32.85	32.9	31.9	32.05	52204.0
2009-07-09	AIS	ETF	0.81	0.81	0.75	0.76	315811.0
2009-07-09	AIVI	ETF	34.06	34.13	33.71	33.89	11600.0
2009-07-09	AMJ	ETF	22.14	22.52	22.14	22.43	130759.0
2009-07-09	AOA	ETF	24.46	24.46	24.3	24.3	5900.0
2009-07-09	AOK	ETF	25.6	25.79	25.4861	25.5	16954.0
2009-07-09	AOM	ETF	25.39	25.39	24.85	25.13	8397.0
2009-07-09	AOR	ETF	25.1	25.1	24.86	24.89	1893.0
2009-07-09	ARB	ETF	15.95	16.09	15.68	15.94	305853.0
2009-07-09	BAL	ETF	30.91	31.8199	30.91	31.75	2870.0
2009-07-09	BBH	ETF	31.7167	31.7167	31.2433	31.3767	553500.0
2009-07-09	BIL	ETF	91.76	91.76	91.74	91.74	113000.0
2009-07-09	BITS	ETF	20.6	21.68	20.6	21.56	4802.0
2009-07-09	BIV	ETF	77.73	78.13	77.29	77.52	123000.0
2009-07-09	BJK	ETF	19.86	20.07	19.45	19.94	8300.0
2009-07-09	BKF	ETF	33.16	33.79	33.16	33.56	55963.0
2009-07-09	BLV	ETF	75.15	75.35	74.67	74.68	35400.0
2009-07-09	BMVP	ETF	10.61	10.64	10.56	10.57	23051.0
2009-07-09	BND	ETF	77.9	77.94	77.62	77.81	462400.0
2009-07-09	BNE	ETF	6.56	6.58	6.32	6.35	168839.0
2009-07-09	BOSS	ETF	15.42	15.42	15.13	15.13	400.0
2009-07-09	BRF	ETF	27.36	27.8	27.05	27.43	73661.0
2009-07-09	BSV	ETF	79.32	79.42	79.11	79.4	216200.0
2009-07-09	BTF	ETF	46.9	47.34499999999999	46.8	46.95	9298.6
2009-07-09	BWX	ETF	27.465	27.5564	27.371	27.555	242738.0
2009-07-09	BWZ	ETF	35.1904	35.34	35.1904	35.3	5603.0
2009-07-09	BZQ	ETF	10398.4	10772.8	10267.2	10528.0	55.0
2009-07-09	CBON	ETF	0.8	0.92	0.8	0.92	28675.0
2009-07-09	CEF	ETF	11.22	11.36	11.14	11.18	470000.0
2009-07-09	CEW	ETF	20.646	20.68	20.58	20.662	3525.0
2009-07-09	CGO	ETF	10.95	11.05	10.76	10.86	35251.0
2009-07-09	CGW	ETF	14.82	14.88	14.56	14.77	55671.0
2009-07-09	CHB	ETF	0.31	0.33	0.3	0.31	338881.0
2009-07-09	CHI	ETF	9.94	10.0016	9.75	9.78	197884.0
2009-07-09	CHIC	ETF	12.16	12.24	11.38	12.1	230589.0

> showing 50 of 663 rows — these rows as CSV

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