PREVIEW / etf_daily / 2015-09-10

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-10.parquet
  size:    48 KB
  rows:    1,194

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-10	SPY	ETF	194.56	197.22	194.25	195.85	158611100.0
2015-09-10	QQQ	ETF	103.74	105.68	103.62	104.99	47686714.0
2015-09-10	IWM	ETF	113.75	115.28	113.73	114.64	29877900.0
2015-09-10	DIA	ETF	162.54	164.5	162.15	163.39	8327000.0
2015-09-10	GLD	ETF	106.61	106.7	106.18	106.38	6204000.0
2015-09-10	TLT	ETF	121.02	121.19	120.45	120.63	6789700.0
2015-09-10	AADR	ETF	36.8	36.8	36.5	36.79	600.0
2015-09-10	AAXJ	ETF	53.3	53.75	53.11	53.48	1595100.0
2015-09-10	ACTX	ETF	2.36	2.95	1.77	2.95	2408.0
2015-09-10	ACWI	ETF	55.02	55.62	54.86	55.31	3631600.0
2015-09-10	ACWV	ETF	66.67	67.25	66.55	66.88	94100.0
2015-09-10	ACWX	ETF	40.11	40.52	40.01	40.38	975532.0
2015-09-10	ADRE	ETF	29.16	29.335	29.0	29.24	3124.0
2015-09-10	AFK	ETF	19.93	20.04	19.93	19.99	7615.0
2015-09-10	AFTY	ETF	15.4	15.55	15.1	15.32	49600.0
2015-09-10	AGG	ETF	109.0	109.01	108.81	108.93	2564400.0
2015-09-10	AGQ	ETF	31.87	31.95	31.16	31.18	145100.0
2015-09-10	AGZ	ETF	113.21	113.4572	113.16	113.31	39462.0
2015-09-10	AGZD	ETF	24.05	24.105	24.05	24.05	2400.0
2015-09-10	AIA	ETF	42.33	42.566	42.24	42.43	11382.0
2015-09-10	AIQ	ETF	14.6	15.179	14.55	15.14	18957.0
2015-09-10	AIRR	ETF	16.31	16.46	16.31	16.41	2400.0
2015-09-10	AIVI	ETF	39.63	40.01	39.62	39.91	78000.0
2015-09-10	ALTY	ETF	14.25	14.25	14.25	14.25	300.0
2015-09-10	AMJ	ETF	34.47	34.76	34.25	34.52	2153020.0
2015-09-10	AMLP	ETF	71.2	71.3	70.55	70.75	1548060.0
2015-09-10	AMZA	ETF	161.2	162.2	160.1	162.2	700.0
2015-09-10	ANGL	ETF	26.55	26.56	26.53	26.55	16700.0
2015-09-10	AOA	ETF	44.24	44.59	44.11	44.34	41400.0
2015-09-10	AOK	ETF	31.55	31.69	31.55	31.69	50675.0
2015-09-10	AOM	ETF	34.05	34.1699	33.9501	34.03	94436.0
2015-09-10	AOR	ETF	38.41	38.73	38.41	38.61	99051.0
2015-09-10	ARGT	ETF	17.75	17.78	17.72	17.78	1700.0
2015-09-10	ARKG	ETF	21.45	21.45	21.39	21.39	500.0
2015-09-10	ARKK	ETF	20.01	20.01	20.01	20.01	100.0
2015-09-10	ARKQ	ETF	18.13	18.13	18.1	18.12	400.0
2015-09-10	ARKW	ETF	21.95	22.04	21.88	21.88	1900.0
2015-09-10	ASEA	ETF	12.53	12.6	12.5	12.6	8700.0
2015-09-10	ASHR	ETF	33.07	33.43	32.99	33.28	2236800.0
2015-09-10	ASHS	ETF	37.24	38.06	37.24	37.75	204000.0
2015-09-10	ATMP	ETF	23.52	23.54	23.3	23.5	74300.0
2015-09-10	AWAY	ETF	28.13	29.02	28.13	28.89	659220.0
2015-09-10	BAB	ETF	28.82	28.82	28.65	28.7254	57765.0
2015-09-10	BAL	ETF	42.2599	42.2599	42.02	42.02	1851.0
2015-09-10	BBC	ETF	31.786	32.61	31.786	32.61	4011.0
2015-09-10	BBH	ETF	127.02	130.91	127.02	130.02	173200.0
2015-09-10	BBP	ETF	32.45	33.15	32.41	33.11	23200.0
2015-09-10	BCM	ETF	27.03	27.149	26.994	27.05	26318.0
2015-09-10	BFOR	ETF	7.665	7.7525	7.665	7.715	88400.0
2015-09-10	BIB	ETF	75.95	80.39	75.95	79.48	663646.0

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

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