PREVIEW / etf_daily / 2014-01-21

all etf daily files

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

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-21	SPY	ETF	184.7	184.77	183.05	184.18	88621200.0
2014-01-21	QQQ	ETF	88.43	88.59	87.81	88.55	26432336.0
2014-01-21	IWM	ETF	116.73	116.87	115.78	116.62	29828700.0
2014-01-21	DIA	ETF	165.03	165.05	162.79	163.73	9675200.0
2014-01-21	GLD	ETF	119.23	119.97	119.23	119.7	6763500.0
2014-01-21	TLT	ETF	105.45	105.74	105.4	105.56	6436000.0
2014-01-21	AADR	ETF	37.6	37.64	37.54	37.54	600.0
2014-01-21	AAXJ	ETF	58.45	58.61	57.83	58.03	621800.0
2014-01-21	ACWI	ETF	57.36	57.46	57.03	57.28	2054800.0
2014-01-21	ACWV	ETF	62.93	63.19	62.62	62.83	99100.0
2014-01-21	ACWX	ETF	46.19	46.235	45.93	46.08	1150289.0
2014-01-21	ADRE	ETF	35.53	35.6304	35.27	35.45	31567.0
2014-01-21	AFK	ETF	31.05	31.499	30.88	31.18	92001.0
2014-01-21	AGG	ETF	107.21	107.34	107.17	107.3	1777100.0
2014-01-21	AGQ	ETF	64.84	66.04	64.72	65.72	728000.0
2014-01-21	AGZ	ETF	111.0	111.11	110.99	111.02	12318.0
2014-01-21	AGZD	ETF	25.09	25.09	25.005	25.01	6200.0
2014-01-21	AIA	ETF	46.32	46.32	45.72	46.0	50580.0
2014-01-21	AIQ	ETF	27.31	27.85	27.13	27.57	26960.0
2014-01-21	AIVI	ETF	47.54	47.63	47.31	47.58	35700.0
2014-01-21	AMJ	ETF	45.38	45.97	45.31	45.93	345921.0
2014-01-21	AMLP	ETF	87.7	88.15	87.5	88.1	563220.0
2014-01-21	ANGL	ETF	27.16	27.17	27.06	27.16	8800.0
2014-01-21	AOA	ETF	44.66	44.73	44.43	44.61	125400.0
2014-01-21	AOK	ETF	32.18	32.18	32.0701	32.14	55875.0
2014-01-21	AOM	ETF	34.46	34.48	34.32	34.41	128892.0
2014-01-21	AOR	ETF	38.67	38.67	38.4501	38.59	31901.0
2014-01-21	ARGT	ETF	19.39	19.99	19.39	19.55	1600.0
2014-01-21	ASEA	ETF	15.16	15.16	15.0	15.05	55000.0
2014-01-21	ASHR	ETF	23.08	23.08	22.86	22.97	186100.0
2014-01-21	ATMP	ETF	26.99	27.06	26.99	27.06	2900.0
2014-01-21	AVIV	ETF	24.07	24.52	23.82	24.51	128169.0
2014-01-21	AWAY	ETF	42.21	42.21	41.07	41.77	792652.0
2014-01-21	BAB	ETF	27.69	27.83	27.63	27.81	561257.0
2014-01-21	BAL	ETF	54.6	55.55	54.6	55.34	8182.0
2014-01-21	BALT	ETF	6.27	6.27	5.97	6.03	708713.0
2014-01-21	BBH	ETF	97.23	98.0	96.23	97.99	187900.0
2014-01-21	BCM	ETF	39.02	39.029	38.97	38.98	89130.0
2014-01-21	BFOR	ETF	7.435	7.4675	7.385	7.435	273200.0
2014-01-21	BIB	ETF	46.375	46.4725	44.9275	46.4525	580584.0
2014-01-21	BICK	ETF	23.685	23.78	23.685	23.78	648.0
2014-01-21	BIL	ETF	91.54	91.56	91.54	91.56	216350.0
2014-01-21	BIS	ETF	687.6	688.4	665.28	665.28	1795.0
2014-01-21	BIV	ETF	82.72	82.85	82.68	82.77	421400.0
2014-01-21	BIZD	ETF	21.34	21.4	21.34	21.4	2300.0
2014-01-21	BJK	ETF	55.1	55.1	54.43	54.67	33600.0
2014-01-21	BKF	ETF	36.06	36.13	35.73	35.86	125284.0
2014-01-21	BKLN	ETF	24.95	24.95	24.93	24.94	2348700.0
2014-01-21	BLV	ETF	83.99	84.27	83.92	84.18	48600.0
2014-01-21	BMVP	ETF	22.8567	22.8741	22.6633	22.7933	9281.0

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

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