PREVIEW / etf_daily / 2014-11-19

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-19.parquet
  size:    46 KB
  rows:    1,143

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-19	SPY	ETF	205.31	205.55	204.3	205.22	82373000.0
2014-11-19	QQQ	ETF	103.57	103.57	102.73	103.21	23760243.0
2014-11-19	IWM	ETF	116.25	116.25	114.37	115.15	38258700.0
2014-11-19	DIA	ETF	176.85	177.19	176.29	176.93	4011400.0
2014-11-19	GLD	ETF	114.93	115.35	112.88	113.68	11997700.0
2014-11-19	TLT	ETF	118.88	119.58	118.76	118.76	5792500.0
2014-11-19	AADR	ETF	37.78	37.91	37.67	37.67	500.0
2014-11-19	AAXJ	ETF	61.78	61.98	61.56	61.83	261600.0
2014-11-19	ACWI	ETF	60.0	60.07	59.69	59.96	724400.0
2014-11-19	ACWV	ETF	69.51	69.73	69.36	69.65	355200.0
2014-11-19	ACWX	ETF	45.17	45.2497	44.9	45.09	416117.0
2014-11-19	ADRE	ETF	38.38	38.523	38.2	38.523	7145.0
2014-11-19	AFK	ETF	29.37	29.41	29.0	29.27	38998.0
2014-11-19	AGG	ETF	109.68	109.84	109.56	109.57	1361800.0
2014-11-19	AGQ	ETF	41.34	42.79	39.46	40.84	311300.0
2014-11-19	AGZ	ETF	112.86	112.98	112.67	112.8052	5852.0
2014-11-19	AGZD	ETF	24.785	24.79	24.715	24.725	24000.0
2014-11-19	AIA	ETF	47.11	47.29	47.04	47.26	22448.0
2014-11-19	AIQ	ETF	23.4499	23.73	22.39	22.49	22013.0
2014-11-19	AIRR	ETF	18.86	18.86	18.42	18.42	81600.0
2014-11-19	AIVI	ETF	45.91	46.09	45.75	45.98	78600.0
2014-11-19	AMJ	ETF	51.54	52.04	51.54	52.03	721285.0
2014-11-19	AMLP	ETF	93.35	94.1	93.35	94.1	758280.0
2014-11-19	AMZA	ETF	249.8	249.8	247.9	248.5	680.0
2014-11-19	ANGL	ETF	27.62	27.68	27.4	27.47	2600.0
2014-11-19	AOA	ETF	46.71	46.71	46.47	46.54	24400.0
2014-11-19	AOK	ETF	32.77	32.77	32.688	32.73	22401.0
2014-11-19	AOM	ETF	35.38	35.38	35.22	35.3	51456.0
2014-11-19	AOR	ETF	40.14	40.26	40.09	40.17	98692.0
2014-11-19	ARGT	ETF	21.0	21.01	20.71	20.82	4700.0
2014-11-19	ARKG	ETF	19.92	19.92	19.92	19.92	900.0
2014-11-19	ARKK	ETF	20.29	20.29	20.29	20.29	1100.0
2014-11-19	ARKQ	ETF	20.17	20.19	20.12	20.13	1000.0
2014-11-19	ARKW	ETF	20.48	20.48	20.236	20.236	2100.0
2014-11-19	ASEA	ETF	16.92	16.94	16.77	16.87	40500.0
2014-11-19	ASHR	ETF	27.12	27.35	27.05	27.33	890400.0
2014-11-19	ASHS	ETF	34.1	34.27	34.08	34.27	8300.0
2014-11-19	ATMP	ETF	32.36	32.53	32.28	32.53	40600.0
2014-11-19	AVIV	ETF	32.93	33.12	32.47	32.5	457999.0
2014-11-19	AWAY	ETF	30.36	30.36	29.88	30.18	613964.0
2014-11-19	BAB	ETF	29.79	29.84	29.71	29.71	169660.0
2014-11-19	BAL	ETF	40.85	40.85	40.28	40.31	4002.0
2014-11-19	BALT	ETF	3.3	3.31	3.19	3.23	701076.0
2014-11-19	BAR	ETF	2.8741	2.9	2.738	2.786	215860.0
2014-11-19	BBH	ETF	114.68	115.39	113.72	114.74	48900.0
2014-11-19	BCM	ETF	35.081	35.081	35.0427	35.0427	546.0
2014-11-19	BFOR	ETF	7.8925	7.8925	7.8125	7.8675	82400.0
2014-11-19	BIB	ETF	59.785	60.575	58.7527	59.475	249588.0
2014-11-19	BICK	ETF	24.349	24.349	24.349	24.349	180.0
2014-11-19	BIL	ETF	91.5	91.5	91.48	91.48	272750.0

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

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