PREVIEW / etf_daily / 2009-02-11

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-11.parquet
  size:    28 KB
  rows:    642

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-02-11	SPY	ETF	83.45	84.05	82.4	83.6	324442500.0
2009-02-11	QQQ	ETF	30.34	30.53	29.73	30.2	169172553.0
2009-02-11	IWM	ETF	44.88	45.19	44.09	44.76	58417600.0
2009-02-11	DIA	ETF	79.62	80.01	78.68	79.55	33244600.0
2009-02-11	GLD	ETF	90.93	93.25	90.8	92.29	55582400.0
2009-02-11	TLT	ETF	105.71	106.5	105.53	106.21	2774200.0
2009-02-11	AAXJ	ETF	31.7	31.81	31.08	31.45	1018100.0
2009-02-11	ACWI	ETF	29.25	29.51	28.94	29.29	121100.0
2009-02-11	ACWX	ETF	27.37	27.43	26.8	27.2	497096.0
2009-02-11	ADRE	ETF	27.7	27.96	27.034	27.55	252266.0
2009-02-11	AFK	ETF	18.87	18.87	18.39	18.53	4619.0
2009-02-11	AGG	ETF	101.48	102.15	101.4	101.56	518800.0
2009-02-11	AGQ	ETF	84.94	92.88	84.22	87.0	51250.0
2009-02-11	AGZ	ETF	108.0	108.04	107.93	107.94	3707.0
2009-02-11	AIA	ETF	24.3	24.36	23.85	24.04	10224.0
2009-02-11	AIQ	ETF	45.7	46.55	45.225	45.9	31947.0
2009-02-11	AIS	ETF	0.41	0.42	0.38	0.4075	26400.0
2009-02-11	AIVI	ETF	29.31	29.31	28.7	29.12	21400.0
2009-02-11	AOA	ETF	22.6	22.6	22.11	22.32	9100.0
2009-02-11	AOK	ETF	26.09	26.09	24.94	25.1	3235.0
2009-02-11	AOM	ETF	24.33	24.49	24.14	24.41	1853.0
2009-02-11	AOR	ETF	23.1977	23.88	23.19	23.19	2130.0
2009-02-11	ARB	ETF	13.6	13.8237	13.43	13.66	202000.0
2009-02-11	BAL	ETF	27.33	27.33	27.04	27.04	693.0
2009-02-11	BBH	ETF	57.8733	58.0967	57.6467	58.0967	75600.0
2009-02-11	BIL	ETF	91.72	91.72	91.68	91.68	147750.0
2009-02-11	BITS	ETF	19.796	19.796	18.64	19.16	772.0
2009-02-11	BIV	ETF	76.8	77.65	76.7	77.41	98800.0
2009-02-11	BKF	ETF	24.53	24.7699	23.96	24.11	16727.0
2009-02-11	BLV	ETF	75.25	75.55	74.57	74.64	61900.0
2009-02-11	BMVP	ETF	10.25	10.3215	10.17	10.3	55996.0
2009-02-11	BND	ETF	76.92	77.55	76.88	77.52	250000.0
2009-02-11	BNE	ETF	2.85	2.95	2.69	2.81	127380.0
2009-02-11	BOSS	ETF	12.5	12.5	12.44	12.44	100.0
2009-02-11	BSV	ETF	79.08	79.57	78.8	79.55	173400.0
2009-02-11	BTF	ETF	47.199999999999996	47.64999999999999	46.55	47.449999999999996	18412.8
2009-02-11	BWX	ETF	25.5	25.52	25.355	25.475	246598.0
2009-02-11	BWZ	ETF	32.92	32.92	32.79	32.79	1500.0
2009-02-11	CBON	ETF	1.73	1.77	1.65	1.75	45300.0
2009-02-11	CDL	ETF	0.16	0.17	0.15	0.15	326772.0
2009-02-11	CEF	ETF	11.47	11.84	11.42	11.66	1712500.0
2009-02-11	CGO	ETF	10.85	10.85	9.9	9.92	24652.0
2009-02-11	CGW	ETF	13.1	13.3199	12.88	13.16	78111.0
2009-02-11	CHB	ETF	0.32	0.48	0.32	0.41	844298.0
2009-02-11	CHI	ETF	8.9	8.94	8.7	8.76	187321.0
2009-02-11	CHIC	ETF	5.77	5.77	5.22	5.26	204134.0
2009-02-11	CHW	ETF	6.59	6.59	6.3201	6.47	229595.0
2009-02-11	CHY	ETF	9.08	9.08	8.75	8.86	268863.0
2009-02-11	CMF	ETF	52.09	52.195	51.785	52.126	8090.0
2009-02-11	CNXT	ETF	0.62	0.6597	0.62	0.649	167954.0

> showing 50 of 642 rows — these rows as CSV

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