PREVIEW / etf_daily / 2010-02-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-17.parquet
  size:    32 KB
  rows:    729

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-17	SPY	ETF	110.27	110.41	109.74	110.26	168845100.0
2010-02-17	QQQ	ETF	44.5	44.57	44.26	44.57	82691607.0
2010-02-17	IWM	ETF	62.36	62.61	61.99	62.47	50459400.0
2010-02-17	DIA	ETF	103.16	103.44	102.95	103.38	8784900.0
2010-02-17	GLD	ETF	109.66	110.01	108.87	109.25	19593400.0
2010-02-17	TLT	ETF	89.92	90.09	89.08	89.33	4368200.0
2010-02-17	AAXJ	ETF	53.41	53.63	53.29	53.39	57800.0
2010-02-17	ACWI	ETF	41.18	41.18	40.91	41.12	88000.0
2010-02-17	ACWX	ETF	39.44	39.44	39.134	39.3	116541.0
2010-02-17	ADRE	ETF	41.67	41.67	41.18	41.53	298231.0
2010-02-17	AFK	ETF	29.29	29.3	29.26	29.3	3435.0
2010-02-17	AGG	ETF	104.24	104.26	103.91	103.96	509200.0
2010-02-17	AGQ	ETF	101.12	102.24	97.24	98.88	348850.0
2010-02-17	AGZ	ETF	108.43	108.46	108.21	108.35	12670.0
2010-02-17	AIA	ETF	38.65	38.72	38.42	38.56	29282.0
2010-02-17	AIQ	ETF	24.9	26.0	24.8	25.5	27810.0
2010-02-17	AIS	ETF	1.19	1.23	1.17	1.22	225848.0
2010-02-17	AIVI	ETF	40.78	41.38	40.53	40.66	40100.0
2010-02-17	AMJ	ETF	29.9	29.9	29.4055	29.66	450924.0
2010-02-17	AOA	ETF	29.59	29.68	29.57	29.65	13700.0
2010-02-17	AOK	ETF	27.28	27.3599	27.2701	27.309	6310.0
2010-02-17	AOM	ETF	28.02	28.02	27.91	27.96	6046.0
2010-02-17	AOR	ETF	28.58	28.6599	28.56	28.62	12087.0
2010-02-17	ARB	ETF	25.03	25.68	24.85	25.37	228612.0
2010-02-17	BAB	ETF	24.63	24.67	24.5	24.53	152230.0
2010-02-17	BAL	ETF	36.77	36.77	36.5	36.53	7600.0
2010-02-17	BBH	ETF	33.8667	34.45	33.8633	34.31	119400.0
2010-02-17	BIL	ETF	91.74	91.74	91.68	91.68	338900.0
2010-02-17	BITS	ETF	32.04	32.04	31.64	31.9996	1093.0
2010-02-17	BIV	ETF	80.04	80.19	79.81	79.93	120400.0
2010-02-17	BJK	ETF	23.95	24.06	23.75	23.85	15700.0
2010-02-17	BKF	ETF	43.28	43.31	42.69	43.0	195156.0
2010-02-17	BLV	ETF	76.15	76.26	75.69	75.79	16100.0
2010-02-17	BMVP	ETF	12.5233	12.5921	12.5215	12.58	29042.0
2010-02-17	BND	ETF	79.3	79.32	79.04	79.15	660100.0
2010-02-17	BNE	ETF	6.91	6.91	6.78	6.84	215418.0
2010-02-17	BRF	ETF	46.22	46.22	45.2801	45.88	366721.0
2010-02-17	BSV	ETF	80.22	80.26	80.15	80.16	469800.0
2010-02-17	BTF	ETF	67.0	67.16999999999999	66.64999999999999	67.0	4546.2
2010-02-17	BWX	ETF	27.89	27.995	27.785	27.915	249400.0
2010-02-17	BWZ	ETF	35.66	35.69	35.48	35.535	9170.0
2010-02-17	BZQ	ETF	4123.2	4272.0	4110.4	4206.4	778.0
2010-02-17	CEF	ETF	13.7	13.79	13.5	13.51	1149900.0
2010-02-17	CEW	ETF	21.86	21.88	21.77	21.83	211111.0
2010-02-17	CGO	ETF	13.88	14.02	13.88	14.02	24352.0
2010-02-17	CGW	ETF	17.69	17.72	17.5803	17.68	39392.0
2010-02-17	CHI	ETF	12.17	12.19	12.0	12.04	259283.0
2010-02-17	CHIE	ETF	14.1	14.22	14.0999	14.0999	5927.0
2010-02-17	CHII	ETF	14.57	14.61	14.5225	14.6	2922.0
2010-02-17	CHIM	ETF	25.96	25.96	25.64	25.9	7088.0

> showing 50 of 729 rows — these rows as CSV

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