PREVIEW / etf_daily / 2016-05-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-06.parquet
  size:    50 KB
  rows:    1,252

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-06	SPY	ETF	204.06	205.77	203.88	205.72	89315000.0
2016-05-06	QQQ	ETF	104.51	105.6	104.4	105.58	30758516.0
2016-05-06	IWM	ETF	109.8	110.93	109.54	110.91	25497400.0
2016-05-06	DIA	ETF	175.69	177.4	175.68	177.34	2940800.0
2016-05-06	GLD	ETF	122.83	123.81	122.59	123.18	11366800.0
2016-05-06	TLT	ETF	130.85	130.86	130.29	130.45	7232500.0
2016-05-06	AAXJ	ETF	52.01	52.3	51.9	52.12	1573000.0
2016-05-06	ACTX	ETF	4.72	4.72	4.13	4.13	183.0
2016-05-06	ACWI	ETF	55.54	55.98	55.5	55.98	1841300.0
2016-05-06	ACWV	ETF	73.31	73.71	73.19	73.67	93700.0
2016-05-06	ACWX	ETF	39.21	39.5199	39.18	39.47	616588.0
2016-05-06	ADRE	ETF	30.13	30.31	30.13	30.3069	7440.0
2016-05-06	AFK	ETF	19.97	20.2869	19.97	20.2014	10512.0
2016-05-06	AFTY	ETF	12.52	12.52	12.47	12.479	1500.0
2016-05-06	AGG	ETF	111.12	111.12	110.97	110.97	2718500.0
2016-05-06	AGGY	ETF	50.938	51.028	50.938	51.028	800.0
2016-05-06	AGQ	ETF	41.29	42.35	41.17	41.77	231900.0
2016-05-06	AGZ	ETF	115.0	115.0	114.7801	114.8101	19005.0
2016-05-06	AIA	ETF	41.4	41.65	41.4	41.55	15462.0
2016-05-06	AIQ	ETF	7.01	7.1653	6.65	6.74	29838.0
2016-05-06	AIRR	ETF	17.5	17.61	17.5	17.61	2000.0
2016-05-06	AIVI	ETF	38.15	38.45	38.15	38.39	4500.0
2016-05-06	ALTY	ETF	14.52	14.52	14.52	14.52	400.0
2016-05-06	AMJ	ETF	29.54	29.94	29.3243	29.59	2222963.0
2016-05-06	AMLP	ETF	60.3	61.2	59.95	60.35	1756300.0
2016-05-06	AMZA	ETF	104.9	104.9	102.5	103.1	5310.0
2016-05-06	ANGL	ETF	26.68	26.7	26.58	26.59	61900.0
2016-05-06	AOA	ETF	44.95	45.21	44.92	45.18	27800.0
2016-05-06	AOK	ETF	32.22	32.37	32.22	32.33	56479.0
2016-05-06	AOM	ETF	34.77	34.8	34.68	34.78	47691.0
2016-05-06	AOR	ETF	39.22	39.38	39.2001	39.33	50746.0
2016-05-06	ARGT	ETF	20.23	20.57	20.22	20.48	39600.0
2016-05-06	ARKG	ETF	16.7	16.7	16.7	16.7	300.0
2016-05-06	ARKK	ETF	18.07	18.29	17.94	17.94	3000.0
2016-05-06	ARKQ	ETF	18.12	18.12	17.965	17.965	800.0
2016-05-06	ARKW	ETF	20.105	20.38	20.1	20.38	1000.0
2016-05-06	ASHR	ETF	23.4	23.52	23.39	23.43	2300800.0
2016-05-06	ASHS	ETF	33.0	33.08	32.71	33.08	34600.0
2016-05-06	ATMP	ETF	20.19	20.69	20.19	20.41	52700.0
2016-05-06	BAB	ETF	30.4	30.44	30.26	30.3601	179693.0
2016-05-06	BAL	ETF	41.16	41.16	40.85	40.85	18070.0
2016-05-06	BBC	ETF	17.88	17.9188	17.33	17.62	9292.0
2016-05-06	BBH	ETF	103.38	104.4	102.16	103.22	77500.0
2016-05-06	BBP	ETF	24.72	24.73	24.27	24.589	6100.0
2016-05-06	BCM	ETF	25.98	26.0399	25.98	26.02	5988.0
2016-05-06	BFOR	ETF	7.4075	7.4825	7.4075	7.4775	57200.0
2016-05-06	BIB	ETF	39.21	40.0699	37.8	38.87	1025983.0
2016-05-06	BICK	ETF	19.652	19.73	19.652	19.72	3913.0
2016-05-06	BIL	ETF	91.4	91.42	91.4	91.42	2157200.0
2016-05-06	BIS	ETF	348.56	360.56	340.912	352.08	47738.0

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

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