PREVIEW / etf_daily / 2014-06-25

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-25.parquet
  size:    45 KB
  rows:    1,102

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-06-25	SPY	ETF	194.29	195.78	194.25	195.58	82782000.0
2014-06-25	QQQ	ETF	92.49	93.45	92.48	93.29	32818591.0
2014-06-25	IWM	ETF	116.06	117.79	116.05	117.75	34620800.0
2014-06-25	DIA	ETF	167.52	168.48	167.51	168.28	3657500.0
2014-06-25	GLD	ETF	126.78	127.55	126.66	126.99	6692300.0
2014-06-25	TLT	ETF	113.1	113.36	112.69	112.87	5699300.0
2014-06-25	AADR	ETF	38.56	38.85	38.56	38.85	8500.0
2014-06-25	AAXJ	ETF	61.98	62.2	61.9	62.11	228700.0
2014-06-25	ACWI	ETF	59.83	60.12	59.74	60.04	391900.0
2014-06-25	ACWV	ETF	66.38	66.52	66.21	66.52	46100.0
2014-06-25	ACWX	ETF	47.76	47.87	47.66	47.84	224406.0
2014-06-25	ADRE	ETF	38.77	38.89	38.66	38.84	3532.0
2014-06-25	AFK	ETF	32.67	32.77	32.52	32.6	35334.0
2014-06-25	AGG	ETF	109.2	109.28	109.11	109.18	713700.0
2014-06-25	AGQ	ETF	70.73	72.07	70.69	71.13	281100.0
2014-06-25	AGZ	ETF	112.47	112.57	112.441	112.49	4789.0
2014-06-25	AGZD	ETF	25.02	25.02	24.905	24.905	3000.0
2014-06-25	AIA	ETF	47.36	47.706	47.36	47.65	4132.0
2014-06-25	AIQ	ETF	28.49	28.49	26.72	27.11	52241.0
2014-06-25	AIRR	ETF	19.04	19.21	19.02	19.2	8700.0
2014-06-25	AIVI	ETF	50.45	50.55	50.36	50.55	14000.0
2014-06-25	ALTL	ETF	35.56	35.56	35.556	35.556	421.0
2014-06-25	AMJ	ETF	51.47	51.9	51.4101	51.75	482626.0
2014-06-25	AMLP	ETF	93.95	94.4	93.75	94.25	527260.0
2014-06-25	ANGL	ETF	28.42	28.45	28.42	28.44	1400.0
2014-06-25	AOA	ETF	46.85	47.06	46.85	47.05	27600.0
2014-06-25	AOK	ETF	32.92	33.03	32.92	33.03	29490.0
2014-06-25	AOM	ETF	35.6	35.65	35.578	35.63	31642.0
2014-06-25	AOR	ETF	40.26	40.38	40.24	40.38	28211.0
2014-06-25	ARGT	ETF	22.1	22.24	21.96	22.23	27200.0
2014-06-25	ASEA	ETF	16.63	16.7	16.61	16.7	4600.0
2014-06-25	ASHR	ETF	22.05	22.05	21.98	22.01	39500.0
2014-06-25	ASHS	ETF	25.4	25.54	25.25	25.4	9400.0
2014-06-25	ATMP	ETF	31.15	31.28	31.02	31.28	15600.0
2014-06-25	AVIV	ETF	28.61	28.83	28.42	28.64	241691.0
2014-06-25	AWAY	ETF	34.06	35.07	34.06	35.05	1843214.0
2014-06-25	BAB	ETF	29.11	29.39	29.11	29.21	56645.0
2014-06-25	BAL	ETF	51.5999	51.5999	50.76	50.761	6433.0
2014-06-25	BALT	ETF	6.03	6.19	5.99	6.14	852168.0
2014-06-25	BBH	ETF	94.77	95.92	94.5	95.11	93800.0
2014-06-25	BCHP	ETF	20.52	20.52	20.5	20.5199	2100.0
2014-06-25	BCM	ETF	42.06	42.16	42.02	42.132	4302.0
2014-06-25	BFOR	ETF	7.755	7.8075	7.735	7.7975	62000.0
2014-06-25	BIB	ETF	45.785	46.66	45.4453	46.11	565076.0
2014-06-25	BICK	ETF	26.48	26.633	26.45	26.45	934.0
2014-06-25	BIL	ETF	91.52	91.54	91.52	91.52	56800.0
2014-06-25	BIS	ETF	587.2	587.2	544.0	544.0	5482.5
2014-06-25	BIV	ETF	84.62	84.69	84.51	84.55	229700.0
2014-06-25	BIZD	ETF	20.3	20.39	20.21	20.39	40900.0
2014-06-25	BJK	ETF	48.49	48.9	48.49	48.8	26100.0

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

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