PREVIEW / etf_daily / 2015-06-05

all etf daily files

  file:    by_date/etf_daily/2015/2015-06-05.parquet
  size:    48 KB
  rows:    1,180

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
2015-06-05	SPY	ETF	209.95	210.58	208.98	209.77	121704700.0
2015-06-05	QQQ	ETF	109.43	109.69	108.63	109.3	22641732.0
2015-06-05	IWM	ETF	124.23	125.52	123.32	125.4	36626500.0
2015-06-05	DIA	ETF	179.08	179.46	178.25	178.5	5228700.0
2015-06-05	GLD	ETF	111.6	112.39	111.57	112.24	5561300.0
2015-06-05	TLT	ETF	117.84	118.57	117.38	117.6	11200200.0
2015-06-05	AADR	ETF	39.43	39.43	39.43	39.43	200.0
2015-06-05	AAXJ	ETF	64.66	65.04	64.56	64.83	609400.0
2015-06-05	ACTX	ETF	3.54	4.13	2.95	4.13	33.0
2015-06-05	ACWF	ETF	24.7799	24.87	24.7799	24.87	1600.0
2015-06-05	ACWI	ETF	61.0	61.29	60.8	61.05	806100.0
2015-06-05	ACWV	ETF	71.22	71.22	70.8	70.91	59700.0
2015-06-05	ACWX	ETF	45.47	45.71	45.32	45.56	119192.0
2015-06-05	ADRE	ETF	35.16	35.42	35.1456	35.36	2736.0
2015-06-05	AFK	ETF	25.1	25.2599	25.04	25.11	5885.0
2015-06-05	AFTY	ETF	23.39	23.39	23.07	23.07	51000.0
2015-06-05	AGG	ETF	108.63	108.79	108.51	108.55	1619000.0
2015-06-05	AGQ	ETF	38.0	38.85	37.95	38.48	254200.0
2015-06-05	AGZ	ETF	112.92	113.2475	112.4101	112.82	25928.0
2015-06-05	AGZD	ETF	24.48	24.485	24.335	24.46	7600.0
2015-06-05	AIA	ETF	51.57	51.69	51.28	51.6	33164.0
2015-06-05	AIQ	ETF	18.0	18.69	17.83	18.56	17714.0
2015-06-05	AIRR	ETF	18.32	18.475	18.32	18.46	6400.0
2015-06-05	AIVI	ETF	44.39	44.66	44.25	44.47	26600.0
2015-06-05	ALTL	ETF	36.8199	36.8199	36.727	36.727	2188.0
2015-06-05	AMJ	ETF	41.61	42.295	41.45	42.16	1776762.0
2015-06-05	AMLP	ETF	80.5	81.6	80.3	81.3	1242400.0
2015-06-05	AMZA	ETF	207.1	209.69	204.8	209.5	1060.0
2015-06-05	ANGL	ETF	27.58	27.61	27.51	27.55	9500.0
2015-06-05	AOA	ETF	47.94	47.94	47.63	47.83	55400.0
2015-06-05	AOK	ETF	32.57	32.62	32.48	32.53	16507.0
2015-06-05	AOM	ETF	35.41	35.47	35.253	35.358	49704.0
2015-06-05	AOR	ETF	40.95	40.96	40.714	40.8407	78005.0
2015-06-05	ARGT	ETF	21.29	21.5	21.12	21.45	8200.0
2015-06-05	ARKG	ETF	23.446	23.506	23.446	23.506	400.0
2015-06-05	ARKK	ETF	21.625	21.625	21.625	21.625	1500.0
2015-06-05	ARKQ	ETF	19.94	20.07	19.94	20.07	300.0
2015-06-05	ARKW	ETF	23.41	23.447	23.39	23.425	2700.0
2015-06-05	ASEA	ETF	15.0	15.04	14.92	14.94	9100.0
2015-06-05	ASHR	ETF	53.05	53.15	52.77	52.96	1945000.0
2015-06-05	ASHS	ETF	71.83	72.11	71.47	71.75	140700.0
2015-06-05	ATMP	ETF	28.44	28.79	28.26	28.66	17300.0
2015-06-05	AWAY	ETF	30.36	31.41	30.36	31.28	1443739.0
2015-06-05	BAB	ETF	28.75	28.98	28.75	28.78	76441.0
2015-06-05	BAL	ETF	43.89	43.89	43.38	43.82	6253.0
2015-06-05	BALT	ETF	1.51	1.51	1.45	1.49	308812.0
2015-06-05	BAR	ETF	2.505	2.506	2.489	2.506	27340.0
2015-06-05	BBC	ETF	36.42	36.5	35.41	36.5	17084.0
2015-06-05	BBH	ETF	132.38	133.93	131.21	133.66	117300.0
2015-06-05	BBP	ETF	33.43	34.02	33.17	33.97	30600.0

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

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