PREVIEW / etf_daily / 2009-02-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-09.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-02-09	SPY	ETF	86.96	87.74	86.32	87.1	240075200.0
2009-02-09	QQQ	ETF	31.39	31.67	31.19	31.5	98853886.0
2009-02-09	IWM	ETF	46.79	47.14	46.22	46.75	55265000.0
2009-02-09	DIA	ETF	82.8	83.29	82.1	82.75	20793600.0
2009-02-09	GLD	ETF	88.35	88.65	87.6	88.32	21263800.0
2009-02-09	TLT	ETF	101.69	102.67	101.06	102.62	2257300.0
2009-02-09	AAXJ	ETF	33.13	33.13	32.4	32.84	1602600.0
2009-02-09	ACWI	ETF	30.54	30.69	30.29	30.5	27300.0
2009-02-09	ACWX	ETF	28.24	28.47	28.17	28.344	39533.0
2009-02-09	ADRE	ETF	28.95	28.95	28.28	28.53	609263.0
2009-02-09	AFK	ETF	19.02	19.0699	19.0	19.0699	500.0
2009-02-09	AGG	ETF	101.15	101.24	100.73	100.96	588300.0
2009-02-09	AGQ	ETF	81.4	81.42	78.74	79.34	27800.0
2009-02-09	AGZ	ETF	106.51	107.49	106.51	107.3	14106.0
2009-02-09	AIA	ETF	25.27	25.29	25.0	25.09	9032.0
2009-02-09	AIQ	ETF	46.8	47.05	46.2	46.85	20013.0
2009-02-09	AIS	ETF	0.48	0.48	0.4001	0.43	56222.0
2009-02-09	AIVI	ETF	30.31	30.68	30.17	30.31	58800.0
2009-02-09	AOA	ETF	24.05	24.05	23.0	23.02	11500.0
2009-02-09	AOK	ETF	25.285	25.36	25.285	25.3585	1000.0
2009-02-09	AOM	ETF	26.1	26.1	24.65	24.82	6589.0
2009-02-09	AOR	ETF	23.85	24.1	23.79	23.89	8043.0
2009-02-09	ARB	ETF	14.47	14.66	14.21	14.47	122746.0
2009-02-09	BAL	ETF	29.362	29.362	29.25	29.25	1400.0
2009-02-09	BBH	ETF	58.3333	58.4967	58.0	58.4067	227700.0
2009-02-09	BIL	ETF	91.7	91.74	91.64	91.72	164200.0
2009-02-09	BITS	ETF	20.04	20.36	19.0	19.8	1961.0
2009-02-09	BIV	ETF	77.07	77.07	76.37	76.62	87600.0
2009-02-09	BKF	ETF	25.49	25.49	24.81	24.893	17849.0
2009-02-09	BLV	ETF	73.68	74.14	73.56	74.14	19300.0
2009-02-09	BMVP	ETF	10.59	10.71	10.55	10.64	86278.0
2009-02-09	BND	ETF	77.13	77.13	76.63	76.82	263800.0
2009-02-09	BNE	ETF	2.99	3.03	2.8301	3.01	126207.0
2009-02-09	BSV	ETF	79.0	79.48	79.0	79.4	149500.0
2009-02-09	BTF	ETF	48.8	49.149499999999996	48.349999999999994	49.149499999999996	6325.200000000001
2009-02-09	BWX	ETF	25.6	25.625	25.385	25.45	434228.0
2009-02-09	BWZ	ETF	33.19	33.2	33.134	33.14	13108.0
2009-02-09	CBON	ETF	1.6	2.22	1.6	1.85	86043.0
2009-02-09	CDL	ETF	0.19	0.19	0.16	0.17	587895.0
2009-02-09	CEF	ETF	11.01	11.2	10.99	11.16	722900.0
2009-02-09	CGO	ETF	10.0	10.0	9.9	9.98	22117.0
2009-02-09	CGW	ETF	13.75	13.75	13.5415	13.66	38450.0
2009-02-09	CHB	ETF	0.428	0.428	0.37	0.37	485323.0
2009-02-09	CHI	ETF	9.02	9.03	8.92	9.0	137648.0
2009-02-09	CHIC	ETF	5.78	6.545	5.68	6.46	222028.0
2009-02-09	CHW	ETF	6.45	6.59	6.35	6.56	246443.0
2009-02-09	CHY	ETF	8.87	9.12	8.83	9.12	313587.0
2009-02-09	CMF	ETF	51.645	52.125	51.07	52.125	17306.0
2009-02-09	CNXT	ETF	0.64	0.65	0.625	0.64	201876.0
2009-02-09	COW	ETF	31.49	31.9	31.49	31.8	17996.0

> showing 50 of 646 rows — these rows as CSV

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