PREVIEW / etf_daily / 2016-05-23

all etf daily files

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

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-23	SPY	ETF	205.51	205.84	204.99	205.21	58682600.0
2016-05-23	QQQ	ETF	106.55	106.97	106.23	106.33	15729764.0
2016-05-23	IWM	ETF	110.77	111.39	110.5	110.66	23721700.0
2016-05-23	DIA	ETF	174.84	175.33	174.6	174.78	1736000.0
2016-05-23	GLD	ETF	118.86	119.6	118.75	119.37	8628200.0
2016-05-23	TLT	ETF	130.36	130.73	129.92	130.44	6979700.0
2016-05-23	AADR	ETF	38.32	38.45	37.69	37.8	3400.0
2016-05-23	AAXJ	ETF	51.38	51.68	51.37	51.39	775700.0
2016-05-23	ACTX	ETF	5.9001	5.9001	5.31	5.9001	380.0
2016-05-23	ACWF	ETF	22.75	22.75	22.7	22.7	1045.0
2016-05-23	ACWI	ETF	55.83	55.93	55.71	55.76	965900.0
2016-05-23	ACWV	ETF	72.9	72.95	72.68	72.68	399400.0
2016-05-23	ACWX	ETF	39.15	39.25	39.095	39.17	460932.0
2016-05-23	ADRE	ETF	29.72	29.81	29.66	29.66	3555.0
2016-05-23	AFK	ETF	20.16	20.51	19.75	20.03	56345.0
2016-05-23	AFTY	ETF	12.21	12.3	12.21	12.29	22400.0
2016-05-23	AGG	ETF	110.54	110.6	110.43	110.52	2244300.0
2016-05-23	AGGY	ETF	50.573	50.68	50.565	50.649	5100.0
2016-05-23	AGQ	ETF	36.5	36.9	36.31	36.71	131500.0
2016-05-23	AGZ	ETF	114.2466	114.7599	114.2466	114.6137	15397.0
2016-05-23	AGZD	ETF	24.105	24.105	23.84	23.845	12400.0
2016-05-23	AIA	ETF	41.05	41.1	41.03	41.04	5830.0
2016-05-23	AIQ	ETF	7.25	7.44	7.23	7.23	9679.0
2016-05-23	AIRR	ETF	17.57	17.689	17.5	17.604	2900.0
2016-05-23	AIVI	ETF	37.91	37.99	37.77	37.92	38500.0
2016-05-23	ALTY	ETF	14.548	14.548	14.52	14.52	400.0
2016-05-23	AMJ	ETF	30.97	31.12	30.76	30.91	1436436.0
2016-05-23	AMLP	ETF	62.1	62.4	61.5	61.8	1361820.0
2016-05-23	AMZA	ETF	111.0	111.0	108.1	110.3	26950.0
2016-05-23	ANGL	ETF	26.82	26.83	26.75	26.78	35800.0
2016-05-23	AOA	ETF	45.14	45.14	44.92	44.99	29200.0
2016-05-23	AOK	ETF	32.31	32.31	32.1631	32.24	77402.0
2016-05-23	AOM	ETF	34.73	34.73	34.57	34.6	50950.0
2016-05-23	AOR	ETF	39.31	39.31	39.16	39.25	64975.0
2016-05-23	ARGT	ETF	20.43	20.62	20.41	20.44	34300.0
2016-05-23	ARKG	ETF	17.092	17.114	17.065	17.065	3900.0
2016-05-23	ARKK	ETF	18.376	18.376	18.376	18.376	100.0
2016-05-23	ARKQ	ETF	18.25	18.48	18.25	18.39	2300.0
2016-05-23	ARKW	ETF	21.05	21.07	21.035	21.068	500.0
2016-05-23	ASEA	ETF	12.72	12.76	12.69	12.76	4000.0
2016-05-23	ASHR	ETF	23.1	23.14	23.01	23.03	675900.0
2016-05-23	ASHS	ETF	31.86	32.09	31.86	31.92	17800.0
2016-05-23	ATMP	ETF	21.34	21.41	21.19	21.19	37800.0
2016-05-23	BAB	ETF	30.55	30.55	30.4326	30.52	147248.0
2016-05-23	BAL	ETF	40.63	40.63	40.45	40.49	750.0
2016-05-23	BBC	ETF	18.96	19.59	18.96	19.42	31436.0
2016-05-23	BBH	ETF	104.92	106.43	104.92	105.52	60700.0
2016-05-23	BBP	ETF	26.18	26.85	26.18	26.562	24000.0
2016-05-23	BCM	ETF	26.406	26.406	26.406	26.406	181.0
2016-05-23	BDCZ	ETF	19.9999	19.9999	19.9801	19.9801	500.0

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

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