PREVIEW / etf_daily / 2013-10-03

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-03.parquet
  size:    41 KB
  rows:    1,015

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
2013-10-03	SPY	ETF	168.79	168.94	166.84	167.62	176698000.0
2013-10-03	QQQ	ETF	79.55	79.72	78.3	78.72	42998195.0
2013-10-03	IWM	ETF	107.21	107.36	105.6	106.31	57799200.0
2013-10-03	DIA	ETF	150.66	150.76	149.17	149.67	10949200.0
2013-10-03	GLD	ETF	126.77	127.69	126.22	127.18	11632900.0
2013-10-03	TLT	ETF	105.75	106.41	105.7	105.79	6648900.0
2013-10-03	AAXJ	ETF	59.89	59.99	59.02	59.4	353500.0
2013-10-03	ACTV	ETF	14.38	14.41	14.35	14.37	1097050.0
2013-10-03	ACWI	ETF	54.31	54.32	53.76	53.96	1012100.0
2013-10-03	ACWV	ETF	61.89	61.89	61.53	61.69	57300.0
2013-10-03	ACWX	ETF	45.16	45.21	44.84	44.94	130471.0
2013-10-03	ADRE	ETF	37.75	37.78	37.3	37.491	14886.0
2013-10-03	AFK	ETF	30.23	30.2662	30.05	30.2044	7509.0
2013-10-03	AGEM	ETF	22.55	22.55	22.49	22.49	751.0
2013-10-03	AGG	ETF	106.96	107.22	106.96	107.15	905000.0
2013-10-03	AGQ	ETF	80.12	81.36	78.96	80.28	450275.0
2013-10-03	AGZ	ETF	110.92	111.1699	110.92	111.15	13258.0
2013-10-03	AIA	ETF	47.64	47.6699	47.15	47.36	30228.0
2013-10-03	AIQ	ETF	29.46	30.05	28.52	28.73	15271.0
2013-10-03	AIVI	ETF	45.49	45.56	45.34	45.38	16600.0
2013-10-03	AMJ	ETF	44.82	45.08	44.46	44.64	432143.0
2013-10-03	AMLP	ETF	88.5	88.75	87.9	88.1	499120.0
2013-10-03	ANGL	ETF	26.36	26.36	26.32	26.36	4200.0
2013-10-03	AOA	ETF	42.08	42.11	41.78	41.9	44700.0
2013-10-03	AOK	ETF	31.32	31.35	31.29	31.3465	21836.0
2013-10-03	AOM	ETF	33.32	33.32	33.171	33.24	11434.0
2013-10-03	AOR	ETF	36.883	36.883	36.632	36.74	125379.0
2013-10-03	ARGT	ETF	20.08	20.08	19.66	19.86	15100.0
2013-10-03	ASEA	ETF	16.63	16.64	16.49	16.58	11900.0
2013-10-03	ATMP	ETF	26.2	26.21	26.05	26.21	15400.0
2013-10-03	AVIV	ETF	23.04	23.26	22.64	22.95	110953.0
2013-10-03	AWAY	ETF	27.48	30.5	27.45	29.65	5066608.0
2013-10-03	BAB	ETF	27.24	27.42	27.1601	27.4	733234.0
2013-10-03	BAL	ETF	56.04	56.2	55.961	56.06	5569.0
2013-10-03	BALT	ETF	5.24	5.38	5.1	5.29	1122603.0
2013-10-03	BBH	ETF	83.48	83.66	81.41	82.22	80500.0
2013-10-03	BCM	ETF	40.284	40.284	40.284	40.284	108.0
2013-10-03	BFOR	ETF	6.8775	6.8825	6.7825	6.8275	253600.0
2013-10-03	BIB	ETF	33.86	33.9625	32.0928	32.9025	223056.0
2013-10-03	BICK	ETF	24.06	24.09	23.902	23.902	1914.0
2013-10-03	BIL	ETF	91.6	91.6	91.58	91.6	1240550.0
2013-10-03	BIS	ETF	984.8	1028.8	984.8	1008.8	538.5
2013-10-03	BIV	ETF	83.37	83.6	83.27	83.44	122100.0
2013-10-03	BIZD	ETF	20.19	20.19	19.93	20.05	6000.0
2013-10-03	BJK	ETF	48.49	48.71	47.97	48.34	22400.0
2013-10-03	BKF	ETF	38.0	38.04	37.5	37.69	83817.0
2013-10-03	BKLN	ETF	24.7	24.71	24.66	24.7	1598000.0
2013-10-03	BLV	ETF	82.74	83.04	82.72	82.77	87300.0
2013-10-03	BMVP	ETF	20.343	20.343	20.106	20.27	35759.0
2013-10-03	BND	ETF	80.63	80.76	80.62	80.74	6070900.0

> showing 50 of 1,015 rows — these rows as CSV

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