PREVIEW / etf_daily / 2016-08-18

all etf daily files

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

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-18	SPY	ETF	218.34	218.9	218.21	218.86	52989300.0
2016-08-18	QQQ	ETF	117.15	117.46	116.945	117.29	10023604.0
2016-08-18	IWM	ETF	122.08	122.97	122.04	122.94	16244600.0
2016-08-18	DIA	ETF	185.97	186.41	185.72	186.34	2571800.0
2016-08-18	GLD	ETF	128.89	129.17	128.58	129.11	9500600.0
2016-08-18	TLT	ETF	139.2	139.76	138.79	139.44	3805200.0
2016-08-18	AADR	ETF	41.16	41.16	41.12	41.12	300.0
2016-08-18	AAXJ	ETF	59.65	59.87	59.53	59.85	669400.0
2016-08-18	ACTX	ETF	3.54	5.9001	3.54	3.54	3522.0
2016-08-18	ACWI	ETF	59.22	59.41	59.16	59.39	1321200.0
2016-08-18	ACWV	ETF	77.47	77.64	77.38	77.64	110200.0
2016-08-18	ACWX	ETF	41.49	41.67	41.46	41.66	350959.0
2016-08-18	ADRE	ETF	34.623	34.63	34.6	34.63	1156.0
2016-08-18	AFK	ETF	21.46	21.49	20.8	21.16	33847.0
2016-08-18	AFTY	ETF	13.66	13.66	13.61	13.61	900.0
2016-08-18	AGG	ETF	112.64	112.78	112.54	112.73	1962900.0
2016-08-18	AGGY	ETF	52.09	52.29	52.09	52.26	5700.0
2016-08-18	AGNG	ETF	16.7	16.7	16.7	16.7	400.0
2016-08-18	AGQ	ETF	51.69	52.17	51.31	51.62	151300.0
2016-08-18	AGZ	ETF	115.69	115.81	115.5001	115.67	20544.0
2016-08-18	AGZD	ETF	23.875	23.88	23.865	23.88	2800.0
2016-08-18	AIA	ETF	48.68	48.96	48.61	48.96	90331.0
2016-08-18	AIQ	ETF	6.17	6.17	6.13	6.14	3634.0
2016-08-18	AIRR	ETF	19.62	19.67	19.616	19.67	8000.0
2016-08-18	AIVI	ETF	39.2	39.53	39.15	39.53	16600.0
2016-08-18	ALTY	ETF	15.71	15.77	15.675	15.74	3900.0
2016-08-18	AMJ	ETF	32.1	32.56	31.68	32.36	3462338.0
2016-08-18	AMLP	ETF	63.65	64.1	63.6	64.05	1848340.0
2016-08-18	AMZA	ETF	116.5	119.3	116.28	117.5	14560.0
2016-08-18	ANGL	ETF	28.67	28.72	28.62	28.72	139700.0
2016-08-18	AOA	ETF	47.38	47.64	47.38	47.62	24700.0
2016-08-18	AOK	ETF	33.34	33.48	33.338	33.4601	30713.0
2016-08-18	AOM	ETF	36.02	36.1489	36.02	36.13	49341.0
2016-08-18	AOR	ETF	41.13	41.2699	41.02	41.19	50579.0
2016-08-18	ARGT	ETF	23.05	23.26	23.05	23.25	7700.0
2016-08-18	ARKG	ETF	18.92	18.97	18.92	18.97	500.0
2016-08-18	ARKK	ETF	21.225	21.225	21.225	21.225	400.0
2016-08-18	ARKQ	ETF	21.34	21.46	21.34	21.41	2100.0
2016-08-18	ARKW	ETF	24.572	24.66	24.572	24.66	1000.0
2016-08-18	ASEA	ETF	14.25	14.38	14.25	14.35	4000.0
2016-08-18	ASET	ETF	27.1	27.12	27.1	27.12	200.0
2016-08-18	ASHR	ETF	25.61	25.68	25.54	25.67	726900.0
2016-08-18	ASHS	ETF	35.86	35.86	35.61	35.81	14200.0
2016-08-18	ATMP	ETF	23.32	23.71	23.32	23.61	30500.0
2016-08-18	BAB	ETF	31.62	31.699	31.5901	31.66	146583.0
2016-08-18	BAL	ETF	46.44	46.45	45.7908	45.8392	6854.0
2016-08-18	BBC	ETF	20.54	20.6924	20.3325	20.61	8184.0
2016-08-18	BBH	ETF	115.37	116.32	114.94	115.6	30500.0
2016-08-18	BBP	ETF	30.73	31.096	30.73	30.95	5000.0
2016-08-18	BCM	ETF	27.16	27.16	27.135	27.14	803.0

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

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