PREVIEW / etf_daily / 2013-11-14

all etf daily files

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

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-11-14	SPY	ETF	178.54	179.42	178.25	179.27	103435000.0
2013-11-14	QQQ	ETF	83.29	83.86	83.14	83.8	31101157.0
2013-11-14	IWM	ETF	110.47	110.6	109.74	110.41	33226800.0
2013-11-14	DIA	ETF	158.1	158.81	157.95	158.73	6931000.0
2013-11-14	GLD	ETF	123.92	124.91	123.88	124.27	7669700.0
2013-11-14	TLT	ETF	104.31	105.12	104.15	104.52	8895500.0
2013-11-14	AADR	ETF	36.2	36.43	36.2	36.4	6400.0
2013-11-14	AAXJ	ETF	58.34	59.1	58.3	59.01	706700.0
2013-11-14	ACTV	ETF	14.49	14.5	14.48	14.48	1271514.0
2013-11-14	ACWI	ETF	56.11	56.46	56.09	56.42	721500.0
2013-11-14	ACWV	ETF	64.28	64.59	64.11	64.54	17300.0
2013-11-14	ACWX	ETF	45.7	46.05	45.68	46.02	190732.0
2013-11-14	ADRE	ETF	37.09	37.5805	37.09	37.58	39816.0
2013-11-14	AFK	ETF	31.04	31.26	30.7107	31.21	18417.0
2013-11-14	AGG	ETF	107.12	107.33	107.1	107.33	1437800.0
2013-11-14	AGQ	ETF	72.2	73.4	72.0	72.84	377950.0
2013-11-14	AGZ	ETF	111.24	111.69	111.24	111.66	11263.0
2013-11-14	AIA	ETF	46.59	47.0786	46.59	47.0786	6639.0
2013-11-14	AIQ	ETF	24.25	25.12	23.25	23.74	22932.0
2013-11-14	AIVI	ETF	46.45	46.84	46.45	46.78	16500.0
2013-11-14	ALTL	ETF	31.8	31.96	31.75	31.9344	1951.0
2013-11-14	AMJ	ETF	45.15	45.71	45.0	45.44	632287.0
2013-11-14	AMLP	ETF	86.75	87.65	86.75	87.25	533760.0
2013-11-14	ANGL	ETF	26.66	26.66	26.65	26.65	2100.0
2013-11-14	AOA	ETF	43.53	43.7	43.53	43.7	39100.0
2013-11-14	AOK	ETF	31.75	31.88	31.75	31.84	45700.0
2013-11-14	AOM	ETF	33.91	34.0672	33.91	34.03	33411.0
2013-11-14	AOR	ETF	37.88	38.0	37.82	38.0	158586.0
2013-11-14	ARGT	ETF	19.38	19.84	19.38	19.79	6000.0
2013-11-14	ASEA	ETF	16.57	16.74	16.56	16.72	17500.0
2013-11-14	ASHR	ETF	24.18	24.33	24.13	24.31	36600.0
2013-11-14	ATMP	ETF	26.76	26.76	26.65	26.65	150800.0
2013-11-14	AVIV	ETF	24.95	25.72	24.95	25.44	200008.0
2013-11-14	AWAY	ETF	35.15	36.22	34.5905	35.94	3868863.0
2013-11-14	BAB	ETF	27.46	27.5999	27.46	27.49	76316.0
2013-11-14	BAL	ETF	49.0	49.0	48.55	48.601	5340.0
2013-11-14	BALT	ETF	4.78	5.03	4.75	4.89	1149804.0
2013-11-14	BBH	ETF	81.44	82.38	81.3	82.09	41200.0
2013-11-14	BCM	ETF	39.32	39.326	39.26	39.274	3652.0
2013-11-14	BFOR	ETF	7.1775	7.2125	7.1475	7.2075	226800.0
2013-11-14	BIB	ETF	31.9175	32.485	31.7688	32.2028	289712.0
2013-11-14	BICK	ETF	23.74	23.93	23.74	23.895	1791.0
2013-11-14	BIL	ETF	91.58	91.58	91.56	91.56	156700.0
2013-11-14	BIS	ETF	1000.0	1006.0	979.84	980.6	511.0
2013-11-14	BIV	ETF	83.6	83.89	83.6	83.84	215100.0
2013-11-14	BIZD	ETF	20.81	20.81	20.81	20.81	100.0
2013-11-14	BJK	ETF	49.78	49.82	49.35	49.7	28300.0
2013-11-14	BKF	ETF	37.17	37.6899	37.08	37.61	54218.0
2013-11-14	BKLN	ETF	24.88	24.91	24.88	24.88	4492500.0
2013-11-14	BLV	ETF	82.5	82.88	82.28	82.66	28100.0

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

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