PREVIEW / etf_daily / 2014-02-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-18.parquet
  size:    44 KB
  rows:    1,077

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-02-18	SPY	ETF	184.18	184.49	183.65	184.24	80460900.0
2014-02-18	QQQ	ETF	89.93	90.4172	89.74	90.25	29614391.0
2014-02-18	IWM	ETF	114.4	115.45	114.14	115.25	33630400.0
2014-02-18	DIA	ETF	161.7	161.76	161.13	161.41	4966400.0
2014-02-18	GLD	ETF	127.42	127.75	127.09	127.4	7685800.0
2014-02-18	TLT	ETF	106.66	107.2	106.62	106.82	4855800.0
2014-02-18	AADR	ETF	37.52	37.67	37.5	37.63	3200.0
2014-02-18	AAXJ	ETF	57.65	57.89	57.49	57.51	649600.0
2014-02-18	ACWI	ETF	57.25	57.36	57.08	57.26	505700.0
2014-02-18	ACWV	ETF	62.79	62.98	62.76	62.94	20500.0
2014-02-18	ACWX	ETF	46.02	46.1252	45.92	46.045	371409.0
2014-02-18	ADRE	ETF	34.84	35.0481	34.84	34.87	22231.0
2014-02-18	AFK	ETF	30.27	30.6834	30.27	30.4835	23829.0
2014-02-18	AGG	ETF	107.76	107.94	107.74	107.84	940900.0
2014-02-18	AGQ	ETF	77.54	79.55	76.96	79.55	904700.0
2014-02-18	AGZ	ETF	111.88	111.88	111.62	111.7294	52727.0
2014-02-18	AIA	ETF	45.09	45.1649	44.92	45.08	27117.0
2014-02-18	AIQ	ETF	29.0	30.0	28.766	29.75	31255.0
2014-02-18	AIVI	ETF	48.37	48.5	48.2	48.43	12600.0
2014-02-18	ALTL	ETF	33.19	33.19	33.19	33.19	1422.0
2014-02-18	AMJ	ETF	47.14	47.63	47.14	47.44	422656.0
2014-02-18	AMLP	ETF	88.55	89.0	88.35	88.5	801580.0
2014-02-18	ANGL	ETF	27.35	27.35	27.3	27.3	1500.0
2014-02-18	AOA	ETF	44.66	44.7	44.48	44.68	43000.0
2014-02-18	AOK	ETF	32.19	32.21	32.14	32.21	35610.0
2014-02-18	AOM	ETF	34.48	34.51	34.43	34.51	75916.0
2014-02-18	AOR	ETF	38.64	38.67	38.56	38.66	29418.0
2014-02-18	ARGT	ETF	19.48	19.48	19.05	19.09	10300.0
2014-02-18	ASEA	ETF	15.43	15.44	15.37	15.37	11700.0
2014-02-18	ASHR	ETF	23.86	23.86	23.78	23.78	201100.0
2014-02-18	ATMP	ETF	27.98	27.98	27.81	27.82	143100.0
2014-02-18	AVIV	ETF	23.92	24.05	23.72	23.92	104922.0
2014-02-18	AWAY	ETF	41.82	42.72	41.71	42.53	1726745.0
2014-02-18	BAB	ETF	28.325	28.4004	28.25	28.34	126677.0
2014-02-18	BAL	ETF	55.85	56.1	55.67	55.99	6690.0
2014-02-18	BALT	ETF	6.53	6.542	6.305	6.39	520617.0
2014-02-18	BBH	ETF	102.21	103.56	102.21	103.5	195900.0
2014-02-18	BCM	ETF	40.72	40.92	40.64	40.92	41679.0
2014-02-18	BFOR	ETF	7.3675	7.43	7.3675	7.42	291200.0
2014-02-18	BIB	ETF	48.86	50.655	48.785	50.5505	545468.0
2014-02-18	BICK	ETF	22.97	22.97	22.97	22.97	1763.0
2014-02-18	BIL	ETF	91.56	91.56	91.54	91.54	303550.0
2014-02-18	BIS	ETF	615.2	615.2	587.6	590.0	3824.0
2014-02-18	BIV	ETF	83.38	83.68	83.38	83.58	163000.0
2014-02-18	BIZD	ETF	21.38	21.46	21.27	21.39	5500.0
2014-02-18	BJK	ETF	52.69	52.7	52.25	52.39	16100.0
2014-02-18	BKF	ETF	35.22	35.25	34.93	34.99	76592.0
2014-02-18	BKLN	ETF	24.83	24.83	24.82	24.82	1627600.0
2014-02-18	BLNG	ETF	37.65	37.65	37.65	37.65	100.0
2014-02-18	BLV	ETF	85.09	85.39	84.81	85.13	116200.0

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

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