PREVIEW / etf_daily / 2016-05-27

all etf daily files

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

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-27	SPY	ETF	209.53	210.25	209.47	210.24	64211200.0
2016-05-27	QQQ	ETF	109.65	110.14	109.61	110.13	19870010.0
2016-05-27	IWM	ETF	113.56	114.6	113.51	114.6	21265100.0
2016-05-27	DIA	ETF	178.22	178.59	178.06	178.5	1628300.0
2016-05-27	GLD	ETF	116.27	116.36	115.29	115.62	8686700.0
2016-05-27	TLT	ETF	130.07	130.26	129.7	129.85	5267600.0
2016-05-27	AADR	ETF	38.85	39.19	38.85	39.19	400.0
2016-05-27	AAXJ	ETF	52.95	53.17	52.79	52.89	461800.0
2016-05-27	ACTX	ETF	4.72	5.31	4.13	4.72	398.0
2016-05-27	ACWF	ETF	23.17	23.17	23.17	23.17	1120.0
2016-05-27	ACWI	ETF	57.02	57.17	57.0	57.14	1124800.0
2016-05-27	ACWV	ETF	73.78	73.93	73.66	73.77	216700.0
2016-05-27	ACWX	ETF	40.12	40.22	40.05	40.12	662363.0
2016-05-27	ADRE	ETF	30.46	30.6199	30.46	30.49	6530.0
2016-05-27	AFK	ETF	20.43	20.43	20.1163	20.42	11354.0
2016-05-27	AFTY	ETF	12.24	12.26	12.177	12.19	6600.0
2016-05-27	AGG	ETF	110.68	110.7	110.48	110.63	2164800.0
2016-05-27	AGGY	ETF	50.83	50.83	50.65	50.78	6300.0
2016-05-27	AGNG	ETF	15.66	15.66	15.66	15.66	200.0
2016-05-27	AGQ	ETF	36.05	36.24	35.5	35.77	163200.0
2016-05-27	AGZ	ETF	114.61	114.79	114.43	114.43	155077.0
2016-05-27	AGZD	ETF	23.95	23.95	23.925	23.925	4400.0
2016-05-27	AIA	ETF	42.42	42.46	42.249	42.27	5837.0
2016-05-27	AIQ	ETF	7.21	7.37	7.11	7.18	6639.0
2016-05-27	AIRR	ETF	18.06	18.06	18.03	18.03	2300.0
2016-05-27	AIVI	ETF	38.77	38.82	38.65	38.73	3600.0
2016-05-27	AMJ	ETF	30.16	30.28	29.75	30.12	1273547.0
2016-05-27	AMLP	ETF	61.2	61.55	60.35	61.1	1181100.0
2016-05-27	AMZA	ETF	108.3	109.5	107.1	109.3	14120.0
2016-05-27	ANGL	ETF	27.0	27.01	26.97	26.98	588200.0
2016-05-27	AOA	ETF	45.87	45.96	45.79	45.88	20400.0
2016-05-27	AOK	ETF	32.52	32.57	32.4124	32.5	62315.0
2016-05-27	AOM	ETF	35.05	35.12	34.9599	35.05	69132.0
2016-05-27	AOR	ETF	39.86	39.8999	39.7401	39.83	99546.0
2016-05-27	ARGT	ETF	20.86	20.89	20.71	20.88	11700.0
2016-05-27	ARKG	ETF	17.52	17.52	17.52	17.52	100.0
2016-05-27	ARKK	ETF	19.38	19.38	19.29	19.29	6100.0
2016-05-27	ARKQ	ETF	19.14	19.22	19.14	19.22	200.0
2016-05-27	ARKW	ETF	21.68	21.68	21.68	21.68	100.0
2016-05-27	ASEA	ETF	12.85	12.92	12.83	12.83	4100.0
2016-05-27	ASET	ETF	25.989	25.989	25.989	25.989	250.0
2016-05-27	ASHR	ETF	23.19	23.19	23.06	23.14	713400.0
2016-05-27	ASHS	ETF	31.58	31.98	31.58	31.92	20500.0
2016-05-27	ASHX	ETF	20.83	20.83	20.83	20.83	2022.0
2016-05-27	ATMP	ETF	20.64	20.77	20.56	20.67	135700.0
2016-05-27	BAB	ETF	30.69	30.69	30.55	30.58	322263.0
2016-05-27	BAL	ETF	42.66	42.6701	42.29	42.6701	1746.0
2016-05-27	BBC	ETF	20.1	20.25	19.96	20.25	4013.0
2016-05-27	BBH	ETF	108.51	109.38	108.18	109.33	48500.0
2016-05-27	BBP	ETF	27.15	27.373	27.086	27.33	20300.0

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

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