PREVIEW / etf_daily / 2016-04-28

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-28.parquet
  size:    50 KB
  rows:    1,269

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
2016-04-28	SPY	ETF	208.46	209.76	206.96	207.45	97216200.0
2016-04-28	QQQ	ETF	107.69	108.3335	106.0705	106.28	29818155.0
2016-04-28	IWM	ETF	114.27	115.0	113.19	113.5	26126500.0
2016-04-28	DIA	ETF	179.06	180.15	177.74	178.2	3550700.0
2016-04-28	GLD	ETF	119.92	121.42	119.73	121.29	15133600.0
2016-04-28	TLT	ETF	128.21	129.14	128.04	129.05	7974600.0
2016-04-28	AADR	ETF	38.9	39.06	38.51	38.51	3900.0
2016-04-28	AAXJ	ETF	54.57	55.01	54.51	54.58	1445400.0
2016-04-28	ACTX	ETF	4.13	4.72	4.13	4.13	1169.0
2016-04-28	ACWF	ETF	23.4893	23.5	23.27	23.27	1382.0
2016-04-28	ACWI	ETF	57.19	57.59	56.92	57.06	1456000.0
2016-04-28	ACWV	ETF	73.81	74.24	73.63	73.85	236600.0
2016-04-28	ACWX	ETF	40.51	40.88	40.47	40.6	4010511.0
2016-04-28	ADRE	ETF	31.71	31.94	31.5	31.5	4104.0
2016-04-28	AFK	ETF	20.43	20.87	20.301	20.52	53147.0
2016-04-28	AFTY	ETF	12.77	12.78	12.75	12.78	1800.0
2016-04-28	AGG	ETF	110.68	110.95	110.59	110.9	9405200.0
2016-04-28	AGGY	ETF	50.82	50.885	50.813	50.855	7700.0
2016-04-28	AGQ	ETF	41.33	42.71	41.17	42.55	486500.0
2016-04-28	AGZ	ETF	114.44	114.6899	114.44	114.6899	9215.0
2016-04-28	AIA	ETF	43.66	43.86	43.49	43.49	11696.0
2016-04-28	AIQ	ETF	7.04	7.27	6.9509	7.16	35763.0
2016-04-28	AIRR	ETF	18.0	18.445	18.0	18.259	1000.0
2016-04-28	AIVI	ETF	39.36	39.69	39.3	39.3	33800.0
2016-04-28	ALTY	ETF	14.71	14.75	14.61	14.69	12400.0
2016-04-28	AMJ	ETF	29.86	30.1599	29.53	29.62	3272273.0
2016-04-28	AMLP	ETF	60.95	61.4	60.0	60.15	2102940.0
2016-04-28	AMZA	ETF	106.5	106.5	101.8	102.6	5920.0
2016-04-28	ANGL	ETF	27.15	27.19	27.09	27.15	89700.0
2016-04-28	AOA	ETF	45.88	46.15	45.67	45.7	70200.0
2016-04-28	AOK	ETF	32.54	32.5799	32.45	32.49	33177.0
2016-04-28	AOM	ETF	35.05	35.1	34.85	34.96	81899.0
2016-04-28	AOR	ETF	39.78	39.95	39.65	39.73	68364.0
2016-04-28	ARGT	ETF	20.73	20.9	20.62	20.78	108300.0
2016-04-28	ARKG	ETF	18.409	18.409	18.02	18.02	500.0
2016-04-28	ARKK	ETF	19.595	19.595	19.595	19.595	200.0
2016-04-28	ARKQ	ETF	19.36	19.36	19.36	19.36	200.0
2016-04-28	ARKW	ETF	21.05	21.05	21.05	21.05	1300.0
2016-04-28	ASEA	ETF	13.46	13.46	13.42	13.42	600.0
2016-04-28	ASHR	ETF	23.95	24.0	23.84	23.85	1120500.0
2016-04-28	ASHS	ETF	33.6	33.67	33.29	33.29	42500.0
2016-04-28	ATMP	ETF	20.42	20.77	20.28	20.3	45200.0
2016-04-28	BAB	ETF	29.98	30.1799	29.98	30.16	91817.0
2016-04-28	BAL	ETF	42.17	42.47	42.15	42.1975	12896.0
2016-04-28	BBC	ETF	20.31	20.86	20.2975	20.3685	6063.0
2016-04-28	BBH	ETF	109.45	111.6	108.11	109.17	77400.0
2016-04-28	BBP	ETF	26.87	26.99	26.19	26.81	20200.0
2016-04-28	BCM	ETF	26.35	26.5	26.35	26.4679	1528.0
2016-04-28	BFOR	ETF	7.745	7.7625	7.67	7.67	48000.0
2016-04-28	BIB	ETF	45.52	47.3399	44.3101	45.29	700506.0

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

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