PREVIEW / etf_daily / 2015-02-11

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-11.parquet
  size:    47 KB
  rows:    1,156

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-02-11	SPY	ETF	206.61	207.45	205.83	206.93	91087800.0
2015-02-11	QQQ	ETF	104.52	105.02	104.32	104.78	20303617.0
2015-02-11	IWM	ETF	119.37	119.82	118.62	119.45	23794200.0
2015-02-11	DIA	ETF	178.09	179.09	177.67	178.7	5174500.0
2015-02-11	GLD	ETF	118.49	118.57	117.0	117.07	6784400.0
2015-02-11	TLT	ETF	129.7	130.27	128.96	129.95	6506400.0
2015-02-11	AADR	ETF	37.31	37.31	37.31	37.31	100.0
2015-02-11	AAXJ	ETF	62.3	62.57	62.16	62.42	602700.0
2015-02-11	ACWI	ETF	59.26	59.45	59.04	59.32	880000.0
2015-02-11	ACWV	ETF	70.69	70.87	70.38	70.72	71700.0
2015-02-11	ACWX	ETF	43.61	43.7	43.41	43.6	260232.0
2015-02-11	ADRE	ETF	35.65	35.71	35.4501	35.7	12623.0
2015-02-11	AFK	ETF	25.23	25.34	24.918	25.06	51428.0
2015-02-11	AGG	ETF	110.88	110.99	110.74	110.87	1803400.0
2015-02-11	AGQ	ETF	43.72	43.72	42.59	42.88	107500.0
2015-02-11	AGZ	ETF	114.03	114.4954	113.8391	114.13	23148.0
2015-02-11	AGZD	ETF	24.59	24.59	24.475	24.535	10000.0
2015-02-11	AIA	ETF	48.36	48.45	48.11	48.29	37780.0
2015-02-11	AIQ	ETF	23.39	25.26	23.39	24.7	22405.0
2015-02-11	AIRR	ETF	17.879	17.879	17.675	17.8	20800.0
2015-02-11	AIVI	ETF	44.05	44.08	43.83	44.02	21600.0
2015-02-11	AMJ	ETF	45.3	45.58	44.69	44.72	1349726.0
2015-02-11	AMLP	ETF	84.9	85.0	83.9	83.95	1021480.0
2015-02-11	AMZA	ETF	215.0	215.0	215.0	215.0	30.0
2015-02-11	ANGL	ETF	27.16	27.17	27.12	27.16	5200.0
2015-02-11	AOA	ETF	46.66	46.75	46.5	46.67	34400.0
2015-02-11	AOK	ETF	32.6	32.6	32.48	32.53	27175.0
2015-02-11	AOM	ETF	35.15	35.19	35.0801	35.18	38917.0
2015-02-11	AOR	ETF	40.43	40.43	40.11	40.27	65607.0
2015-02-11	ARGT	ETF	19.15	19.15	19.1	19.15	1000.0
2015-02-11	ARKG	ETF	22.64	22.64	22.51	22.586	1900.0
2015-02-11	ARKK	ETF	20.95	21.026	20.86	21.026	2200.0
2015-02-11	ARKQ	ETF	19.81	19.81	19.53	19.666	1300.0
2015-02-11	ARKW	ETF	21.46	21.46	21.46	21.46	200.0
2015-02-11	ASEA	ETF	15.57	15.66	15.57	15.66	29200.0
2015-02-11	ASHR	ETF	34.89	35.22	34.73	34.88	1805100.0
2015-02-11	ASHS	ETF	36.74	36.84	36.68	36.78	2200.0
2015-02-11	ATMP	ETF	29.92	30.06	29.88	29.88	134300.0
2015-02-11	AVIV	ETF	36.26	36.82	35.92	36.27	308544.0
2015-02-11	AWAY	ETF	27.1	27.41	26.725	27.24	1018856.0
2015-02-11	BAB	ETF	30.66	30.75	30.59	30.73	224818.0
2015-02-11	BAL	ETF	42.34	42.5	42.06	42.333	9987.0
2015-02-11	BALT	ETF	1.67	1.73	1.66	1.66	294037.0
2015-02-11	BAR	ETF	3.01	3.01	2.906	2.929	24600.0
2015-02-11	BBC	ETF	28.45	28.9799	28.11	28.2985	7765.0
2015-02-11	BBH	ETF	120.64	122.31	119.83	120.59	137100.0
2015-02-11	BBP	ETF	28.78	28.78	27.81	27.96	6500.0
2015-02-11	BCHP	ETF	18.65	18.65	18.65	18.65	300.0
2015-02-11	BCM	ETF	31.3	31.31	31.24	31.3	38797.0
2015-02-11	BFOR	ETF	7.97	7.995	7.9425	7.9925	417200.0

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

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