PREVIEW / etf_daily / 2014-03-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-06.parquet
  size:    44 KB
  rows:    1,073

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-06	SPY	ETF	188.21	188.61	187.78	188.18	82516500.0
2014-03-06	QQQ	ETF	91.25	91.335	90.65	90.98	24086220.0
2014-03-06	IWM	ETF	120.12	120.25	119.42	119.74	35087600.0
2014-03-06	DIA	ETF	163.82	164.31	163.76	164.09	4651800.0
2014-03-06	GLD	ETF	129.71	130.47	129.47	130.17	5408900.0
2014-03-06	TLT	ETF	106.76	106.97	106.52	106.56	7418200.0
2014-03-06	AADR	ETF	38.91	38.96	38.38	38.38	800.0
2014-03-06	AAXJ	ETF	58.63	59.1	58.63	58.93	1409300.0
2014-03-06	ACWI	ETF	58.21	58.45	58.21	58.3	862100.0
2014-03-06	ACWV	ETF	63.75	64.15	63.75	64.04	9400.0
2014-03-06	ACWX	ETF	46.68	46.885	46.68	46.77	202807.0
2014-03-06	ADRE	ETF	35.45	35.9	35.45	35.75	12232.0
2014-03-06	AFK	ETF	31.63	31.84	31.63	31.8299	9903.0
2014-03-06	AGG	ETF	107.76	107.83	107.69	107.77	689200.0
2014-03-06	AGQ	ETF	75.18	76.92	74.67	75.84	418200.0
2014-03-06	AGZ	ETF	111.65	111.67	111.49	111.4901	9540.0
2014-03-06	AIA	ETF	45.7	45.86	45.69	45.7615	11695.0
2014-03-06	AIQ	ETF	30.92	32.9	30.48	31.17	38552.0
2014-03-06	AIVI	ETF	49.33	49.77	49.33	49.7	10900.0
2014-03-06	ALTL	ETF	34.0175	34.0175	33.9875	33.9875	330.0
2014-03-06	AMJ	ETF	46.43	46.495	46.094	46.24	566428.0
2014-03-06	AMLP	ETF	87.9	88.0	87.4	87.65	587420.0
2014-03-06	ANGL	ETF	27.64	27.64	27.55	27.55	1400.0
2014-03-06	AOA	ETF	45.41	45.54	45.4	45.46	21400.0
2014-03-06	AOK	ETF	32.48	32.48	32.426	32.44	18395.0
2014-03-06	AOM	ETF	34.848	34.92	34.84	34.87	30928.0
2014-03-06	AOR	ETF	39.16	39.262	39.16	39.2	33656.0
2014-03-06	ARGT	ETF	19.09	19.38	19.09	19.37	2400.0
2014-03-06	ASEA	ETF	15.74	15.9	15.74	15.86	13400.0
2014-03-06	ASHR	ETF	22.39	22.55	22.39	22.48	214300.0
2014-03-06	ATMP	ETF	27.46	27.55	27.42	27.47	26500.0
2014-03-06	AVIV	ETF	25.66	25.67	25.26	25.29	81087.0
2014-03-06	AWAY	ETF	46.57	47.69	46.57	46.93	1541880.0
2014-03-06	BAB	ETF	28.51	28.63	28.47	28.47	91403.0
2014-03-06	BAL	ETF	55.71	57.3199	55.65	57.16	29306.0
2014-03-06	BALT	ETF	7.75	7.94	7.47	7.6	1154221.0
2014-03-06	BBH	ETF	103.91	104.43	100.44	100.92	199200.0
2014-03-06	BCM	ETF	41.38	41.52	41.36	41.52	36120.0
2014-03-06	BFOR	ETF	7.72	7.73	7.69	7.7025	140400.0
2014-03-06	BIB	ETF	52.535	52.9	48.65	49.24	1092604.0
2014-03-06	BICK	ETF	24.09	24.12	24.01	24.01	1435.0
2014-03-06	BIL	ETF	91.54	91.56	91.54	91.56	159550.0
2014-03-06	BIS	ETF	564.8	602.8	557.2	597.2	14301.0
2014-03-06	BIV	ETF	83.47	83.47	83.29	83.35	196600.0
2014-03-06	BIZD	ETF	20.99	21.04	20.97	20.99	27700.0
2014-03-06	BJK	ETF	56.07	56.26	55.8	56.17	27800.0
2014-03-06	BKF	ETF	34.94	35.239	34.92	34.97	88012.0
2014-03-06	BKLN	ETF	24.86	24.87	24.84	24.86	7775100.0
2014-03-06	BLV	ETF	85.06	85.15	84.94	84.94	110900.0
2014-03-06	BMVP	ETF	23.6167	23.6194	23.5667	23.6167	3164.0

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

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