PREVIEW / etf_daily / 2016-03-08

all etf daily files

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

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-08	SPY	ETF	199.32	199.92	198.21	198.4	123974900.0
2016-03-08	QQQ	ETF	104.3	105.2138	103.97	104.15	28898525.0
2016-03-08	IWM	ETF	108.29	108.29	106.14	106.26	46193900.0
2016-03-08	DIA	ETF	169.8	170.76	169.22	169.62	2832700.0
2016-03-08	GLD	ETF	121.79	121.88	120.47	120.58	11531000.0
2016-03-08	TLT	ETF	130.35	130.99	129.95	129.98	7175400.0
2016-03-08	AAXJ	ETF	51.83	51.9	51.5	51.54	614300.0
2016-03-08	ACTX	ETF	4.13	4.13	3.422	3.422	1163.0
2016-03-08	ACWI	ETF	54.27	54.34	53.96	54.01	2523900.0
2016-03-08	ACWV	ETF	70.6	70.95	70.5	70.58	718600.0
2016-03-08	ACWX	ETF	38.37	38.4	38.13	38.19	848823.0
2016-03-08	ADRE	ETF	29.37	29.37	29.1201	29.2252	6229.0
2016-03-08	AFK	ETF	18.4735	18.4735	18.26	18.35	16495.0
2016-03-08	AFTY	ETF	12.38	12.41	12.32	12.32	5400.0
2016-03-08	AGG	ETF	109.73	109.83	109.56	109.62	1984400.0
2016-03-08	AGGY	ETF	49.925	49.95	49.78	49.858	15400.0
2016-03-08	AGQ	ETF	33.77	33.87	32.68	32.74	218200.0
2016-03-08	AGZ	ETF	114.33	114.33	114.0944	114.22	17172.0
2016-03-08	AGZD	ETF	23.52	23.74	23.52	23.74	1200.0
2016-03-08	AIA	ETF	40.87	40.87	40.59	40.62	8053.0
2016-03-08	AIQ	ETF	8.12	8.12	7.98	8.06	10053.0
2016-03-08	AIRR	ETF	16.79	16.83	16.67	16.67	6100.0
2016-03-08	AIVI	ETF	37.28	37.44	37.25	37.29	9100.0
2016-03-08	AMJ	ETF	27.37	27.42	25.61	25.68	5511624.0
2016-03-08	AMLP	ETF	54.95	54.95	51.65	51.75	3598340.0
2016-03-08	AMUB	ETF	16.39	16.39	16.34	16.34	300.0
2016-03-08	AMZA	ETF	92.6	92.6	84.1	85.2	7410.0
2016-03-08	ANGL	ETF	25.19	25.19	25.07	25.08	34800.0
2016-03-08	AOA	ETF	44.06	44.06	43.79	43.79	19900.0
2016-03-08	AOK	ETF	31.67	31.7499	31.66	31.66	21679.0
2016-03-08	AOM	ETF	34.13	34.13	34.011	34.03	64722.0
2016-03-08	AOR	ETF	38.54	38.54	38.34	38.35	127958.0
2016-03-08	ARGT	ETF	18.89	18.91	18.62	18.77	181200.0
2016-03-08	ARKG	ETF	17.48	17.48	17.48	17.48	200.0
2016-03-08	ARKK	ETF	18.21	18.21	18.21	18.21	200.0
2016-03-08	ARKQ	ETF	17.905	17.905	17.905	17.905	600.0
2016-03-08	ARKW	ETF	19.659	19.659	19.659	19.659	200.0
2016-03-08	ASEA	ETF	12.89	12.89	12.84	12.84	400.0
2016-03-08	ASET	ETF	24.63	25.36	24.54	24.6106	1772.0
2016-03-08	ASHR	ETF	23.5	23.5	23.12	23.16	2358400.0
2016-03-08	ASHS	ETF	32.0	32.0	31.3	31.47	10300.0
2016-03-08	ATMP	ETF	18.29	18.29	17.25	17.25	35800.0
2016-03-08	BAB	ETF	30.03	30.05	29.94	29.94	216410.0
2016-03-08	BAL	ETF	37.11	37.34	36.95	37.24	27157.0
2016-03-08	BBC	ETF	19.91	19.92	18.58	18.58	9426.0
2016-03-08	BBH	ETF	104.4	105.17	102.38	102.67	73500.0
2016-03-08	BBP	ETF	25.25	25.25	24.621	24.621	3800.0
2016-03-08	BDCZ	ETF	19.36	19.36	19.3105	19.3105	400.0
2016-03-08	BFOR	ETF	7.3475	7.3475	7.245	7.245	36800.0
2016-03-08	BIB	ETF	43.86	43.86	40.75	40.95	782623.0

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

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