PREVIEW / etf_daily / 2016-04-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-07.parquet
  size:    50 KB
  rows:    1,254

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-04-07	SPY	ETF	205.14	205.56	203.09	203.95	113859000.0
2016-04-07	QQQ	ETF	110.04	110.225	108.61	109.08	28567202.0
2016-04-07	IWM	ETF	109.37	109.88	108.13	108.68	33298400.0
2016-04-07	DIA	ETF	175.78	176.23	174.68	175.29	5251900.0
2016-04-07	GLD	ETF	118.65	118.85	115.0	118.61	11900500.0
2016-04-07	TLT	ETF	132.19	132.99	132.01	132.85	5963300.0
2016-04-07	AADR	ETF	38.55	38.55	38.28	38.29	1900.0
2016-04-07	AAXJ	ETF	53.08	53.15	52.6	52.69	949300.0
2016-04-07	ACTX	ETF	4.72	5.9001	4.13	5.9001	4000.0
2016-04-07	ACWI	ETF	55.31	55.43	54.8	54.97	2125500.0
2016-04-07	ACWV	ETF	73.23	73.36	72.85	73.01	215000.0
2016-04-07	ACWX	ETF	38.46	38.55	38.12	38.22	602036.0
2016-04-07	ADRE	ETF	30.17	30.17	29.96	30.0	3700.0
2016-04-07	AFK	ETF	18.67	18.9	18.61	18.61	57938.0
2016-04-07	AFTY	ETF	12.78	12.78	12.6	12.605	20800.0
2016-04-07	AGG	ETF	110.98	111.05	110.77	110.99	1876100.0
2016-04-07	AGGY	ETF	50.72	50.87	50.72	50.84	5100.0
2016-04-07	AGQ	ETF	32.22	32.6	31.7	31.94	193000.0
2016-04-07	AGZ	ETF	114.8	114.8599	114.7	114.83	21101.0
2016-04-07	AGZD	ETF	23.47	23.815	23.32	23.41	17200.0
2016-04-07	AIA	ETF	42.06	42.06	41.6401	41.76	18098.0
2016-04-07	AIQ	ETF	6.92	7.124	6.9	6.95	15210.0
2016-04-07	AIRR	ETF	17.08	17.24	17.08	17.12	6200.0
2016-04-07	AIVI	ETF	37.36	37.51	37.09	37.16	24100.0
2016-04-07	AMJ	ETF	26.3	26.5	25.93	26.29	2657579.0
2016-04-07	AMLP	ETF	52.2	53.25	52.05	53.05	1283180.0
2016-04-07	AMZA	ETF	83.5	84.65	82.6	84.3	8180.0
2016-04-07	ANGL	ETF	25.7	25.71	25.57	25.63	90300.0
2016-04-07	AOA	ETF	44.71	44.77	44.36	44.47	31300.0
2016-04-07	AOK	ETF	32.18	32.21	32.06	32.06	124444.0
2016-04-07	AOM	ETF	34.39	34.544	34.35	34.46	117184.0
2016-04-07	AOR	ETF	38.99	39.05	38.764	38.86	74051.0
2016-04-07	ARGT	ETF	18.65	18.78	18.37	18.39	39100.0
2016-04-07	ARKG	ETF	18.529	18.529	18.529	18.529	600.0
2016-04-07	ARKK	ETF	19.75	19.75	19.5	19.5	1900.0
2016-04-07	ARKQ	ETF	19.19	19.19	19.19	19.19	300.0
2016-04-07	ARKW	ETF	20.86	20.86	20.74	20.76	1700.0
2016-04-07	ASEA	ETF	13.33	13.33	13.17	13.17	2000.0
2016-04-07	ASHR	ETF	24.4	24.55	24.04	24.15	3114000.0
2016-04-07	ASHS	ETF	34.88	35.07	34.5	34.59	42900.0
2016-04-07	ASHX	ETF	21.37	21.68	21.37	21.47	4868.0
2016-04-07	ATMP	ETF	17.55	17.74	17.47	17.61	11900.0
2016-04-07	BAB	ETF	30.4	30.5	30.34	30.45	237712.0
2016-04-07	BAL	ETF	38.4801	38.74	38.48	38.52	2181.0
2016-04-07	BBC	ETF	21.32	21.74	20.3201	21.2208	33923.0
2016-04-07	BBH	ETF	111.84	112.94	109.7	109.76	152800.0
2016-04-07	BBP	ETF	26.37	26.678	26.08	26.25	10500.0
2016-04-07	BCM	ETF	23.844	23.942	23.84	23.942	1564.0
2016-04-07	BFOR	ETF	7.48	7.49	7.395	7.4225	48400.0
2016-04-07	BIB	ETF	48.66	49.6	46.68	47.25	2351474.0

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

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