PREVIEW / etf_daily / 2015-10-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-02.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-10-02	SPY	ETF	189.77	195.03	189.12	195.0	211003300.0
2015-10-02	QQQ	ETF	100.8	104.01	100.48	104.01	59370859.0
2015-10-02	IWM	ETF	107.98	110.63	107.12	110.63	58019200.0
2015-10-02	DIA	ETF	160.35	164.58	159.93	164.58	11877500.0
2015-10-02	GLD	ETF	108.54	109.32	108.54	108.99	7730600.0
2015-10-02	TLT	ETF	125.59	126.21	124.18	124.56	13000400.0
2015-10-02	AADR	ETF	36.56	36.64	36.1	36.28	1600.0
2015-10-02	AAXJ	ETF	52.87	54.3	52.69	54.3	1792800.0
2015-10-02	ACTX	ETF	16.5201	16.5201	9.4401	12.9801	6669.0
2015-10-02	ACWI	ETF	53.59	55.0	53.48	54.99	1821900.0
2015-10-02	ACWV	ETF	66.43	67.94	66.43	67.94	328300.0
2015-10-02	ACWX	ETF	39.01	39.91	38.91	39.91	1760856.0
2015-10-02	ADRE	ETF	27.81	28.91	27.75	28.9	4472.0
2015-10-02	AFK	ETF	19.84	20.31	19.7999	20.31	7827.0
2015-10-02	AFTY	ETF	15.21	15.42	15.21	15.39	7600.0
2015-10-02	AGG	ETF	109.85	110.15	109.7	109.79	3553300.0
2015-10-02	AGQ	ETF	32.0	33.75	32.0	33.45	331700.0
2015-10-02	AGZ	ETF	114.28	114.2999	113.94	114.09	18180.0
2015-10-02	AIA	ETF	41.82	42.84	41.74	42.81	50269.0
2015-10-02	AIQ	ETF	9.94	10.0	9.56	9.99	24165.0
2015-10-02	AIRR	ETF	14.92	15.33	14.92	15.33	6000.0
2015-10-02	AIVI	ETF	38.03	38.87	37.96	38.87	10400.0
2015-10-02	ALTY	ETF	13.94	13.94	13.9	13.92	900.0
2015-10-02	AMJ	ETF	31.39	32.74	30.9552	32.64	6239293.0
2015-10-02	AMLP	ETF	64.2	67.5	63.8	67.1	2546300.0
2015-10-02	AMZA	ETF	141.65	147.1	141.65	147.1	340.0
2015-10-02	ANGL	ETF	25.4	25.53	25.32	25.53	14000.0
2015-10-02	AOA	ETF	43.24	44.2	43.24	44.2	43500.0
2015-10-02	AOK	ETF	31.46	31.7001	31.46	31.654	16102.0
2015-10-02	AOM	ETF	33.68	34.04	33.62	34.04	41104.0
2015-10-02	AOR	ETF	37.87	38.51	37.87	38.51	51930.0
2015-10-02	ARGT	ETF	15.87	16.13	15.87	16.13	7300.0
2015-10-02	ARKG	ETF	18.507	19.04	18.507	19.04	1100.0
2015-10-02	ARKK	ETF	18.74	19.08	18.74	19.08	600.0
2015-10-02	ARKQ	ETF	17.38	17.38	17.38	17.38	100.0
2015-10-02	ARKW	ETF	21.23	21.66	21.0	21.63	8200.0
2015-10-02	ASEA	ETF	11.95	12.1	11.95	12.1	9700.0
2015-10-02	ASHR	ETF	32.38	33.44	32.38	33.4	3069800.0
2015-10-02	ASHS	ETF	36.66	37.87	36.54	37.66	61100.0
2015-10-02	ATMP	ETF	21.33	22.24	21.27	22.24	67200.0
2015-10-02	AWAY	ETF	26.2	27.46	26.09	27.42	917600.0
2015-10-02	BAB	ETF	29.48	29.5799	29.34	29.44	107348.0
2015-10-02	BAL	ETF	40.4388	40.4388	40.14	40.14	1186.0
2015-10-02	BBC	ETF	25.93	27.8892	25.7634	27.83	22408.0
2015-10-02	BBH	ETF	113.14	118.59	112.69	118.58	211600.0
2015-10-02	BBP	ETF	27.15	29.14	27.15	29.12	19200.0
2015-10-02	BCHP	ETF	17.454	17.454	17.454	17.454	600.0
2015-10-02	BCM	ETF	26.7965	26.8	26.794	26.794	3992.0
2015-10-02	BFOR	ETF	7.35	7.475	7.29	7.475	60400.0
2015-10-02	BIB	ETF	56.72	63.5	56.5	63.3	2391388.0

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

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