PREVIEW / etf_daily / 2016-08-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-05.parquet
  size:    51 KB
  rows:    1,280

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-08-05	SPY	ETF	216.41	218.23	216.41	218.18	71892200.0
2016-08-05	QQQ	ETF	116.28	117.04	116.13	116.78	23196570.0
2016-08-05	IWM	ETF	121.34	122.58	120.97	122.3	28643400.0
2016-08-05	DIA	ETF	184.4	185.28	183.43	185.26	4187700.0
2016-08-05	GLD	ETF	128.46	128.55	127.39	127.55	16205100.0
2016-08-05	TLT	ETF	139.05	139.18	137.82	138.0	7778600.0
2016-08-05	AAXJ	ETF	58.0	58.28	57.89	58.24	476000.0
2016-08-05	ACTX	ETF	3.54	3.54	2.891	2.891	927.0
2016-08-05	ACWI	ETF	58.16	58.47	58.16	58.44	815700.0
2016-08-05	ACWV	ETF	77.43	77.49	77.28	77.4	182200.0
2016-08-05	ACWX	ETF	40.36	40.58	40.36	40.56	536904.0
2016-08-05	ADRE	ETF	33.16	33.37	33.15	33.3544	9004.0
2016-08-05	AFK	ETF	20.4475	20.88	20.3101	20.65	10748.0
2016-08-05	AFTY	ETF	13.07	13.07	13.07	13.07	200.0
2016-08-05	AGG	ETF	112.54	112.54	112.14	112.17	2474600.0
2016-08-05	AGGY	ETF	51.96	51.97	51.77	51.86	10500.0
2016-08-05	AGNG	ETF	16.865	16.865	16.865	16.865	100.0
2016-08-05	AGQ	ETF	52.89	52.89	51.53	51.53	523900.0
2016-08-05	AGZ	ETF	115.52	115.6085	115.309	115.46	11692.0
2016-08-05	AGZD	ETF	23.71	23.71	23.71	23.71	400.0
2016-08-05	AIA	ETF	47.44	47.6624	47.44	47.65	14930.0
2016-08-05	AIQ	ETF	6.18	6.19	5.98	6.04	10444.0
2016-08-05	AIRR	ETF	19.36	19.584	19.36	19.54	19300.0
2016-08-05	AIVI	ETF	38.41	38.61	38.41	38.6	13300.0
2016-08-05	ALTY	ETF	15.54	15.59	15.438	15.438	4800.0
2016-08-05	AMJ	ETF	31.63	32.25	31.41	31.84	1364280.0
2016-08-05	AMLP	ETF	64.2	64.6	63.8	64.2	1659860.0
2016-08-05	AMZA	ETF	113.6	114.5	112.24	113.9	7210.0
2016-08-05	ANGL	ETF	28.17	28.21	28.1	28.18	84500.0
2016-08-05	AOA	ETF	46.88	47.08	46.88	47.08	52500.0
2016-08-05	AOK	ETF	33.22	33.26	33.1057	33.21	20596.0
2016-08-05	AOM	ETF	35.88	35.88	35.67	35.83	45076.0
2016-08-05	AOR	ETF	40.75	40.79	40.6	40.79	91426.0
2016-08-05	ARGT	ETF	22.68	22.95	22.67	22.87	37000.0
2016-08-05	ARKG	ETF	19.03	19.26	19.03	19.22	1400.0
2016-08-05	ARKK	ETF	20.832	20.832	20.832	20.832	100.0
2016-08-05	ARKQ	ETF	20.953	20.97	20.953	20.97	600.0
2016-08-05	ARKW	ETF	24.15	24.225	24.15	24.225	300.0
2016-08-05	ASEA	ETF	14.0	14.0	14.0	14.0	200.0
2016-08-05	ASHR	ETF	24.25	24.28	24.21	24.26	543400.0
2016-08-05	ASHS	ETF	34.03	34.12	34.0	34.08	10200.0
2016-08-05	ATMP	ETF	22.55	22.9	22.55	22.76	24900.0
2016-08-05	BAB	ETF	31.63	31.65	31.43	31.46	152215.0
2016-08-05	BAL	ETF	51.67	51.7946	50.75	51.2351	65533.0
2016-08-05	BBC	ETF	20.51	21.16	20.49	21.06	7071.0
2016-08-05	BBH	ETF	117.78	118.52	117.46	117.75	63300.0
2016-08-05	BBP	ETF	31.58	31.594	31.15	31.48	9200.0
2016-08-05	BCM	ETF	25.62	25.78	25.62	25.76	7747.0
2016-08-05	BFOR	ETF	7.97	8.0525	7.97	8.045	39600.0
2016-08-05	BIB	ETF	52.02	52.26	51.15	51.63	1404113.0

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

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