PREVIEW / etf_daily / 2015-05-13

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-13.parquet
  size:    48 KB
  rows:    1,174

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-05-13	SPY	ETF	210.47	211.22	209.74	210.02	94667900.0
2015-05-13	QQQ	ETF	108.25	108.81	107.84	108.0	20738434.0
2015-05-13	IWM	ETF	122.76	123.21	122.0	122.49	27214700.0
2015-05-13	DIA	ETF	180.85	181.44	180.48	180.75	3851400.0
2015-05-13	GLD	ETF	115.74	116.93	115.68	116.55	11768200.0
2015-05-13	TLT	ETF	120.65	120.72	118.64	118.88	15760000.0
2015-05-13	AADR	ETF	40.34	40.4	40.34	40.4	2000.0
2015-05-13	AAXJ	ETF	67.08	67.25	66.86	66.9	1363400.0
2015-05-13	ACTX	ETF	2.95	2.95	2.36	2.95	910.0
2015-05-13	ACWF	ETF	25.18	25.18	25.17	25.17	446.0
2015-05-13	ACWI	ETF	62.39	62.49	62.07	62.13	1329000.0
2015-05-13	ACWV	ETF	73.29	73.44	72.91	72.91	86900.0
2015-05-13	ACWX	ETF	47.3	47.4	47.0679	47.13	98755.0
2015-05-13	ADRE	ETF	37.22	37.22	36.86	36.86	9757.0
2015-05-13	AFK	ETF	26.82	26.881	26.7	26.7	33711.0
2015-05-13	AFTY	ETF	22.18	22.18	21.91	21.95	91800.0
2015-05-13	AGG	ETF	109.91	109.92	109.45	109.57	2441600.0
2015-05-13	AGQ	ETF	43.4	44.22	43.12	43.7	630900.0
2015-05-13	AGZ	ETF	113.13	113.26	113.06	113.08	22248.0
2015-05-13	AGZD	ETF	24.545	24.545	24.425	24.425	11800.0
2015-05-13	AIA	ETF	52.73	52.84	52.63	52.64	70867.0
2015-05-13	AIQ	ETF	20.6	21.0	20.6	20.89	14902.0
2015-05-13	AIRR	ETF	18.176	18.18	18.07	18.18	8100.0
2015-05-13	AIVI	ETF	46.69	46.84	46.52	46.59	25200.0
2015-05-13	AMJ	ETF	44.68	45.56	44.572	44.95	1554153.0
2015-05-13	AMLP	ETF	85.0	85.1	83.55	84.2	1103020.0
2015-05-13	AMZA	ETF	226.5	226.5	222.6	222.6	2990.0
2015-05-13	ANGL	ETF	27.56	27.58	27.46	27.56	14100.0
2015-05-13	AOA	ETF	48.51	48.75	48.39	48.49	17700.0
2015-05-13	AOK	ETF	32.97	33.0291	32.8404	32.94	25928.0
2015-05-13	AOM	ETF	35.78	35.8742	35.68	35.76	34781.0
2015-05-13	AOR	ETF	41.38	41.51	41.28	41.34	39247.0
2015-05-13	ARGT	ETF	22.25	22.27	22.11	22.16	9000.0
2015-05-13	ARKG	ETF	22.73	22.73	22.73	22.73	200.0
2015-05-13	ARKK	ETF	21.01	21.01	21.01	21.01	200.0
2015-05-13	ARKQ	ETF	19.79	19.79	19.79	19.79	200.0
2015-05-13	ARKW	ETF	22.709	22.709	22.63	22.63	300.0
2015-05-13	ASEA	ETF	16.04	16.04	15.96	15.96	2400.0
2015-05-13	ASHR	ETF	48.21	48.39	47.82	47.96	1650200.0
2015-05-13	ASHS	ETF	57.14	57.45	57.14	57.41	48500.0
2015-05-13	ATMP	ETF	30.85	30.86	30.32	30.45	10900.0
2015-05-13	AWAY	ETF	26.81	27.35	26.51	26.99	1484579.0
2015-05-13	BAB	ETF	29.21	29.27	28.9504	29.03	142526.0
2015-05-13	BAL	ETF	44.46	44.6899	44.08	44.637	4285.0
2015-05-13	BALT	ETF	1.47	1.48	1.4351	1.45	157491.0
2015-05-13	BAR	ETF	2.75	2.853	2.7316	2.853	18060.0
2015-05-13	BBC	ETF	33.2	33.3899	32.6401	33.0275	25471.0
2015-05-13	BBH	ETF	131.48	131.95	129.95	130.44	44700.0
2015-05-13	BBP	ETF	32.36	32.36	31.33	31.494	21800.0
2015-05-13	BCHP	ETF	20.72	20.72	20.5778	20.5778	2101.0

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

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