PREVIEW / etf_daily / 2014-03-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-25.parquet
  size:    44 KB
  rows:    1,075

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
2014-03-25	SPY	ETF	186.37	186.94	185.27	186.31	103852000.0
2014-03-25	QQQ	ETF	88.69	89.25	87.7701	88.51	41723335.0
2014-03-25	IWM	ETF	117.67	118.31	116.14	116.93	47699700.0
2014-03-25	DIA	ETF	163.37	163.72	162.57	163.39	5991100.0
2014-03-25	GLD	ETF	126.44	126.82	126.24	126.41	6566900.0
2014-03-25	TLT	ETF	108.41	108.82	108.17	108.59	5032000.0
2014-03-25	AADR	ETF	37.5	37.63	37.33	37.6	2800.0
2014-03-25	AAXJ	ETF	57.72	57.98	57.58	57.8	437900.0
2014-03-25	ACWI	ETF	57.36	57.44	57.05	57.35	1268500.0
2014-03-25	ACWV	ETF	63.27	63.49	63.12	63.43	37600.0
2014-03-25	ACWX	ETF	45.44	45.74	45.38	45.67	1788772.0
2014-03-25	ADRE	ETF	35.26	35.42	35.2479	35.31	12128.0
2014-03-25	AFK	ETF	31.0001	31.5775	31.0001	31.21	5979.0
2014-03-25	AGG	ETF	107.69	107.83	107.63	107.64	1377600.0
2014-03-25	AGQ	ETF	65.76	66.62	65.18	65.44	212100.0
2014-03-25	AGZ	ETF	111.5244	111.5244	111.44	111.4464	13068.0
2014-03-25	AIA	ETF	44.42	44.664	44.42	44.604	8523.0
2014-03-25	AIQ	ETF	31.255	32.26	30.59	32.08	36377.0
2014-03-25	AIRR	ETF	19.84	19.86	19.676	19.73	5100.0
2014-03-25	AIVI	ETF	48.06	48.55	47.99	48.54	26300.0
2014-03-25	ALTL	ETF	33.7366	33.7366	33.7366	33.7366	339.0
2014-03-25	AMJ	ETF	45.83	45.99	45.63	45.71	630929.0
2014-03-25	AMLP	ETF	87.3	87.4	86.9	87.05	359900.0
2014-03-25	ANGL	ETF	27.59	27.6	27.59	27.6	700.0
2014-03-25	AOA	ETF	44.97	45.03	44.77	44.91	26800.0
2014-03-25	AOK	ETF	32.27	32.27	32.2	32.2352	25001.0
2014-03-25	AOM	ETF	34.66	34.66	34.5548	34.63	40263.0
2014-03-25	AOR	ETF	38.91	38.92	38.77	38.89	18917.0
2014-03-25	ARGT	ETF	19.51	19.51	19.07	19.07	2700.0
2014-03-25	ASEA	ETF	15.68	15.68	15.57	15.68	14600.0
2014-03-25	ASHR	ETF	22.12	22.26	22.12	22.2	142900.0
2014-03-25	ATMP	ETF	27.22	27.23	27.13	27.17	12000.0
2014-03-25	AVIV	ETF	24.23	24.4596	23.89	24.44	265437.0
2014-03-25	AWAY	ETF	39.52	39.98	38.12	38.64	3477086.0
2014-03-25	BAB	ETF	28.62	28.66	28.574	28.63	88639.0
2014-03-25	BAL	ETF	56.45	59.28	56.45	58.8	26653.0
2014-03-25	BALT	ETF	6.39	6.55	6.3	6.37	483902.0
2014-03-25	BBH	ETF	93.0	94.43	90.74	92.05	299800.0
2014-03-25	BFOR	ETF	7.5875	7.6125	7.53	7.5675	134000.0
2014-03-25	BIB	ETF	41.585	43.245	39.82	41.135	1477118.0
2014-03-25	BICK	ETF	23.66	23.8	23.64	23.7	11006.0
2014-03-25	BIL	ETF	91.56	91.56	91.54	91.56	73600.0
2014-03-25	BIS	ETF	693.6	723.6	662.8	700.8	34908.5
2014-03-25	BIV	ETF	83.12	83.24	83.06	83.17	182100.0
2014-03-25	BIZD	ETF	20.63	20.69	20.58	20.67	12400.0
2014-03-25	BJK	ETF	51.72	51.97	51.32	51.34	127500.0
2014-03-25	BKF	ETF	34.83	35.13	34.77	34.93	72258.0
2014-03-25	BKLN	ETF	24.81	24.82	24.79	24.79	1432000.0
2014-03-25	BLV	ETF	86.05	86.33	85.94	86.22	57900.0
2014-03-25	BMVP	ETF	23.68	23.68	23.477	23.62	24672.0

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

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