PREVIEW / etf_daily / 2014-01-29

all etf daily files

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

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-29	SPY	ETF	177.58	178.55	176.88	177.35	216597300.0
2014-01-29	QQQ	ETF	85.1	85.74	84.76	84.93	52064566.0
2014-01-29	IWM	ETF	111.88	112.58	111.02	111.34	61904600.0
2014-01-29	DIA	ETF	157.66	158.25	156.75	157.1	14271200.0
2014-01-29	GLD	ETF	122.19	122.51	121.13	122.47	12257500.0
2014-01-29	TLT	ETF	107.37	108.15	106.99	107.87	11709400.0
2014-01-29	AADR	ETF	35.73	35.73	35.67	35.67	500.0
2014-01-29	AAXJ	ETF	55.62	55.92	55.3	55.55	1035200.0
2014-01-29	ACWI	ETF	55.12	55.38	54.91	55.03	2419300.0
2014-01-29	ACWV	ETF	61.05	61.25	60.69	60.76	339300.0
2014-01-29	ACWX	ETF	44.04	44.3899	44.03	44.14	401372.0
2014-01-29	ADRE	ETF	33.69	33.936	33.54	33.59	22526.0
2014-01-29	AFK	ETF	29.75	30.28	29.72	30.1	34308.0
2014-01-29	AGG	ETF	107.68	107.92	107.68	107.85	1116200.0
2014-01-29	AGQ	ETF	65.39	65.79	63.0	64.85	785700.0
2014-01-29	AGZ	ETF	111.49	111.56	111.31	111.54	11742.0
2014-01-29	AIA	ETF	43.58	43.9209	43.521	43.65	18814.0
2014-01-29	AIQ	ETF	27.51	27.99	27.5	27.79	22169.0
2014-01-29	AIVI	ETF	45.85	46.15	45.84	45.95	23500.0
2014-01-29	ALTL	ETF	32.009	32.009	31.986	31.986	408.0
2014-01-29	AMJ	ETF	45.71	46.15	45.5	45.82	765521.0
2014-01-29	AMLP	ETF	87.75	88.5	87.65	88.15	466280.0
2014-01-29	ANGL	ETF	27.07	27.09	27.05	27.06	1400.0
2014-01-29	AOA	ETF	43.18	43.44	43.12	43.18	22200.0
2014-01-29	AOK	ETF	31.81	31.83	31.75	31.779	33201.0
2014-01-29	AOM	ETF	33.87	33.9399	33.81	33.82	58294.0
2014-01-29	AOR	ETF	37.71	37.7919	37.6	37.64	24715.0
2014-01-29	ARGT	ETF	17.6	17.83	17.09	17.26	12700.0
2014-01-29	ASEA	ETF	14.64	14.64	14.53	14.53	11400.0
2014-01-29	ASHR	ETF	23.23	23.23	23.05	23.13	117100.0
2014-01-29	ATMP	ETF	27.11	27.26	26.95	26.95	48400.0
2014-01-29	AVIV	ETF	24.4	24.62	24.223	24.48	60997.0
2014-01-29	AWAY	ETF	39.25	40.21	38.01	39.83	1306187.0
2014-01-29	BAB	ETF	28.12	28.14	27.944	28.06	195015.0
2014-01-29	BAL	ETF	53.09	54.13	52.78	53.66	6511.0
2014-01-29	BALT	ETF	5.27	5.485	5.15	5.45	516661.0
2014-01-29	BBH	ETF	93.83	97.13	93.83	95.56	164700.0
2014-01-29	BCM	ETF	39.01	39.04	38.74	38.9801	11520.0
2014-01-29	BFOR	ETF	7.1625	7.1825	7.1025	7.1225	224800.0
2014-01-29	BIB	ETF	42.5	44.3895	41.63	43.065	461786.0
2014-01-29	BICK	ETF	22.56	22.705	22.51	22.58	2971.0
2014-01-29	BIL	ETF	91.54	91.56	91.54	91.56	146350.0
2014-01-29	BIS	ETF	714.4	729.6	685.204	705.76	2424.0
2014-01-29	BIV	ETF	83.3	83.48	83.18	83.37	233300.0
2014-01-29	BIZD	ETF	20.96	20.97	20.76	20.76	11200.0
2014-01-29	BJK	ETF	50.72	50.72	50.0	50.33	31900.0
2014-01-29	BKF	ETF	34.04	34.429	33.8401	34.13	60722.0
2014-01-29	BKLN	ETF	24.89	24.9	24.87	24.9	2126300.0
2014-01-29	BLV	ETF	85.11	85.49	84.82	85.32	46400.0
2014-01-29	BMVP	ETF	21.92	22.07	21.8933	21.8933	6564.0

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

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