PREVIEW / etf_daily / 2010-02-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-11.parquet
  size:    31 KB
  rows:    717

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-11	SPY	ETF	106.87	108.25	106.25	108.13	223591600.0
2010-02-11	QQQ	ETF	43.01	43.79	42.76	43.67	93050785.0
2010-02-11	IWM	ETF	59.46	60.62	59.0	60.58	51969700.0
2010-02-11	DIA	ETF	100.42	101.75	99.87	101.58	9934200.0
2010-02-11	GLD	ETF	105.58	107.56	105.27	107.13	19350100.0
2010-02-11	TLT	ETF	90.2	90.28	89.38	89.82	5087500.0
2010-02-11	AAXJ	ETF	51.71	52.67	51.63	52.5	176700.0
2010-02-11	ACWI	ETF	39.78	40.37	39.61	40.37	124400.0
2010-02-11	ACWX	ETF	38.12	38.65	37.77	38.6	87930.0
2010-02-11	ADRE	ETF	39.98	40.75	39.55	40.75	166095.0
2010-02-11	AFK	ETF	28.77	28.95	28.7	28.91	7492.0
2010-02-11	AGG	ETF	104.04	104.1	103.82	104.0	547400.0
2010-02-11	AGQ	ETF	90.38	95.5	89.2	94.6	482850.0
2010-02-11	AGZ	ETF	108.35	108.35	108.16	108.33	19400.0
2010-02-11	AIA	ETF	37.54	38.11	37.54	38.09	14871.0
2010-02-11	AIQ	ETF	24.25	25.25	23.85	25.2	19144.0
2010-02-11	AIS	ETF	1.1	1.15	1.08	1.14	256246.0
2010-02-11	AIVI	ETF	39.88	40.41	39.51	40.33	16400.0
2010-02-11	AMJ	ETF	28.17	28.5	28.02	28.5	312265.0
2010-02-11	AOA	ETF	28.67	29.1	28.67	29.07	7900.0
2010-02-11	AOK	ETF	27.08	27.17	27.0799	27.1699	4087.0
2010-02-11	AOM	ETF	27.64	27.75	27.567	27.69	23827.0
2010-02-11	AOR	ETF	28.066	28.29	28.06	28.29	24972.0
2010-02-11	ARB	ETF	24.69	25.05	24.43	24.94	128072.0
2010-02-11	BAB	ETF	24.76	24.77	24.6	24.63	357587.0
2010-02-11	BAL	ETF	36.09	36.09	35.41	35.655	17621.0
2010-02-11	BBH	ETF	33.0	33.7667	33.0	33.6233	224400.0
2010-02-11	BIL	ETF	91.74	91.74	91.72	91.74	109900.0
2010-02-11	BITS	ETF	32.0	32.16	31.2	31.4	1964.0
2010-02-11	BIV	ETF	80.07	80.1	79.81	79.99	145300.0
2010-02-11	BJK	ETF	23.06	23.53	23.01	23.53	11600.0
2010-02-11	BKF	ETF	41.57	42.3	41.0	42.21	197667.0
2010-02-11	BLV	ETF	76.27	76.3	75.6	75.9	27400.0
2010-02-11	BMVP	ETF	12.12	12.29	12.08	12.28	19912.0
2010-02-11	BND	ETF	79.19	79.21	78.97	79.12	505300.0
2010-02-11	BNE	ETF	6.2	6.32	6.0	6.31	180071.0
2010-02-11	BRF	ETF	43.82	44.809	43.539	44.66	551622.0
2010-02-11	BSV	ETF	80.12	80.14	80.06	80.12	637500.0
2010-02-11	BTF	ETF	65.25	66.35	64.8	66.35	4303.2
2010-02-11	BWX	ETF	27.915	27.915	27.65	27.91	3790788.0
2010-02-11	BWZ	ETF	35.62	35.7199	35.46	35.71	15653.0
2010-02-11	BZQ	ETF	4632.0	4723.2	4358.4	4411.2	882.5
2010-02-11	CEF	ETF	13.02	13.33	12.96	13.31	848500.0
2010-02-11	CEW	ETF	21.65	21.75	21.5801	21.71	129601.0
2010-02-11	CGO	ETF	13.44	13.79	13.37	13.62	32109.0
2010-02-11	CGW	ETF	17.28	17.48	17.11	17.48	67708.0
2010-02-11	CHI	ETF	12.02	12.1	11.97	12.0595	131344.0
2010-02-11	CHIE	ETF	13.72	13.92	13.72	13.91	4400.0
2010-02-11	CHII	ETF	14.42	14.575	14.33	14.57	5778.0
2010-02-11	CHIM	ETF	24.7	24.82	24.7	24.82	2650.0

> showing 50 of 717 rows — these rows as CSV

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