PREVIEW / etf_daily / 2014-02-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-24.parquet
  size:    43 KB
  rows:    1,069

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-02-24	SPY	ETF	184.28	186.15	184.2	184.91	114063900.0
2014-02-24	QQQ	ETF	90.1	90.82	90.04	90.41	31517522.0
2014-02-24	IWM	ETF	115.84	117.31	115.76	116.51	43102800.0
2014-02-24	DIA	ETF	161.02	162.69	160.97	161.66	6704400.0
2014-02-24	GLD	ETF	128.51	129.07	128.34	128.99	12114200.0
2014-02-24	TLT	ETF	106.7	106.74	106.17	106.4	3816700.0
2014-02-24	AADR	ETF	37.96	37.96	37.96	37.96	200.0
2014-02-24	AAXJ	ETF	57.51	58.06	57.43	57.67	614100.0
2014-02-24	ACWI	ETF	57.46	57.92	57.38	57.61	1555400.0
2014-02-24	ACWV	ETF	63.2	63.55	63.07	63.16	56100.0
2014-02-24	ACWX	ETF	46.22	46.58	46.195	46.4	223163.0
2014-02-24	ADRE	ETF	35.1	35.25	35.1	35.13	19694.0
2014-02-24	AFK	ETF	30.98	31.19	30.74	30.95	41391.0
2014-02-24	AGG	ETF	107.8	107.8	107.68	107.7	838500.0
2014-02-24	AGQ	ETF	79.8	80.77	79.58	79.82	668100.0
2014-02-24	AGZ	ETF	111.67	111.78	111.6205	111.74	32395.0
2014-02-24	AIA	ETF	45.08	45.36	45.08	45.209	8318.0
2014-02-24	AIQ	ETF	29.89	31.75	28.73	30.96	45446.0
2014-02-24	AIVI	ETF	48.86	49.46	48.83	49.28	12600.0
2014-02-24	ALTL	ETF	33.5341	33.5341	33.5341	33.5341	386.0
2014-02-24	AMJ	ETF	46.41	46.5	46.1	46.33	719102.0
2014-02-24	AMLP	ETF	87.35	87.35	86.6	87.0	968300.0
2014-02-24	ANGL	ETF	27.4	27.44	27.4	27.44	1100.0
2014-02-24	AOA	ETF	44.76	45.1	44.76	44.87	50900.0
2014-02-24	AOK	ETF	32.15	32.31	32.15	32.22	19517.0
2014-02-24	AOM	ETF	34.48	34.67	34.48	34.55	41369.0
2014-02-24	AOR	ETF	38.7	38.92	38.7	38.75	52344.0
2014-02-24	ARGT	ETF	18.62	18.97	18.6	18.95	20400.0
2014-02-24	ASEA	ETF	15.53	15.66	15.53	15.59	18600.0
2014-02-24	ASHR	ETF	23.1	23.12	23.02	23.05	278300.0
2014-02-24	ATMP	ETF	27.4	27.4	27.16	27.28	10600.0
2014-02-24	AVIV	ETF	24.73	25.35	24.526	24.89	107896.0
2014-02-24	AWAY	ETF	46.15	47.45	46.15	46.98	3121009.0
2014-02-24	BAB	ETF	28.36	28.39	28.3001	28.34	82461.0
2014-02-24	BAL	ETF	55.372	56.45	55.372	55.43	27919.0
2014-02-24	BALT	ETF	6.33	6.59	6.32	6.52	711933.0
2014-02-24	BBH	ETF	104.99	106.82	104.99	106.01	164200.0
2014-02-24	BCM	ETF	41.36	41.36	40.95	41.16	99280.0
2014-02-24	BFOR	ETF	7.475	7.5675	7.475	7.53	165200.0
2014-02-24	BIB	ETF	53.21	54.24	52.84	53.625	677898.0
2014-02-24	BICK	ETF	23.48	23.55	23.48	23.5299	580.0
2014-02-24	BIL	ETF	91.54	91.56	91.54	91.56	613700.0
2014-02-24	BIS	ETF	560.0	560.0	546.0	554.0	6152.5
2014-02-24	BIV	ETF	83.45	83.46	83.32	83.41	229700.0
2014-02-24	BIZD	ETF	21.55	21.64	21.55	21.55	3400.0
2014-02-24	BJK	ETF	52.68	53.8	52.68	53.59	26400.0
2014-02-24	BKF	ETF	35.04	35.3499	35.02	35.11	45394.0
2014-02-24	BKLN	ETF	24.84	24.84	24.83	24.84	1299100.0
2014-02-24	BLV	ETF	85.2	85.22	84.9	85.05	65800.0
2014-02-24	BMVP	ETF	22.8867	23.2984	22.8867	23.2067	5064.0

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

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