PREVIEW / etf_daily / 2010-02-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-26.parquet
  size:    31 KB
  rows:    723

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-26	SPY	ETF	110.77	111.12	110.11	110.74	173589300.0
2010-02-26	QQQ	ETF	44.6	44.86	44.4	44.76	66222356.0
2010-02-26	IWM	ETF	63.16	63.21	62.46	62.8	60093900.0
2010-02-26	DIA	ETF	103.35	103.61	102.78	103.3	6961100.0
2010-02-26	GLD	ETF	108.89	109.6	108.41	109.43	13033900.0
2010-02-26	TLT	ETF	91.46	92.06	91.41	91.67	4349100.0
2010-02-26	AAXJ	ETF	52.24	52.77	52.0	52.7	380200.0
2010-02-26	ACWI	ETF	40.9	41.09	40.56	40.92	78700.0
2010-02-26	ACWX	ETF	38.82	39.11	38.5518	39.02	69174.0
2010-02-26	ADRE	ETF	40.79	41.2	40.558	41.14	70949.0
2010-02-26	AFK	ETF	28.82	28.99	28.64	28.8	6650.0
2010-02-26	AGG	ETF	104.5	104.65	104.5	104.53	658600.0
2010-02-26	AGQ	ETF	100.74	104.78	99.84	103.72	343400.0
2010-02-26	AGZ	ETF	108.82	108.94	108.694	108.88	9408.0
2010-02-26	AIA	ETF	37.77	37.85	37.52	37.83	10202.0
2010-02-26	AIQ	ETF	25.5	25.5	24.75	24.95	11966.0
2010-02-26	AIS	ETF	1.35	1.35	1.3	1.34	258406.0
2010-02-26	AIVI	ETF	40.1	40.42	40.09	40.37	4800.0
2010-02-26	AMJ	ETF	29.44	29.57	29.28	29.57	487424.0
2010-02-26	AOA	ETF	29.64	29.76	29.57	29.71	5800.0
2010-02-26	AOK	ETF	27.3456	27.42	27.3456	27.42	1914.0
2010-02-26	AOM	ETF	27.9406	28.05	27.94	28.05	5160.0
2010-02-26	AOR	ETF	28.6452	28.74	28.63	28.63	4573.0
2010-02-26	ARB	ETF	21.84	21.91	21.21	21.5	403671.0
2010-02-26	BAB	ETF	24.98	25.05	24.91	24.98	462149.0
2010-02-26	BAL	ETF	39.58	39.78	39.17	39.78	19285.0
2010-02-26	BBH	ETF	33.9367	34.1367	33.7367	34.0433	56700.0
2010-02-26	BIL	ETF	91.7	91.72	91.68	91.72	104250.0
2010-02-26	BITS	ETF	31.64	32.12	31.64	32.1196	1419.0
2010-02-26	BIV	ETF	80.53	80.88	80.53	80.76	70800.0
2010-02-26	BJK	ETF	23.08	23.53	23.08	23.53	4800.0
2010-02-26	BKF	ETF	42.46	43.0	42.35	42.95	129713.0
2010-02-26	BLV	ETF	77.21	77.66	77.21	77.5	21700.0
2010-02-26	BMVP	ETF	12.56	12.581	12.513	12.563	23253.0
2010-02-26	BND	ETF	79.51	79.72	79.51	79.61	936200.0
2010-02-26	BNE	ETF	11.14	11.15	11.13	11.13	1715967.0
2010-02-26	BRF	ETF	44.92	45.3	44.22	45.11	237094.0
2010-02-26	BSV	ETF	80.36	80.44	80.3	80.4	441000.0
2010-02-26	BTF	ETF	67.24999999999999	68.1	66.85	67.85	1865.0
2010-02-26	BWX	ETF	28.005	28.21	27.865	27.985	922630.0
2010-02-26	BWZ	ETF	36.02	36.02	35.65	35.74	15026.0
2010-02-26	BZQ	ETF	4246.4	4352.0	4172.8	4206.4	857.5
2010-02-26	CEF	ETF	13.61	13.67	13.45	13.63	796900.0
2010-02-26	CEW	ETF	21.67	21.824	21.67	21.79	342081.0
2010-02-26	CGO	ETF	14.17	14.37	14.05	14.11	14249.0
2010-02-26	CGW	ETF	17.56	17.61	17.412	17.55	46264.0
2010-02-26	CHI	ETF	12.31	12.33	12.24	12.28	105646.0
2010-02-26	CHIE	ETF	13.85	13.9	13.85	13.89	2070.0
2010-02-26	CHII	ETF	14.43	14.56	14.36	14.56	13626.0
2010-02-26	CHIM	ETF	25.46	25.64	25.34	25.62	7652.0

> showing 50 of 723 rows — these rows as CSV

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