PREVIEW / etf_daily / 2009-07-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-27.parquet
  size:    29 KB
  rows:    665

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-27	SPY	ETF	97.88	98.4	97.34	98.35	159259400.0
2009-07-27	QQQ	ETF	39.29	39.41	38.87	39.35	94718534.0
2009-07-27	IWM	ETF	54.8	55.22	54.42	55.09	32672800.0
2009-07-27	DIA	ETF	90.86	91.27	90.37	91.14	10045200.0
2009-07-27	GLD	ETF	93.9	93.95	93.36	93.71	5167300.0
2009-07-27	TLT	ETF	90.23	90.66	89.94	90.4	2755900.0
2009-07-27	AAXJ	ETF	49.7	49.7	48.9	49.43	200500.0
2009-07-27	ACWI	ETF	37.32	37.42	36.98	37.31	158200.0
2009-07-27	ACWX	ETF	36.04	36.16	35.817	36.14	52772.0
2009-07-27	ADRE	ETF	37.99	38.15	37.5301	37.98	103676.0
2009-07-27	AFK	ETF	27.48	27.9809	27.398	27.96	4057.0
2009-07-27	AGG	ETF	102.0	102.37	101.85	102.08	883400.0
2009-07-27	AGQ	ETF	85.78	86.0	84.38	85.3	110000.0
2009-07-27	AGZ	ETF	106.87	107.53	106.6475	107.52	12286.0
2009-07-27	AIA	ETF	35.75	36.23	35.51	36.0	46740.0
2009-07-27	AIQ	ETF	33.65	34.65	33.5	34.5	50981.0
2009-07-27	AIS	ETF	0.91	0.92	0.86	0.89	206505.0
2009-07-27	AIVI	ETF	37.58	37.95	37.31	37.91	24700.0
2009-07-27	AMJ	ETF	24.7	25.04	24.68	24.79	218398.0
2009-07-27	AOA	ETF	26.74	26.74	26.53	26.64	7700.0
2009-07-27	AOK	ETF	26.0	26.67	26.0	26.05	19003.0
2009-07-27	AOM	ETF	26.78	27.03	25.97	26.344	20771.0
2009-07-27	AOR	ETF	26.6	26.61	26.45	26.61	13799.0
2009-07-27	ARB	ETF	17.67	17.85	17.1	17.35	122740.0
2009-07-27	BAL	ETF	30.5299	30.95	30.41	30.95	6700.0
2009-07-27	BBH	ETF	33.6933	33.9033	33.4733	33.8267	372300.0
2009-07-27	BIL	ETF	91.7	91.72	91.7	91.7	158600.0
2009-07-27	BITS	ETF	22.64	22.68	21.44	22.56	2415.0
2009-07-27	BIV	ETF	77.21	77.47	77.06	77.43	83500.0
2009-07-27	BJK	ETF	22.31	22.47	22.09	22.32	15500.0
2009-07-27	BKF	ETF	38.72	38.99	38.11	38.88	342325.0
2009-07-27	BLV	ETF	73.51	73.94	73.48	73.94	20600.0
2009-07-27	BMVP	ETF	11.4333	11.4857	11.4023	11.4833	11408.0
2009-07-27	BND	ETF	77.6	77.7	77.5	77.7	597100.0
2009-07-27	BNE	ETF	7.95	8.19	7.67	8.11	85091.0
2009-07-27	BOSS	ETF	16.72	16.78	16.72	16.78	100.0
2009-07-27	BRF	ETF	33.32	33.32	32.078	32.69	81998.0
2009-07-27	BSV	ETF	79.12	79.34	79.12	79.24	293900.0
2009-07-27	BTF	ETF	52.5	53.449999999999996	52.0505	53.449999999999996	23012.4
2009-07-27	BWX	ETF	27.81	27.81	27.67	27.79	297586.0
2009-07-27	BWZ	ETF	35.79	35.82	35.7	35.81	6288.0
2009-07-27	CBON	ETF	0.75	0.75	0.68	0.68	26311.0
2009-07-27	CEF	ETF	12.03	12.05	11.92	12.05	463700.0
2009-07-27	CEW	ETF	21.32	21.34	21.23	21.34	20651.0
2009-07-27	CGO	ETF	12.24	12.67	12.1	12.34	43610.0
2009-07-27	CGW	ETF	16.29	16.42	16.1504	16.42	25167.0
2009-07-27	CHB	ETF	0.33	0.52	0.33	0.49	4217474.0
2009-07-27	CHI	ETF	11.06	11.18	11.02	11.11	198411.0
2009-07-27	CHIC	ETF	14.14	14.48	14.07	14.33	438345.0
2009-07-27	CHW	ETF	6.89	7.08	6.89	7.0	221625.0

> showing 50 of 665 rows — these rows as CSV

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