PREVIEW / etf_daily / 2009-10-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-14.parquet
  size:    30 KB
  rows:    678

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-10-14	SPY	ETF	108.72	109.42	107.42	109.31	191421600.0
2009-10-14	QQQ	ETF	43.1	43.293	42.85	43.16	91004866.0
2009-10-14	IWM	ETF	62.07	62.46	61.55	62.34	38634600.0
2009-10-14	DIA	ETF	99.77	100.36	99.43	100.23	9162700.0
2009-10-14	GLD	ETF	104.29	104.7	103.76	104.18	17871100.0
2009-10-14	TLT	ETF	95.51	96.1	94.9	95.12	5421000.0
2009-10-14	AAXJ	ETF	54.61	55.11	54.26	55.11	461300.0
2009-10-14	ACWI	ETF	42.25	42.27	41.91	42.26	546600.0
2009-10-14	ACWX	ETF	41.55	41.65	41.287	41.604	51521.0
2009-10-14	ADRE	ETF	43.6	44.2	43.55	44.174	194050.0
2009-10-14	AFK	ETF	30.43	30.82	30.4	30.72	24267.0
2009-10-14	AGG	ETF	104.29	104.54	104.29	104.41	491400.0
2009-10-14	AGQ	ETF	131.36	132.28	130.12	130.96	228750.0
2009-10-14	AGZ	ETF	108.65	108.685	108.3516	108.47	9245.0
2009-10-14	AIA	ETF	39.32	39.76	39.32	39.74	50027.0
2009-10-14	AIQ	ETF	31.55	31.65	30.65	31.15	74604.0
2009-10-14	AIS	ETF	1.12	1.14	1.08	1.13	441866.0
2009-10-14	AIVI	ETF	43.74	43.99	43.57	43.98	22400.0
2009-10-14	AMJ	ETF	26.0	26.16	25.97	26.108	266347.0
2009-10-14	AOA	ETF	29.83	29.85	29.72	29.85	5900.0
2009-10-14	AOK	ETF	27.65	27.65	27.208	27.32	3943.0
2009-10-14	AOM	ETF	28.05	28.18	28.0304	28.18	9304.0
2009-10-14	AOR	ETF	28.82	28.98	28.8	28.98	10962.0
2009-10-14	ARB	ETF	22.57	23.51	22.5	23.51	206245.0
2009-10-14	BAL	ETF	36.5	36.5	34.58	34.95	24237.0
2009-10-14	BBH	ETF	33.56	33.9967	33.4567	33.8667	235200.0
2009-10-14	BIL	ETF	91.7	91.72	91.7	91.7	345450.0
2009-10-14	BITS	ETF	25.8	26.8	24.84	25.96	9050.0
2009-10-14	BIV	ETF	79.88	80.18	79.85	79.87	108000.0
2009-10-14	BJK	ETF	26.99	26.99	26.6	26.66	16300.0
2009-10-14	BKF	ETF	45.1	45.97	45.1	45.69	292875.0
2009-10-14	BLV	ETF	78.11	78.39	77.69	77.82	50800.0
2009-10-14	BMVP	ETF	12.33	12.4122	12.3033	12.402	55632.0
2009-10-14	BND	ETF	79.13	79.24	78.95	79.0	1088300.0
2009-10-14	BNE	ETF	7.93	8.23	7.85	7.97	361111.0
2009-10-14	BOSS	ETF	22.42	22.78	22.17	22.42	300.0
2009-10-14	BRF	ETF	45.65	46.06	45.43	45.94	955011.0
2009-10-14	BSV	ETF	79.82	79.96	79.81	79.89	433100.0
2009-10-14	BTF	ETF	60.9	61.95	60.9	61.449999999999996	4472.8
2009-10-14	BWX	ETF	29.65	29.65	29.5	29.57	284734.0
2009-10-14	BWZ	ETF	37.82	37.88	37.8	37.88	20191.0
2009-10-14	BZQ	ETF	4374.4	4396.8	4188.8	4188.8	62.0
2009-10-14	CEF	ETF	13.98	14.05	13.9	13.93	734100.0
2009-10-14	CEW	ETF	22.11	22.21	22.1	22.16	104178.0
2009-10-14	CGO	ETF	14.28	14.44	14.26	14.42	39302.0
2009-10-14	CGW	ETF	18.01	18.14	17.9183	18.0668	104404.0
2009-10-14	CHB	ETF	0.34	0.38	0.33	0.35	10384060.0
2009-10-14	CHI	ETF	11.74	11.76	11.5	11.7	313837.0
2009-10-14	CHW	ETF	7.85	7.96	7.81	7.89	277951.0
2009-10-14	CHY	ETF	11.5	11.63	11.4	11.63	277426.0

> showing 50 of 678 rows — these rows as CSV

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