PREVIEW / etf_daily / 2015-09-30

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-30.parquet
  size:    49 KB
  rows:    1,224

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-09-30	SPY	ETF	190.37	191.83	189.44	191.63	163452000.0
2015-09-30	QQQ	ETF	100.89	101.87	100.5	101.76	41411432.0
2015-09-30	IWM	ETF	108.48	109.43	107.91	109.2	50834500.0
2015-09-30	DIA	ETF	162.04	162.75	161.05	162.62	7621400.0
2015-09-30	GLD	ETF	106.78	107.08	106.47	106.86	7405600.0
2015-09-30	TLT	ETF	123.41	123.8	123.12	123.54	9832600.0
2015-09-30	AADR	ETF	35.67	35.67	35.64	35.64	3600.0
2015-09-30	AAXJ	ETF	52.44	52.81	52.28	52.75	1191600.0
2015-09-30	ACTX	ETF	23.3052	23.6002	12.3901	15.9301	10700.0
2015-09-30	ACWF	ETF	22.31	22.31	22.31	22.31	900.0
2015-09-30	ACWI	ETF	53.58	53.99	53.32	53.94	6196500.0
2015-09-30	ACWV	ETF	66.76	66.96	66.4	66.96	371800.0
2015-09-30	ACWX	ETF	38.9	39.07	38.6601	39.05	987146.0
2015-09-30	ADRE	ETF	27.78	27.97	27.732	27.952	21150.0
2015-09-30	AFK	ETF	19.64	19.79	19.59	19.73	11458.0
2015-09-30	AFTY	ETF	15.16	15.16	14.86	14.93	21600.0
2015-09-30	AGG	ETF	109.47	109.63	109.44	109.58	3121600.0
2015-09-30	AGGY	ETF	49.72	49.78	49.65	49.67	600.0
2015-09-30	AGQ	ETF	30.67	31.44	30.26	30.53	136200.0
2015-09-30	AGZ	ETF	113.96	114.06	113.96	114.04	28891.0
2015-09-30	AGZD	ETF	23.965	23.99	23.92	23.99	2000.0
2015-09-30	AIA	ETF	41.49	41.6	41.22	41.58	39324.0
2015-09-30	AIQ	ETF	10.0	10.0	9.5501	9.76	39042.0
2015-09-30	AIRR	ETF	15.1	15.29	15.1	15.29	8800.0
2015-09-30	AIVI	ETF	38.03	38.12	37.86	38.12	39000.0
2015-09-30	ALTY	ETF	13.9	13.9	13.89	13.89	800.0
2015-09-30	AMJ	ETF	28.33	30.6	28.3	30.39	7153126.0
2015-09-30	AMLP	ETF	58.35	63.1	58.35	62.4	4037600.0
2015-09-30	AMZA	ETF	122.5	143.2	118.9	133.5	10470.0
2015-09-30	ANGL	ETF	25.52	25.65	25.52	25.62	41200.0
2015-09-30	AOA	ETF	43.46	43.63	43.33	43.63	95200.0
2015-09-30	AOK	ETF	31.5255	31.5255	31.3701	31.46	33230.0
2015-09-30	AOM	ETF	33.83	33.85	33.67	33.85	100696.0
2015-09-30	AOR	ETF	37.92	38.16	37.89	38.16	238555.0
2015-09-30	ARGT	ETF	15.95	15.95	15.95	15.95	100.0
2015-09-30	ARKG	ETF	18.75	18.75	18.75	18.75	200.0
2015-09-30	ARKK	ETF	18.79	18.79	18.79	18.79	100.0
2015-09-30	ARKQ	ETF	17.35	17.35	17.35	17.35	100.0
2015-09-30	ARKW	ETF	21.04	21.28	21.01	21.28	8900.0
2015-09-30	ASEA	ETF	11.93	11.93	11.93	11.93	800.0
2015-09-30	ASHR	ETF	32.2	32.37	32.01	32.34	972800.0
2015-09-30	ASHS	ETF	36.39	37.13	36.33	36.45	50000.0
2015-09-30	ATMP	ETF	19.5	20.74	19.45	20.71	276800.0
2015-09-30	AWAY	ETF	26.23	26.625	25.92	26.54	1195891.0
2015-09-30	BAB	ETF	29.28	29.29	29.2001	29.28	80538.0
2015-09-30	BAL	ETF	40.92	40.92	40.12	40.22	13204.0
2015-09-30	BBC	ETF	26.24	26.61	25.644	26.3801	20561.0
2015-09-30	BBH	ETF	112.09	115.4	112.09	114.32	335000.0
2015-09-30	BBP	ETF	27.52	28.0	27.074	27.6	12000.0
2015-09-30	BCHP	ETF	17.18	17.19	17.11	17.19	500.0

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

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