PREVIEW / etf_daily / 2016-03-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-01.parquet
  size:    51 KB
  rows:    1,261

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
2016-03-01	SPY	ETF	195.01	198.21	194.45	198.11	141799700.0
2016-03-01	QQQ	ETF	103.45	105.79	103.16	105.79	37699779.0
2016-03-01	IWM	ETF	103.62	104.94	103.07	104.94	36422700.0
2016-03-01	DIA	ETF	166.01	168.59	165.71	168.52	3914300.0
2016-03-01	GLD	ETF	118.74	119.11	117.34	117.77	14139300.0
2016-03-01	TLT	ETF	130.82	130.85	128.32	128.43	13729100.0
2016-03-01	AADR	ETF	36.84	36.98	36.84	36.88	12000.0
2016-03-01	AAXJ	ETF	50.18	50.9	50.11	50.85	776800.0
2016-03-01	ACTX	ETF	3.54	4.72	3.54	4.72	526.0
2016-03-01	ACWF	ETF	22.08	22.08	22.08	22.08	125.0
2016-03-01	ACWI	ETF	52.71	53.54	52.65	53.48	1813200.0
2016-03-01	ACWV	ETF	69.9	70.49	69.88	70.43	315300.0
2016-03-01	ACWX	ETF	37.17	37.57	37.03	37.55	569730.0
2016-03-01	ADRE	ETF	27.68	28.31	27.68	28.25	7851.0
2016-03-01	AFK	ETF	17.24	17.45	17.2	17.44	15697.0
2016-03-01	AFTY	ETF	11.873	11.9	11.82	11.82	8500.0
2016-03-01	AGG	ETF	109.93	110.05	109.4	109.54	3984500.0
2016-03-01	AGGY	ETF	49.84	49.86	49.65	49.718	11400.0
2016-03-01	AGQ	ETF	31.06	31.06	30.2	30.79	175300.0
2016-03-01	AGZ	ETF	114.65	114.7232	114.042	114.19	35432.0
2016-03-01	AGZD	ETF	23.605	23.625	23.605	23.605	1400.0
2016-03-01	AIA	ETF	39.5	40.17	39.5	40.1	36143.0
2016-03-01	AIQ	ETF	7.27	7.67	7.18	7.59	11237.0
2016-03-01	AIRR	ETF	15.892	16.16	15.892	16.16	4000.0
2016-03-01	AIVI	ETF	36.42	36.82	36.32	36.8	17000.0
2016-03-01	ALTY	ETF	13.202	13.202	13.202	13.202	100.0
2016-03-01	AMJ	ETF	25.07	25.2	24.68	25.07	3558024.0
2016-03-01	AMLP	ETF	51.1	51.2	49.65	50.55	2626200.0
2016-03-01	AMUB	ETF	15.68	15.68	15.63	15.63	300.0
2016-03-01	AMZA	ETF	85.0	85.0	81.41	84.25	4560.0
2016-03-01	ANGL	ETF	24.31	24.57	24.29	24.55	74100.0
2016-03-01	AOA	ETF	43.08	43.52	42.98	43.52	26300.0
2016-03-01	AOK	ETF	31.45	31.57	31.415	31.57	33099.0
2016-03-01	AOM	ETF	33.73	33.8399	33.67	33.82	62061.0
2016-03-01	AOR	ETF	37.84	38.1	37.7	38.09	49933.0
2016-03-01	ARGT	ETF	18.72	18.74	18.51	18.59	85400.0
2016-03-01	ARKG	ETF	16.85	16.96	16.85	16.96	1000.0
2016-03-01	ARKK	ETF	17.485	17.485	17.485	17.485	500.0
2016-03-01	ARKQ	ETF	17.1	17.1	17.1	17.1	600.0
2016-03-01	ARKW	ETF	19.3	19.56	19.3	19.56	900.0
2016-03-01	ASEA	ETF	12.46	12.58	12.46	12.58	2900.0
2016-03-01	ASET	ETF	24.1	24.1	24.1	24.1	200.0
2016-03-01	ASHR	ETF	22.17	22.49	22.11	22.46	1945100.0
2016-03-01	ASHS	ETF	29.92	30.39	29.92	30.35	46200.0
2016-03-01	ASHX	ETF	20.0	20.0	19.99	19.99	2140.0
2016-03-01	ATMP	ETF	17.17	17.17	16.58	16.82	99800.0
2016-03-01	BAB	ETF	30.07	30.1046	29.85	29.92	347947.0
2016-03-01	BAL	ETF	37.0	37.61	36.57	36.654	38234.0
2016-03-01	BBC	ETF	17.31	18.118	17.25	18.118	5557.0
2016-03-01	BBH	ETF	101.21	104.57	100.61	104.55	54100.0

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

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