PREVIEW / etf_daily / 2013-09-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-25.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-09-25	SPY	ETF	169.64	169.98	168.89	169.04	117306500.0
2013-09-25	QQQ	ETF	78.88	79.0	78.4	78.56	22746397.0
2013-09-25	IWM	ETF	106.77	107.48	106.33	106.47	37106600.0
2013-09-25	DIA	ETF	153.26	153.39	152.19	152.42	7187200.0
2013-09-25	GLD	ETF	127.57	129.21	127.52	128.79	7519100.0
2013-09-25	TLT	ETF	106.54	107.28	106.39	107.05	8130900.0
2013-09-25	AAXJ	ETF	59.47	59.47	58.92	59.02	1046800.0
2013-09-25	ACTV	ETF	10.71	11.21	10.58	11.16	546536.0
2013-09-25	ACWI	ETF	54.4	54.55	54.25	54.34	1057400.0
2013-09-25	ACWV	ETF	62.27	62.44	62.18	62.23	13000.0
2013-09-25	ACWX	ETF	45.14	45.38	45.135	45.26	574343.0
2013-09-25	ADRE	ETF	37.51	37.57	37.41	37.49	17850.0
2013-09-25	AFK	ETF	30.21	30.21	29.93	29.95	19133.0
2013-09-25	AGEM	ETF	22.73	22.79	22.69	22.7473	2512.0
2013-09-25	AGG	ETF	107.08	107.32	107.06	107.25	647700.0
2013-09-25	AGQ	ETF	80.68	82.2	80.32	80.84	305525.0
2013-09-25	AGZ	ETF	111.04	111.129	110.98	111.09	6977.0
2013-09-25	AIA	ETF	47.29	47.29	47.0	47.06	47650.0
2013-09-25	AIQ	ETF	24.49	24.97	24.33	24.45	41403.0
2013-09-25	AIVI	ETF	45.39	45.67	45.39	45.53	19800.0
2013-09-25	AMJ	ETF	44.12	44.45	43.961	44.37	1613960.0
2013-09-25	AMLP	ETF	87.4	87.55	86.9	87.45	368720.0
2013-09-25	ANGL	ETF	26.75	26.75	26.63	26.73	2100.0
2013-09-25	AOA	ETF	42.25	42.33	42.15	42.28	13600.0
2013-09-25	AOK	ETF	31.421	31.48	31.42	31.44	9803.0
2013-09-25	AOM	ETF	33.46	33.481	33.41	33.44	102215.0
2013-09-25	AOR	ETF	36.98	37.1	36.98	37.01	18080.0
2013-09-25	ARB	ETF	47.98	48.0	47.98	48.0	226974.0
2013-09-25	ARGT	ETF	19.83	20.07	19.83	19.97	13000.0
2013-09-25	ASEA	ETF	16.8	16.86	16.74	16.75	16200.0
2013-09-25	ATMP	ETF	25.92	25.98	25.92	25.98	9300.0
2013-09-25	AVIV	ETF	23.06	23.62	23.06	23.22	121877.0
2013-09-25	AWAY	ETF	30.91	31.142	30.46	30.71	363039.0
2013-09-25	BAB	ETF	27.34	27.4	27.3	27.39	127062.0
2013-09-25	BAL	ETF	53.99	54.5	53.94	54.15	12770.0
2013-09-25	BALT	ETF	5.08	5.5	5.08	5.3	2021915.0
2013-09-25	BBH	ETF	81.95	81.95	81.25	81.31	25400.0
2013-09-25	BCM	ETF	40.328	40.328	40.328	40.328	499.0
2013-09-25	BFOR	ETF	6.825	6.845	6.7825	6.8	268800.0
2013-09-25	BIB	ETF	32.315	32.345	31.7703	31.845	47944.0
2013-09-25	BICK	ETF	23.72	23.8	23.72	23.72	807.0
2013-09-25	BIL	ETF	91.58	91.6	91.58	91.58	83150.0
2013-09-25	BIS	ETF	1035.64	1052.48	1035.64	1051.2	155.0
2013-09-25	BIV	ETF	83.3	83.59	83.29	83.53	294600.0
2013-09-25	BIZD	ETF	20.55	20.67	20.55	20.67	2700.0
2013-09-25	BJK	ETF	47.69	47.74	47.45	47.53	15400.0
2013-09-25	BKF	ETF	38.1	38.1	37.732	37.87	59109.0
2013-09-25	BKLN	ETF	24.78	24.79	24.74	24.76	1965800.0
2013-09-25	BLV	ETF	83.31	83.56	83.17	83.48	88400.0
2013-09-25	BMVP	ETF	20.2	20.323	20.2	20.2867	922.0

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

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