PREVIEW / etf_daily / 2015-05-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-27.parquet
  size:    48 KB
  rows:    1,189

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
2015-05-27	SPY	ETF	211.25	212.98	210.76	212.7	93214000.0
2015-05-27	QQQ	ETF	109.53	111.08	109.29	110.96	30572695.0
2015-05-27	IWM	ETF	123.36	124.87	122.79	124.75	32086300.0
2015-05-27	DIA	ETF	180.77	181.79	180.45	181.52	3588200.0
2015-05-27	GLD	ETF	113.78	114.01	113.63	113.89	2681100.0
2015-05-27	TLT	ETF	122.18	122.86	121.61	122.74	6490300.0
2015-05-27	AADR	ETF	40.29	40.29	40.29	40.29	300.0
2015-05-27	AAXJ	ETF	67.43	67.78	67.34	67.74	1531500.0
2015-05-27	ACTX	ETF	3.54	3.54	2.95	2.95	331.0
2015-05-27	ACWF	ETF	25.22	25.25	25.2199	25.25	719.0
2015-05-27	ACWI	ETF	61.99	62.41	61.83	62.34	1056900.0
2015-05-27	ACWV	ETF	72.6	72.92	72.47	72.91	192700.0
2015-05-27	ACWX	ETF	46.49	46.96	46.49	46.91	455450.0
2015-05-27	ADRE	ETF	36.4	36.62	36.2301	36.61	5613.0
2015-05-27	AFK	ETF	25.9	25.98	25.85	25.98	14608.0
2015-05-27	AFTY	ETF	23.79	23.79	23.47	23.56	24700.0
2015-05-27	AGG	ETF	110.06	110.19	109.9	110.17	888700.0
2015-05-27	AGQ	ETF	41.37	41.62	41.09	41.33	111600.0
2015-05-27	AGZ	ETF	113.64	113.64	113.44	113.58	30447.0
2015-05-27	AGZD	ETF	24.41	24.44	24.41	24.415	7600.0
2015-05-27	AIA	ETF	53.3	53.5	53.16	53.48	29760.0
2015-05-27	AIQ	ETF	19.37	19.76	19.1001	19.48	15196.0
2015-05-27	AIRR	ETF	18.07	18.32	18.07	18.32	22600.0
2015-05-27	AIVI	ETF	45.34	45.87	45.34	45.81	25700.0
2015-05-27	AMJ	ETF	43.91	44.17	43.79	43.91	1365263.0
2015-05-27	AMLP	ETF	83.6	84.05	83.6	83.85	582880.0
2015-05-27	AMZA	ETF	221.36	221.36	219.2	220.3	1700.0
2015-05-27	ANGL	ETF	27.67	27.69	27.65	27.67	33100.0
2015-05-27	AOA	ETF	48.62	48.79	48.48	48.79	23500.0
2015-05-27	AOK	ETF	32.92	33.1001	32.9	33.1	33048.0
2015-05-27	AOM	ETF	35.91	35.97	35.775	35.97	44100.0
2015-05-27	AOR	ETF	41.55	41.62	41.34	41.62	50358.0
2015-05-27	ARGT	ETF	21.19	21.22	21.1	21.16	28700.0
2015-05-27	ARKG	ETF	23.26	23.26	23.26	23.26	200.0
2015-05-27	ARKK	ETF	21.32	21.32	21.32	21.32	700.0
2015-05-27	ARKQ	ETF	19.9	20.091	19.9	20.091	4600.0
2015-05-27	ARKW	ETF	23.16	23.41	23.14	23.41	800.0
2015-05-27	ASEA	ETF	15.5	15.57	15.36	15.54	3800.0
2015-05-27	ASHR	ETF	53.65	53.67	53.06	53.25	2845800.0
2015-05-27	ASHS	ETF	69.08	69.96	69.08	69.62	137000.0
2015-05-27	ATMP	ETF	29.9	29.94	29.72	29.92	34500.0
2015-05-27	AWAY	ETF	28.29	28.475	27.775	28.32	768820.0
2015-05-27	BAB	ETF	29.19	29.24	29.05	29.24	56923.0
2015-05-27	BAL	ETF	42.9601	43.17	42.67	42.8	12808.0
2015-05-27	BALT	ETF	1.56	1.57	1.52	1.55	345609.0
2015-05-27	BAR	ETF	2.605	2.6423	2.605	2.605	9600.0
2015-05-27	BBC	ETF	34.75	35.37	34.75	35.3664	26224.0
2015-05-27	BBH	ETF	134.16	136.01	133.57	135.95	190800.0
2015-05-27	BBP	ETF	32.41	32.768	32.19	32.768	8700.0
2015-05-27	BCHP	ETF	20.586	20.586	20.586	20.586	301.0

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

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