PREVIEW / etf_daily / 2014-03-11

all etf daily files

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

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-11	SPY	ETF	188.44	188.71	186.8	187.23	99009100.0
2014-03-11	QQQ	ETF	90.83	91.055	89.95	90.22	27505046.0
2014-03-11	IWM	ETF	119.41	119.81	117.51	118.06	50359500.0
2014-03-11	DIA	ETF	164.28	164.49	163.11	163.42	5198700.0
2014-03-11	GLD	ETF	130.01	130.15	128.93	129.86	7289800.0
2014-03-11	TLT	ETF	105.98	106.34	105.78	106.32	3815700.0
2014-03-11	AADR	ETF	38.31	38.31	38.03	38.03	2500.0
2014-03-11	AAXJ	ETF	58.2	58.28	57.44	57.52	465400.0
2014-03-11	ACWI	ETF	58.03	58.08	57.47	57.58	645400.0
2014-03-11	ACWV	ETF	63.94	63.97	63.51	63.63	28000.0
2014-03-11	ACWX	ETF	46.04	46.2399	45.76	45.81	136009.0
2014-03-11	ADRE	ETF	34.98	35.02	34.4901	34.56	11499.0
2014-03-11	AFK	ETF	31.6386	31.74	31.34	31.36	13940.0
2014-03-11	AGG	ETF	107.53	107.56	107.44	107.46	2060700.0
2014-03-11	AGQ	ETF	73.37	73.76	70.1	71.13	595800.0
2014-03-11	AGZ	ETF	111.65	113.8952	111.32	111.46	8185.0
2014-03-11	AGZD	ETF	25.045	25.045	25.045	25.045	2000.0
2014-03-11	AIA	ETF	45.15	45.33	44.6845	44.7	10263.0
2014-03-11	AIQ	ETF	30.62	31.51	29.81	29.86	19773.0
2014-03-11	AIRR	ETF	20.01	20.01	19.69	19.69	1300.0
2014-03-11	AIVI	ETF	49.0	49.2	48.77	48.8	28100.0
2014-03-11	AMJ	ETF	46.14	46.31	45.65	45.83	1153467.0
2014-03-11	AMLP	ETF	87.35	87.4	86.75	87.2	444960.0
2014-03-11	ANGL	ETF	27.68	27.68	27.57	27.57	600.0
2014-03-11	AOA	ETF	45.27	45.3	44.9	44.96	23700.0
2014-03-11	AOK	ETF	32.324	32.36	32.2341	32.2426	20893.0
2014-03-11	AOM	ETF	34.74	34.78	34.56	34.56	43988.0
2014-03-11	AOR	ETF	38.99	39.078	38.83	38.8697	21964.0
2014-03-11	ARGT	ETF	18.86	19.0	18.86	18.95	1300.0
2014-03-11	ASEA	ETF	15.59	15.62	15.47	15.49	13600.0
2014-03-11	ASHR	ETF	21.64	21.7	21.45	21.48	221700.0
2014-03-11	ATMP	ETF	27.16	27.3	27.16	27.25	2594000.0
2014-03-11	AVIV	ETF	25.0	25.24	24.83	25.13	113913.0
2014-03-11	AWAY	ETF	45.75	46.07	44.58	44.8	2111517.0
2014-03-11	BAB	ETF	28.45	28.48	28.4	28.45	68674.0
2014-03-11	BAL	ETF	57.2	57.653	57.071	57.1234	6567.0
2014-03-11	BALT	ETF	7.3	7.48	7.1	7.1	841235.0
2014-03-11	BBH	ETF	100.88	101.37	99.7	100.19	236100.0
2014-03-11	BCM	ETF	41.13	41.17	40.901	40.92	37825.0
2014-03-11	BFOR	ETF	7.6925	7.72	7.6025	7.63	162800.0
2014-03-11	BIB	ETF	49.485	50.0	48.0	48.405	623376.0
2014-03-11	BICK	ETF	23.54	23.7299	23.54	23.7299	582.0
2014-03-11	BIL	ETF	91.54	91.56	91.54	91.54	42250.0
2014-03-11	BIS	ETF	598.4	611.2	584.4	606.8	7368.5
2014-03-11	BIV	ETF	83.06	83.2	83.0	83.11	182400.0
2014-03-11	BIZD	ETF	21.02	21.02	20.7	20.72	6900.0
2014-03-11	BJK	ETF	54.73	55.23	54.21	54.57	16400.0
2014-03-11	BKF	ETF	34.22	34.369	33.77	33.8	73697.0
2014-03-11	BKLN	ETF	24.86	24.87	24.86	24.87	1886700.0
2014-03-11	BLV	ETF	84.43	84.67	84.4	84.61	51300.0

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

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