PREVIEW / etf_daily / 2010-02-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-25.parquet
  size:    32 KB
  rows:    726

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-25	SPY	ETF	109.24	110.75	108.94	110.67	259634700.0
2010-02-25	QQQ	ETF	44.11	44.7	43.83	44.6	97961296.0
2010-02-25	IWM	ETF	62.18	63.12	61.98	63.06	51949700.0
2010-02-25	DIA	ETF	102.25	103.34	101.92	103.3	10052900.0
2010-02-25	GLD	ETF	106.7	108.7	106.6	108.31	23400400.0
2010-02-25	TLT	ETF	91.18	91.29	90.9	91.2	3707700.0
2010-02-25	AAXJ	ETF	51.41	52.41	51.36	52.26	172100.0
2010-02-25	ACWI	ETF	40.37	40.73	40.12	40.7	205300.0
2010-02-25	ACWX	ETF	38.25	38.78	38.1	38.78	139889.0
2010-02-25	ADRE	ETF	39.93	40.74	39.69	40.68	134000.0
2010-02-25	AFK	ETF	28.18	28.54	28.0938	28.54	7024.0
2010-02-25	AGG	ETF	104.46	104.51	104.23	104.51	658800.0
2010-02-25	AGQ	ETF	94.28	100.32	94.06	99.42	260200.0
2010-02-25	AGZ	ETF	108.74	108.81	108.74	108.81	11813.0
2010-02-25	AIA	ETF	37.34	37.6648	36.93	37.6648	18037.0
2010-02-25	AIQ	ETF	25.35	25.55	25.2875	25.55	9523.0
2010-02-25	AIS	ETF	1.28	1.34	1.22	1.33	368886.0
2010-02-25	AIVI	ETF	39.61	40.0	39.4	39.97	46800.0
2010-02-25	AMJ	ETF	29.16	29.34	28.905	29.32	796822.0
2010-02-25	AOA	ETF	29.17	29.51	29.16	29.47	14100.0
2010-02-25	AOK	ETF	27.26	27.28	27.19	27.2452	9446.0
2010-02-25	AOM	ETF	27.78	27.97	27.7765	27.97	16029.0
2010-02-25	AOR	ETF	28.43	28.6215	28.3601	28.599	16155.0
2010-02-25	ARB	ETF	21.85	22.14	21.5	21.76	308276.0
2010-02-25	BAB	ETF	24.92	24.93	24.84	24.93	167224.0
2010-02-25	BAL	ETF	38.02	39.41	37.85	39.32	7024.0
2010-02-25	BBH	ETF	33.5833	33.9133	33.4967	33.9133	98700.0
2010-02-25	BIL	ETF	91.7	91.72	91.7	91.72	67250.0
2010-02-25	BITS	ETF	31.04	32.0	30.2	32.0	1980.0
2010-02-25	BIV	ETF	80.53	80.65	80.46	80.58	95400.0
2010-02-25	BJK	ETF	22.92	23.18	22.75	23.16	12600.0
2010-02-25	BKF	ETF	41.48	42.56	41.42	42.5	393685.0
2010-02-25	BLV	ETF	77.38	77.38	76.76	77.1	20200.0
2010-02-25	BMVP	ETF	12.42	12.573	12.389	12.56	15067.0
2010-02-25	BND	ETF	79.52	79.52	79.38	79.52	858200.0
2010-02-25	BNE	ETF	11.15	11.15	11.13	11.14	3696843.0
2010-02-25	BRF	ETF	43.59	44.5	43.3	44.31	637813.0
2010-02-25	BSV	ETF	80.35	80.4	80.31	80.36	481000.0
2010-02-25	BTF	ETF	66.75	67.39999999999999	66.64999999999999	67.35	3611.8
2010-02-25	BWX	ETF	27.995	28.125	27.945	28.035	184224.0
2010-02-25	BWZ	ETF	35.45	35.66	35.41	35.5374	23270.0
2010-02-25	BZQ	ETF	4572.8	4606.4	4248.0	4307.2	1531.0
2010-02-25	CEF	ETF	13.23	13.58	13.22	13.51	955100.0
2010-02-25	CEW	ETF	21.57	21.68	21.5301	21.68	71509.0
2010-02-25	CGO	ETF	14.32	14.33	14.1	14.15	14745.0
2010-02-25	CGW	ETF	17.29	17.61	17.11	17.61	55204.0
2010-02-25	CHI	ETF	12.25	12.32	12.2	12.27	157458.0
2010-02-25	CHIE	ETF	13.51	13.74	13.47	13.74	11924.0
2010-02-25	CHII	ETF	14.19	14.44	14.14	14.44	7528.0
2010-02-25	CHIM	ETF	24.94	24.96	24.86	24.96	384.0

> showing 50 of 726 rows — these rows as CSV

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