PREVIEW / etf_daily / 2009-02-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-19.parquet
  size:    28 KB
  rows:    633

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-19	SPY	ETF	79.84	80.15	78.02	78.18	316867500.0
2009-02-19	QQQ	ETF	29.43	29.61	28.72	28.79	155322371.0
2009-02-19	IWM	ETF	42.78	43.0	41.63	41.7	64544300.0
2009-02-19	DIA	ETF	76.43	76.5	74.8	75.03	30933800.0
2009-02-19	GLD	ETF	95.91	96.57	95.43	95.77	21305400.0
2009-02-19	TLT	ETF	102.69	104.06	102.23	102.92	3219400.0
2009-02-19	AAXJ	ETF	30.3	30.3	29.36	29.41	436100.0
2009-02-19	ACWI	ETF	27.97	28.08	27.16	27.19	109000.0
2009-02-19	ACWX	ETF	25.7	25.864	24.61	25.1	459857.0
2009-02-19	ADRE	ETF	26.0	26.79	25.5	25.5	207188.0
2009-02-19	AFK	ETF	18.91	18.91	18.34	18.34	300.0
2009-02-19	AGG	ETF	101.6	101.7	101.26	101.5	532400.0
2009-02-19	AGQ	ETF	95.06	95.94	91.8	93.8	76250.0
2009-02-19	AGZ	ETF	107.5049	107.74	107.18	107.54	4377.0
2009-02-19	AIA	ETF	23.25	23.49	22.72	22.72	11464.0
2009-02-19	AIQ	ETF	45.7	46.3	44.95	45.45	24298.0
2009-02-19	AIS	ETF	0.39	0.4	0.39	0.4	57051.0
2009-02-19	AIVI	ETF	28.02	28.02	27.12	27.25	16500.0
2009-02-19	AOA	ETF	21.6	21.6	20.99	21.27	21200.0
2009-02-19	AOK	ETF	24.72	24.72	24.59	24.59	1860.0
2009-02-19	AOM	ETF	23.77	23.8	23.68	23.72	3003.0
2009-02-19	AOR	ETF	22.9	22.9	22.58	22.58	5542.0
2009-02-19	ARB	ETF	13.37	13.48	12.93	13.0	300089.0
2009-02-19	BAL	ETF	25.72	25.72	25.6899	25.6899	216.0
2009-02-19	BBH	ETF	58.3867	58.3867	58.0433	58.1233	56700.0
2009-02-19	BIL	ETF	91.72	91.8	91.7	91.78	641800.0
2009-02-19	BITS	ETF	18.8	19.0	18.8	19.0	550.0
2009-02-19	BIV	ETF	76.8	77.47	76.73	76.9	102300.0
2009-02-19	BJK	ETF	14.92	15.04	13.7	14.2	2900.0
2009-02-19	BKF	ETF	23.01	23.4	22.59	22.64	120176.0
2009-02-19	BLV	ETF	73.4	73.55	72.55	73.01	37500.0
2009-02-19	BMVP	ETF	9.9033	9.9955	9.7967	9.81	55210.0
2009-02-19	BND	ETF	76.97	77.07	76.6	76.83	351200.0
2009-02-19	BNE	ETF	2.22	2.53	2.22	2.26	196686.0
2009-02-19	BOSS	ETF	11.4	11.4	10.85	10.85	100.0
2009-02-19	BSV	ETF	78.92	79.04	78.39	78.9	203200.0
2009-02-19	BTF	ETF	42.35	43.4	38.349999999999994	39.9	63784.600000000006
2009-02-19	BWX	ETF	24.75	24.89	24.635	24.635	156018.0
2009-02-19	BWZ	ETF	32.1	32.1	31.86	31.86	10511.0
2009-02-19	CBON	ETF	1.67	1.67	1.28	1.45	37959.0
2009-02-19	CDL	ETF	0.15	0.16	0.13	0.14	677858.0
2009-02-19	CEF	ETF	12.37	12.4	11.88	12.02	2183900.0
2009-02-19	CGO	ETF	9.69	9.7	9.06	9.18	20009.0
2009-02-19	CGW	ETF	12.47	12.64	12.25	12.3	26882.0
2009-02-19	CHB	ETF	0.37	0.38	0.32	0.32	568275.0
2009-02-19	CHI	ETF	8.17	8.37	8.01	8.04	338313.0
2009-02-19	CHIC	ETF	5.02	5.07	4.85	4.85	154593.0
2009-02-19	CHW	ETF	5.95	5.97	5.48	5.58	203417.0
2009-02-19	CHY	ETF	8.22	8.22	7.51	7.67	408800.0
2009-02-19	CMF	ETF	51.45	51.925	51.16	51.5525	14964.0

> showing 50 of 633 rows — these rows as CSV

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