PREVIEW / etf_daily / 2016-03-24

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-24.parquet
  size:    50 KB
  rows:    1,242

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-24	SPY	ETF	202.0	203.16	201.74	203.12	84360900.0
2016-03-24	QQQ	ETF	106.67	107.29	106.53	107.26	19017258.0
2016-03-24	IWM	ETF	106.24	107.22	105.74	107.2	30924300.0
2016-03-24	DIA	ETF	173.85	174.94	173.7	174.94	5104900.0
2016-03-24	GLD	ETF	116.77	116.94	116.3	116.33	6280900.0
2016-03-24	TLT	ETF	130.58	130.64	129.0	129.54	6343300.0
2016-03-24	AADR	ETF	37.42	37.68	37.22	37.23	24600.0
2016-03-24	AAXJ	ETF	53.13	53.46	53.01	53.46	667500.0
2016-03-24	ACTX	ETF	6.4901	8.2601	5.9001	7.6701	1038.0
2016-03-24	ACWI	ETF	54.96	55.23	53.77	55.23	1111000.0
2016-03-24	ACWV	ETF	72.2	72.48	72.14	72.47	104700.0
2016-03-24	ACWX	ETF	38.59	38.79	38.47	38.79	770258.0
2016-03-24	ADRE	ETF	29.91	30.172	29.91	30.172	2129.0
2016-03-24	AFK	ETF	18.94	19.19	18.6501	19.15	5424.0
2016-03-24	AFTY	ETF	12.64	12.66	12.62	12.635	10000.0
2016-03-24	AGG	ETF	110.29	110.29	110.03	110.11	2846400.0
2016-03-24	AGGY	ETF	50.31	50.31	50.16	50.21	2400.0
2016-03-24	AGQ	ETF	32.43	32.5	31.8	31.83	151200.0
2016-03-24	AGZ	ETF	114.6	114.7798	114.19	114.77	17750.0
2016-03-24	AIA	ETF	42.17	42.31	42.07	42.31	18547.0
2016-03-24	AIQ	ETF	6.91	7.17	6.76	7.02	8119.0
2016-03-24	AIRR	ETF	17.1	17.23	17.07	17.23	1500.0
2016-03-24	AIVI	ETF	37.39	37.59	37.33	37.48	89000.0
2016-03-24	ALTY	ETF	14.1	14.1	14.1	14.1	100.0
2016-03-24	AMJ	ETF	25.6	26.47	25.41	26.2	1643439.0
2016-03-24	AMLP	ETF	51.75	53.2	51.25	52.35	2102120.0
2016-03-24	AMZA	ETF	87.0	89.09	83.5	87.7	3870.0
2016-03-24	ANGL	ETF	26.13	26.13	25.56	25.66	48200.0
2016-03-24	AOA	ETF	44.45	44.67	44.45	44.67	27700.0
2016-03-24	AOK	ETF	32.0	32.02	31.9291	32.02	29626.0
2016-03-24	AOM	ETF	34.42	34.5	34.29	34.42	56471.0
2016-03-24	AOR	ETF	38.84	38.96	38.68	38.96	141336.0
2016-03-24	ARGT	ETF	18.92	19.02	18.73	18.99	26600.0
2016-03-24	ARKK	ETF	18.2	18.27	18.2	18.27	1400.0
2016-03-24	ARKQ	ETF	17.98	18.24	17.98	18.21	2200.0
2016-03-24	ARKW	ETF	20.004	20.004	20.004	20.004	200.0
2016-03-24	ASEA	ETF	13.13	13.18	13.13	13.18	11900.0
2016-03-24	ASHR	ETF	24.0	24.01	23.85	23.93	2248700.0
2016-03-24	ASHS	ETF	33.78	33.78	33.27	33.55	74600.0
2016-03-24	ATMP	ETF	17.01	17.58	17.01	17.5	86200.0
2016-03-24	BAB	ETF	30.0	30.0699	29.91	29.92	119366.0
2016-03-24	BAL	ETF	37.99	37.99	37.4811	37.661	9820.0
2016-03-24	BBC	ETF	17.51	18.315	17.1901	17.881	16042.0
2016-03-24	BBH	ETF	100.56	103.46	99.83	102.09	79500.0
2016-03-24	BBP	ETF	23.33	24.156	23.0	23.82	5600.0
2016-03-24	BCM	ETF	24.476	24.6	24.47	24.6	15064.0
2016-03-24	BFOR	ETF	7.34	7.3725	7.2975	7.3725	27600.0
2016-03-24	BIB	ETF	38.1	40.452	37.4101	39.33	1042130.0
2016-03-24	BICK	ETF	19.367	19.515	19.35	19.51	2568.0
2016-03-24	BIL	ETF	91.36	91.38	91.36	91.38	711350.0

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

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