PREVIEW / etf_daily / 2015-08-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-07.parquet
  size:    48 KB
  rows:    1,186

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-08-07	SPY	ETF	208.16	208.34	206.87	207.95	117858000.0
2015-08-07	QQQ	ETF	110.18	110.57	109.4	110.31	30006846.0
2015-08-07	IWM	ETF	120.14	120.44	119.07	119.88	42261400.0
2015-08-07	DIA	ETF	173.89	174.12	172.8	173.84	6158400.0
2015-08-07	GLD	ETF	104.56	105.38	104.55	104.65	4400900.0
2015-08-07	TLT	ETF	123.3	124.5	123.24	124.34	8317000.0
2015-08-07	AADR	ETF	38.93	39.34	38.93	39.34	600.0
2015-08-07	AAXJ	ETF	58.31	58.45	58.15	58.27	690300.0
2015-08-07	ACTX	ETF	1.77	1.77	1.77	1.77	166.0
2015-08-07	ACWI	ETF	59.36	59.47	59.2	59.44	1375700.0
2015-08-07	ACWV	ETF	70.88	71.08	70.74	70.95	76500.0
2015-08-07	ACWX	ETF	43.71	43.85	43.69	43.84	182160.0
2015-08-07	ADRE	ETF	32.562	32.562	32.2804	32.31	6408.0
2015-08-07	AFK	ETF	22.17	22.41	22.17	22.28	9572.0
2015-08-07	AFTY	ETF	18.41	18.48	18.36	18.36	52800.0
2015-08-07	AGG	ETF	109.14	109.28	109.04	109.2	2154700.0
2015-08-07	AGQ	ETF	32.09	33.13	31.97	32.1	516500.0
2015-08-07	AGZ	ETF	113.19	113.4265	113.15	113.415	3886.0
2015-08-07	AGZD	ETF	24.26	24.325	24.26	24.325	5000.0
2015-08-07	AIA	ETF	46.38	46.38	46.17	46.24	12827.0
2015-08-07	AIQ	ETF	14.38	15.4199	14.06	14.86	12341.0
2015-08-07	AIRR	ETF	17.07	17.07	16.82	16.84	17400.0
2015-08-07	AIVI	ETF	42.96	43.2	42.88	43.2	23200.0
2015-08-07	ALTY	ETF	14.77	14.77	14.71	14.71	1800.0
2015-08-07	AMJ	ETF	34.8	35.46	34.68	35.01	1398090.0
2015-08-07	AMLP	ETF	72.05	72.95	71.75	72.15	1706620.0
2015-08-07	AMZA	ETF	161.9	163.5	155.2	160.1	1960.0
2015-08-07	ANGL	ETF	26.76	26.76	26.7	26.72	12000.0
2015-08-07	AOA	ETF	47.05	47.05	46.85	46.94	50500.0
2015-08-07	AOK	ETF	32.34	32.44	32.34	32.44	9841.0
2015-08-07	AOM	ETF	35.05	35.13	35.0005	35.05	103105.0
2015-08-07	AOR	ETF	40.24	40.36	40.2001	40.28	36776.0
2015-08-07	ARGT	ETF	18.71	18.73	18.51	18.72	5300.0
2015-08-07	ARKG	ETF	21.96	21.96	21.5	21.76	2400.0
2015-08-07	ARKK	ETF	20.777	20.777	20.777	20.777	200.0
2015-08-07	ARKQ	ETF	19.12	19.12	19.12	19.12	100.0
2015-08-07	ARKW	ETF	23.28	23.43	23.26	23.37	1600.0
2015-08-07	ASEA	ETF	14.13	14.15	14.02	14.07	17600.0
2015-08-07	ASHR	ETF	40.55	40.59	40.24	40.43	2279500.0
2015-08-07	ASHS	ETF	50.0	50.11	49.75	49.88	37800.0
2015-08-07	ATMP	ETF	23.9	24.23	23.9	23.95	46800.0
2015-08-07	AWAY	ETF	30.63	31.01	30.33	30.77	1174717.0
2015-08-07	BAB	ETF	29.22	29.39	29.22	29.33	32295.0
2015-08-07	BAL	ETF	41.39	41.55	41.063	41.1695	6009.0
2015-08-07	BBC	ETF	34.39	34.39	32.72	33.5	56015.0
2015-08-07	BBH	ETF	136.02	136.02	133.09	135.29	172300.0
2015-08-07	BBP	ETF	35.0	35.0	33.67	34.31	76300.0
2015-08-07	BCM	ETF	27.338	27.34	27.3199	27.3199	879.0
2015-08-07	BFOR	ETF	8.1375	8.145	8.085	8.1125	131200.0
2015-08-07	BIB	ETF	90.37	90.99	85.88	89.34	1277879.0

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

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