PREVIEW / etf_daily / 2010-02-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-19.parquet
  size:    31 KB
  rows:    727

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
2010-02-19	SPY	ETF	110.62	111.57	110.36	111.14	222684900.0
2010-02-19	QQQ	ETF	44.76	45.05	44.62	44.83	80416418.0
2010-02-19	IWM	ETF	62.74	63.38	62.61	63.06	56840800.0
2010-02-19	DIA	ETF	103.7	104.39	103.42	103.99	9324500.0
2010-02-19	GLD	ETF	109.32	110.39	108.81	109.47	21928700.0
2010-02-19	TLT	ETF	89.24	89.51	88.9	89.45	3502500.0
2010-02-19	AAXJ	ETF	52.88	53.09	52.54	52.87	226900.0
2010-02-19	ACWI	ETF	41.04	41.29	40.85	41.18	97200.0
2010-02-19	ACWX	ETF	38.98	39.35	38.92	39.3	35222.0
2010-02-19	ADRE	ETF	41.33	41.668	41.15	41.42	52986.0
2010-02-19	AFK	ETF	29.3	29.3	29.1301	29.3	11249.0
2010-02-19	AGG	ETF	103.75	104.0	103.69	104.0	501500.0
2010-02-19	AGQ	ETF	100.32	104.88	98.48	102.2	287750.0
2010-02-19	AGZ	ETF	108.05	108.31	108.018	108.06	11054.0
2010-02-19	AIA	ETF	38.17	38.4499	38.137	38.335	21934.0
2010-02-19	AIQ	ETF	25.85	25.9	25.35	25.75	16338.0
2010-02-19	AIS	ETF	1.25	1.25	1.19	1.24	411233.0
2010-02-19	AIVI	ETF	40.32	40.96	40.32	40.96	18800.0
2010-02-19	AMJ	ETF	29.69	29.69	29.48	29.66	229010.0
2010-02-19	AOA	ETF	29.68	29.85	29.6	29.74	11200.0
2010-02-19	AOK	ETF	27.34	27.37	27.3	27.3499	10282.0
2010-02-19	AOM	ETF	27.965	28.03	27.965	28.03	4640.0
2010-02-19	AOR	ETF	28.67	28.73	28.6	28.73	14216.0
2010-02-19	ARB	ETF	22.35	22.78	21.96	22.55	845600.0
2010-02-19	BAB	ETF	24.52	24.56	24.4456	24.53	283516.0
2010-02-19	BAL	ETF	37.83	38.166	37.7	38.01	44621.0
2010-02-19	BBH	ETF	34.48	34.71	34.3633	34.57	84000.0
2010-02-19	BIL	ETF	91.72	91.72	91.68	91.68	287550.0
2010-02-19	BITS	ETF	31.68	31.68	31.6	31.6	1219.0
2010-02-19	BIV	ETF	79.82	79.85	79.61	79.8	97900.0
2010-02-19	BJK	ETF	23.04	23.51	23.0	23.37	15500.0
2010-02-19	BKF	ETF	42.9	43.24	42.7	43.13	176319.0
2010-02-19	BLV	ETF	75.77	76.0	75.59	75.92	18300.0
2010-02-19	BMVP	ETF	12.65	12.73	12.6	12.71	12490.0
2010-02-19	BND	ETF	79.01	79.04	78.88	79.04	509300.0
2010-02-19	BNE	ETF	6.8	6.96	6.72	6.95	424120.0
2010-02-19	BRF	ETF	46.0	46.75	45.71	46.58	494595.0
2010-02-19	BSV	ETF	80.07	80.07	79.96	80.06	517400.0
2010-02-19	BTF	ETF	67.14999999999999	67.4005	66.69999999999999	67.14999999999999	4448.6
2010-02-19	BWX	ETF	27.715	27.845	27.625	27.78	316058.0
2010-02-19	BWZ	ETF	35.3	35.46	35.15	35.45	48923.0
2010-02-19	BZQ	ETF	4132.8	4132.8	3992.0	4057.6	427.0
2010-02-19	CEF	ETF	13.43	13.58	13.22	13.43	1501000.0
2010-02-19	CEW	ETF	21.67	21.809	21.66	21.79	114344.0
2010-02-19	CGO	ETF	14.18	14.27	14.05	14.17	16852.0
2010-02-19	CGW	ETF	17.72	17.7812	17.56	17.703	49013.0
2010-02-19	CHI	ETF	12.06	12.22	12.02	12.03	183969.0
2010-02-19	CHIE	ETF	13.73	13.8099	13.73	13.8099	1600.0
2010-02-19	CHII	ETF	14.41	14.54	14.3501	14.52	8530.0
2010-02-19	CHIM	ETF	25.1	25.26	24.96	25.2	9880.0

> showing 50 of 727 rows — these rows as CSV

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