PREVIEW / etf_daily / 2013-10-23

all etf daily files

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

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-23	SPY	ETF	174.81	174.89	173.96	174.57	105484000.0
2013-10-23	QQQ	ETF	82.04	82.2	81.55	81.95	38021281.0
2013-10-23	IWM	ETF	110.24	110.55	109.77	110.39	32275300.0
2013-10-23	DIA	ETF	153.81	154.03	153.32	153.82	5428400.0
2013-10-23	GLD	ETF	128.55	129.09	128.35	128.69	5092200.0
2013-10-23	TLT	ETF	108.07	108.73	108.04	108.31	9163100.0
2013-10-23	AADR	ETF	37.01	37.01	37.01	37.01	600.0
2013-10-23	AAXJ	ETF	60.57	60.57	60.13	60.16	598800.0
2013-10-23	ACTV	ETF	14.42	14.45	14.41	14.43	1405538.0
2013-10-23	ACWI	ETF	56.17	56.17	55.88	56.06	647500.0
2013-10-23	ACWV	ETF	63.98	63.98	63.76	63.88	24300.0
2013-10-23	ACWX	ETF	46.67	46.67	46.44	46.56	339764.0
2013-10-23	ADRE	ETF	38.62	38.62	38.3	38.33	33777.0
2013-10-23	AFK	ETF	31.79	31.82	31.542	31.705	8667.0
2013-10-23	AGG	ETF	108.07	108.16	108.0	108.01	694300.0
2013-10-23	AGQ	ETF	86.2	87.08	86.16	86.2	210075.0
2013-10-23	AGZ	ETF	111.7	111.98	111.53	111.82	43213.0
2013-10-23	AIA	ETF	47.84	47.87	47.69	47.72	26195.0
2013-10-23	AIQ	ETF	31.31	31.64	30.5	30.97	13011.0
2013-10-23	AIVI	ETF	47.46	47.46	47.18	47.29	30700.0
2013-10-23	AMJ	ETF	45.98	46.03	45.6	45.84	502369.0
2013-10-23	AMLP	ETF	89.5	89.65	88.9	89.4	807140.0
2013-10-23	ANGL	ETF	26.88	26.92	26.88	26.91	500.0
2013-10-23	AOA	ETF	43.33	43.33	43.14	43.31	12800.0
2013-10-23	AOK	ETF	31.8	31.869	31.8	31.8568	19695.0
2013-10-23	AOM	ETF	33.92	33.97	33.9101	33.92	19254.0
2013-10-23	AOR	ETF	37.78	37.78	37.6701	37.7	36334.0
2013-10-23	ARGT	ETF	21.59	21.59	21.0	21.03	18800.0
2013-10-23	ASEA	ETF	17.2	17.2	17.06	17.11	4700.0
2013-10-23	ATMP	ETF	26.87	26.87	26.69	26.79	16700.0
2013-10-23	AVIV	ETF	24.49	24.8	24.41	24.78	145810.0
2013-10-23	AWAY	ETF	29.1	29.6	28.69	29.53	702700.0
2013-10-23	BAB	ETF	27.81	27.9699	27.81	27.852	124965.0
2013-10-23	BAL	ETF	52.66	52.66	51.47	51.6	18232.0
2013-10-23	BALT	ETF	5.03	5.05	4.95	5.0	543599.0
2013-10-23	BBH	ETF	82.01	82.64	81.29	82.64	60900.0
2013-10-23	BCM	ETF	40.214	40.214	40.214	40.214	137.0
2013-10-23	BFOR	ETF	7.0925	7.0925	7.04	7.07	261600.0
2013-10-23	BIB	ETF	31.7425	32.2225	31.338	32.2175	334992.0
2013-10-23	BICK	ETF	24.99	24.99	24.94	24.94	963.0
2013-10-23	BIL	ETF	91.58	91.58	91.56	91.58	259950.0
2013-10-23	BIS	ETF	1020.8	1041.4	998.0	998.0	815.5
2013-10-23	BIV	ETF	84.43	84.64	84.43	84.57	260500.0
2013-10-23	BIZD	ETF	20.64	20.74	20.55	20.73	4700.0
2013-10-23	BJK	ETF	50.74	50.74	50.25	50.25	38300.0
2013-10-23	BKF	ETF	38.88	38.88	38.39	38.4	51810.0
2013-10-23	BKLN	ETF	24.74	24.78	24.74	24.78	4685600.0
2013-10-23	BLV	ETF	84.78	85.13	84.78	84.89	32700.0
2013-10-23	BMVP	ETF	21.3333	21.4047	21.3333	21.3835	2719.0
2013-10-23	BND	ETF	81.45	81.53	81.4	81.41	741100.0

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

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