PREVIEW / etf_daily / 2014-03-04

all etf daily files

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

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-04	SPY	ETF	186.79	187.98	186.75	187.58	167545900.0
2014-03-04	QQQ	ETF	90.63	90.98	90.56	90.81	33213909.0
2014-03-04	IWM	ETF	118.2	120.58	118.18	119.83	112793900.0
2014-03-04	DIA	ETF	163.13	164.0	163.05	163.63	7947500.0
2014-03-04	GLD	ETF	128.54	129.24	128.32	128.68	6341700.0
2014-03-04	TLT	ETF	108.35	108.35	107.36	107.39	8068100.0
2014-03-04	AADR	ETF	38.41	38.41	38.41	38.41	300.0
2014-03-04	AAXJ	ETF	58.24	58.46	58.11	58.24	514600.0
2014-03-04	ACWI	ETF	57.77	58.04	57.77	57.97	600000.0
2014-03-04	ACWV	ETF	63.54	63.96	63.54	63.93	21400.0
2014-03-04	ACWX	ETF	46.19	46.38	46.19	46.275	215562.0
2014-03-04	ADRE	ETF	35.08	35.2	34.97	35.17	12213.0
2014-03-04	AFK	ETF	31.3	31.3899	31.041	31.3	7556.0
2014-03-04	AGG	ETF	108.25	108.25	107.92	107.95	953700.0
2014-03-04	AGQ	ETF	73.17	74.53	72.69	73.75	674100.0
2014-03-04	AGZ	ETF	111.73	111.75	111.67	111.75	11320.0
2014-03-04	AIA	ETF	45.36	45.615	45.36	45.4	9661.0
2014-03-04	AIQ	ETF	30.26	31.94	30.26	31.0	22036.0
2014-03-04	AIVI	ETF	48.86	49.0	48.78	48.95	77800.0
2014-03-04	ALTL	ETF	33.7801	33.9817	33.7801	33.9025	825.0
2014-03-04	AMJ	ETF	46.11	46.5882	46.07	46.27	395859.0
2014-03-04	AMLP	ETF	87.5	87.7	87.2	87.5	666200.0
2014-03-04	ANGL	ETF	27.54	27.54	27.47	27.47	600.0
2014-03-04	AOA	ETF	44.94	45.35	44.94	45.33	56400.0
2014-03-04	AOK	ETF	32.4	32.43	32.3802	32.41	16372.0
2014-03-04	AOM	ETF	34.75	34.84	34.75	34.83	43204.0
2014-03-04	AOR	ETF	39.15	39.1699	39.0426	39.14	47423.0
2014-03-04	ARGT	ETF	19.21	19.21	18.8	18.95	2500.0
2014-03-04	ASEA	ETF	15.59	15.61	15.55	15.6	7600.0
2014-03-04	ASHR	ETF	22.51	22.6	22.5	22.54	109600.0
2014-03-04	ATMP	ETF	27.4	27.48	27.35	27.46	7600.0
2014-03-04	AVIV	ETF	25.61	26.22	25.55	25.98	128639.0
2014-03-04	AWAY	ETF	46.44	47.37	45.38	46.8	1124963.0
2014-03-04	BAB	ETF	28.64	28.64	28.49	28.54	226564.0
2014-03-04	BAL	ETF	55.49	55.69	55.41	55.59	6083.0
2014-03-04	BALT	ETF	7.0	7.25	6.97	7.12	1222496.0
2014-03-04	BBH	ETF	103.4	103.84	102.75	103.51	226400.0
2014-03-04	BCM	ETF	41.1638	41.44	41.16	41.34	258542.0
2014-03-04	BFOR	ETF	7.5925	7.7175	7.5925	7.705	226000.0
2014-03-04	BIB	ETF	52.32	52.79	51.8	52.405	717550.0
2014-03-04	BICK	ETF	23.53	23.535	23.52	23.53	3105.0
2014-03-04	BIL	ETF	91.54	91.56	91.54	91.54	490100.0
2014-03-04	BIS	ETF	565.2	569.6	556.4	558.8	10463.0
2014-03-04	BIV	ETF	83.8	83.81	83.56	83.58	154300.0
2014-03-04	BIZD	ETF	21.42	21.42	21.01	21.01	12100.0
2014-03-04	BJK	ETF	55.0	55.53	55.0	55.51	85600.0
2014-03-04	BKF	ETF	34.83	34.98	34.6501	34.75	40877.0
2014-03-04	BKLN	ETF	24.85	24.86	24.85	24.85	2881700.0
2014-03-04	BLV	ETF	85.94	86.17	85.45	85.58	145600.0
2014-03-04	BMVP	ETF	23.2233	23.5566	23.2233	23.5396	7033.0

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

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