PREVIEW / etf_daily / 2017-01-30

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-30.parquet
  size:    54 KB
  rows:    1,374

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
2017-01-30	SPY	ETF	228.17	228.2	226.41	227.55	79737300.0
2017-01-30	QQQ	ETF	125.37	125.38	124.13	124.82	25006715.0
2017-01-30	IWM	ETF	135.23	135.24	133.24	134.29	40464400.0
2017-01-30	DIA	ETF	199.83	199.9	198.42	199.38	4718000.0
2017-01-30	GLD	ETF	113.61	114.3	113.54	113.97	7687800.0
2017-01-30	TLT	ETF	119.44	119.88	119.2	119.27	6569500.0
2017-01-30	AADR	ETF	44.5	44.54	43.73	43.94	5000.0
2017-01-30	AAXJ	ETF	58.71	58.83	58.6	58.8	1626500.0
2017-01-30	ACSI	ETF	27.07	27.08	26.97	27.08	5254.0
2017-01-30	ACTX	ETF	153.4014	201.7818	132.7512	171.1015	10088.0
2017-01-30	ACWF	ETF	26.18	26.18	25.52	25.61	406.0
2017-01-30	ACWI	ETF	60.89	60.9	60.54	60.8	4898200.0
2017-01-30	ACWV	ETF	73.65	73.68	73.44	73.65	564300.0
2017-01-30	ACWX	ETF	41.66	41.74	41.542	41.71	812474.0
2017-01-30	ADRE	ETF	35.15	35.15	34.9713	35.07	4702.0
2017-01-30	AFK	ETF	21.23	21.93	21.03	21.07	13797.0
2017-01-30	AFTY	ETF	13.851	13.858	13.851	13.858	700.0
2017-01-30	AGG	ETF	108.16	108.21	108.03	108.03	2946200.0
2017-01-30	AGGY	ETF	49.558	49.61	49.486	49.55	25000.0
2017-01-30	AGNG	ETF	15.617	15.67	15.617	15.67	200.0
2017-01-30	AGQ	ETF	37.11	37.58	36.75	36.96	102800.0
2017-01-30	AGZ	ETF	112.63	113.05	112.4715	112.68	45716.0
2017-01-30	AGZD	ETF	23.965	24.085	23.965	24.06	8800.0
2017-01-30	AIA	ETF	49.34	49.58	49.33	49.58	85279.0
2017-01-30	AIQ	ETF	9.75	9.8	9.7	9.75	19731.0
2017-01-30	AIRR	ETF	24.38	24.38	23.745	23.97	216000.0
2017-01-30	AIVI	ETF	38.29	38.3	38.04	38.28	10200.0
2017-01-30	ALTY	ETF	15.34	15.34	15.211	15.32	7900.0
2017-01-30	AMJ	ETF	33.73	33.73	32.79	32.94	4679098.0
2017-01-30	AMLP	ETF	65.8	65.8	64.55	64.95	1847680.0
2017-01-30	AMZA	ETF	112.0	112.29	108.94	109.2	55450.0
2017-01-30	ANGL	ETF	29.38	29.38	29.3	29.37	243200.0
2017-01-30	AOA	ETF	48.2	48.2	47.97	48.19	160600.0
2017-01-30	AOK	ETF	32.77	32.77	32.6605	32.7	128991.0
2017-01-30	AOM	ETF	35.56	35.56	35.45	35.53	351229.0
2017-01-30	AOR	ETF	41.25	41.25	41.0097	41.09	408159.0
2017-01-30	ARGT	ETF	25.84	25.84	25.34	25.54	21900.0
2017-01-30	ARKG	ETF	17.55	17.55	17.514	17.53	1000.0
2017-01-30	ARKK	ETF	22.27	22.27	21.83	22.003	2200.0
2017-01-30	ARKQ	ETF	23.57	23.57	23.15	23.34	5100.0
2017-01-30	ARKW	ETF	27.82	27.82	27.29	27.52	5900.0
2017-01-30	ASEA	ETF	13.47	13.65	13.47	13.63	22400.0
2017-01-30	ASET	ETF	25.72	25.73	25.66	25.7183	2206.0
2017-01-30	ASHR	ETF	24.91	24.93	24.85	24.88	294500.0
2017-01-30	ASHS	ETF	33.11	33.2	33.11	33.2	2700.0
2017-01-30	ATMP	ETF	23.99	24.07	23.78	23.97	95200.0
2017-01-30	BAB	ETF	29.14	29.1604	29.06	29.09	215654.0
2017-01-30	BAL	ETF	49.4399	49.5906	48.98	49.0219	10250.0
2017-01-30	BBC	ETF	18.99	18.99	18.7042	18.89	6910.0
2017-01-30	BBH	ETF	111.72	111.99	110.56	111.06	61900.0

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

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