PREVIEW / etf_daily / 2014-08-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-12.parquet
  size:    45 KB
  rows:    1,102

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-08-12	SPY	ETF	193.61	194.15	192.94	193.53	73632000.0
2014-08-12	QQQ	ETF	95.38	95.67	94.93	95.42	28158723.0
2014-08-12	IWM	ETF	112.94	113.47	112.04	112.56	31188400.0
2014-08-12	DIA	ETF	165.28	165.77	165.0	165.49	3274300.0
2014-08-12	GLD	ETF	126.42	126.81	125.87	125.99	4609700.0
2014-08-12	TLT	ETF	115.41	115.44	114.73	114.76	8122400.0
2014-08-12	AADR	ETF	37.67	37.67	37.67	37.67	100.0
2014-08-12	AAXJ	ETF	64.78	64.96	64.64	64.93	380700.0
2014-08-12	ACWI	ETF	59.17	59.27	59.02	59.18	1475500.0
2014-08-12	ACWV	ETF	66.46	66.61	66.46	66.59	32700.0
2014-08-12	ACWX	ETF	46.76	46.8567	46.68	46.83	197405.0
2014-08-12	ADRE	ETF	41.15	41.42	41.11	41.2	6009.0
2014-08-12	AFK	ETF	33.73	33.799	33.6109	33.68	28467.0
2014-08-12	AGG	ETF	109.44	109.44	109.31	109.34	876000.0
2014-08-12	AGQ	ETF	64.18	64.59	63.07	63.76	121100.0
2014-08-12	AGZ	ETF	112.6	112.7899	112.56	112.7599	4886.0
2014-08-12	AGZD	ETF	24.955	24.955	24.955	24.955	1400.0
2014-08-12	AIA	ETF	50.1	50.1	49.788	50.0999	210205.0
2014-08-12	AIQ	ETF	29.2	29.55	28.76	28.78	24250.0
2014-08-12	AIRR	ETF	18.69	18.72	18.45	18.554	98000.0
2014-08-12	AIVI	ETF	48.79	48.85	48.7	48.83	14700.0
2014-08-12	AMJ	ETF	51.8	52.12	51.02	51.75	628982.0
2014-08-12	AMLP	ETF	93.2	93.45	92.6	93.0	590040.0
2014-08-12	ANGL	ETF	27.89	27.96	27.81	27.96	6000.0
2014-08-12	AOA	ETF	45.92	45.97	45.76	45.85	25200.0
2014-08-12	AOK	ETF	32.64	32.64	32.56	32.6	17976.0
2014-08-12	AOM	ETF	35.12	35.14	35.06	35.06	20801.0
2014-08-12	AOR	ETF	39.67	39.68	39.55	39.62	61372.0
2014-08-12	ARGT	ETF	21.57	21.57	21.23	21.36	21300.0
2014-08-12	ASEA	ETF	17.32	17.32	17.27	17.3	13000.0
2014-08-12	ASHR	ETF	25.0	25.06	24.97	25.04	220200.0
2014-08-12	ASHS	ETF	30.24	30.36	30.21	30.36	4600.0
2014-08-12	ATMP	ETF	31.6	31.6	31.26	31.35	60200.0
2014-08-12	AVIV	ETF	27.75	27.89	27.71	27.79	141546.0
2014-08-12	AWAY	ETF	32.9	33.13	31.61	32.98	2734934.0
2014-08-12	BAB	ETF	29.67	29.67	29.6	29.61	57568.0
2014-08-12	BAL	ETF	43.2	43.2	42.47	42.47	4906.0
2014-08-12	BALT	ETF	5.38	5.58	5.31	5.58	515216.0
2014-08-12	BBH	ETF	98.38	98.72	97.52	97.93	30000.0
2014-08-12	BCHP	ETF	20.033	20.0899	20.033	20.0595	2281.0
2014-08-12	BCM	ETF	39.82	39.82	39.66	39.66	2259.0
2014-08-12	BFOR	ETF	7.6625	7.6675	7.595	7.6175	130000.0
2014-08-12	BIB	ETF	44.395	44.74	44.0	44.37	203918.0
2014-08-12	BICK	ETF	26.72	26.7892	26.72	26.7892	1004.0
2014-08-12	BIL	ETF	91.5	91.52	91.5	91.5	103950.0
2014-08-12	BIS	ETF	577.2	583.996	574.4	578.0	3863.0
2014-08-12	BIV	ETF	84.73	84.82	84.68	84.69	159700.0
2014-08-12	BIZD	ETF	20.31	20.31	20.18	20.19	16200.0
2014-08-12	BJK	ETF	47.96	48.05	47.67	47.9	23300.0
2014-08-12	BKF	ETF	40.049	40.14	39.94	40.07	179045.0

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

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