PREVIEW / etf_daily / 2010-01-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-07.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-01-07	SPY	ETF	113.5	114.33	113.18	114.19	131091100.0
2010-01-07	QQQ	ETF	46.2	46.27	45.92	46.17	77094032.0
2010-01-07	IWM	ETF	63.74	64.22	63.14	64.17	56123500.0
2010-01-07	DIA	ETF	105.38	106.02	104.95	105.94	6312000.0
2010-01-07	GLD	ETF	111.07	111.29	110.62	110.82	13609800.0
2010-01-07	TLT	ETF	89.22	89.64	89.12	89.33	2793200.0
2010-01-07	AAXJ	ETF	57.64	57.67	57.22	57.48	236300.0
2010-01-07	ACWI	ETF	43.42	43.46	43.08	43.3	113400.0
2010-01-07	ACWX	ETF	42.1	42.15	41.88	42.06	165923.0
2010-01-07	ADRE	ETF	45.54	45.54	45.14	45.33	152737.0
2010-01-07	AFK	ETF	29.59	29.6	29.3	29.5	10248.0
2010-01-07	AGG	ETF	103.66	103.71	103.47	103.6	705700.0
2010-01-07	AGQ	ETF	130.52	132.94	129.64	130.86	189400.0
2010-01-07	AGZ	ETF	107.96	108.47	107.7	107.85	10582.0
2010-01-07	AIA	ETF	41.25	41.25	40.73	40.92	62754.0
2010-01-07	AIQ	ETF	26.95	27.3	26.5	26.95	57615.0
2010-01-07	AIS	ETF	1.16	1.16	1.11	1.11	378589.0
2010-01-07	AIVI	ETF	44.4	44.4	43.98	44.17	27200.0
2010-01-07	AMJ	ETF	29.59	29.8	29.22	29.25	272660.0
2010-01-07	AOA	ETF	30.59	30.67	30.46	30.66	21000.0
2010-01-07	AOK	ETF	27.5799	27.5999	27.52	27.5601	11947.0
2010-01-07	AOM	ETF	28.51	28.53	28.458	28.5101	14382.0
2010-01-07	AOR	ETF	29.42	29.47	29.3	29.47	12356.0
2010-01-07	ARB	ETF	26.41	28.77	26.26	27.26	949468.0
2010-01-07	BAB	ETF	24.22	24.25	24.16	24.21	220821.0
2010-01-07	BAL	ETF	35.9	35.9	35.69	35.805	2408.0
2010-01-07	BBH	ETF	32.7933	33.0167	32.4633	32.8833	265500.0
2010-01-07	BIL	ETF	91.68	91.7	91.68	91.68	264350.0
2010-01-07	BITS	ETF	31.44	32.0	31.44	32.0	2361.0
2010-01-07	BIV	ETF	79.61	79.62	79.42	79.5	113400.0
2010-01-07	BJK	ETF	24.73	25.11	24.73	25.11	7000.0
2010-01-07	BKF	ETF	47.61	47.7	47.32	47.36	860538.0
2010-01-07	BLV	ETF	76.21	76.39	76.04	76.15	32700.0
2010-01-07	BMVP	ETF	12.9233	12.9767	12.8871	12.9767	12501.0
2010-01-07	BND	ETF	78.72	78.87	78.72	78.82	661700.0
2010-01-07	BNE	ETF	7.2	7.31	7.03	7.28	178086.0
2010-01-07	BOSS	ETF	20.8	20.955	20.8	20.955	300.0
2010-01-07	BRF	ETF	50.4	50.6	49.65	49.65	1418573.0
2010-01-07	BSV	ETF	79.89	79.89	79.69	79.77	414500.0
2010-01-07	BTF	ETF	64.5005	64.6995	64.25	64.5	3520.0
2010-01-07	BWX	ETF	28.425	28.455	28.33	28.415	442634.0
2010-01-07	BWZ	ETF	36.6	36.6	36.24	36.25	209605.0
2010-01-07	BZQ	ETF	3444.8	3512.0	3444.8	3486.4	156.0
2010-01-07	CEF	ETF	14.45	14.51	14.38	14.49	759600.0
2010-01-07	CEW	ETF	22.25	22.25	22.18	22.23	332842.0
2010-01-07	CGO	ETF	14.77	14.88	14.62	14.79	24160.0
2010-01-07	CGW	ETF	18.7	18.71	18.56	18.62	56569.0
2010-01-07	CHI	ETF	12.52	12.72	12.52	12.61	206121.0
2010-01-07	CHIE	ETF	16.15	16.16	16.04	16.1	22559.0
2010-01-07	CHII	ETF	16.34	16.34	16.1618	16.23	21140.0

> showing 50 of 714 rows — these rows as CSV

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