PREVIEW / etf_daily / 2017-01-27

all etf daily files

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

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-27	SPY	ETF	229.42	229.59	228.76	228.97	59711100.0
2017-01-27	QQQ	ETF	125.8	125.9211	125.39	125.8	15052983.0
2017-01-27	IWM	ETF	136.77	137.04	135.65	136.19	19467800.0
2017-01-27	DIA	ETF	200.69	200.87	200.45	200.63	3576500.0
2017-01-27	GLD	ETF	112.93	113.55	112.81	113.49	6706600.0
2017-01-27	TLT	ETF	119.4	119.83	119.25	119.63	7197800.0
2017-01-27	AADR	ETF	44.49	44.5	44.22	44.33	9700.0
2017-01-27	AAXJ	ETF	58.95	59.08	58.75	58.97	1541900.0
2017-01-27	ACSI	ETF	27.29	27.29	27.22	27.23	24762.0
2017-01-27	ACTX	ETF	104.7259	135.7012	104.7259	132.7512	5468.0
2017-01-27	ACWF	ETF	25.95	25.95	25.7503	25.7503	2130.0
2017-01-27	ACWI	ETF	61.31	61.32	61.13	61.19	1003400.0
2017-01-27	ACWV	ETF	73.9	73.9	73.72	73.82	209000.0
2017-01-27	ACWX	ETF	42.04	42.06	41.92	42.01	1001593.0
2017-01-27	ADRE	ETF	35.4	35.4	35.3119	35.3579	2857.0
2017-01-27	AFK	ETF	21.61	21.649	21.22	21.22	9930.0
2017-01-27	AFTY	ETF	13.82	13.82	13.82	13.82	3000.0
2017-01-27	AGG	ETF	108.03	108.16	108.02	108.08	3096800.0
2017-01-27	AGGY	ETF	49.47	49.544	49.44	49.48	12600.0
2017-01-27	AGQ	ETF	35.41	37.46	35.29	36.91	240200.0
2017-01-27	AGZ	ETF	112.75	112.942	112.425	112.67	21872.0
2017-01-27	AGZD	ETF	24.13	24.13	23.96	24.075	5200.0
2017-01-27	AIA	ETF	49.74	49.74	49.5228	49.68	24733.0
2017-01-27	AIQ	ETF	9.65	9.75	9.65	9.75	23689.0
2017-01-27	AIRR	ETF	24.61	24.61	24.15	24.34	96000.0
2017-01-27	AIVI	ETF	38.65	38.67	38.51	38.67	12700.0
2017-01-27	ALTY	ETF	15.61	15.61	15.25	15.345	4200.0
2017-01-27	AMJ	ETF	33.93	33.93	33.39	33.76	4860404.0
2017-01-27	AMLP	ETF	66.05	66.05	65.3	65.8	2431940.0
2017-01-27	AMZA	ETF	113.5	113.5	110.8	111.6	58680.0
2017-01-27	ANGL	ETF	29.36	29.4	29.33	29.38	525600.0
2017-01-27	AOA	ETF	48.5	48.5	48.35	48.44	126400.0
2017-01-27	AOK	ETF	32.85	32.85	32.75	32.81	63264.0
2017-01-27	AOM	ETF	35.56	35.6653	35.56	35.61	91684.0
2017-01-27	AOR	ETF	41.33	41.33	41.23	41.26	270834.0
2017-01-27	ARGT	ETF	25.89	25.93	25.74	25.75	56300.0
2017-01-27	ARKG	ETF	17.91	17.91	17.91	17.91	100.0
2017-01-27	ARKK	ETF	22.15	22.18	22.085	22.175	4900.0
2017-01-27	ARKQ	ETF	23.58	23.58	23.46	23.56	14200.0
2017-01-27	ARKW	ETF	27.61	27.699	27.56	27.699	1400.0
2017-01-27	ASEA	ETF	13.58	13.58	13.58	13.58	900.0
2017-01-27	ASET	ETF	25.8599	25.87	25.8566	25.87	1462.0
2017-01-27	ASHR	ETF	24.85	24.92	24.85	24.91	326900.0
2017-01-27	ASHS	ETF	33.17	33.17	33.1	33.1	4100.0
2017-01-27	ASHX	ETF	19.08	19.47	19.08	19.47	900.0
2017-01-27	ATMP	ETF	24.28	24.51	24.19	24.5	39000.0
2017-01-27	BAB	ETF	29.08	29.1287	29.02	29.07	213122.0
2017-01-27	BAL	ETF	49.26	49.48	49.26	49.36	4441.0
2017-01-27	BBC	ETF	19.1883	19.2711	19.1392	19.2711	3560.0
2017-01-27	BBH	ETF	110.96	112.48	110.96	112.36	58100.0

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

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