PREVIEW / etf_daily / 2015-01-13

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-13.parquet
  size:    47 KB
  rows:    1,158

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
2015-01-13	SPY	ETF	204.12	205.48	200.51	202.08	214553300.0
2015-01-13	QQQ	ETF	102.54	103.62	100.7	101.52	56162334.0
2015-01-13	IWM	ETF	118.09	119.39	115.82	117.27	49991400.0
2015-01-13	DIA	ETF	177.72	179.03	174.7	175.98	9913500.0
2015-01-13	GLD	ETF	118.96	119.19	117.87	118.16	7693200.0
2015-01-13	TLT	ETF	131.39	132.61	131.14	131.82	8260800.0
2015-01-13	AAXJ	ETF	61.96	62.24	61.35	61.74	774400.0
2015-01-13	ACWI	ETF	58.0	58.37	57.17	57.61	7197800.0
2015-01-13	ACWV	ETF	69.66	69.98	68.77	69.21	132800.0
2015-01-13	ACWX	ETF	42.47	42.6699	41.91	42.22	998346.0
2015-01-13	ADRE	ETF	35.66	35.7839	35.4299	35.52	8450.0
2015-01-13	AFK	ETF	25.7	25.7799	25.2901	25.35	39419.0
2015-01-13	AGG	ETF	111.15	111.33	111.03	111.15	5537000.0
2015-01-13	AGQ	ETF	44.82	45.47	43.97	44.45	344300.0
2015-01-13	AGZ	ETF	114.63	114.63	114.0	114.41	41204.0
2015-01-13	AGZD	ETF	24.58	24.58	24.505	24.545	9400.0
2015-01-13	AIA	ETF	48.16	48.32	47.65	47.97	24919.0
2015-01-13	AIQ	ETF	20.75	21.68	20.75	21.1	38557.0
2015-01-13	AIRR	ETF	17.3	17.59	16.94	17.14	41900.0
2015-01-13	AIVI	ETF	42.47	42.67	42.01	42.29	29700.0
2015-01-13	ALTL	ETF	38.0382	38.0382	38.0382	38.0382	115.0
2015-01-13	AMJ	ETF	42.4	42.93	41.44	41.8	2672404.0
2015-01-13	AMLP	ETF	83.3	83.95	81.5	81.95	1583420.0
2015-01-13	AMZA	ETF	201.89	201.89	196.4	196.4	380.0
2015-01-13	ANGL	ETF	26.36	26.53	26.36	26.49	1900.0
2015-01-13	AOA	ETF	46.21	46.38	45.56	45.83	30100.0
2015-01-13	AOK	ETF	32.57	32.67	32.4928	32.5336	28862.0
2015-01-13	AOM	ETF	35.09	35.24	34.89	35.0	78480.0
2015-01-13	AOR	ETF	40.11	40.22	39.7	39.87	31029.0
2015-01-13	ARGT	ETF	17.99	18.08	17.74	17.97	6300.0
2015-01-13	ARKG	ETF	22.89	22.89	22.25	22.36	9000.0
2015-01-13	ARKK	ETF	20.26	20.26	19.982	19.99	400.0
2015-01-13	ARKQ	ETF	18.99	18.99	18.62	18.79	1200.0
2015-01-13	ARKW	ETF	20.37	20.37	20.0	20.0	200.0
2015-01-13	ASEA	ETF	15.5	15.54	15.37	15.41	6100.0
2015-01-13	ASHR	ETF	36.69	36.85	36.2	36.33	1748000.0
2015-01-13	ASHS	ETF	35.97	35.97	35.66	35.67	8300.0
2015-01-13	ATMP	ETF	28.61	28.65	27.73	27.89	55100.0
2015-01-13	AVIV	ETF	37.84	38.1	37.61	38.04	435263.0
2015-01-13	AWAY	ETF	27.68	28.085	26.75	26.93	1156529.0
2015-01-13	BAB	ETF	30.86	31.0995	30.74	30.92	634549.0
2015-01-13	BAL	ETF	40.67	41.0751	40.67	41.0252	1573.0
2015-01-13	BALT	ETF	2.11	2.16	1.92	1.95	781695.0
2015-01-13	BAR	ETF	3.102	3.13	3.078	3.083	160850.0
2015-01-13	BBC	ETF	29.7	29.82	28.5193	28.91	38772.0
2015-01-13	BBH	ETF	120.9	122.47	118.42	119.79	156300.0
2015-01-13	BBP	ETF	28.25	28.402	27.58	27.58	9100.0
2015-01-13	BCHP	ETF	17.881	17.881	17.61	17.61	3624.0
2015-01-13	BCM	ETF	30.72	30.72	30.46	30.46	60300.0
2015-01-13	BFOR	ETF	7.7375	7.83	7.6275	7.675	121200.0

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

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