PREVIEW / etf_daily / 2015-02-19

all etf daily files

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

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-19	SPY	ETF	209.41	210.42	209.24	209.98	91462500.0
2015-02-19	QQQ	ETF	107.09	107.76	107.06	107.69	19828113.0
2015-02-19	IWM	ETF	121.76	122.38	121.54	122.05	16620500.0
2015-02-19	DIA	ETF	179.87	180.43	179.43	180.09	2663500.0
2015-02-19	GLD	ETF	116.4	116.54	115.74	115.94	6528700.0
2015-02-19	TLT	ETF	126.78	127.45	126.17	126.17	8584800.0
2015-02-19	AADR	ETF	38.73	38.75	38.59	38.64	5100.0
2015-02-19	AAXJ	ETF	63.42	63.57	63.21	63.35	427500.0
2015-02-19	ACWI	ETF	60.5	60.75	60.41	60.6	926000.0
2015-02-19	ACWV	ETF	71.29	71.47	71.19	71.25	51000.0
2015-02-19	ACWX	ETF	44.87	45.0281	44.77	44.9	675919.0
2015-02-19	ADRE	ETF	36.61	36.6199	36.415	36.44	6256.0
2015-02-19	AFK	ETF	25.64	25.815	25.48	25.48	25154.0
2015-02-19	AGG	ETF	110.62	110.76	110.48	110.53	1443000.0
2015-02-19	AGQ	ETF	41.45	41.68	40.63	40.92	346200.0
2015-02-19	AGZ	ETF	114.01	115.289	113.6501	113.76	17597.0
2015-02-19	AGZD	ETF	24.535	24.57	24.525	24.555	10000.0
2015-02-19	AIA	ETF	49.09	49.1745	48.95	49.03	5512.0
2015-02-19	AIQ	ETF	24.9	25.2	24.57	24.99	10993.0
2015-02-19	AIRR	ETF	18.1	18.19	18.0	18.1	14800.0
2015-02-19	AIVI	ETF	45.0	45.2	44.81	45.02	46900.0
2015-02-19	ALTL	ETF	37.7801	37.7801	37.7801	37.7801	330.0
2015-02-19	AMJ	ETF	45.12	45.649	44.6	45.5	1345462.0
2015-02-19	AMLP	ETF	84.7	85.45	84.25	85.3	1108400.0
2015-02-19	AMZA	ETF	217.12	221.9	217.12	221.9	170.0
2015-02-19	ANGL	ETF	27.4	27.48	27.25	27.37	26900.0
2015-02-19	AOA	ETF	47.39	47.63	47.36	47.55	145800.0
2015-02-19	AOK	ETF	32.81	32.81	32.7	32.754	39614.0
2015-02-19	AOM	ETF	35.37	35.5	35.37	35.5	54384.0
2015-02-19	AOR	ETF	40.8	40.8641	40.715	40.8	44599.0
2015-02-19	ARGT	ETF	19.83	19.85	19.75	19.85	10300.0
2015-02-19	ARKG	ETF	23.28	23.28	23.2	23.256	3400.0
2015-02-19	ARKK	ETF	21.53	21.54	21.34	21.54	1700.0
2015-02-19	ARKQ	ETF	20.179	20.22	20.141	20.194	5600.0
2015-02-19	ARKW	ETF	22.182	22.216	22.182	22.216	200.0
2015-02-19	ASEA	ETF	15.76	15.76	15.75	15.76	8600.0
2015-02-19	ASHR	ETF	35.91	36.07	35.87	35.9	466700.0
2015-02-19	ASHS	ETF	38.4	38.5	38.4	38.5	500.0
2015-02-19	ATMP	ETF	30.18	30.53	30.07	30.39	340900.0
2015-02-19	AVIV	ETF	36.79	36.79	35.63	35.73	86668.0
2015-02-19	AWAY	ETF	30.79	31.09	30.41	30.78	1467543.0
2015-02-19	BAB	ETF	30.09	30.47	29.7	29.71	424124.0
2015-02-19	BAL	ETF	44.71	44.83	43.89	44.056	27130.0
2015-02-19	BALT	ETF	1.64	1.7	1.62	1.64	512900.0
2015-02-19	BAR	ETF	2.85	2.858	2.84	2.858	7940.0
2015-02-19	BBC	ETF	30.55	30.55	30.35	30.5	5037.0
2015-02-19	BBH	ETF	124.25	125.69	124.25	125.36	102100.0
2015-02-19	BBP	ETF	29.582	29.7	29.5	29.59	13800.0
2015-02-19	BCHP	ETF	19.12	19.15	19.12	19.15	810.0
2015-02-19	BCM	ETF	31.47	31.842	31.47	31.842	3647.0

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

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