PREVIEW / etf_daily / 2016-05-04

all etf daily files

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

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-04	SPY	ETF	204.99	205.85	204.42	205.01	92243800.0
2016-05-04	QQQ	ETF	105.12	105.4811	104.7902	105.05	27474504.0
2016-05-04	IWM	ETF	110.99	111.99	110.37	110.7	30767200.0
2016-05-04	DIA	ETF	176.38	177.21	175.9	176.32	3446000.0
2016-05-04	GLD	ETF	122.85	123.23	121.51	122.21	9398200.0
2016-05-04	TLT	ETF	129.68	130.17	129.19	130.14	7211200.0
2016-05-04	AADR	ETF	37.77	37.82	37.72	37.82	10500.0
2016-05-04	AAXJ	ETF	52.63	52.67	52.1	52.17	742600.0
2016-05-04	ACTX	ETF	4.13	4.72	4.13	4.72	567.0
2016-05-04	ACWI	ETF	55.99	56.15	55.69	55.81	2339900.0
2016-05-04	ACWV	ETF	73.39	73.62	73.2	73.47	262300.0
2016-05-04	ACWX	ETF	39.62	39.67	39.36	39.46	509227.0
2016-05-04	ADRE	ETF	30.21	30.274	30.19	30.274	4963.0
2016-05-04	AFK	ETF	20.1	20.25	19.87	20.07	21354.0
2016-05-04	AFTY	ETF	12.74	12.74	12.74	12.74	400.0
2016-05-04	AGG	ETF	110.91	110.93	110.76	110.86	2920200.0
2016-05-04	AGGY	ETF	50.97	51.08	50.91	51.06	6800.0
2016-05-04	AGQ	ETF	41.33	41.68	40.68	41.2	252600.0
2016-05-04	AGZ	ETF	114.86	114.8799	114.12	114.84	50393.0
2016-05-04	AGZD	ETF	24.025	24.025	23.925	23.925	4200.0
2016-05-04	AIA	ETF	41.71	41.752	41.49	41.57	11755.0
2016-05-04	AIQ	ETF	7.05	7.06	6.9	7.04	32829.0
2016-05-04	AIRR	ETF	17.57	17.57	17.57	17.57	100.0
2016-05-04	AIVI	ETF	38.5	38.57	38.3	38.46	10400.0
2016-05-04	ALTY	ETF	14.318	14.318	14.318	14.318	200.0
2016-05-04	AMJ	ETF	29.11	29.55	28.84	29.25	3176188.0
2016-05-04	AMLP	ETF	59.65	60.2	58.7	59.55	2120980.0
2016-05-04	AMZA	ETF	102.0	102.9	99.5	101.9	7360.0
2016-05-04	ANGL	ETF	27.1	27.1	26.78	26.79	25300.0
2016-05-04	AOA	ETF	45.19	45.22	45.01	45.05	38100.0
2016-05-04	AOK	ETF	32.31	32.333	32.24	32.285	106671.0
2016-05-04	AOM	ETF	34.7	34.7899	34.6301	34.7	93025.0
2016-05-04	AOR	ETF	39.46	39.46	39.2101	39.26	85430.0
2016-05-04	ARGT	ETF	19.95	20.2	19.86	20.07	50900.0
2016-05-04	ARKG	ETF	16.68	16.736	16.68	16.725	1500.0
2016-05-04	ARKK	ETF	18.2	18.21	18.2	18.21	500.0
2016-05-04	ARKQ	ETF	18.289	18.289	18.12	18.12	700.0
2016-05-04	ARKW	ETF	20.72	20.72	20.43	20.43	1100.0
2016-05-04	ASEA	ETF	13.0	13.0	12.82	12.86	2500.0
2016-05-04	ASHR	ETF	24.15	24.21	23.99	24.01	804900.0
2016-05-04	ASHS	ETF	34.11	34.3	33.97	34.04	30500.0
2016-05-04	ATMP	ETF	20.3	20.3	19.85	20.15	157600.0
2016-05-04	BAB	ETF	30.25	30.34	30.2	30.31	153140.0
2016-05-04	BAL	ETF	41.5699	41.845	41.48	41.703	3131.0
2016-05-04	BBC	ETF	19.07	19.07	18.2686	18.31	15391.0
2016-05-04	BBH	ETF	104.54	104.95	102.87	102.91	98100.0
2016-05-04	BBP	ETF	25.24	25.59	24.62	24.65	4400.0
2016-05-04	BCM	ETF	26.27	26.27	25.927	25.99	868.0
2016-05-04	BDCZ	ETF	20.2898	20.29	20.26	20.2601	1100.0
2016-05-04	BFOR	ETF	7.4775	7.4775	7.4525	7.475	25200.0

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

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