PREVIEW / etf_daily / 2016-03-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-22.parquet
  size:    50 KB
  rows:    1,249

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-03-22	SPY	ETF	203.76	205.23	203.57	204.56	97471900.0
2016-03-22	QQQ	ETF	107.18	108.37	107.16	108.12	18840278.0
2016-03-22	IWM	ETF	108.78	109.69	108.47	109.22	23602100.0
2016-03-22	DIA	ETF	175.3	176.26	175.15	175.7	3980100.0
2016-03-22	GLD	ETF	119.73	120.16	118.96	119.31	6786800.0
2016-03-22	TLT	ETF	128.83	129.02	127.92	128.04	4997900.0
2016-03-22	AADR	ETF	37.89	37.89	37.84	37.85	2100.0
2016-03-22	AAXJ	ETF	54.09	54.44	54.02	54.25	377700.0
2016-03-22	ACTX	ETF	5.9001	8.2601	5.9001	8.2601	2075.0
2016-03-22	ACWF	ETF	22.91	22.91	22.91	22.91	600.0
2016-03-22	ACWI	ETF	55.71	56.07	55.61	55.93	1479500.0
2016-03-22	ACWV	ETF	72.69	72.89	72.6	72.71	119000.0
2016-03-22	ACWX	ETF	39.24	39.57	39.23	39.48	571032.0
2016-03-22	ADRE	ETF	30.52	30.85	30.52	30.79	1998.0
2016-03-22	AFK	ETF	19.4219	19.7599	19.4219	19.54	4749.0
2016-03-22	AFTY	ETF	12.99	13.0	12.92	12.93	13900.0
2016-03-22	AGG	ETF	110.27	110.27	109.83	109.86	2023000.0
2016-03-22	AGGY	ETF	50.15	50.15	50.03	50.03	1100.0
2016-03-22	AGQ	ETF	34.97	35.28	34.41	34.94	228100.0
2016-03-22	AGZ	ETF	114.35	114.35	114.05	114.16	27464.0
2016-03-22	AGZD	ETF	23.945	24.045	23.72	23.835	5600.0
2016-03-22	AIA	ETF	42.87	43.1255	42.8	43.01	6684.0
2016-03-22	AIQ	ETF	7.0	7.0	6.78	6.89	10101.0
2016-03-22	AIRR	ETF	17.532	17.561	17.5	17.5	1400.0
2016-03-22	AIVI	ETF	38.02	38.29	38.02	38.16	13200.0
2016-03-22	ALTY	ETF	14.248	14.283	14.248	14.283	500.0
2016-03-22	AMJ	ETF	26.7	27.39	26.595	27.23	1099310.0
2016-03-22	AMLP	ETF	53.9	55.35	53.65	54.95	1456000.0
2016-03-22	AMZA	ETF	89.7	92.5	89.7	91.9	4450.0
2016-03-22	ANGL	ETF	25.82	26.05	25.82	25.93	104800.0
2016-03-22	AOA	ETF	45.14	45.24	44.98	45.13	32600.0
2016-03-22	AOK	ETF	32.04	32.15	32.031	32.04	89736.0
2016-03-22	AOM	ETF	34.67	34.67	34.54	34.54	92136.0
2016-03-22	AOR	ETF	39.25	39.31	39.105	39.26	127322.0
2016-03-22	ARGT	ETF	19.23	19.42	19.18	19.31	26500.0
2016-03-22	ARKG	ETF	17.4	17.4	17.4	17.4	200.0
2016-03-22	ARKK	ETF	18.835	18.87	18.835	18.87	500.0
2016-03-22	ARKQ	ETF	18.58	18.684	18.58	18.684	1200.0
2016-03-22	ARKW	ETF	20.419	20.419	20.419	20.419	200.0
2016-03-22	ASEA	ETF	13.35	13.43	13.35	13.43	3500.0
2016-03-22	ASET	ETF	25.41	25.41	25.41	25.41	100.0
2016-03-22	ASHR	ETF	24.65	24.75	24.52	24.55	1973900.0
2016-03-22	ASHS	ETF	34.45	34.45	34.09	34.29	48600.0
2016-03-22	ATMP	ETF	17.98	18.37	17.95	18.19	69200.0
2016-03-22	BAB	ETF	29.83	29.9199	29.7098	29.73	507475.0
2016-03-22	BAL	ETF	37.86	38.27	37.73	38.23	55133.0
2016-03-22	BBC	ETF	18.58	19.219	18.58	19.04	19322.0
2016-03-22	BBH	ETF	101.53	104.44	101.53	104.19	90800.0
2016-03-22	BBP	ETF	23.78	24.64	23.78	24.64	2700.0
2016-03-22	BCM	ETF	25.125	25.22	25.12	25.22	7498.0

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

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