PREVIEW / etf_daily / 2013-10-29

all etf daily files

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

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-29	SPY	ETF	176.63	177.24	176.38	177.17	87401000.0
2013-10-29	QQQ	ETF	83.1601	83.26	82.7	83.06	36878062.0
2013-10-29	IWM	ETF	111.33	111.62	110.53	111.35	30026900.0
2013-10-29	DIA	ETF	155.71	156.5	155.62	156.5	5779100.0
2013-10-29	GLD	ETF	130.16	130.59	129.57	129.77	5328500.0
2013-10-29	TLT	ETF	107.62	108.07	107.51	108.06	5270500.0
2013-10-29	AADR	ETF	37.0	37.0	36.71	36.81	1600.0
2013-10-29	AAXJ	ETF	60.37	60.61	60.37	60.56	360100.0
2013-10-29	ACTV	ETF	14.41	14.45	14.4	14.45	896210.0
2013-10-29	ACWI	ETF	56.39	56.58	56.39	56.57	736300.0
2013-10-29	ACWV	ETF	64.5	64.54	64.39	64.54	74600.0
2013-10-29	ACWX	ETF	46.83	46.83	46.7149	46.8	102414.0
2013-10-29	ADRE	ETF	38.69	38.84	38.63	38.84	20820.0
2013-10-29	AFK	ETF	31.88	31.88	31.65	31.8	10786.0
2013-10-29	AGG	ETF	107.92	108.09	107.87	108.09	521400.0
2013-10-29	AGQ	ETF	85.8	86.52	85.36	85.56	191975.0
2013-10-29	AGZ	ETF	111.94	112.0	111.541	111.98	18962.0
2013-10-29	AIA	ETF	48.25	48.25	48.04	48.08	7274.0
2013-10-29	AIQ	ETF	23.08	25.379	23.08	24.42	49798.0
2013-10-29	AIVI	ETF	47.88	47.88	47.62	47.68	62800.0
2013-10-29	AMJ	ETF	45.55	45.99	45.52	45.9	256061.0
2013-10-29	AMLP	ETF	89.3	89.75	88.95	89.45	410320.0
2013-10-29	AOA	ETF	43.57	43.65	43.52	43.65	26900.0
2013-10-29	AOK	ETF	31.9	31.97	31.9	31.97	32756.0
2013-10-29	AOM	ETF	34.07	34.1	34.03	34.08	21902.0
2013-10-29	AOR	ETF	37.93	38.0	37.9299	37.99	17568.0
2013-10-29	ARGT	ETF	21.1	21.1	20.71	20.74	17900.0
2013-10-29	ASEA	ETF	17.29	17.32	17.29	17.3	11300.0
2013-10-29	ATMP	ETF	26.81	26.86	26.72	26.72	31300.0
2013-10-29	AVIV	ETF	25.58	25.74	25.37	25.7	331865.0
2013-10-29	AWAY	ETF	29.69	30.09	29.69	29.92	636582.0
2013-10-29	BAB	ETF	27.82	27.88	27.78	27.84	336912.0
2013-10-29	BAL	ETF	50.21	50.21	49.99	49.99	7937.0
2013-10-29	BALT	ETF	4.64	4.75	4.55	4.72	592949.0
2013-10-29	BBH	ETF	83.96	83.96	82.73	83.92	66200.0
2013-10-29	BCM	ETF	40.24	40.44	40.19	40.44	14118.0
2013-10-29	BFOR	ETF	7.1375	7.1525	7.115	7.1525	805200.0
2013-10-29	BIB	ETF	33.125	33.125	32.2544	32.91	87356.0
2013-10-29	BICK	ETF	24.79	24.79	24.79	24.79	435.0
2013-10-29	BIL	ETF	91.56	91.58	91.56	91.56	873700.0
2013-10-29	BIS	ETF	993.2	997.6	988.0	988.0	26.25
2013-10-29	BIV	ETF	84.45	84.67	84.42	84.67	276000.0
2013-10-29	BIZD	ETF	20.88	20.88	20.74	20.74	1800.0
2013-10-29	BJK	ETF	50.07	50.07	49.76	49.93	18600.0
2013-10-29	BKF	ETF	38.61	38.73	38.61	38.69	49689.0
2013-10-29	BKLN	ETF	24.82	24.83	24.8	24.82	4358400.0
2013-10-29	BLV	ETF	84.6	84.8	84.55	84.68	21500.0
2013-10-29	BMVP	ETF	21.5333	21.5931	21.5333	21.5774	1552.0
2013-10-29	BND	ETF	81.4	81.49	81.38	81.49	683700.0
2013-10-29	BNDX	ETF	50.02	50.04	49.91	50.04	89800.0

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

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