PREVIEW / etf_daily / 2014-01-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-14.parquet
  size:    43 KB
  rows:    1,064

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-01-14	SPY	ETF	182.29	183.77	181.95	183.67	105016100.0
2014-01-14	QQQ	ETF	86.3	87.72	86.3	87.65	37194076.0
2014-01-14	IWM	ETF	114.44	115.51	114.18	115.34	39125300.0
2014-01-14	DIA	ETF	162.74	163.47	162.37	163.45	7335400.0
2014-01-14	GLD	ETF	120.54	121.06	119.72	119.89	7505400.0
2014-01-14	TLT	ETF	104.65	104.83	104.39	104.45	10343100.0
2014-01-14	AADR	ETF	37.48	37.48	37.43	37.43	2700.0
2014-01-14	AAXJ	ETF	58.27	58.51	57.94	58.43	213000.0
2014-01-14	ACWI	ETF	56.79	57.17	56.65	57.14	1177500.0
2014-01-14	ACWV	ETF	62.49	62.97	62.49	62.84	66100.0
2014-01-14	ACWX	ETF	45.91	46.05	45.695	46.01	186682.0
2014-01-14	ADRE	ETF	35.52	35.75	35.5099	35.75	8160.0
2014-01-14	AFK	ETF	30.15	30.7	30.15	30.69	55425.0
2014-01-14	AGG	ETF	107.18	107.25	106.98	107.04	987500.0
2014-01-14	AGQ	ETF	68.64	70.52	67.4	67.64	709800.0
2014-01-14	AGZ	ETF	111.021	111.17	110.9722	110.991	10472.0
2014-01-14	AGZD	ETF	25.05	25.05	25.01	25.01	8400.0
2014-01-14	AIA	ETF	45.89	46.17	45.76	46.17	9351.0
2014-01-14	AIQ	ETF	27.33	27.49	27.11	27.35	17113.0
2014-01-14	AIVI	ETF	46.9	47.24	46.79	47.19	72700.0
2014-01-14	ALTL	ETF	32.79	32.81	32.73	32.73	6200.0
2014-01-14	AMJ	ETF	45.12	45.45	45.02	45.34	318157.0
2014-01-14	AMLP	ETF	87.25	87.45	86.9	87.35	484480.0
2014-01-14	AOA	ETF	44.27	44.5	44.17	44.49	22700.0
2014-01-14	AOK	ETF	32.0	32.069	32.0	32.03	22091.0
2014-01-14	AOM	ETF	34.28	34.35	34.21	34.31	46764.0
2014-01-14	AOR	ETF	38.36	38.49	38.3	38.49	23858.0
2014-01-14	ARGT	ETF	19.0	19.1	18.83	18.86	1300.0
2014-01-14	ASEA	ETF	15.27	15.31	15.2	15.3	15300.0
2014-01-14	ASHR	ETF	23.32	23.47	23.3	23.44	269900.0
2014-01-14	ATMP	ETF	26.7	26.83	26.64	26.8	25500.0
2014-01-14	AVIV	ETF	23.84	24.4099	23.79	24.09	40828.0
2014-01-14	AWAY	ETF	40.33	41.44	40.286	41.22	988991.0
2014-01-14	BAB	ETF	27.81	27.8175	27.7	27.72	89336.0
2014-01-14	BAL	ETF	52.66	52.66	52.51	52.51	1610.0
2014-01-14	BALT	ETF	5.89	6.13	5.82	6.08	962537.0
2014-01-14	BBH	ETF	91.25	94.27	91.22	94.27	139900.0
2014-01-14	BCM	ETF	38.92	38.93	38.85	38.86	117175.0
2014-01-14	BFOR	ETF	7.325	7.425	7.325	7.41	129200.0
2014-01-14	BIB	ETF	41.2025	43.47	40.8651	43.47	316636.0
2014-01-14	BICK	ETF	23.69	23.84	23.69	23.84	3665.0
2014-01-14	BIL	ETF	91.54	91.56	91.54	91.56	188500.0
2014-01-14	BIS	ETF	760.0	763.12	710.0	714.796	2633.5
2014-01-14	BIV	ETF	82.62	82.71	82.52	82.57	207300.0
2014-01-14	BIZD	ETF	21.03	21.07	21.02	21.06	11700.0
2014-01-14	BJK	ETF	53.82	54.54	53.53	54.52	17800.0
2014-01-14	BKF	ETF	36.09	36.4	35.98	36.34	86723.0
2014-01-14	BKLN	ETF	24.99	25.0	24.97	25.0	2711200.0
2014-01-14	BLV	ETF	83.55	83.63	83.45	83.47	39600.0
2014-01-14	BMVP	ETF	22.59	22.86	22.56	22.86	4007.0

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

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