PREVIEW / etf_daily / 2016-03-07

all etf daily files

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

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-07	SPY	ETF	199.34	201.07	199.25	200.59	100219000.0
2016-03-07	QQQ	ETF	105.12	105.74	104.27	105.02	25861160.0
2016-03-07	IWM	ETF	107.21	108.99	107.21	108.89	38739900.0
2016-03-07	DIA	ETF	169.37	170.93	169.3	170.62	3236000.0
2016-03-07	GLD	ETF	121.18	121.58	120.41	121.14	9358600.0
2016-03-07	TLT	ETF	128.45	128.67	128.05	128.56	5493300.0
2016-03-07	AADR	ETF	37.28	37.28	37.25	37.25	500.0
2016-03-07	AAXJ	ETF	52.14	52.73	52.11	52.52	718100.0
2016-03-07	ACTX	ETF	4.72	4.72	4.13	4.13	841.0
2016-03-07	ACWI	ETF	54.22	54.76	54.14	54.6	1156000.0
2016-03-07	ACWV	ETF	70.69	71.03	70.5	70.83	274600.0
2016-03-07	ACWX	ETF	38.27	38.765	38.23	38.63	1086309.0
2016-03-07	ADRE	ETF	29.42	29.71	29.42	29.6115	3024.0
2016-03-07	AFK	ETF	18.26	18.79	18.26	18.58	96226.0
2016-03-07	AFTY	ETF	12.51	12.55	12.51	12.52	9100.0
2016-03-07	AGG	ETF	109.39	109.39	109.21	109.35	2823200.0
2016-03-07	AGGY	ETF	49.73	49.76	49.654	49.722	11300.0
2016-03-07	AGQ	ETF	33.97	34.36	33.56	34.0	257100.0
2016-03-07	AGZ	ETF	113.97	114.0799	113.81	114.0	19473.0
2016-03-07	AGZD	ETF	23.81	23.81	23.67	23.67	5000.0
2016-03-07	AIA	ETF	41.04	41.43	41.04	41.34	28704.0
2016-03-07	AIQ	ETF	7.94	8.28	7.89	8.11	14456.0
2016-03-07	AIRR	ETF	16.92	17.02	16.88	17.02	9400.0
2016-03-07	AIVI	ETF	37.28	37.76	37.27	37.65	29900.0
2016-03-07	AMJ	ETF	26.6	27.44	26.46	27.43	5653725.0
2016-03-07	AMLP	ETF	53.1	55.45	53.1	55.45	2301880.0
2016-03-07	AMZA	ETF	91.0	93.7	90.72	92.6	8260.0
2016-03-07	ANGL	ETF	24.99	25.13	24.95	25.09	39500.0
2016-03-07	AOA	ETF	44.0	44.3	43.97	44.24	52200.0
2016-03-07	AOK	ETF	31.64	31.7491	31.6001	31.7	45325.0
2016-03-07	AOM	ETF	33.99	34.13	33.95	34.1	68742.0
2016-03-07	AOR	ETF	38.43	38.6199	38.4101	38.59	66575.0
2016-03-07	ARGT	ETF	18.9	19.12	18.88	18.99	74700.0
2016-03-07	ARKG	ETF	17.94	17.94	17.892	17.892	300.0
2016-03-07	ARKK	ETF	18.23	18.51	18.23	18.51	1400.0
2016-03-07	ARKQ	ETF	18.11	18.11	18.11	18.11	100.0
2016-03-07	ARKW	ETF	19.63	19.67	19.63	19.67	400.0
2016-03-07	ASEA	ETF	13.1	13.21	13.1	13.11	1400.0
2016-03-07	ASHR	ETF	23.62	23.7	23.49	23.51	1598400.0
2016-03-07	ASHS	ETF	31.61	31.78	31.61	31.72	14900.0
2016-03-07	ASHX	ETF	21.0	21.19	21.0	21.15	1610.0
2016-03-07	ATMP	ETF	17.81	18.41	17.81	18.28	24000.0
2016-03-07	BAB	ETF	29.86	29.86	29.733	29.86	268100.0
2016-03-07	BAL	ETF	37.62	37.68	37.431	37.47	15517.0
2016-03-07	BBC	ETF	19.08	20.29	19.08	19.9	27652.0
2016-03-07	BBH	ETF	103.0	106.38	102.97	105.51	69600.0
2016-03-07	BBP	ETF	24.16	25.51	24.16	25.29	9900.0
2016-03-07	BDCZ	ETF	19.54	19.54	19.43	19.43	300.0
2016-03-07	BFOR	ETF	7.3025	7.3875	7.3025	7.38	236400.0
2016-03-07	BIB	ETF	41.62	44.83	41.35	44.1	1213694.0

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

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