PREVIEW / etf_daily / 2016-03-04

all etf daily files

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

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-04	SPY	ETF	200.01	201.35	199.03	200.43	129293600.0
2016-03-04	QQQ	ETF	105.76	106.35	104.97	105.67	31655424.0
2016-03-04	IWM	ETF	107.07	108.32	106.67	107.72	38180900.0
2016-03-04	DIA	ETF	169.53	170.55	168.92	170.02	3524900.0
2016-03-04	GLD	ETF	121.13	122.37	120.22	120.54	16261100.0
2016-03-04	TLT	ETF	128.75	129.13	127.76	128.6	8687000.0
2016-03-04	AADR	ETF	37.39	37.43	37.39	37.43	500.0
2016-03-04	AAXJ	ETF	52.21	53.04	52.12	52.91	590200.0
2016-03-04	ACTX	ETF	3.54	4.72	3.54	4.13	429.0
2016-03-04	ACWI	ETF	54.37	54.82	54.25	54.56	1472200.0
2016-03-04	ACWV	ETF	70.81	71.14	70.6	70.99	238100.0
2016-03-04	ACWX	ETF	38.46	38.815	38.4592	38.63	817524.0
2016-03-04	ADRE	ETF	29.37	29.8713	29.37	29.75	8421.0
2016-03-04	AFK	ETF	18.02	18.61	17.96	18.55	61778.0
2016-03-04	AFTY	ETF	12.61	12.67	12.59	12.66	6200.0
2016-03-04	AGG	ETF	109.5	109.58	109.28	109.38	4461100.0
2016-03-04	AGGY	ETF	49.729	49.77	49.651	49.77	4300.0
2016-03-04	AGQ	ETF	33.07	34.68	32.91	33.4	561800.0
2016-03-04	AGZ	ETF	114.11	114.28	113.92	114.11	25822.0
2016-03-04	AGZD	ETF	23.7	23.75	23.655	23.75	1800.0
2016-03-04	AIA	ETF	41.14	41.73	41.14	41.66	15101.0
2016-03-04	AIQ	ETF	7.73	8.0	7.64	8.0	18827.0
2016-03-04	AIRR	ETF	16.801	16.85	16.66	16.7	276300.0
2016-03-04	AIVI	ETF	37.56	37.75	37.55	37.65	22400.0
2016-03-04	ALTY	ETF	13.89	13.89	13.89	13.89	200.0
2016-03-04	AMJ	ETF	26.56	27.0	26.25	26.48	5577137.0
2016-03-04	AMLP	ETF	54.3	54.75	53.0	53.45	3296200.0
2016-03-04	AMZA	ETF	92.7	93.0	89.1	90.4	7930.0
2016-03-04	ANGL	ETF	24.93	25.05	24.82	25.04	891300.0
2016-03-04	AOA	ETF	44.09	44.39	44.06	44.23	65200.0
2016-03-04	AOK	ETF	31.73	31.74	31.66	31.71	42842.0
2016-03-04	AOM	ETF	34.16	34.1799	34.03	34.11	87079.0
2016-03-04	AOR	ETF	38.57	38.698	38.46	38.59	169480.0
2016-03-04	ARGT	ETF	19.15	19.22	18.91	19.03	92700.0
2016-03-04	ARKG	ETF	17.63	17.63	17.585	17.585	3700.0
2016-03-04	ARKK	ETF	18.29	18.64	18.29	18.54	1300.0
2016-03-04	ARKQ	ETF	17.97	18.36	17.97	18.36	400.0
2016-03-04	ARKW	ETF	19.95	20.05	19.87	19.98	1100.0
2016-03-04	ASEA	ETF	13.06	13.25	13.04	13.17	3400.0
2016-03-04	ASHR	ETF	23.51	23.91	23.45	23.88	2503800.0
2016-03-04	ASHS	ETF	31.09	31.41	30.91	31.32	27800.0
2016-03-04	ASHX	ETF	21.08	21.08	21.08	21.08	300.0
2016-03-04	ATMP	ETF	17.99	18.21	17.69	17.92	39600.0
2016-03-04	BAB	ETF	30.02	30.02	29.776	29.88	632323.0
2016-03-04	BAL	ETF	36.7467	37.26	36.7467	37.1562	9090.0
2016-03-04	BBC	ETF	18.96	19.53	18.928	19.0799	13009.0
2016-03-04	BBH	ETF	103.86	105.09	103.06	103.52	75600.0
2016-03-04	BBP	ETF	24.44	25.09	24.44	24.621	6500.0
2016-03-04	BCM	ETF	24.115	24.42	24.114	24.3905	12791.0
2016-03-04	BFOR	ETF	7.3125	7.39	7.3125	7.345	146000.0

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

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