PREVIEW / etf_daily / 2016-05-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-11.parquet
  size:    51 KB
  rows:    1,279

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-05-11	SPY	ETF	207.91	208.54	206.5	206.5	81727000.0
2016-05-11	QQQ	ETF	107.16	107.49	106.33	106.36	20966257.0
2016-05-11	IWM	ETF	112.1	112.27	110.87	110.96	23604600.0
2016-05-11	DIA	ETF	178.7	178.94	177.26	177.3	2697200.0
2016-05-11	GLD	ETF	121.85	122.16	121.38	122.12	7590100.0
2016-05-11	TLT	ETF	130.83	132.0	130.66	131.61	9256000.0
2016-05-11	AADR	ETF	38.19	38.21	38.09	38.21	2600.0
2016-05-11	AAXJ	ETF	52.25	52.44	52.09	52.09	412000.0
2016-05-11	ACTX	ETF	4.13	4.72	3.54	4.72	679.0
2016-05-11	ACWF	ETF	22.87	22.88	22.87	22.88	914.0
2016-05-11	ACWI	ETF	56.42	56.61	56.21	56.24	2019000.0
2016-05-11	ACWV	ETF	74.35	74.35	73.92	73.94	166800.0
2016-05-11	ACWX	ETF	39.68	39.87	39.63	39.63	435020.0
2016-05-11	ADRE	ETF	30.48	30.63	30.48	30.54	2336.0
2016-05-11	AFK	ETF	20.21	20.57	20.21	20.52	38912.0
2016-05-11	AFTY	ETF	12.32	12.335	12.3	12.3	1300.0
2016-05-11	AGG	ETF	111.06	111.26	111.02	111.09	2507000.0
2016-05-11	AGGY	ETF	51.13	51.175	51.05	51.174	2700.0
2016-05-11	AGQ	ETF	41.5	41.93	40.8	41.38	173800.0
2016-05-11	AGZ	ETF	114.99	115.25	114.53	115.1099	124091.0
2016-05-11	AGZD	ETF	23.99	23.99	23.885	23.885	2800.0
2016-05-11	AIA	ETF	41.47	41.5894	41.32	41.32	24853.0
2016-05-11	AIQ	ETF	6.78	6.88	6.65	6.82	18855.0
2016-05-11	AIRR	ETF	17.79	17.95	17.79	17.889	1400.0
2016-05-11	AIVI	ETF	38.33	38.6	38.31	38.36	13300.0
2016-05-11	ALTY	ETF	14.79	14.79	14.682	14.682	300.0
2016-05-11	AMJ	ETF	29.3	29.86	28.81	29.57	3893804.0
2016-05-11	AMLP	ETF	57.95	59.55	57.1	58.85	3199980.0
2016-05-11	AMZA	ETF	101.5	104.4	99.5	103.1	28270.0
2016-05-11	ANGL	ETF	26.68	26.78	26.65	26.73	61800.0
2016-05-11	AOA	ETF	45.56	45.56	45.29	45.31	17500.0
2016-05-11	AOK	ETF	32.47	32.4999	32.37	32.41	84048.0
2016-05-11	AOM	ETF	34.85	34.9899	34.81	34.89	90858.0
2016-05-11	AOR	ETF	39.69	39.69	39.46	39.51	79317.0
2016-05-11	ARGT	ETF	20.77	20.9	20.52	20.81	55400.0
2016-05-11	ARKG	ETF	16.88	16.88	16.82	16.834	700.0
2016-05-11	ARKK	ETF	18.308	18.308	18.308	18.308	100.0
2016-05-11	ARKQ	ETF	18.2	18.2	18.2	18.2	200.0
2016-05-11	ARKW	ETF	20.598	20.598	20.598	20.598	100.0
2016-05-11	ASEA	ETF	12.85	12.91	12.85	12.91	300.0
2016-05-11	ASHR	ETF	23.01	23.1	22.94	22.95	849700.0
2016-05-11	ASHS	ETF	31.55	31.62	31.45	31.51	41100.0
2016-05-11	ASHX	ETF	20.57	20.57	20.57	20.57	4329.0
2016-05-11	ATMP	ETF	19.94	20.57	19.94	20.38	32400.0
2016-05-11	BAB	ETF	30.5	30.6	30.4299	30.55	126000.0
2016-05-11	BAL	ETF	40.15	40.53	40.0957	40.1	8569.0
2016-05-11	BBC	ETF	18.37	18.5789	17.8899	17.8899	7053.0
2016-05-11	BBH	ETF	106.05	106.36	103.36	103.42	58000.0
2016-05-11	BBP	ETF	25.12	25.229	25.12	25.229	1700.0
2016-05-11	BCM	ETF	26.414	26.414	26.414	26.414	395.0

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

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