PREVIEW / etf_daily / 2015-08-18

all etf daily files

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

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-18	SPY	ETF	210.26	210.68	209.7	209.98	71692700.0
2015-08-18	QQQ	ETF	111.275	111.37	110.71	110.86	13984363.0
2015-08-18	IWM	ETF	121.46	121.46	120.52	120.66	26360400.0
2015-08-18	DIA	ETF	175.28	175.93	175.08	175.33	4050400.0
2015-08-18	GLD	ETF	106.67	107.33	106.31	107.11	4121800.0
2015-08-18	TLT	ETF	123.8	124.29	123.38	123.54	5024300.0
2015-08-18	AADR	ETF	38.6	38.66	38.5	38.51	3300.0
2015-08-18	AAXJ	ETF	55.66	55.9	55.62	55.67	1165000.0
2015-08-18	ACTX	ETF	1.77	1.77	1.18	1.18	847.0
2015-08-18	ACWF	ETF	24.74	24.74	24.74	24.74	300.0
2015-08-18	ACWI	ETF	59.02	59.19	58.95	59.03	511100.0
2015-08-18	ACWV	ETF	71.12	71.37	71.05	71.15	163100.0
2015-08-18	ACWX	ETF	42.94	42.99	42.8201	42.9	363642.0
2015-08-18	ADRE	ETF	31.19	31.43	31.19	31.331	6036.0
2015-08-18	AFK	ETF	21.12	21.19	20.998	21.03	37965.0
2015-08-18	AFTY	ETF	17.18	17.18	16.97	17.02	35900.0
2015-08-18	AGG	ETF	109.19	109.24	109.04	109.06	785400.0
2015-08-18	AGQ	ETF	32.26	32.64	31.72	32.36	267200.0
2015-08-18	AGZ	ETF	113.28	113.3878	113.2445	113.2445	5964.0
2015-08-18	AGZD	ETF	24.32	24.34	24.16	24.175	8200.0
2015-08-18	AIA	ETF	44.29	44.4012	44.25	44.27	9939.0
2015-08-18	AIQ	ETF	14.77	15.23	14.7	14.82	10881.0
2015-08-18	AIRR	ETF	17.12	17.12	16.89	16.93	4100.0
2015-08-18	AIVI	ETF	42.36	42.42	42.22	42.29	12900.0
2015-08-18	AMJ	ETF	37.13	37.341	36.89	37.01	1208179.0
2015-08-18	AMLP	ETF	73.9	74.2	73.2	73.4	810500.0
2015-08-18	AMZA	ETF	172.57	172.8	170.0	170.8	780.0
2015-08-18	ANGL	ETF	26.61	26.61	26.56	26.58	12500.0
2015-08-18	AOA	ETF	46.94	46.94	46.73	46.85	21500.0
2015-08-18	AOK	ETF	32.329	32.4199	32.3	32.335	16906.0
2015-08-18	AOM	ETF	34.99	35.1	34.96	35.06	103662.0
2015-08-18	AOR	ETF	40.37	40.37	40.164	40.24	79405.0
2015-08-18	ARGT	ETF	18.71	18.73	18.68	18.7	6100.0
2015-08-18	ARKG	ETF	21.815	21.815	21.72	21.72	2100.0
2015-08-18	ARKK	ETF	20.98	20.98	20.98	20.98	200.0
2015-08-18	ARKQ	ETF	19.11	19.189	19.07	19.07	4300.0
2015-08-18	ARKW	ETF	23.551	23.56	23.38	23.44	1800.0
2015-08-18	ASEA	ETF	13.18	13.18	13.13	13.13	1600.0
2015-08-18	ASHR	ETF	37.93	38.01	37.54	37.63	4223700.0
2015-08-18	ASHS	ETF	51.25	51.25	47.0	47.73	134900.0
2015-08-18	ATMP	ETF	25.39	25.41	25.15	25.24	56600.0
2015-08-18	AWAY	ETF	31.3	31.5	30.95	31.32	900888.0
2015-08-18	BAB	ETF	29.05	29.1699	29.0	29.04	119888.0
2015-08-18	BAL	ETF	44.5	44.743	44.5	44.7	5738.0
2015-08-18	BBC	ETF	33.78	33.78	32.59	32.61	43291.0
2015-08-18	BBH	ETF	137.39	138.0	136.19	136.43	104000.0
2015-08-18	BBP	ETF	34.54	35.124	34.465	34.49	38000.0
2015-08-18	BCHP	ETF	18.63	18.767	18.63	18.64	10001.0
2015-08-18	BCM	ETF	26.95	26.95	26.85	26.9499	7197.0
2015-08-18	BFOR	ETF	8.215	8.215	8.175	8.19	28000.0

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

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