PREVIEW / etf_daily / 2017-05-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-19.parquet
  size:    55 KB
  rows:    1,390

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-05-19	SPY	ETF	237.33	239.08	237.27	238.31	115011400.0
2017-05-19	QQQ	ETF	137.71	138.42	137.66	137.84	36730112.0
2017-05-19	IWM	ETF	135.64	136.76	135.42	136.03	44450500.0
2017-05-19	DIA	ETF	206.75	208.31	206.58	207.77	4892800.0
2017-05-19	GLD	ETF	119.39	119.55	118.88	119.4	6787300.0
2017-05-19	TLT	ETF	123.36	123.78	123.01	123.71	11277400.0
2017-05-19	AADR	ETF	47.25	47.77	47.25	47.52	21100.0
2017-05-19	AAXJ	ETF	66.07	66.48	65.97	66.42	730100.0
2017-05-19	ACSI	ETF	28.01	28.1305	27.89	28.1305	2338.0
2017-05-19	ACTX	ETF	64.3106	64.3106	53.1005	59.0005	1717.0
2017-05-19	ACWF	ETF	26.595	26.595	26.595	26.595	100.0
2017-05-19	ACWI	ETF	64.91	65.37	64.91	65.25	1207000.0
2017-05-19	ACWV	ETF	78.76	79.1	78.63	79.03	857400.0
2017-05-19	ACWX	ETF	45.71	45.975	45.7	45.93	611218.0
2017-05-19	ADRE	ETF	37.7	38.1124	37.7	38.09	9447.0
2017-05-19	AFK	ETF	21.312	21.4625	21.312	21.45	19791.0
2017-05-19	AFTY	ETF	13.89	13.89	13.88	13.88	800.0
2017-05-19	AGG	ETF	109.51	109.54	109.35	109.52	1504000.0
2017-05-19	AGGY	ETF	50.45	50.57	50.437	50.57	12700.0
2017-05-19	AGNG	ETF	17.75	17.81	17.75	17.81	300.0
2017-05-19	AGQ	ETF	34.99	35.06	34.58	35.0	216000.0
2017-05-19	AGZ	ETF	113.55	113.7	113.505	113.7	15206.0
2017-05-19	AGZD	ETF	24.03	24.07	24.025	24.065	3000.0
2017-05-19	AIA	ETF	55.73	55.959	55.68	55.88	24240.0
2017-05-19	AIQ	ETF	13.15	13.2	13.1	13.2	4512.0
2017-05-19	AIRR	ETF	23.09	23.47	23.09	23.24	22000.0
2017-05-19	AIVI	ETF	41.61	41.85	41.61	41.76	9300.0
2017-05-19	ALTY	ETF	15.286	15.374	15.286	15.374	4600.0
2017-05-19	AMJ	ETF	31.1	31.54	30.98	31.41	935036.0
2017-05-19	AMLP	ETF	60.95	61.45	60.65	61.25	1007360.0
2017-05-19	AMZA	ETF	103.7	104.9	103.35	104.7	50400.0
2017-05-19	ANGL	ETF	29.69	29.7	29.61	29.65	225700.0
2017-05-19	AOA	ETF	50.98	51.28	50.98	51.13	31200.0
2017-05-19	AOK	ETF	33.78	33.87	33.6815	33.85	48436.0
2017-05-19	AOM	ETF	36.91	37.0324	36.8701	37.02	48573.0
2017-05-19	AOR	ETF	43.05	43.299	43.05	43.26	50134.0
2017-05-19	ARCM	ETF	100.05	100.05	100.05	100.05	200.0
2017-05-19	ARGT	ETF	29.73	30.24	29.73	30.15	189800.0
2017-05-19	ARKG	ETF	20.818	20.818	20.644	20.66	3000.0
2017-05-19	ARKK	ETF	27.04	27.213	26.9	26.93	54300.0
2017-05-19	ARKQ	ETF	28.19	28.43	28.19	28.27	47200.0
2017-05-19	ARKW	ETF	32.61	32.88	32.61	32.634	25500.0
2017-05-19	ASEA	ETF	14.9	14.99	14.84	14.99	2100.0
2017-05-19	ASET	ETF	27.1	27.2	27.1	27.2	360.0
2017-05-19	ASHR	ETF	24.59	24.68	24.54	24.68	563600.0
2017-05-19	ASHS	ETF	31.35	31.44	31.35	31.44	300.0
2017-05-19	ASHX	ETF	19.0999	19.0999	19.0995	19.0995	1408.0
2017-05-19	ATMP	ETF	22.88	23.23	22.71	23.07	29200.0
2017-05-19	BAB	ETF	29.82	29.85	29.77	29.84	94036.0
2017-05-19	BAL	ETF	50.07	50.6788	50.02	50.66	9066.0

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

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