PREVIEW / etf_daily / 2010-02-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-04.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-04	SPY	ETF	108.98	109.03	106.42	106.44	356715700.0
2010-02-04	QQQ	ETF	43.58	43.66	42.62	42.62	151652403.0
2010-02-04	IWM	ETF	60.66	60.68	58.99	59.04	99167300.0
2010-02-04	DIA	ETF	101.95	102.07	100.01	100.04	16419300.0
2010-02-04	GLD	ETF	106.79	106.8	103.75	104.37	39991900.0
2010-02-04	TLT	ETF	90.99	91.82	90.9	91.78	6095000.0
2010-02-04	AAXJ	ETF	52.7	52.75	51.26	51.34	395800.0
2010-02-04	ACWI	ETF	40.44	40.58	39.61	39.61	366800.0
2010-02-04	ACWX	ETF	38.92	38.92	37.9	37.97	105164.0
2010-02-04	ADRE	ETF	40.39	40.39	38.89	39.03	387434.0
2010-02-04	AFK	ETF	29.0	29.0	28.08	28.37	36424.0
2010-02-04	AGG	ETF	104.28	104.52	104.22	104.36	595300.0
2010-02-04	AGQ	ETF	100.5	100.54	90.96	91.12	734100.0
2010-02-04	AGZ	ETF	108.47	108.54	108.305	108.4461	6440.0
2010-02-04	AIA	ETF	38.02	38.02	36.84	36.86	72553.0
2010-02-04	AIQ	ETF	24.95	25.2	24.1	24.35	23896.0
2010-02-04	AIS	ETF	1.17	1.19	1.1	1.11	335847.0
2010-02-04	AIVI	ETF	41.22	41.22	40.0	40.0	88000.0
2010-02-04	AMJ	ETF	29.34	29.34	28.25	28.49	832715.0
2010-02-04	AOA	ETF	29.28	29.28	28.57	28.57	27600.0
2010-02-04	AOK	ETF	27.22	27.22	27.12	27.125	3680.0
2010-02-04	AOM	ETF	27.83	27.83	27.59	27.59	20604.0
2010-02-04	AOR	ETF	28.3	28.3	28.05	28.085	5146.0
2010-02-04	ARB	ETF	25.0	25.14	24.51	24.55	188964.0
2010-02-04	BAB	ETF	24.9	24.985	24.8	24.97	159229.0
2010-02-04	BAL	ETF	33.74	33.74	33.5	33.62	3323.0
2010-02-04	BBH	ETF	34.0933	34.1633	33.3767	33.43	144900.0
2010-02-04	BIL	ETF	91.72	91.74	91.72	91.74	155750.0
2010-02-04	BITS	ETF	32.4076	32.436	31.44	31.888	3406.0
2010-02-04	BIV	ETF	80.13	80.58	80.13	80.57	96700.0
2010-02-04	BJK	ETF	23.67	23.73	22.82	22.82	9500.0
2010-02-04	BKF	ETF	42.41	42.56	40.75	40.89	1010402.0
2010-02-04	BLV	ETF	77.09	77.5	76.83	77.33	21700.0
2010-02-04	BMVP	ETF	12.4	12.4	12.1	12.1	32231.0
2010-02-04	BND	ETF	79.37	79.52	79.37	79.45	428800.0
2010-02-04	BNE	ETF	6.22	6.26	5.65	5.85	359309.0
2010-02-04	BRF	ETF	44.1	44.1	41.7983	41.85	588665.0
2010-02-04	BSV	ETF	80.13	80.24	80.1	80.22	393000.0
2010-02-04	BTF	ETF	66.3	66.3	63.89999999999999	63.89999999999999	10237.0
2010-02-04	BWX	ETF	27.795	28.04	27.795	27.835	569896.0
2010-02-04	BWZ	ETF	35.79	35.79	35.59	35.725	38491.0
2010-02-04	BZQ	ETF	4569.6	4939.2	4564.8	4912.0	1034.0
2010-02-04	CEF	ETF	12.88	12.91	12.5	12.55	2397200.0
2010-02-04	CEW	ETF	21.62	21.6995	21.5	21.57	420725.0
2010-02-04	CGO	ETF	14.01	14.01	13.33	13.33	39227.0
2010-02-04	CGW	ETF	17.66	17.81	17.3	17.3	82137.0
2010-02-04	CHI	ETF	12.36	12.53	12.27	12.53	221936.0
2010-02-04	CHIE	ETF	13.75	13.75	13.37	13.38	5415.0
2010-02-04	CHII	ETF	14.5	14.5	14.09	14.09	25524.0
2010-02-04	CHIM	ETF	24.98	24.98	24.34	24.34	429.0

> showing 50 of 717 rows — these rows as CSV

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