PREVIEW / etf_daily / 2015-03-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-16.parquet
  size:    48 KB
  rows:    1,181

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-16	SPY	ETF	206.71	208.69	205.86	208.58	136099200.0
2015-03-16	QQQ	ETF	105.73	106.74	105.62	106.7	25674085.0
2015-03-16	IWM	ETF	123.11	123.58	122.88	123.33	19906300.0
2015-03-16	DIA	ETF	178.25	179.91	178.25	179.78	5550100.0
2015-03-16	GLD	ETF	111.09	111.21	110.42	110.81	3265300.0
2015-03-16	TLT	ETF	127.94	128.15	127.27	127.94	6374600.0
2015-03-16	AADR	ETF	38.11	38.85	38.11	38.53	2000.0
2015-03-16	AAXJ	ETF	61.93	62.32	61.92	62.26	787300.0
2015-03-16	ACWI	ETF	59.47	59.86	59.31	59.83	672000.0
2015-03-16	ACWV	ETF	70.53	71.11	70.53	71.0	101900.0
2015-03-16	ACWX	ETF	43.88	44.1099	43.82	44.05	212000.0
2015-03-16	ADRE	ETF	34.16	34.3847	34.1501	34.3095	7734.0
2015-03-16	AFK	ETF	24.51	24.6599	24.28	24.3	68353.0
2015-03-16	AFTY	ETF	18.27	18.29	18.22	18.23	32600.0
2015-03-16	AGG	ETF	110.62	110.67	110.42	110.58	1305800.0
2015-03-16	AGQ	ETF	37.31	37.45	36.43	37.05	134200.0
2015-03-16	AGZ	ETF	113.76	113.89	113.57	113.6	36592.0
2015-03-16	AGZD	ETF	24.59	24.62	24.495	24.575	6400.0
2015-03-16	AIA	ETF	48.68	48.9	48.68	48.87	24603.0
2015-03-16	AIQ	ETF	25.09	25.33	25.0	25.17	15031.0
2015-03-16	AIRR	ETF	18.23	18.23	18.16	18.17	27200.0
2015-03-16	AIVI	ETF	43.23	43.56	43.23	43.43	26800.0
2015-03-16	AMJ	ETF	41.82	41.82	41.06	41.54	900108.0
2015-03-16	AMLP	ETF	81.15	81.15	80.35	81.1	1283120.0
2015-03-16	AMZA	ETF	203.0	204.6	203.0	204.6	70.0
2015-03-16	ANGL	ETF	27.11	27.38	27.01	27.25	17400.0
2015-03-16	AOA	ETF	47.0	47.24	46.99	47.24	29800.0
2015-03-16	AOK	ETF	32.67	32.74	32.62	32.72	14360.0
2015-03-16	AOM	ETF	35.25	35.44	35.1901	35.44	64459.0
2015-03-16	AOR	ETF	40.5	40.64	40.5	40.64	68034.0
2015-03-16	ARGT	ETF	20.51	20.95	20.47	20.95	24000.0
2015-03-16	ARKG	ETF	22.613	23.34	22.613	23.29	1800.0
2015-03-16	ARKK	ETF	20.83	20.83	20.8	20.8	300.0
2015-03-16	ARKQ	ETF	20.15	20.16	20.11	20.155	8100.0
2015-03-16	ARKW	ETF	21.67	21.693	21.6	21.69	2000.0
2015-03-16	ASEA	ETF	15.13	15.26	15.13	15.26	8300.0
2015-03-16	ASHR	ETF	37.98	38.25	37.94	38.1	1688900.0
2015-03-16	ASHS	ETF	43.42	43.43	43.25	43.34	21200.0
2015-03-16	ATMP	ETF	28.33	28.4	28.03	28.35	66400.0
2015-03-16	AVIV	ETF	35.41	35.89	35.37	35.43	141365.0
2015-03-16	AWAY	ETF	30.46	30.99	30.1348	30.98	994684.0
2015-03-16	BAB	ETF	29.93	30.0	29.69	29.82	200347.0
2015-03-16	BAL	ETF	40.98	41.3399	40.92	41.0101	33667.0
2015-03-16	BALT	ETF	1.45	1.47	1.35	1.36	421121.0
2015-03-16	BAR	ETF	2.464	2.482	2.45	2.482	43730.0
2015-03-16	BBC	ETF	34.29	34.29	33.65	33.95	58377.0
2015-03-16	BBH	ETF	130.62	133.99	130.62	133.89	110500.0
2015-03-16	BBP	ETF	32.35	32.35	31.682	31.87	20700.0
2015-03-16	BCM	ETF	29.7	30.06	29.7	30.06	20361.0
2015-03-16	BFOR	ETF	8.16	8.21	8.16	8.21	138000.0

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

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