PREVIEW / etf_daily / 2013-10-11

all etf daily files

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

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-11	SPY	ETF	168.91	170.32	168.77	170.26	105040000.0
2013-10-11	QQQ	ETF	78.41	79.29	78.4	79.23	25214124.0
2013-10-11	IWM	ETF	105.84	107.73	105.83	107.68	43197100.0
2013-10-11	DIA	ETF	150.92	152.22	150.76	152.17	8186000.0
2013-10-11	GLD	ETF	122.37	122.81	121.85	122.6	15972600.0
2013-10-11	TLT	ETF	106.16	106.23	105.41	105.46	6500800.0
2013-10-11	AADR	ETF	35.69	35.84	35.5	35.58	36300.0
2013-10-11	AAXJ	ETF	60.63	61.01	60.52	60.98	294900.0
2013-10-11	ACTV	ETF	14.37	14.4	14.37	14.4	1642989.0
2013-10-11	ACWI	ETF	54.28	54.77	54.28	54.76	864900.0
2013-10-11	ACWV	ETF	62.13	62.45	62.11	62.45	26600.0
2013-10-11	ACWX	ETF	45.26	45.64	45.26	45.63	117659.0
2013-10-11	ADRE	ETF	37.8	38.17	37.77	38.17	179273.0
2013-10-11	AFK	ETF	30.31	30.74	30.24	30.74	7069.0
2013-10-11	AGG	ETF	107.22	107.27	107.04	107.07	1032200.0
2013-10-11	AGQ	ETF	77.0	77.36	75.96	77.2	547475.0
2013-10-11	AGZ	ETF	111.16	111.486	110.92	111.0001	4298.0
2013-10-11	AIA	ETF	47.88	48.358	47.88	48.23	23928.0
2013-10-11	AIQ	ETF	28.0	29.1	27.48	28.06	55971.0
2013-10-11	AIVI	ETF	45.69	46.05	45.69	46.05	60700.0
2013-10-11	ALTL	ETF	30.31	30.52	30.2	30.43	119551.0
2013-10-11	AMJ	ETF	44.17	44.48	43.88	44.48	533704.0
2013-10-11	AMLP	ETF	87.05	87.55	86.85	87.5	529080.0
2013-10-11	ANGL	ETF	26.2	26.45	26.2	26.45	2100.0
2013-10-11	AOA	ETF	41.86	42.36	41.86	42.36	55200.0
2013-10-11	AOK	ETF	31.401	31.46	31.4	31.44	12961.0
2013-10-11	AOM	ETF	33.309	33.45	33.309	33.45	16124.0
2013-10-11	AOR	ETF	36.9	37.06	36.9	37.03	29715.0
2013-10-11	ARGT	ETF	20.07	20.09	19.94	20.09	17000.0
2013-10-11	ASEA	ETF	17.06	17.16	17.06	17.11	8000.0
2013-10-11	ATMP	ETF	25.99	26.09	25.89	26.08	19800.0
2013-10-11	AVIV	ETF	23.15	23.96	23.08	23.95	222842.0
2013-10-11	AWAY	ETF	29.23	29.3	28.87	29.11	452788.0
2013-10-11	BAB	ETF	27.5	27.5	27.31	27.37	160122.0
2013-10-11	BAL	ETF	53.38	53.43	53.19	53.21	15153.0
2013-10-11	BALT	ETF	5.11	5.13	4.91	4.98	446466.0
2013-10-11	BBH	ETF	78.76	78.92	77.91	78.46	122200.0
2013-10-11	BCM	ETF	40.3	40.3	40.3	40.3	1575.0
2013-10-11	BFOR	ETF	6.8275	6.9	6.8125	6.9	322400.0
2013-10-11	BIB	ETF	30.5	30.5	29.5053	29.9125	296412.0
2013-10-11	BICK	ETF	24.67	24.72	24.5775	24.72	3562.0
2013-10-11	BIL	ETF	91.58	91.58	91.54	91.54	6366750.0
2013-10-11	BIS	ETF	1090.8	1105.6	1059.6	1074.8	985.0
2013-10-11	BIV	ETF	83.37	83.48	83.24	83.31	145800.0
2013-10-11	BIZD	ETF	20.43	20.43	20.22	20.36	4800.0
2013-10-11	BJK	ETF	48.66	49.22	48.66	49.15	18100.0
2013-10-11	BKF	ETF	38.74	38.88	38.58	38.85	234402.0
2013-10-11	BKLN	ETF	24.72	24.73	24.7	24.71	1585200.0
2013-10-11	BLV	ETF	83.11	83.18	82.77	82.77	30800.0
2013-10-11	BMVP	ETF	20.5233	20.673	20.5233	20.6037	6396.0

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

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