PREVIEW / etf_daily / 2013-04-29

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-29.parquet
  size:    40 KB
  rows:    990

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-04-29	SPY	ETF	158.67	159.65	158.42	159.3	88572800.0
2013-04-29	QQQ	ETF	69.78	70.48	69.76	70.21	31663920.0
2013-04-29	IWM	ETF	93.31	93.78	93.07	93.57	20791400.0
2013-04-29	DIA	ETF	147.2	148.15	146.91	147.86	6132000.0
2013-04-29	GLD	ETF	142.13	142.66	141.49	142.3	11004500.0
2013-04-29	TLT	ETF	123.58	123.73	122.76	122.94	4916000.0
2013-04-29	AADR	ETF	34.05	34.09	33.99	34.09	1000.0
2013-04-29	AAXJ	ETF	59.55	59.85	59.37	59.68	405600.0
2013-04-29	ACTV	ETF	5.16	5.2	5.07	5.16	264189.0
2013-04-29	ACWI	ETF	51.68	52.11	51.68	52.0	429800.0
2013-04-29	ACWV	ETF	63.25	63.66	63.25	63.59	75600.0
2013-04-29	ACWX	ETF	43.76	44.236	43.76	44.19	552954.0
2013-04-29	ADRE	ETF	38.57	38.66	38.42	38.6	67886.0
2013-04-29	AFK	ETF	29.34	29.6999	29.3	29.66	81025.0
2013-04-29	AGEM	ETF	22.41	22.41	22.41	22.41	100.0
2013-04-29	AGG	ETF	111.49	111.57	111.47	111.56	869400.0
2013-04-29	AGQ	ETF	106.64	108.68	105.28	107.44	610500.0
2013-04-29	AGZ	ETF	113.73	113.87	113.73	113.7936	8093.0
2013-04-29	AIA	ETF	46.44	46.7233	46.36	46.661	6703.0
2013-04-29	AIQ	ETF	11.77	12.37	11.585	12.25	51495.0
2013-04-29	AIVI	ETF	43.69	44.12	43.69	44.06	42300.0
2013-04-29	AMJ	ETF	46.87	46.98	46.3	46.43	692966.0
2013-04-29	AMLP	ETF	88.75	89.05	88.45	88.75	544900.0
2013-04-29	ANGL	ETF	27.6	27.62	27.6	27.6	600.0
2013-04-29	AOA	ETF	40.26	40.45	40.21	40.38	48100.0
2013-04-29	AOK	ETF	31.48	31.559	31.48	31.54	21415.0
2013-04-29	AOM	ETF	33.05	33.19	33.05	33.13	25065.0
2013-04-29	AOR	ETF	36.05	36.17	36.0	36.13	28701.0
2013-04-29	ARB	ETF	46.7	46.7	46.55	46.6	132209.0
2013-04-29	ARGT	ETF	17.2	17.32	17.16	17.28	3600.0
2013-04-29	ASEA	ETF	18.27	18.39	18.22	18.35	18800.0
2013-04-29	ATMP	ETF	26.43	26.43	26.22	26.34	7900.0
2013-04-29	AVIV	ETF	25.36	25.45	25.13	25.32	150358.0
2013-04-29	AWAY	ETF	31.0	31.25	30.27	30.71	854712.0
2013-04-29	BAB	ETF	31.04	31.04	30.95	30.97	92631.0
2013-04-29	BAL	ETF	53.82	54.24	53.51	54.11	55023.0
2013-04-29	BALT	ETF	3.36	3.55	3.29	3.42	32372.0
2013-04-29	BBH	ETF	70.74	70.94	70.28	70.48	278000.0
2013-04-29	BCM	ETF	40.78	40.92	40.76	40.92	760.0
2013-04-29	BIB	ETF	23.105	23.2475	22.7978	22.8717	154912.0
2013-04-29	BICK	ETF	23.77	23.93	23.76	23.87	9865.0
2013-04-29	BIL	ETF	91.62	91.62	91.6	91.6	117850.0
2013-04-29	BIS	ETF	1584.4	1592.8	1580.0	1592.8	63.0
2013-04-29	BIV	ETF	88.75	88.78	88.68	88.72	180100.0
2013-04-29	BIZD	ETF	20.55	20.68	20.44	20.68	25200.0
2013-04-29	BJK	ETF	42.08	42.25	41.84	42.21	10600.0
2013-04-29	BKF	ETF	38.71	38.996	38.66	38.91	40261.0
2013-04-29	BKLN	ETF	25.16	25.17	25.15	25.17	1941200.0
2013-04-29	BLV	ETF	95.03	95.09	94.63	94.66	92800.0
2013-04-29	BMVP	ETF	18.72	18.7867	18.7167	18.7538	1325.0

> showing 50 of 990 rows — these rows as CSV

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