PREVIEW / etf_daily / 2016-02-29

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-29.parquet
  size:    50 KB
  rows:    1,259

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-02-29	SPY	ETF	195.11	196.23	193.33	193.56	125918100.0
2016-02-29	QQQ	ETF	103.31	104.1	102.5	102.5	27553937.0
2016-02-29	IWM	ETF	103.13	104.03	102.72	102.73	32014400.0
2016-02-29	DIA	ETF	166.16	167.21	164.96	164.96	3485000.0
2016-02-29	GLD	ETF	117.59	118.7	117.53	118.64	11517500.0
2016-02-29	TLT	ETF	130.47	131.17	130.42	130.98	8016100.0
2016-02-29	AADR	ETF	36.0	36.0	36.0	36.0	100.0
2016-02-29	AAXJ	ETF	49.36	49.72	49.29	49.31	1830300.0
2016-02-29	ACTX	ETF	4.72	4.72	4.13	4.13	626.0
2016-02-29	ACWF	ETF	21.72	21.76	21.441	21.488	7654.0
2016-02-29	ACWI	ETF	52.51	52.77	52.18	52.2	2991000.0
2016-02-29	ACWV	ETF	69.76	70.03	69.38	69.38	75500.0
2016-02-29	ACWX	ETF	36.65	36.85	36.49	36.49	1084522.0
2016-02-29	ADRE	ETF	27.25	27.506	27.24	27.29	4808.0
2016-02-29	AFK	ETF	17.0	17.1595	16.95	17.05	25024.0
2016-02-29	AFTY	ETF	11.736	11.739	11.671	11.7	4800.0
2016-02-29	AGG	ETF	109.94	110.1	109.91	110.09	3694200.0
2016-02-29	AGGY	ETF	49.835	49.85	49.76	49.806	3700.0
2016-02-29	AGQ	ETF	30.22	31.03	30.14	31.03	140900.0
2016-02-29	AGZ	ETF	114.51	114.56	114.3901	114.464	11881.0
2016-02-29	AGZD	ETF	23.495	23.57	23.495	23.56	2400.0
2016-02-29	AIA	ETF	39.09	39.301	38.99	38.99	21830.0
2016-02-29	AIQ	ETF	7.59	7.59	7.14	7.15	21591.0
2016-02-29	AIRR	ETF	15.86	15.936	15.78	15.78	3300.0
2016-02-29	AIVI	ETF	35.95	36.2	35.88	35.94	9500.0
2016-02-29	ALTY	ETF	13.202	13.202	13.202	13.202	100.0
2016-02-29	AMJ	ETF	24.98	25.26	24.64	25.0	3273641.0
2016-02-29	AMLP	ETF	50.1	50.95	49.5	50.6	2994560.0
2016-02-29	AMZA	ETF	83.3	84.2	82.5	84.1	6490.0
2016-02-29	ANGL	ETF	24.23	24.4	24.13	24.38	64100.0
2016-02-29	AOA	ETF	42.93	42.99	42.68	42.68	75400.0
2016-02-29	AOK	ETF	31.4	31.4302	31.32	31.36	21018.0
2016-02-29	AOM	ETF	33.63	33.68	33.52	33.55	77997.0
2016-02-29	AOR	ETF	37.62	37.7899	37.54	37.58	196093.0
2016-02-29	ARGT	ETF	18.53	18.92	18.35	18.51	93300.0
2016-02-29	ARKG	ETF	16.71	16.71	16.35	16.35	700.0
2016-02-29	ARKK	ETF	17.1	17.1	17.1	17.1	100.0
2016-02-29	ARKQ	ETF	16.74	16.83	16.69	16.81	700.0
2016-02-29	ARKW	ETF	19.29	19.29	19.29	19.29	200.0
2016-02-29	ASEA	ETF	12.27	12.27	12.27	12.27	2000.0
2016-02-29	ASET	ETF	23.93	24.12	23.93	24.12	480.0
2016-02-29	ASHR	ETF	21.84	21.92	21.76	21.76	1509600.0
2016-02-29	ASHS	ETF	29.34	29.58	29.23	29.43	45300.0
2016-02-29	ASHX	ETF	19.7199	19.7199	19.6	19.65	730.0
2016-02-29	ATMP	ETF	16.61	16.93	16.61	16.79	38300.0
2016-02-29	BAB	ETF	30.1	30.1599	30.04	30.11	309393.0
2016-02-29	BAL	ETF	36.62	36.92	35.5816	36.885	18718.0
2016-02-29	BBC	ETF	18.0	18.0	17.26	17.26	5361.0
2016-02-29	BBH	ETF	101.82	102.46	100.47	100.47	50800.0
2016-02-29	BBP	ETF	23.29	23.29	22.88	22.948	14600.0

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

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