PREVIEW / etf_daily / 2016-08-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-08.parquet
  size:    52 KB
  rows:    1,290

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-08	SPY	ETF	218.4	218.52	217.74	218.05	39906500.0
2016-08-08	QQQ	ETF	116.82	116.87	116.28	116.65	12358181.0
2016-08-08	IWM	ETF	122.35	122.85	122.03	122.24	14625700.0
2016-08-08	DIA	ETF	185.5	185.7	185.02	185.28	2076700.0
2016-08-08	GLD	ETF	127.29	127.7	127.27	127.44	6773800.0
2016-08-08	TLT	ETF	137.6	138.54	137.32	138.26	5185200.0
2016-08-08	AADR	ETF	40.5	40.5	40.5	40.5	300.0
2016-08-08	AAXJ	ETF	58.58	58.69	58.52	58.54	1041300.0
2016-08-08	ACTX	ETF	2.95	3.54	2.95	2.95	879.0
2016-08-08	ACWI	ETF	58.5	58.63	58.48	58.53	2016800.0
2016-08-08	ACWV	ETF	77.46	77.46	77.18	77.24	311200.0
2016-08-08	ACWX	ETF	40.69	40.741	40.64	40.7	1740881.0
2016-08-08	ADRE	ETF	33.37	33.529	33.37	33.47	7477.0
2016-08-08	AFK	ETF	20.6499	21.28	20.4599	21.06	37190.0
2016-08-08	AFTY	ETF	13.13	13.13	13.13	13.13	100.0
2016-08-08	AGG	ETF	112.16	112.32	112.03	112.24	2604000.0
2016-08-08	AGGY	ETF	51.83	51.935	51.77	51.9	18500.0
2016-08-08	AGQ	ETF	51.7	52.41	50.98	51.64	489500.0
2016-08-08	AGZ	ETF	115.74	115.74	115.24	115.27	17951.0
2016-08-08	AGZD	ETF	23.84	23.84	23.84	23.84	200.0
2016-08-08	AIA	ETF	47.87	47.94	47.85	47.9	57718.0
2016-08-08	AIQ	ETF	6.11	6.14	5.97	6.09	27436.0
2016-08-08	AIRR	ETF	19.6	19.64	19.563	19.59	1200.0
2016-08-08	AIVI	ETF	38.61	38.75	38.61	38.73	9400.0
2016-08-08	ALTY	ETF	15.38	15.6	15.38	15.55	6500.0
2016-08-08	AMJ	ETF	31.96	32.47	31.6	32.16	1896982.0
2016-08-08	AMLP	ETF	64.7	65.05	64.5	64.7	1697020.0
2016-08-08	AMZA	ETF	114.6	116.0	114.35	115.3	14920.0
2016-08-08	ANGL	ETF	28.26	28.3	28.18	28.3	163200.0
2016-08-08	AOA	ETF	47.18	47.21	47.02	47.12	25000.0
2016-08-08	AOK	ETF	33.21	33.31	33.151	33.21	14204.0
2016-08-08	AOM	ETF	35.89	35.94	35.771	35.79	216849.0
2016-08-08	AOR	ETF	40.73	40.8299	40.73	40.82	112601.0
2016-08-08	ARGT	ETF	22.91	23.1	22.89	23.0	10100.0
2016-08-08	ARKG	ETF	19.2	19.2	19.06	19.06	700.0
2016-08-08	ARKK	ETF	20.91	20.91	20.9	20.9	700.0
2016-08-08	ARKQ	ETF	21.1	21.1	21.1	21.1	100.0
2016-08-08	ARKW	ETF	24.36	24.42	24.36	24.37	1400.0
2016-08-08	ASEA	ETF	14.19	14.19	14.16	14.16	400.0
2016-08-08	ASHR	ETF	24.38	24.54	24.38	24.41	465600.0
2016-08-08	ASHS	ETF	34.43	34.46	34.38	34.38	3300.0
2016-08-08	ATMP	ETF	22.8	23.2	22.8	23.08	14000.0
2016-08-08	BAB	ETF	31.49	31.56	31.4401	31.53	111784.0
2016-08-08	BAL	ETF	51.27	51.27	50.6901	50.6908	13324.0
2016-08-08	BBC	ETF	21.12	21.12	20.6	20.6	6512.0
2016-08-08	BBH	ETF	118.0	118.02	116.09	116.5	66300.0
2016-08-08	BBP	ETF	31.36	31.36	30.95	30.95	4500.0
2016-08-08	BCM	ETF	26.5	26.5	25.8872	25.94	15438.0
2016-08-08	BFOR	ETF	8.0475	8.0625	8.03	8.035	42000.0
2016-08-08	BIB	ETF	51.94	52.05	50.1708	50.57	1064697.0

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

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