PREVIEW / etf_daily / 2010-02-01

all etf daily files

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

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-01	SPY	ETF	108.15	109.07	107.5	109.06	187865000.0
2010-02-01	QQQ	ETF	42.91	43.2807	42.88	43.26	136827088.0
2010-02-01	IWM	ETF	60.39	60.94	60.16	60.82	60731800.0
2010-02-01	DIA	ETF	101.21	102.35	101.07	101.84	9985500.0
2010-02-01	GLD	ETF	106.64	108.48	106.37	108.35	14901900.0
2010-02-01	TLT	ETF	91.71	91.73	91.05	91.15	3598500.0
2010-02-01	AAXJ	ETF	52.31	53.07	52.31	53.07	204100.0
2010-02-01	ACWI	ETF	40.41	40.85	40.41	40.79	172900.0
2010-02-01	ACWX	ETF	38.91	39.32	38.91	39.3	51708.0
2010-02-01	ADRE	ETF	40.01	40.85	40.01	40.74	345569.0
2010-02-01	AFK	ETF	28.5	29.0	28.44	28.9	22571.0
2010-02-01	AGG	ETF	104.36	104.4	104.13	104.18	501300.0
2010-02-01	AGQ	ETF	104.06	108.7	103.18	108.56	338150.0
2010-02-01	AGZ	ETF	108.37	108.43	108.13	108.42	52633.0
2010-02-01	AIA	ETF	37.75	38.32	37.75	38.32	12732.0
2010-02-01	AIQ	ETF	24.95	25.65	24.65	25.1	21498.0
2010-02-01	AIS	ETF	1.18	1.2	1.14	1.17	237603.0
2010-02-01	AIVI	ETF	41.38	41.56	41.31	41.55	46800.0
2010-02-01	AMJ	ETF	28.78	29.19	28.52	29.17	733264.0
2010-02-01	AOA	ETF	29.16	29.35	29.16	29.34	11700.0
2010-02-01	AOK	ETF	27.274	27.37	27.274	27.3518	3400.0
2010-02-01	AOM	ETF	27.87	27.97	27.83	27.964	15555.0
2010-02-01	AOR	ETF	28.34	28.54	28.34	28.54	19965.0
2010-02-01	ARB	ETF	25.31	25.69	24.95	25.05	175961.0
2010-02-01	BAB	ETF	24.9	24.92	24.79	24.8	99594.0
2010-02-01	BAL	ETF	33.76	33.78	33.3	33.3	12525.0
2010-02-01	BBH	ETF	34.26	34.26	33.9833	34.11	204600.0
2010-02-01	BIL	ETF	91.7	91.74	91.7	91.72	364350.0
2010-02-01	BITS	ETF	32.48	32.912	32.48	32.48	1737.0
2010-02-01	BIV	ETF	80.34	80.34	80.05	80.16	135800.0
2010-02-01	BJK	ETF	23.92	24.31	23.92	24.31	5900.0
2010-02-01	BKF	ETF	41.67	42.64	41.61	42.48	676832.0
2010-02-01	BLV	ETF	77.49	77.49	76.83	76.98	24500.0
2010-02-01	BMVP	ETF	12.26	12.38	12.26	12.38	13593.0
2010-02-01	BND	ETF	79.4	79.41	79.24	79.3	437300.0
2010-02-01	BNE	ETF	6.62	6.63	6.25	6.31	267055.0
2010-02-01	BRF	ETF	42.17	43.94	42.17	43.66	664688.0
2010-02-01	BSV	ETF	80.17	80.18	80.06	80.13	670500.0
2010-02-01	BTF	ETF	67.89999999999999	68.15	67.3	67.35	10010.2
2010-02-01	BWX	ETF	28.075	28.1546	27.945	27.9675	1286540.0
2010-02-01	BWZ	ETF	36.11	36.11	35.75	35.93	59509.0
2010-02-01	BZQ	ETF	4724.8	4724.8	4396.8	4411.2	826.0
2010-02-01	CEF	ETF	12.93	13.26	12.84	13.19	1162900.0
2010-02-01	CEW	ETF	21.75	21.8699	21.72	21.8655	77474.0
2010-02-01	CGO	ETF	13.74	13.81	13.4	13.74	44854.0
2010-02-01	CGW	ETF	17.81	17.96	17.751	17.85	128407.0
2010-02-01	CHI	ETF	12.32	12.39	12.27	12.38	87817.0
2010-02-01	CHIE	ETF	13.58	13.78	13.58	13.7589	5307.0
2010-02-01	CHII	ETF	14.45	14.6	14.4	14.5999	29764.0
2010-02-01	CHIM	ETF	24.58	24.74	24.38	24.62	6025.0

> showing 50 of 720 rows — these rows as CSV

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