PREVIEW / etf_daily / 2013-10-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-14.parquet
  size:    42 KB
  rows:    1,035

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
2013-10-14	SPY	ETF	169.21	171.08	169.08	170.94	112106000.0
2013-10-14	QQQ	ETF	78.74	79.79	78.68	79.79	31471884.0
2013-10-14	IWM	ETF	107.06	108.35	106.93	108.22	38774800.0
2013-10-14	DIA	ETF	151.19	152.88	151.08	152.8	6470100.0
2013-10-14	GLD	ETF	123.9	124.24	122.81	122.83	6118200.0
2013-10-14	TLT	ETF	105.39	105.64	104.33	104.61	4205600.0
2013-10-14	AADR	ETF	35.52	35.81	35.52	35.81	14400.0
2013-10-14	AAXJ	ETF	60.61	61.3	60.45	61.22	408700.0
2013-10-14	ACTV	ETF	14.4	14.415	14.38	14.4	1365378.0
2013-10-14	ACWI	ETF	54.52	54.99	54.42	54.93	1336100.0
2013-10-14	ACWV	ETF	61.93	62.59	61.93	62.53	46500.0
2013-10-14	ACWX	ETF	45.35	45.82	45.35	45.79	87476.0
2013-10-14	ADRE	ETF	37.9	38.42	37.76	38.42	37455.0
2013-10-14	AFK	ETF	30.77	30.865	30.65	30.86	17631.0
2013-10-14	AGG	ETF	107.1	107.12	106.85	106.87	412900.0
2013-10-14	AGQ	ETF	78.68	79.0	76.92	76.96	337875.0
2013-10-14	AGZ	ETF	112.97	112.97	110.3601	111.64	9007.0
2013-10-14	AIA	ETF	47.79	48.457	47.79	48.31	27931.0
2013-10-14	AIQ	ETF	28.04	28.06	26.94	27.76	22085.0
2013-10-14	AIVI	ETF	45.94	46.35	45.94	46.28	30300.0
2013-10-14	ALTL	ETF	30.25	30.63	30.25	30.54	132400.0
2013-10-14	AMJ	ETF	44.39	44.96	44.101	44.93	504465.0
2013-10-14	AMLP	ETF	87.75	88.1	87.05	88.0	564980.0
2013-10-14	ANGL	ETF	26.0	26.75	25.94	26.74	4800.0
2013-10-14	AOA	ETF	42.19	42.5	42.12	42.48	16900.0
2013-10-14	AOK	ETF	31.42	31.48	31.415	31.46	16486.0
2013-10-14	AOM	ETF	33.31	33.49	33.31	33.49	22072.0
2013-10-14	AOR	ETF	36.94	37.18	36.87	37.18	19968.0
2013-10-14	ARGT	ETF	20.13	20.4	20.04	20.4	4300.0
2013-10-14	ASEA	ETF	17.07	17.23	17.06	17.21	4500.0
2013-10-14	ATMP	ETF	25.93	26.25	25.93	26.2	12100.0
2013-10-14	AVIV	ETF	23.79	23.98	23.37	23.59	69007.0
2013-10-14	AWAY	ETF	29.05	29.07	28.73	28.95	593074.0
2013-10-14	BAB	ETF	27.42	27.49	27.29	27.31	73000.0
2013-10-14	BAL	ETF	53.43	53.5599	53.3	53.5	3929.0
2013-10-14	BALT	ETF	4.92	4.989	4.85	4.95	339824.0
2013-10-14	BBH	ETF	77.48	79.27	77.3	79.17	82600.0
2013-10-14	BFOR	ETF	6.875	6.94	6.855	6.9375	458400.0
2013-10-14	BIB	ETF	29.1975	30.4975	28.935	30.3875	242068.0
2013-10-14	BICK	ETF	24.68	24.96	24.68	24.96	1450.0
2013-10-14	BIL	ETF	91.54	91.56	91.54	91.54	150500.0
2013-10-14	BIS	ETF	1103.2	1125.56	1076.0	1080.0	364.5
2013-10-14	BIV	ETF	83.38	83.41	83.06	83.17	103200.0
2013-10-14	BIZD	ETF	20.36	20.36	20.26	20.28	6500.0
2013-10-14	BJK	ETF	48.93	49.42	48.83	49.34	18500.0
2013-10-14	BKF	ETF	38.49	39.29	38.49	39.19	101208.0
2013-10-14	BKLN	ETF	24.72	24.74	24.7	24.72	1194000.0
2013-10-14	BLNG	ETF	36.85	36.88	36.85	36.87	1150.0
2013-10-14	BLV	ETF	82.64	82.96	82.09	82.27	43500.0
2013-10-14	BMVP	ETF	20.7151	20.77	20.7151	20.7383	1200.0

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

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