PREVIEW / etf_daily / 2015-09-02

all etf daily files

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

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-02	SPY	ETF	194.62	195.46	192.42	195.41	160269300.0
2015-09-02	QQQ	ETF	102.88	103.92	101.7	103.9	43963563.0
2015-09-02	IWM	ETF	113.41	113.97	112.08	113.91	26865800.0
2015-09-02	DIA	ETF	162.93	163.48	161.29	163.46	8260600.0
2015-09-02	GLD	ETF	109.01	109.34	108.46	108.62	4115700.0
2015-09-02	TLT	ETF	121.42	121.98	120.86	120.98	9515200.0
2015-09-02	AADR	ETF	37.49	37.56	36.04	36.44	10500.0
2015-09-02	AAXJ	ETF	52.28	52.29	51.81	52.22	2495500.0
2015-09-02	ACTX	ETF	1.77	1.77	1.475	1.77	1284.0
2015-09-02	ACWI	ETF	54.88	54.98	54.3	54.98	4670400.0
2015-09-02	ACWV	ETF	66.46	66.76	66.03	66.58	171700.0
2015-09-02	ACWX	ETF	39.96	39.98	39.55	39.96	1194599.0
2015-09-02	ADRE	ETF	29.15	29.18	28.8624	29.18	6896.0
2015-09-02	AFK	ETF	20.17	20.23	19.93	20.15	10929.0
2015-09-02	AFTY	ETF	14.71	14.92	14.5	14.59	157300.0
2015-09-02	AGG	ETF	108.92	109.05	108.81	108.88	3442000.0
2015-09-02	AGQ	ETF	31.39	31.93	30.4	31.32	151500.0
2015-09-02	AGZ	ETF	113.97	114.12	113.66	113.97	24682.0
2015-09-02	AGZD	ETF	24.055	24.055	23.95	24.04	2800.0
2015-09-02	AIA	ETF	41.2	41.34	40.95	41.33	56757.0
2015-09-02	AIQ	ETF	14.02	14.35	13.96	14.09	13679.0
2015-09-02	AIRR	ETF	16.38	16.38	16.143	16.28	19300.0
2015-09-02	AIVI	ETF	39.58	39.58	39.1	39.56	13300.0
2015-09-02	ALTY	ETF	14.112	14.112	14.04	14.04	400.0
2015-09-02	AMJ	ETF	35.46	35.875	34.45	35.33	1672750.0
2015-09-02	AMLP	ETF	71.85	72.45	70.55	71.85	1030100.0
2015-09-02	AMZA	ETF	166.3	167.0	162.8	163.7	2140.0
2015-09-02	ANGL	ETF	26.16	26.36	26.16	26.36	43700.0
2015-09-02	AOA	ETF	44.24	44.24	43.73	44.12	73200.0
2015-09-02	AOK	ETF	31.64	31.64	31.48	31.6	72958.0
2015-09-02	AOM	ETF	33.92	34.02	33.7809	34.02	44925.0
2015-09-02	AOR	ETF	38.5	38.5	38.19	38.43	97613.0
2015-09-02	ARGT	ETF	17.61	17.64	17.44	17.64	11200.0
2015-09-02	ARKG	ETF	20.53	20.53	20.53	20.53	200.0
2015-09-02	ARKK	ETF	19.37	19.585	19.37	19.585	600.0
2015-09-02	ARKQ	ETF	17.79	17.79	17.79	17.79	100.0
2015-09-02	ARKW	ETF	21.62	21.62	21.309	21.309	600.0
2015-09-02	ASEA	ETF	12.7	12.7	12.59	12.64	7100.0
2015-09-02	ASHR	ETF	31.2	31.43	30.92	31.26	1627500.0
2015-09-02	ASHS	ETF	34.1	34.37	33.43	34.35	140500.0
2015-09-02	ATMP	ETF	24.18	24.19	23.42	23.9	29300.0
2015-09-02	AWAY	ETF	27.72	28.16	27.355	28.16	1458331.0
2015-09-02	BAB	ETF	28.93	28.9784	28.84	28.87	33070.0
2015-09-02	BAL	ETF	41.54	41.61	41.43	41.61	3815.0
2015-09-02	BBC	ETF	31.24	32.08	30.84	32.08	8229.0
2015-09-02	BBH	ETF	125.34	127.3	122.3	127.29	256200.0
2015-09-02	BBP	ETF	32.34	32.8	31.75	32.8	8600.0
2015-09-02	BCM	ETF	26.77	27.209	26.77	27.11	3945.0
2015-09-02	BFOR	ETF	7.62	7.6675	7.55	7.665	192000.0
2015-09-02	BIB	ETF	73.92	77.85	72.25	77.85	858915.0

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

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