PREVIEW / etf_daily / 2015-03-13

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-13.parquet
  size:    47 KB
  rows:    1,162

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-03-13	SPY	ETF	206.77	207.93	204.58	205.83	162410900.0
2015-03-13	QQQ	ETF	105.7	106.12	104.68	105.34	42021103.0
2015-03-13	IWM	ETF	122.94	123.19	121.21	122.61	26371000.0
2015-03-13	DIA	ETF	178.39	178.5	176.27	177.56	6833900.0
2015-03-13	GLD	ETF	111.1	111.28	110.51	110.88	4557600.0
2015-03-13	TLT	ETF	126.76	127.59	126.49	126.72	7247200.0
2015-03-13	AADR	ETF	38.39	38.44	38.39	38.44	300.0
2015-03-13	AAXJ	ETF	61.71	61.71	61.27	61.48	1368600.0
2015-03-13	ACWI	ETF	59.28	59.32	58.77	59.12	729000.0
2015-03-13	ACWV	ETF	70.5	70.53	69.95	70.31	153500.0
2015-03-13	ACWX	ETF	43.56	43.5804	43.31	43.56	88442.0
2015-03-13	ADRE	ETF	33.99	33.99	33.7101	33.86	5167.0
2015-03-13	AFK	ETF	24.8	24.8	24.51	24.5581	48101.0
2015-03-13	AFTY	ETF	17.6	17.61	17.54	17.58	22000.0
2015-03-13	AGG	ETF	110.44	110.63	110.25	110.34	3235500.0
2015-03-13	AGQ	ETF	36.83	36.89	36.3	36.71	118900.0
2015-03-13	AGZ	ETF	113.48	113.92	113.48	113.6799	14665.0
2015-03-13	AGZD	ETF	24.58	24.6	24.485	24.56	5200.0
2015-03-13	AIA	ETF	48.26	48.26	47.96	48.14	15520.0
2015-03-13	AIQ	ETF	23.8	24.82	23.71	24.77	16465.0
2015-03-13	AIRR	ETF	18.111	18.2	18.0	18.17	24400.0
2015-03-13	AIVI	ETF	43.15	43.15	42.83	43.0	17100.0
2015-03-13	ALTL	ETF	37.28	37.29	36.96	37.08	1384.0
2015-03-13	AMJ	ETF	41.81	41.98	41.39	41.8	1542135.0
2015-03-13	AMLP	ETF	81.1	81.25	80.65	81.15	919860.0
2015-03-13	AMZA	ETF	205.0	205.0	203.0	203.0	890.0
2015-03-13	ANGL	ETF	27.21	27.27	27.15	27.27	7500.0
2015-03-13	AOA	ETF	46.97	46.97	46.53	46.8	83900.0
2015-03-13	AOK	ETF	32.54	32.6	32.48	32.5	33142.0
2015-03-13	AOM	ETF	35.32	35.32	35.15	35.23	53274.0
2015-03-13	AOR	ETF	40.47	40.47	40.18	40.28	64561.0
2015-03-13	ARGT	ETF	20.26	20.38	20.26	20.38	4000.0
2015-03-13	ARKG	ETF	23.16	23.16	22.76	22.864	4400.0
2015-03-13	ARKK	ETF	20.59	20.616	20.58	20.616	5100.0
2015-03-13	ARKQ	ETF	19.92	19.95	19.92	19.95	400.0
2015-03-13	ARKW	ETF	21.65	21.74	21.481	21.54	1200.0
2015-03-13	ASEA	ETF	15.11	15.11	15.06	15.08	4200.0
2015-03-13	ASHR	ETF	36.8	36.8	36.51	36.66	406500.0
2015-03-13	ASHS	ETF	41.62	41.62	41.38	41.56	16000.0
2015-03-13	ATMP	ETF	28.18	28.31	28.08	28.31	38300.0
2015-03-13	AVIV	ETF	35.36	35.63	34.98	35.25	139676.0
2015-03-13	AWAY	ETF	30.28	30.49	30.08	30.31	1295879.0
2015-03-13	BAB	ETF	29.96	29.9845	29.67	29.73	191632.0
2015-03-13	BAL	ETF	41.31	41.31	41.107	41.2	3299.0
2015-03-13	BALT	ETF	1.44	1.46	1.38	1.44	321459.0
2015-03-13	BAR	ETF	2.45	2.45	2.45	2.45	1610.0
2015-03-13	BBC	ETF	33.24	33.81	32.94	33.45	15302.0
2015-03-13	BBH	ETF	129.88	131.57	129.24	130.31	55400.0
2015-03-13	BBP	ETF	30.96	31.73	30.96	31.57	13500.0
2015-03-13	BCHP	ETF	18.71	18.71	18.6722	18.6722	1000.0

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

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