PREVIEW / etf_daily / 2016-03-28

all etf daily files

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

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-28	SPY	ETF	203.61	203.86	202.71	203.24	62408200.0
2016-03-28	QQQ	ETF	107.56	107.58	106.92	107.11	13892303.0
2016-03-28	IWM	ETF	107.43	107.78	106.55	107.33	21096400.0
2016-03-28	DIA	ETF	175.13	175.59	174.66	175.12	3098800.0
2016-03-28	GLD	ETF	116.73	116.91	116.27	116.6	3879100.0
2016-03-28	TLT	ETF	129.38	130.16	129.28	129.71	5058700.0
2016-03-28	AADR	ETF	37.47	37.77	37.47	37.77	600.0
2016-03-28	AAXJ	ETF	53.3	53.47	53.28	53.45	278200.0
2016-03-28	ACTX	ETF	8.2601	8.2601	6.4901	6.4901	491.0
2016-03-28	ACWF	ETF	22.7501	22.7501	22.7501	22.7501	154.0
2016-03-28	ACWI	ETF	55.44	55.48	55.21	55.4	1017700.0
2016-03-28	ACWV	ETF	72.57	72.78	72.48	72.71	955100.0
2016-03-28	ACWX	ETF	38.98	39.021	38.84	39.0	675659.0
2016-03-28	ADRE	ETF	30.38	30.38	30.25	30.38	6864.0
2016-03-28	AFK	ETF	18.93	19.22	18.78	19.1	81833.0
2016-03-28	AFTY	ETF	12.65	12.7	12.65	12.66	12100.0
2016-03-28	AGG	ETF	110.15	110.3	110.08	110.19	2918100.0
2016-03-28	AGGY	ETF	50.17	50.28	50.15	50.27	27800.0
2016-03-28	AGQ	ETF	32.43	32.62	31.81	31.92	220900.0
2016-03-28	AGZ	ETF	114.42	114.53	114.0311	114.41	21173.0
2016-03-28	AGZD	ETF	23.76	23.85	23.76	23.825	2600.0
2016-03-28	AIA	ETF	42.31	42.51	42.31	42.47	40168.0
2016-03-28	AIQ	ETF	7.05	7.16	6.9	6.95	5040.0
2016-03-28	AIRR	ETF	17.23	17.23	17.23	17.23	200.0
2016-03-28	AIVI	ETF	37.65	37.8	37.58	37.7	16000.0
2016-03-28	ALTY	ETF	13.96	13.96	13.96	13.96	1000.0
2016-03-28	AMJ	ETF	26.51	26.51	25.74	25.92	2335139.0
2016-03-28	AMLP	ETF	53.0	53.0	51.55	52.0	1200100.0
2016-03-28	AMZA	ETF	88.7	89.4	84.8	85.9	7280.0
2016-03-28	ANGL	ETF	25.87	25.87	25.57	25.65	57700.0
2016-03-28	AOA	ETF	44.9	44.9	44.69	44.75	52100.0
2016-03-28	AOK	ETF	32.09	32.0903	31.97	32.07	46553.0
2016-03-28	AOM	ETF	34.55	34.55	34.3601	34.48	100164.0
2016-03-28	AOR	ETF	39.12	39.12	38.9501	39.03	165218.0
2016-03-28	ARGT	ETF	19.15	19.17	18.89	18.99	13400.0
2016-03-28	ARKG	ETF	16.91	16.94	16.77	16.77	3100.0
2016-03-28	ARKQ	ETF	18.44	18.44	18.32	18.32	500.0
2016-03-28	ARKW	ETF	20.22	20.22	19.98	20.0	600.0
2016-03-28	ASEA	ETF	13.15	13.15	13.14	13.15	6000.0
2016-03-28	ASET	ETF	25.22	25.22	25.22	25.22	129.0
2016-03-28	ASHR	ETF	23.8	24.09	23.8	24.08	1114300.0
2016-03-28	ASHS	ETF	33.74	34.05	33.6	33.99	19700.0
2016-03-28	ATMP	ETF	17.69	17.69	17.26	17.27	20400.0
2016-03-28	BAB	ETF	29.9	30.0	29.894	29.93	85718.0
2016-03-28	BAL	ETF	37.42	37.7611	37.42	37.7	2481.0
2016-03-28	BBC	ETF	18.19	18.38	17.6	17.7414	6079.0
2016-03-28	BBH	ETF	102.45	102.65	100.94	101.06	57700.0
2016-03-28	BBP	ETF	24.07	24.07	23.35	23.46	11900.0
2016-03-28	BCM	ETF	24.575	24.6	24.57	24.5785	1981.0
2016-03-28	BDCZ	ETF	20.22	20.22	20.22	20.22	800.0

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

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