PREVIEW / etf_daily / 2010-02-02

all etf daily files

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

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-02	SPY	ETF	109.26	110.59	108.88	110.38	216327900.0
2010-02-02	QQQ	ETF	43.31	43.78	43.03	43.65	110727609.0
2010-02-02	IWM	ETF	60.93	61.56	60.62	61.49	71047700.0
2010-02-02	DIA	ETF	101.95	103.1	101.68	102.88	8891300.0
2010-02-02	GLD	ETF	109.16	109.6	108.61	109.13	14292200.0
2010-02-02	TLT	ETF	91.18	91.45	91.04	91.41	3047500.0
2010-02-02	AAXJ	ETF	53.03	53.7	52.6	53.42	714500.0
2010-02-02	ACWI	ETF	41.2	41.46	40.86	41.45	418700.0
2010-02-02	ACWX	ETF	39.62	40.0	39.45	39.91	90991.0
2010-02-02	ADRE	ETF	41.0	41.3299	40.65	41.17	175601.0
2010-02-02	AFK	ETF	29.1899	29.47	29.18	29.33	21626.0
2010-02-02	AGG	ETF	104.2	104.33	104.19	104.3	619000.0
2010-02-02	AGQ	ETF	109.86	109.92	107.32	108.4	356950.0
2010-02-02	AGZ	ETF	108.44	108.46	108.13	108.4	22151.0
2010-02-02	AIA	ETF	38.02	38.39	37.92	38.27	29667.0
2010-02-02	AIQ	ETF	25.05	26.1	25.0	25.95	46956.0
2010-02-02	AIS	ETF	1.16	1.25	1.14	1.19	850653.0
2010-02-02	AIVI	ETF	41.76	42.19	41.7	42.17	19900.0
2010-02-02	AMJ	ETF	29.38	29.39	28.89	29.26	1017868.0
2010-02-02	AOA	ETF	29.42	29.75	29.42	29.75	4900.0
2010-02-02	AOK	ETF	27.3654	27.4594	27.35	27.4594	3380.0
2010-02-02	AOM	ETF	28.03	28.12	27.94	28.12	7687.0
2010-02-02	AOR	ETF	28.525	28.7894	28.525	28.78	9500.0
2010-02-02	ARB	ETF	25.04	25.4	24.88	25.25	191022.0
2010-02-02	BAB	ETF	24.87	24.94	24.85	24.93	66849.0
2010-02-02	BAL	ETF	32.84	33.935	32.83	33.77	21972.0
2010-02-02	BBH	ETF	34.11	34.5967	33.95	34.5933	105000.0
2010-02-02	BIL	ETF	91.72	91.74	91.7	91.7	170950.0
2010-02-02	BITS	ETF	32.48	32.756	32.168	32.64	1054.0
2010-02-02	BIV	ETF	80.29	80.39	80.17	80.34	72900.0
2010-02-02	BJK	ETF	24.18	24.49	24.18	24.35	17000.0
2010-02-02	BKF	ETF	42.54	43.5	42.52	43.48	425718.0
2010-02-02	BLV	ETF	77.1	77.32	77.01	77.3	15400.0
2010-02-02	BMVP	ETF	12.397	12.534	12.357	12.53	31227.0
2010-02-02	BND	ETF	79.28	79.38	79.19	79.35	573000.0
2010-02-02	BNE	ETF	6.34	6.36	6.1	6.22	358784.0
2010-02-02	BOSS	ETF	20.45	20.45	20.125	20.125	100.0
2010-02-02	BRF	ETF	44.43	45.28	44.035	45.25	926276.0
2010-02-02	BSV	ETF	80.16	80.17	80.09	80.16	486400.0
2010-02-02	BTF	ETF	67.35	67.55	67.05	67.24999999999999	4978.400000000001
2010-02-02	BWX	ETF	28.07	28.176	27.87	28.0896	609560.0
2010-02-02	BWZ	ETF	36.17	36.17	35.9	35.9	44864.0
2010-02-02	BZQ	ETF	4299.2	4406.4	4235.2	4276.8	1274.0
2010-02-02	CEF	ETF	13.3	13.4	13.12	13.23	1164800.0
2010-02-02	CEW	ETF	21.83	21.96	21.83	21.94	3595694.0
2010-02-02	CGO	ETF	13.33	14.1	13.33	14.1	26686.0
2010-02-02	CGW	ETF	17.86	18.12	17.81	18.11	62497.0
2010-02-02	CHI	ETF	12.46	12.49	12.3	12.42	194195.0
2010-02-02	CHIE	ETF	13.82	14.03	13.79	14.03	31080.0
2010-02-02	CHII	ETF	14.62	14.7991	14.6	14.7955	43727.0

> showing 50 of 714 rows — these rows as CSV

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