PREVIEW / etf_daily / 2014-01-09

all etf daily files

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

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-09	SPY	ETF	184.11	184.13	182.8	183.64	90683400.0
2014-01-09	QQQ	ETF	87.62	87.64	86.72	87.02	23695690.0
2014-01-09	IWM	ETF	115.25	115.39	114.16	114.89	29872800.0
2014-01-09	DIA	ETF	164.95	164.99	163.52	164.19	8212900.0
2014-01-09	GLD	ETF	118.11	118.69	117.99	118.46	3972800.0
2014-01-09	TLT	ETF	102.97	103.21	102.51	103.18	6991100.0
2014-01-09	AADR	ETF	37.41	37.5	36.96	37.38	3900.0
2014-01-09	AAXJ	ETF	57.77	58.01	57.29	57.71	956800.0
2014-01-09	ACWI	ETF	57.01	57.01	56.53	56.82	793600.0
2014-01-09	ACWV	ETF	62.6	62.8	62.45	62.67	319200.0
2014-01-09	ACWX	ETF	45.8	45.8	45.38	45.63	778653.0
2014-01-09	ADRE	ETF	35.56	35.6665	35.06	35.24	38416.0
2014-01-09	AFK	ETF	29.94	30.11	29.76	30.11	31995.0
2014-01-09	AGG	ETF	106.56	106.58	106.42	106.56	829400.0
2014-01-09	AGQ	ETF	63.12	64.6	62.64	63.6	351950.0
2014-01-09	AGZ	ETF	110.57	110.6099	110.51	110.588	8525.0
2014-01-09	AGZD	ETF	25.095	25.095	25.05	25.06	20600.0
2014-01-09	AIA	ETF	45.89	45.89	45.43	45.6499	19855.0
2014-01-09	AIQ	ETF	27.16	27.5	27.0	27.16	27703.0
2014-01-09	AIVI	ETF	46.62	46.65	46.33	46.56	21500.0
2014-01-09	ALTL	ETF	32.8616	32.8664	32.7	32.844	3590.0
2014-01-09	AMJ	ETF	45.41	45.6499	45.15	45.37	589185.0
2014-01-09	AMLP	ETF	87.45	87.45	86.95	87.2	496060.0
2014-01-09	ANGL	ETF	26.83	26.94	26.81	26.94	6500.0
2014-01-09	AOA	ETF	44.4	44.4	44.17	44.34	22000.0
2014-01-09	AOK	ETF	31.99	31.99	31.903	31.97	36776.0
2014-01-09	AOM	ETF	34.22	34.25	34.1399	34.24	96778.0
2014-01-09	AOR	ETF	38.4	38.4	38.22	38.27	48148.0
2014-01-09	ARGT	ETF	18.67	18.87	18.62	18.87	4500.0
2014-01-09	ASEA	ETF	15.06	15.06	15.0	15.02	11200.0
2014-01-09	ASHR	ETF	23.4	23.4	23.12	23.2	566500.0
2014-01-09	ATMP	ETF	26.75	26.75	26.73	26.73	3900.0
2014-01-09	AVIV	ETF	23.65	23.95	23.46	23.93	78877.0
2014-01-09	AWAY	ETF	42.34	42.52	40.52	40.96	1007079.0
2014-01-09	BAB	ETF	27.49	27.52	27.44	27.49	127027.0
2014-01-09	BAL	ETF	52.4599	53.03	51.93	52.1009	6683.0
2014-01-09	BALT	ETF	6.74	6.75	6.14	6.15	1731345.0
2014-01-09	BBH	ETF	91.0	91.58	90.15	91.19	284900.0
2014-01-09	BCM	ETF	38.61	38.61	38.41	38.5	88245.0
2014-01-09	BFOR	ETF	7.445	7.455	7.38	7.425	238400.0
2014-01-09	BIB	ETF	39.81	40.4605	39.1625	40.25	494632.0
2014-01-09	BICK	ETF	23.63	23.63	23.405	23.405	902.0
2014-01-09	BIL	ETF	91.54	91.56	91.54	91.54	140700.0
2014-01-09	BIS	ETF	779.6	794.8	770.0	776.0	954.0
2014-01-09	BIV	ETF	81.93	82.06	81.84	82.03	305300.0
2014-01-09	BIZD	ETF	20.78	21.02	20.78	20.94	29600.0
2014-01-09	BJK	ETF	54.6	54.6	54.01	54.3	31400.0
2014-01-09	BKF	ETF	35.95	35.95	35.58	35.74	284040.0
2014-01-09	BKLN	ETF	24.97	24.98	24.96	24.98	1904700.0
2014-01-09	BLV	ETF	82.41	82.59	82.21	82.56	21300.0

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

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