PREVIEW / etf_daily / 2014-12-22

all etf daily files

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

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-22	SPY	ETF	206.75	207.47	206.46	207.47	148318900.0
2014-12-22	QQQ	ETF	104.15	104.61	104.0999	104.58	33869167.0
2014-12-22	IWM	ETF	119.2	119.71	118.8	119.71	27043400.0
2014-12-22	DIA	ETF	178.22	179.36	178.19	179.36	7855600.0
2014-12-22	GLD	ETF	114.81	114.97	112.41	112.55	7483200.0
2014-12-22	TLT	ETF	125.45	126.19	125.32	126.04	4118800.0
2014-12-22	AADR	ETF	38.98	38.98	37.64	37.64	300.0
2014-12-22	AAXJ	ETF	60.46	60.95	60.46	60.88	691000.0
2014-12-22	ACWI	ETF	59.1	59.23	58.99	59.22	2569200.0
2014-12-22	ACWV	ETF	69.07	69.36	68.99	69.19	151700.0
2014-12-22	ACWX	ETF	43.62	43.69	43.45	43.58	1697129.0
2014-12-22	ADRE	ETF	35.76	35.94	35.74	35.87	23162.0
2014-12-22	AFK	ETF	25.98	26.125	25.4	25.4	43695.0
2014-12-22	AGG	ETF	110.35	110.46	110.27	110.45	3827800.0
2014-12-22	AGQ	ETF	39.28	39.5	37.21	37.89	243300.0
2014-12-22	AGZ	ETF	114.95	114.95	113.2001	113.25	16738.0
2014-12-22	AGZD	ETF	24.665	24.675	24.585	24.585	29200.0
2014-12-22	AIA	ETF	46.85	47.09	46.841	46.99	57930.0
2014-12-22	AIQ	ETF	21.9	23.59	21.9	22.44	19279.0
2014-12-22	AIRR	ETF	18.18	18.18	17.94	18.16	70200.0
2014-12-22	AIVI	ETF	43.89	44.09	43.73	43.92	28500.0
2014-12-22	AMJ	ETF	45.29	45.53	44.52	45.49	2191733.0
2014-12-22	AMLP	ETF	86.4	87.05	85.55	87.05	1464920.0
2014-12-22	AMZA	ETF	220.01	224.2	220.01	224.2	120.0
2014-12-22	ANGL	ETF	26.52	26.87	25.76	26.54	4700.0
2014-12-22	AOA	ETF	46.69	46.92	46.69	46.92	34200.0
2014-12-22	AOK	ETF	32.82	32.84	32.76	32.84	31989.0
2014-12-22	AOM	ETF	35.36	35.52	35.36	35.52	260881.0
2014-12-22	AOR	ETF	40.28	40.53	40.28	40.53	1315378.0
2014-12-22	ARGT	ETF	18.86	18.86	18.64	18.65	1800.0
2014-12-22	ARKG	ETF	21.4	21.597	21.347	21.57	3200.0
2014-12-22	ARKK	ETF	20.35	20.35	20.247	20.33	1200.0
2014-12-22	ARKQ	ETF	19.83	19.83	19.76	19.82	1400.0
2014-12-22	ARKW	ETF	20.67	20.67	20.66	20.66	300.0
2014-12-22	ASEA	ETF	16.1	16.19	16.08	16.17	20500.0
2014-12-22	ASHR	ETF	35.71	35.95	35.2	35.4	776600.0
2014-12-22	ASHS	ETF	35.1	35.21	35.08	35.15	27400.0
2014-12-22	ATMP	ETF	29.61	30.34	29.61	30.34	28600.0
2014-12-22	AVIV	ETF	34.21	35.03	34.21	35.03	260572.0
2014-12-22	AWAY	ETF	29.8	30.08	29.24	29.3	705544.0
2014-12-22	BAB	ETF	30.48	30.48	30.3159	30.42	78666.0
2014-12-22	BAL	ETF	41.8899	42.5097	41.72	42.5097	8276.0
2014-12-22	BALT	ETF	2.52	2.635	2.44	2.57	727922.0
2014-12-22	BAR	ETF	2.656	2.657	2.656	2.656	4600.0
2014-12-22	BBC	ETF	28.75	28.75	27.799	28.17	36513.0
2014-12-22	BBH	ETF	119.02	119.77	116.77	117.61	271300.0
2014-12-22	BBP	ETF	26.34	26.56	25.885	26.23	33900.0
2014-12-22	BCHP	ETF	18.47	18.47	18.4	18.4	283.0
2014-12-22	BCM	ETF	32.7	32.72	32.3612	32.41	779182.0
2014-12-22	BFOR	ETF	7.9225	7.9375	7.9025	7.9325	89200.0

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

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