PREVIEW / etf_daily / 2010-01-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-29.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-01-29	SPY	ETF	109.04	109.8	107.22	107.39	310677600.0
2010-01-29	QQQ	ETF	43.9	44.02	42.63	42.79	212125976.0
2010-01-29	IWM	ETF	61.03	61.69	59.97	60.11	79325600.0
2010-01-29	DIA	ETF	101.56	102.36	100.41	100.55	14556900.0
2010-01-29	GLD	ETF	105.88	106.3	105.27	105.96	20278800.0
2010-01-29	TLT	ETF	91.41	92.36	91.25	92.31	4930600.0
2010-01-29	AAXJ	ETF	53.18	53.5	51.92	52.07	262800.0
2010-01-29	ACWI	ETF	40.69	40.98	39.95	40.05	625200.0
2010-01-29	ACWX	ETF	39.13	39.33	38.37	38.52	73292.0
2010-01-29	ADRE	ETF	40.81	40.81	39.41	39.72	286369.0
2010-01-29	AFK	ETF	28.19	28.6499	27.78	27.78	5880.0
2010-01-29	AGG	ETF	104.34	104.72	104.32	104.65	748600.0
2010-01-29	AGQ	ETF	102.2	103.82	100.26	102.64	248400.0
2010-01-29	AGZ	ETF	108.32	108.75	108.308	108.68	8290.0
2010-01-29	AIA	ETF	37.93	38.29	37.4	37.41	40397.0
2010-01-29	AIQ	ETF	24.3	25.25	23.45	25.15	64009.0
2010-01-29	AIS	ETF	1.18	1.19	1.13	1.15	240422.0
2010-01-29	AIVI	ETF	41.55	41.66	40.6	40.78	27000.0
2010-01-29	AMJ	ETF	29.4	29.4	28.5	28.62	544106.0
2010-01-29	AOA	ETF	29.39	29.44	28.86	28.92	10100.0
2010-01-29	AOK	ETF	27.23	27.374	27.23	27.2581	6081.0
2010-01-29	AOM	ETF	27.96	28.03	27.7304	27.81	12063.0
2010-01-29	AOR	ETF	28.56	28.63	28.24	28.24	9891.0
2010-01-29	ARB	ETF	25.44	25.83	24.96	25.31	174200.0
2010-01-29	BAB	ETF	24.78	24.93	24.76	24.91	76459.0
2010-01-29	BAL	ETF	34.06	34.06	33.75	33.76	2776.0
2010-01-29	BBH	ETF	34.0	34.2633	33.91	34.1733	186300.0
2010-01-29	BIL	ETF	91.72	91.74	91.7	91.74	190750.0
2010-01-29	BITS	ETF	32.88	32.88	31.992	32.48	1326.0
2010-01-29	BIV	ETF	80.36	80.71	80.25	80.7	79400.0
2010-01-29	BJK	ETF	24.37	24.37	23.75	23.75	11100.0
2010-01-29	BKF	ETF	42.27	42.53	40.9	41.03	539675.0
2010-01-29	BLV	ETF	77.43	77.94	77.35	77.68	39000.0
2010-01-29	BMVP	ETF	12.373	12.473	12.209	12.21	31268.0
2010-01-29	BND	ETF	79.44	79.64	79.4	79.6	469400.0
2010-01-29	BNE	ETF	6.45	7.0	6.42	6.57	445029.0
2010-01-29	BRF	ETF	42.81	42.87	41.32	41.83	775707.0
2010-01-29	BSV	ETF	80.17	80.34	80.13	80.34	665900.0
2010-01-29	BTF	ETF	67.14999999999999	67.89999999999999	66.64999999999999	67.64999999999999	9078.0
2010-01-29	BWX	ETF	28.06	28.24	27.98	28.0	377926.0
2010-01-29	BWZ	ETF	36.08	36.08	35.77	35.77	27638.0
2010-01-29	BZQ	ETF	4512.0	4883.2	4460.8	4838.4	696.0
2010-01-29	CEF	ETF	12.95	12.98	12.76	12.83	1465500.0
2010-01-29	CEW	ETF	21.76	21.8475	21.68	21.75	36429.0
2010-01-29	CGO	ETF	13.78	14.06	13.61	13.77	39604.0
2010-01-29	CGW	ETF	17.69	17.8599	17.4419	17.51	102257.0
2010-01-29	CHI	ETF	12.44	12.45	12.26	12.29	146360.0
2010-01-29	CHIE	ETF	13.65	13.69	13.29	13.32	9901.0
2010-01-29	CHII	ETF	14.2749	14.35	14.04	14.06	31543.0
2010-01-29	CHIM	ETF	24.44	24.5	24.1198	24.1198	760.0

> showing 50 of 717 rows — these rows as CSV

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