PREVIEW / etf_daily / 2016-07-18

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-18.parquet
  size:    52 KB
  rows:    1,294

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-07-18	SPY	ETF	215.97	216.6	215.67	216.41	58725900.0
2016-07-18	QQQ	ETF	111.86	112.74	111.85	112.54	20713924.0
2016-07-18	IWM	ETF	119.53	120.35	119.33	119.9	17422400.0
2016-07-18	DIA	ETF	184.83	185.38	184.71	185.08	2134900.0
2016-07-18	GLD	ETF	127.02	127.5	126.63	127.04	8489700.0
2016-07-18	TLT	ETF	139.07	139.26	137.73	138.26	5955900.0
2016-07-18	AADR	ETF	39.5	40.65	39.5	40.6	3400.0
2016-07-18	AAXJ	ETF	56.63	57.13	56.63	57.1	221200.0
2016-07-18	ACTX	ETF	4.13	4.13	4.13	4.13	192.0
2016-07-18	ACWI	ETF	57.7	57.96	57.65	57.89	1815400.0
2016-07-18	ACWV	ETF	77.33	77.57	77.33	77.48	273500.0
2016-07-18	ACWX	ETF	40.0	40.18	39.89	40.14	256848.0
2016-07-18	ADRE	ETF	32.37	32.795	32.37	32.795	4331.0
2016-07-18	AFK	ETF	20.47	20.86	20.314	20.45	1878.0
2016-07-18	AFTY	ETF	13.043	13.09	13.043	13.09	2400.0
2016-07-18	AGG	ETF	112.49	112.49	112.2	112.28	1547300.0
2016-07-18	AGGY	ETF	52.06	52.118	51.93	51.99	3700.0
2016-07-18	AGQ	ETF	53.05	54.15	53.01	54.09	219100.0
2016-07-18	AGZ	ETF	115.55	115.65	115.31	115.53	28109.0
2016-07-18	AIA	ETF	46.41	46.85	46.41	46.84	29053.0
2016-07-18	AIQ	ETF	6.39	6.43	6.22	6.275	24029.0
2016-07-18	AIRR	ETF	19.45	19.466	19.44	19.45	7400.0
2016-07-18	AIVI	ETF	38.47	38.69	38.44	38.62	61300.0
2016-07-18	ALTY	ETF	15.44	15.46	15.355	15.46	5200.0
2016-07-18	AMJ	ETF	32.01	32.37	31.9	32.22	1227361.0
2016-07-18	AMLP	ETF	64.05	64.65	64.05	64.35	977460.0
2016-07-18	AMZA	ETF	111.7	113.4	111.5	112.5	7770.0
2016-07-18	ANGL	ETF	28.26	28.32	28.11	28.24	432100.0
2016-07-18	AOA	ETF	46.51	46.71	46.47	46.55	34400.0
2016-07-18	AOK	ETF	33.03	33.1499	33.01	33.03	43055.0
2016-07-18	AOM	ETF	35.55	35.645	35.55	35.58	78348.0
2016-07-18	AOR	ETF	40.49	40.5046	40.39	40.47	82604.0
2016-07-18	ARGT	ETF	22.81	23.01	22.81	22.98	8200.0
2016-07-18	ARKG	ETF	18.05	18.05	18.05	18.05	200.0
2016-07-18	ARKK	ETF	20.472	20.472	20.472	20.472	300.0
2016-07-18	ARKQ	ETF	20.3	20.41	20.3	20.38	600.0
2016-07-18	ARKW	ETF	23.73	24.05	23.73	24.05	900.0
2016-07-18	ASHR	ETF	24.46	24.52	24.3	24.45	750600.0
2016-07-18	ASHS	ETF	34.99	35.37	34.99	35.25	144000.0
2016-07-18	ATMP	ETF	22.54	22.9	22.54	22.9	35200.0
2016-07-18	BAB	ETF	31.37	31.4346	31.19	31.24	450140.0
2016-07-18	BAL	ETF	49.88	49.892	49.18	49.5	58065.0
2016-07-18	BBC	ETF	18.86	19.01	18.83	19.01	4701.0
2016-07-18	BBH	ETF	108.82	109.49	108.35	109.11	68600.0
2016-07-18	BBP	ETF	28.7	28.899	28.62	28.71	4900.0
2016-07-18	BCM	ETF	26.858	26.921	26.85	26.91	16699.0
2016-07-18	BFIT	ETF	15.7001	15.7001	15.7001	15.7001	1022.0
2016-07-18	BFOR	ETF	7.93	7.9675	7.93	7.9575	66400.0
2016-07-18	BIB	ETF	43.38	44.03	43.0	43.72	520805.0
2016-07-18	BIL	ETF	91.42	91.44	91.42	91.42	167100.0

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

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