PREVIEW / etf_daily / 2009-12-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-02.parquet
  size:    31 KB
  rows:    701

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-12-02	SPY	ETF	111.28	112.01	110.92	111.25	132315100.0
2009-12-02	QQQ	ETF	44.16	44.49	43.98	44.07	81653509.0
2009-12-02	IWM	ETF	59.07	60.21	59.06	59.69	71220600.0
2009-12-02	DIA	ETF	104.74	105.25	104.32	104.58	7124600.0
2009-12-02	GLD	ETF	118.8	119.27	118.3	119.18	31109300.0
2009-12-02	TLT	ETF	95.29	95.96	94.99	95.33	2193900.0
2009-12-02	AAXJ	ETF	56.06	56.45	55.97	56.32	133500.0
2009-12-02	ACWI	ETF	42.81	43.09	42.67	42.89	710600.0
2009-12-02	ACWX	ETF	41.81	42.0	41.73	41.88	67347.0
2009-12-02	ADRE	ETF	45.5	45.74	45.162	45.42	85694.0
2009-12-02	AFK	ETF	28.87	29.0	28.6401	29.0	4220.0
2009-12-02	AGG	ETF	105.19	105.3	104.94	105.02	480300.0
2009-12-02	AGQ	ETF	148.78	151.14	146.4	147.78	482450.0
2009-12-02	AGZ	ETF	108.9062	109.0	108.72	108.81	12306.0
2009-12-02	AIA	ETF	39.76	40.0	39.7	39.8	51649.0
2009-12-02	AIQ	ETF	30.05	30.25	28.25	28.55	56526.0
2009-12-02	AIS	ETF	1.11	1.2	1.1	1.19	1165758.0
2009-12-02	AIVI	ETF	44.63	45.05	44.63	44.89	15800.0
2009-12-02	AMJ	ETF	27.06	27.06	26.64	26.756	208208.0
2009-12-02	AOA	ETF	29.88	29.89	29.81	29.89	32600.0
2009-12-02	AOK	ETF	27.64	27.64	27.54	27.56	17035.0
2009-12-02	AOM	ETF	28.54	28.54	28.4	28.4001	32145.0
2009-12-02	AOR	ETF	29.05	29.2095	29.04	29.14	28832.0
2009-12-02	ARB	ETF	21.81	22.23	21.53	21.69	303344.0
2009-12-02	BAB	ETF	24.95	25.09	24.95	25.08	46320.0
2009-12-02	BAL	ETF	36.19	36.275	35.94	36.275	5186.0
2009-12-02	BBH	ETF	32.6633	33.0167	32.6633	32.8533	110400.0
2009-12-02	BIL	ETF	91.74	91.74	91.7	91.7	100950.0
2009-12-02	BITS	ETF	26.84	27.52	26.44	27.4	5672.0
2009-12-02	BIV	ETF	81.14	81.14	80.75	80.86	135900.0
2009-12-02	BJK	ETF	25.14	25.34	25.03	25.18	17000.0
2009-12-02	BKF	ETF	47.1	47.44	46.9415	47.2	130601.0
2009-12-02	BLV	ETF	78.55	78.88	78.29	78.6	51100.0
2009-12-02	BMVP	ETF	12.3306	12.4067	12.2933	12.33	21804.0
2009-12-02	BND	ETF	79.95	79.95	79.72	79.78	463400.0
2009-12-02	BNE	ETF	6.22	6.48	6.03	6.06	121738.0
2009-12-02	BOSS	ETF	19.12	19.4	19.12	19.4	100.0
2009-12-02	BRF	ETF	49.36	49.77	49.0	49.77	276824.0
2009-12-02	BSV	ETF	80.45	80.49	80.27	80.33	367800.0
2009-12-02	BTF	ETF	60.49999999999999	63.25	60.449999999999996	63.099999999999994	2207.6
2009-12-02	BWX	ETF	30.285	30.65	30.1781	30.24	358396.0
2009-12-02	BWZ	ETF	38.3	38.34	37.9	37.93	41732.0
2009-12-02	BZQ	ETF	3577.6	3577.6	3488.0	3510.4	139.5
2009-12-02	CEF	ETF	15.2	15.39	15.2	15.3	1690700.0
2009-12-02	CEW	ETF	22.32	22.44	22.29	22.29	172417.0
2009-12-02	CGO	ETF	14.12	14.21	14.01	14.05	27963.0
2009-12-02	CGW	ETF	18.5	18.7	18.48	18.612	112124.0
2009-12-02	CHI	ETF	12.27	12.42	12.25	12.35	209090.0
2009-12-02	CHII	ETF	16.45	16.45	16.28	16.43	518871.0
2009-12-02	CHIQ	ETF	16.45	18.0	16.36	16.38	139389.0

> showing 50 of 701 rows — these rows as CSV

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