PREVIEW / etf_daily / 2014-12-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-23.parquet
  size:    47 KB
  rows:    1,160

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-12-23	SPY	ETF	208.17	208.23	207.4	207.75	122167900.0
2014-12-23	QQQ	ETF	104.96	104.97	104.09	104.21	30156929.0
2014-12-23	IWM	ETF	120.44	120.44	119.45	119.86	34533000.0
2014-12-23	DIA	ETF	179.87	180.4	179.68	180.03	6224800.0
2014-12-23	GLD	ETF	112.88	113.32	112.61	112.74	7763300.0
2014-12-23	TLT	ETF	125.45	125.6	123.49	123.54	7406100.0
2014-12-23	AADR	ETF	37.58	37.78	37.42	37.42	3500.0
2014-12-23	AAXJ	ETF	60.53	60.57	60.19	60.26	1036000.0
2014-12-23	ACWI	ETF	59.18	59.34	59.09	59.2	2522900.0
2014-12-23	ACWV	ETF	69.18	69.31	69.04	69.19	84200.0
2014-12-23	ACWX	ETF	43.52	43.56	43.35	43.35	1369976.0
2014-12-23	ADRE	ETF	35.71	35.82	35.6107	35.76	28515.0
2014-12-23	AFK	ETF	25.42	25.93	25.42	25.66	33588.0
2014-12-23	AGG	ETF	110.3	110.39	109.9	109.94	2790800.0
2014-12-23	AGQ	ETF	38.03	38.64	37.88	38.0	150100.0
2014-12-23	AGZ	ETF	113.32	113.41	112.96	113.08	34409.0
2014-12-23	AGZD	ETF	24.67	24.67	24.605	24.62	11400.0
2014-12-23	AIA	ETF	46.73	46.95	46.51	46.53	83407.0
2014-12-23	AIQ	ETF	22.55	23.21	21.585	22.61	9915.0
2014-12-23	AIRR	ETF	18.08	18.47	18.08	18.39	51500.0
2014-12-23	AIVI	ETF	43.74	43.86	43.64	43.7	46200.0
2014-12-23	AMJ	ETF	45.64	46.19	45.4	46.01	2512366.0
2014-12-23	AMLP	ETF	87.35	87.9	86.7	87.7	1037380.0
2014-12-23	AMZA	ETF	225.7	227.1	225.7	227.1	140.0
2014-12-23	ANGL	ETF	26.52	26.77	26.52	26.77	3800.0
2014-12-23	AOA	ETF	46.92	46.99	46.86	46.94	131400.0
2014-12-23	AOK	ETF	32.88	32.88	32.7801	32.79	63747.0
2014-12-23	AOM	ETF	35.47	35.51	35.41	35.41	115952.0
2014-12-23	AOR	ETF	40.62	40.62	40.4825	40.53	196734.0
2014-12-23	ARGT	ETF	18.73	18.97	18.73	18.88	7200.0
2014-12-23	ARKG	ETF	21.79	21.79	21.0	21.08	2800.0
2014-12-23	ARKK	ETF	20.4	20.4	20.3	20.337	1800.0
2014-12-23	ARKQ	ETF	19.939	19.97	19.9	19.91	7800.0
2014-12-23	ARKW	ETF	20.69	20.75	20.69	20.73	1900.0
2014-12-23	ASEA	ETF	16.12	16.15	16.11	16.11	5600.0
2014-12-23	ASHR	ETF	34.33	34.48	33.9	34.07	1036100.0
2014-12-23	ASHS	ETF	34.27	34.27	33.8	33.83	25100.0
2014-12-23	ATMP	ETF	30.74	30.99	30.29	30.99	129000.0
2014-12-23	AVIV	ETF	35.2	35.2	34.67	34.78	146332.0
2014-12-23	AWAY	ETF	29.22	29.385	28.75	28.82	710609.0
2014-12-23	BAB	ETF	30.41	30.41	30.133	30.24	110524.0
2014-12-23	BAL	ETF	42.58	42.98	42.15	42.31	5150.0
2014-12-23	BALT	ETF	2.59	2.62	2.5	2.58	519127.0
2014-12-23	BAR	ETF	2.675	2.675	2.648	2.6545	9330.0
2014-12-23	BBC	ETF	27.99	27.99	26.2	26.37	85092.0
2014-12-23	BBH	ETF	117.37	117.6	110.82	112.02	370400.0
2014-12-23	BBP	ETF	26.41	26.41	24.92	25.22	5400.0
2014-12-23	BCHP	ETF	18.26	18.41	18.26	18.27	2447.0
2014-12-23	BCM	ETF	32.39	32.77	32.39	32.64	249380.0
2014-12-23	BFOR	ETF	7.96	7.9875	7.955	7.975	33200.0

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

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