PREVIEW / etf_daily / 2015-08-31

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-31.parquet
  size:    49 KB
  rows:    1,212

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-08-31	SPY	ETF	198.11	199.13	197.01	197.67	163298800.0
2015-08-31	QQQ	ETF	105.03	105.61	104.05	104.31	39549380.0
2015-08-31	IWM	ETF	115.1	115.98	114.76	115.2	29250900.0
2015-08-31	DIA	ETF	165.35	166.18	164.32	165.18	6363700.0
2015-08-31	GLD	ETF	108.19	108.92	108.03	108.82	4532100.0
2015-08-31	TLT	ETF	123.36	123.47	121.34	121.42	8617600.0
2015-08-31	AADR	ETF	37.31	37.31	37.31	37.31	100.0
2015-08-31	AAXJ	ETF	53.33	53.54	52.94	53.34	2275200.0
2015-08-31	ACTX	ETF	1.77	1.77	1.77	1.77	67.0
2015-08-31	ACWF	ETF	23.06	23.09	23.06	23.0899	800.0
2015-08-31	ACWI	ETF	55.85	56.19	55.65	55.86	2232200.0
2015-08-31	ACWV	ETF	67.73	68.0	67.31	67.47	269300.0
2015-08-31	ACWX	ETF	40.69	40.92	40.57	40.8	279006.0
2015-08-31	ADRE	ETF	29.87	29.95	29.3801	29.81	11847.0
2015-08-31	AFK	ETF	20.13	20.54	20.09	20.54	43372.0
2015-08-31	AFTY	ETF	15.05	15.22	14.75	14.79	78200.0
2015-08-31	AGG	ETF	109.28	109.37	108.9	108.92	4145600.0
2015-08-31	AGQ	ETF	30.52	31.34	30.23	31.21	114000.0
2015-08-31	AGZ	ETF	113.79	113.84	113.28	113.56	18861.0
2015-08-31	AGZD	ETF	23.965	24.05	23.965	24.045	78400.0
2015-08-31	AIA	ETF	42.24	42.3	41.886	42.13	54222.0
2015-08-31	AIQ	ETF	14.25	14.68	14.25	14.32	19716.0
2015-08-31	AIRR	ETF	16.36	16.67	16.35	16.64	19100.0
2015-08-31	AIVI	ETF	40.26	40.41	40.16	40.3	15800.0
2015-08-31	ALTY	ETF	14.41	14.45	14.18	14.41	4500.0
2015-08-31	AMJ	ETF	35.78	36.43	35.09	35.81	3238679.0
2015-08-31	AMLP	ETF	72.55	73.2	71.4	72.2	1407520.0
2015-08-31	AMZA	ETF	170.0	172.0	166.1	171.29	1700.0
2015-08-31	ANGL	ETF	26.48	26.48	26.24	26.25	5600.0
2015-08-31	AOA	ETF	44.78	44.92	44.7	44.83	34800.0
2015-08-31	AOK	ETF	31.86	31.86	31.7001	31.71	67496.0
2015-08-31	AOM	ETF	34.33	34.35	34.16	34.25	64535.0
2015-08-31	AOR	ETF	38.97	39.003	38.78	38.88	97389.0
2015-08-31	ARGT	ETF	17.64	18.1	17.64	18.04	1900.0
2015-08-31	ARKG	ETF	21.13	21.13	21.13	21.13	100.0
2015-08-31	ARKK	ETF	20.07	20.13	20.04	20.1	4700.0
2015-08-31	ARKQ	ETF	18.31	18.43	18.31	18.43	200.0
2015-08-31	ARKW	ETF	22.13	22.22	21.92	21.92	700.0
2015-08-31	ASEA	ETF	12.85	12.85	12.76	12.78	10400.0
2015-08-31	ASHR	ETF	32.36	32.68	32.03	32.03	4363800.0
2015-08-31	ASHS	ETF	38.68	38.68	37.45	37.7	192600.0
2015-08-31	ATMP	ETF	23.89	24.65	23.89	24.49	59700.0
2015-08-31	AWAY	ETF	29.12	29.16	28.62	28.69	699326.0
2015-08-31	BAB	ETF	29.25	29.25	28.89	28.9	58983.0
2015-08-31	BAL	ETF	41.85	42.289	41.4	41.81	26032.0
2015-08-31	BBC	ETF	32.01	32.12	31.16	31.16	14994.0
2015-08-31	BBH	ETF	129.95	130.73	125.78	126.01	58200.0
2015-08-31	BBP	ETF	33.57	33.68	32.675	32.83	11400.0
2015-08-31	BCHP	ETF	17.97	18.06	17.96	18.06	3112.0
2015-08-31	BFOR	ETF	7.7525	7.8275	7.7525	7.7975	105200.0

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

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