PREVIEW / etf_daily / 2014-11-21

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-21.parquet
  size:    47 KB
  rows:    1,154

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-11-21	SPY	ETF	207.64	207.84	205.98	206.68	142327300.0
2014-11-21	QQQ	ETF	104.59	104.69	103.54	103.87	34049128.0
2014-11-21	IWM	ETF	118.08	118.12	116.16	116.58	43240400.0
2014-11-21	DIA	ETF	178.52	178.6	177.28	177.7	4782000.0
2014-11-21	GLD	ETF	115.58	115.96	114.47	115.39	6564300.0
2014-11-21	TLT	ETF	119.57	120.16	119.52	120.1	3640100.0
2014-11-21	AADR	ETF	38.17	38.41	38.13	38.29	2800.0
2014-11-21	AAXJ	ETF	63.01	63.04	62.72	62.95	567800.0
2014-11-21	ACWI	ETF	60.63	60.63	60.23	60.44	669500.0
2014-11-21	ACWV	ETF	70.32	70.32	69.73	69.92	79100.0
2014-11-21	ACWX	ETF	45.62	45.6399	45.36	45.5	476957.0
2014-11-21	ADRE	ETF	39.32	40.08	39.32	40.06	16685.0
2014-11-21	AFK	ETF	29.19	29.45	29.095	29.231	15502.0
2014-11-21	AGG	ETF	109.92	109.96	109.84	109.9	1295000.0
2014-11-21	AGQ	ETF	42.45	43.07	41.43	42.45	344600.0
2014-11-21	AGZ	ETF	113.0884	113.17	112.85	113.04	8452.0
2014-11-21	AGZD	ETF	24.735	24.735	24.665	24.715	9200.0
2014-11-21	AIA	ETF	48.03	48.31	47.93	48.05	50791.0
2014-11-21	AIQ	ETF	23.1	23.22	22.78	23.07	14625.0
2014-11-21	AIRR	ETF	18.93	19.06	18.67	18.7	94200.0
2014-11-21	AIVI	ETF	46.19	46.25	45.95	46.1	27400.0
2014-11-21	ALTL	ETF	36.6563	36.6563	36.6563	36.6563	242.0
2014-11-21	AMJ	ETF	52.78	53.34	52.18	52.3	1770207.0
2014-11-21	AMLP	ETF	94.75	95.4	93.65	93.7	1634040.0
2014-11-21	AMZA	ETF	255.5	255.5	250.0	250.3	1350.0
2014-11-21	ANGL	ETF	27.39	27.69	27.25	27.69	7400.0
2014-11-21	AOA	ETF	46.95	47.09	46.88	46.98	27600.0
2014-11-21	AOK	ETF	32.86	32.91	32.8301	32.86	33572.0
2014-11-21	AOM	ETF	35.42	35.539	35.4122	35.5	42757.0
2014-11-21	AOR	ETF	40.61	40.61	40.395	40.48	86559.0
2014-11-21	ARGT	ETF	21.08	21.38	21.08	21.33	7700.0
2014-11-21	ARKG	ETF	20.15	20.15	19.97	20.03	2000.0
2014-11-21	ARKK	ETF	20.37	20.37	20.358	20.36	1300.0
2014-11-21	ARKQ	ETF	20.36	20.36	20.308	20.308	500.0
2014-11-21	ARKW	ETF	20.75	20.75	20.39	20.41	3900.0
2014-11-21	ASEA	ETF	17.01	17.03	16.86	16.97	10300.0
2014-11-21	ASHR	ETF	28.7	28.78	28.4	28.61	948700.0
2014-11-21	ASHS	ETF	34.79	35.49	34.79	35.29	27900.0
2014-11-21	ATMP	ETF	33.0	33.0	32.54	32.54	13100.0
2014-11-21	AVIV	ETF	32.96	33.12	32.87	32.93	547117.0
2014-11-21	AWAY	ETF	30.29	31.653	30.25	30.63	2385946.0
2014-11-21	BAB	ETF	29.85	29.88	29.74	29.86	36692.0
2014-11-21	BAL	ETF	40.3209	40.51	40.31	40.51	6912.0
2014-11-21	BALT	ETF	3.51	3.745	3.48	3.66	1131723.0
2014-11-21	BAR	ETF	2.9155	2.944	2.855	2.9103	30940.0
2014-11-21	BBH	ETF	115.69	116.08	114.33	114.53	78300.0
2014-11-21	BCHP	ETF	18.85	18.85	18.85	18.85	692.0
2014-11-21	BCM	ETF	35.61	35.646	35.61	35.618	1086.0
2014-11-21	BFOR	ETF	8.01	8.05	7.9425	7.95	118000.0
2014-11-21	BIB	ETF	60.575	61.3	59.54	59.68	344762.0

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

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