PREVIEW / etf_daily / 2009-10-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-02.parquet
  size:    30 KB
  rows:    672

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-02	SPY	ETF	102.02	103.1	101.99	102.49	224748800.0
2009-10-02	QQQ	ETF	40.72	41.25	40.72	40.88	145291252.0
2009-10-02	IWM	ETF	57.78	58.52	57.53	58.0	66448000.0
2009-10-02	DIA	ETF	94.22	95.27	94.2	94.86	15752800.0
2009-10-02	GLD	ETF	97.84	98.86	97.74	98.37	10475800.0
2009-10-02	TLT	ETF	100.28	100.31	98.88	99.01	4827700.0
2009-10-02	AAXJ	ETF	51.23	51.44	50.51	51.3	314400.0
2009-10-02	ACWI	ETF	39.06	39.68	38.99	39.37	169400.0
2009-10-02	ACWX	ETF	38.17	38.58	37.97	38.32	49302.0
2009-10-02	ADRE	ETF	39.35	40.26	39.29	40.0834	973668.0
2009-10-02	AFK	ETF	28.2	28.3729	28.11	28.285	7431.0
2009-10-02	AGG	ETF	105.01	107.95	104.53	104.62	683700.0
2009-10-02	AGQ	ETF	106.94	112.0	106.62	107.3	235050.0
2009-10-02	AGZ	ETF	109.11	109.11	108.6062	108.658	32391.0
2009-10-02	AIA	ETF	37.08	37.39	36.92	37.32	102186.0
2009-10-02	AIQ	ETF	27.5	28.9	27.25	28.55	64643.0
2009-10-02	AIS	ETF	1.09	1.1	1.06	1.1	358111.0
2009-10-02	AIVI	ETF	40.2	40.89	40.18	40.52	18900.0
2009-10-02	AMJ	ETF	24.58	24.6	24.26	24.57	346497.0
2009-10-02	AOA	ETF	28.0	28.18	28.0	28.11	1600.0
2009-10-02	AOK	ETF	26.89	26.93	26.7	26.8699	25939.0
2009-10-02	AOM	ETF	27.28	27.356	27.2645	27.3299	2990.0
2009-10-02	AOR	ETF	27.57	27.77	27.57	27.6708	8850.0
2009-10-02	ARB	ETF	20.73	21.26	20.5	21.22	317676.0
2009-10-02	BAL	ETF	31.9901	31.9901	31.9901	31.9901	557.0
2009-10-02	BBH	ETF	32.8533	33.2	32.8067	32.8333	264600.0
2009-10-02	BIL	ETF	91.72	91.76	91.7	91.7	108800.0
2009-10-02	BITS	ETF	21.2	21.48	20.8	21.48	1750.0
2009-10-02	BIV	ETF	80.86	80.91	80.4	80.53	106400.0
2009-10-02	BJK	ETF	24.56	25.36	24.24	25.11	141900.0
2009-10-02	BKF	ETF	40.38	41.07	40.06	40.86	108238.0
2009-10-02	BLV	ETF	80.48	80.5	79.66	79.99	122100.0
2009-10-02	BMVP	ETF	11.63	11.69	11.59	11.63	24215.0
2009-10-02	BND	ETF	79.81	79.81	79.33	79.37	787100.0
2009-10-02	BNE	ETF	7.2	7.41	7.12	7.25	181225.0
2009-10-02	BOSS	ETF	21.9	21.9	21.19	21.19	200.0
2009-10-02	BRF	ETF	38.41	39.99	38.18	39.756	643945.0
2009-10-02	BSV	ETF	80.26	80.29	79.93	80.15	351500.0
2009-10-02	BTF	ETF	58.49999999999999	58.49999999999999	57.949999999999996	58.3	5778.6
2009-10-02	BWX	ETF	29.155	29.28	29.075	29.18	243580.0
2009-10-02	BWZ	ETF	37.18	37.21	37.141	37.17	12253.0
2009-10-02	BZQ	ETF	5712.0	5712.0	5312.0	5369.6	303.0
2009-10-02	CEF	ETF	12.76	12.99	12.59	12.66	1435000.0
2009-10-02	CEW	ETF	21.58	21.8	21.55	21.6463	96587.0
2009-10-02	CGO	ETF	13.77	13.93	13.61	13.61	37611.0
2009-10-02	CGW	ETF	17.2	17.254	17.0	17.1296	145060.0
2009-10-02	CHB	ETF	0.415	0.44	0.4	0.43	1960293.0
2009-10-02	CHI	ETF	11.49	11.5596	11.34	11.5	151767.0
2009-10-02	CHIC	ETF	17.49	17.51	17.49	17.49	245360.0
2009-10-02	CHW	ETF	7.55	7.55	7.14	7.48	418756.0

> showing 50 of 672 rows — these rows as CSV

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