PREVIEW / etf_daily / 2013-10-17

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-17.parquet
  size:    42 KB
  rows:    1,043

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-17	SPY	ETF	171.37	173.32	171.34	173.22	129389000.0
2013-10-17	QQQ	ETF	80.0	80.87	79.95	80.84	32193534.0
2013-10-17	IWM	ETF	108.0	109.46	107.97	109.44	38967200.0
2013-10-17	DIA	ETF	152.11	153.59	152.05	153.48	9916600.0
2013-10-17	GLD	ETF	127.01	127.86	126.81	127.42	11785100.0
2013-10-17	TLT	ETF	106.52	107.12	106.29	106.81	11303400.0
2013-10-17	AADR	ETF	36.03	36.41	36.03	36.24	3600.0
2013-10-17	AAXJ	ETF	60.69	61.27	60.68	61.2	450400.0
2013-10-17	ACTV	ETF	14.36	14.38	14.34	14.38	1904444.0
2013-10-17	ACWI	ETF	55.18	55.73	55.18	55.72	1318800.0
2013-10-17	ACWV	ETF	62.81	63.43	62.81	63.43	31500.0
2013-10-17	ACWX	ETF	45.97	46.37	45.97	46.35	534920.0
2013-10-17	ADRE	ETF	38.5	38.8	38.5	38.8	27116.0
2013-10-17	AFK	ETF	31.35	31.3999	31.09	31.39	38308.0
2013-10-17	AGG	ETF	107.5	107.68	107.44	107.58	1027300.0
2013-10-17	AGQ	ETF	80.04	81.76	80.04	80.68	470000.0
2013-10-17	AGZ	ETF	111.2	111.529	111.1001	111.16	9377.0
2013-10-17	AIA	ETF	48.11	48.4586	48.1	48.38	34849.0
2013-10-17	AIQ	ETF	29.33	30.75	29.33	30.73	36393.0
2013-10-17	AIVI	ETF	46.89	47.2	46.77	47.17	37200.0
2013-10-17	ALTL	ETF	30.72	30.8	30.67	30.76	5000.0
2013-10-17	AMJ	ETF	44.14	44.86	44.02	44.83	487946.0
2013-10-17	AMLP	ETF	87.45	88.05	87.3	87.95	851180.0
2013-10-17	ANGL	ETF	27.39	27.39	26.63	26.67	4400.0
2013-10-17	AOA	ETF	42.6	43.0	42.6	43.0	22200.0
2013-10-17	AOK	ETF	31.58	31.72	31.58	31.7	27123.0
2013-10-17	AOM	ETF	33.629	33.78	33.629	33.78	30820.0
2013-10-17	AOR	ETF	37.33	37.52	37.31	37.48	33085.0
2013-10-17	ARGT	ETF	20.63	20.86	20.63	20.81	24600.0
2013-10-17	ASEA	ETF	17.2	17.29	17.2	17.29	8700.0
2013-10-17	ATMP	ETF	26.06	26.26	26.05	26.22	64900.0
2013-10-17	AVIV	ETF	23.49	24.32	23.39	24.29	324459.0
2013-10-17	AWAY	ETF	28.17	28.58	27.92	28.359	830042.0
2013-10-17	BAB	ETF	27.39	27.61	27.322	27.49	90868.0
2013-10-17	BAL	ETF	53.12	53.65	52.8001	53.622	3237.0
2013-10-17	BALT	ETF	5.13	5.45	5.11	5.21	1363533.0
2013-10-17	BBH	ETF	81.06	81.88	80.35	81.85	120400.0
2013-10-17	BCM	ETF	40.39	40.39	40.34	40.3499	1555.0
2013-10-17	BFOR	ETF	6.9725	7.0275	6.95	7.025	579200.0
2013-10-17	BIB	ETF	31.5	32.2375	31.125	32.2375	293660.0
2013-10-17	BICK	ETF	24.98	25.05	24.98	24.98	1550.0
2013-10-17	BIL	ETF	91.58	91.58	91.56	91.56	140350.0
2013-10-17	BIS	ETF	1046.4	1046.4	1012.0	1012.8	53.5
2013-10-17	BIV	ETF	83.74	83.97	83.73	83.94	151900.0
2013-10-17	BIZD	ETF	20.31	20.46	20.2	20.45	1600.0
2013-10-17	BJK	ETF	49.87	50.31	49.75	50.24	29400.0
2013-10-17	BKF	ETF	38.73	39.13	38.73	39.08	68392.0
2013-10-17	BKLN	ETF	24.65	24.69	24.62	24.68	4057500.0
2013-10-17	BLV	ETF	83.66	84.13	83.53	84.0	33500.0
2013-10-17	BMVP	ETF	20.9267	21.2111	20.9267	21.2033	5568.0

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

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