PREVIEW / etf_daily / 2014-03-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-18.parquet
  size:    43 KB
  rows:    1,076

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-18	SPY	ETF	186.71	187.91	186.51	187.66	101804600.0
2014-03-18	QQQ	ETF	89.55	90.64	89.53	90.53	31250235.0
2014-03-18	IWM	ETF	118.22	119.88	118.1	119.78	41606600.0
2014-03-18	DIA	ETF	162.69	163.64	162.55	163.28	7094600.0
2014-03-18	GLD	ETF	130.39	131.27	130.33	130.62	6424400.0
2014-03-18	TLT	ETF	107.68	108.15	107.6	108.1	4819500.0
2014-03-18	AADR	ETF	37.89	37.95	37.68	37.73	12700.0
2014-03-18	AAXJ	ETF	57.42	57.83	57.4	57.72	242400.0
2014-03-18	ACWI	ETF	57.17	57.59	57.17	57.52	726300.0
2014-03-18	ACWV	ETF	63.55	63.82	63.55	63.72	41800.0
2014-03-18	ACWX	ETF	45.42	45.78	45.42	45.73	454862.0
2014-03-18	ADRE	ETF	34.3	34.689	34.29	34.66	7883.0
2014-03-18	AFK	ETF	30.99	31.19	30.9701	31.13	12470.0
2014-03-18	AGG	ETF	107.88	108.0	107.85	108.0	568500.0
2014-03-18	AGQ	ETF	70.6	71.77	70.55	70.94	391300.0
2014-03-18	AGZ	ETF	111.74	111.81	111.645	111.7999	11890.0
2014-03-18	AIA	ETF	44.29	44.59	44.24	44.52	3926.0
2014-03-18	AIQ	ETF	29.64	29.69	29.03	29.36	13646.0
2014-03-18	AIRR	ETF	19.66	19.87	19.61	19.83	41800.0
2014-03-18	AIVI	ETF	48.64	49.06	48.64	48.94	54100.0
2014-03-18	ALTL	ETF	33.82	33.844	33.82	33.844	3093.0
2014-03-18	AMJ	ETF	46.02	46.58	46.0001	46.42	431430.0
2014-03-18	AMLP	ETF	87.6	88.15	87.5	87.9	589480.0
2014-03-18	ANGL	ETF	27.56	27.58	27.56	27.58	3400.0
2014-03-18	AOA	ETF	44.79	45.16	44.79	45.1	30300.0
2014-03-18	AOK	ETF	32.28	32.35	32.252	32.35	24134.0
2014-03-18	AOM	ETF	34.53	34.75	34.53	34.75	23569.0
2014-03-18	AOR	ETF	38.88	39.03	38.8386	39.03	27613.0
2014-03-18	ARGT	ETF	19.26	19.26	19.26	19.26	100.0
2014-03-18	ASEA	ETF	15.85	15.89	15.82	15.87	11200.0
2014-03-18	ASHR	ETF	21.89	21.93	21.85	21.89	121700.0
2014-03-18	ATMP	ETF	27.39	27.66	27.39	27.6	40000.0
2014-03-18	AVIV	ETF	24.96	25.09	24.93	25.07	147836.0
2014-03-18	AWAY	ETF	43.0	43.83	42.87	43.61	482686.0
2014-03-18	BAB	ETF	28.46	28.6	28.45	28.6	65059.0
2014-03-18	BAL	ETF	57.85	58.19	57.806	58.19	5354.0
2014-03-18	BALT	ETF	6.75	6.87	6.64	6.87	499803.0
2014-03-18	BBH	ETF	98.85	100.73	98.85	100.68	131600.0
2014-03-18	BCM	ETF	40.78	40.85	40.74	40.84	32362.0
2014-03-18	BFOR	ETF	7.63	7.7025	7.63	7.6975	155200.0
2014-03-18	BIB	ETF	47.725	49.55	47.335	49.505	677418.0
2014-03-18	BICK	ETF	23.12	23.24	23.12	23.24	736.0
2014-03-18	BIL	ETF	91.54	91.56	91.54	91.54	106400.0
2014-03-18	BIS	ETF	620.4	620.4	587.2	587.2	9032.5
2014-03-18	BIV	ETF	83.55	83.63	83.49	83.59	231900.0
2014-03-18	BIZD	ETF	20.8	20.8	20.56	20.6	15600.0
2014-03-18	BJK	ETF	53.71	54.06	53.71	53.95	13300.0
2014-03-18	BKF	ETF	33.59	34.15	33.59	34.13	71410.0
2014-03-18	BKLN	ETF	24.78	24.8	24.76	24.78	3872900.0
2014-03-18	BLV	ETF	85.62	86.04	85.52	85.81	63400.0

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

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