PREVIEW / etf_daily / 2016-04-25

all etf daily files

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

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-25	SPY	ETF	208.26	208.66	207.54	208.61	66166500.0
2016-04-25	QQQ	ETF	108.62	108.99	108.45	108.98	14351890.0
2016-04-25	IWM	ETF	113.8	113.91	112.81	113.3	16369600.0
2016-04-25	DIA	ETF	179.23	179.59	178.33	179.54	2485500.0
2016-04-25	GLD	ETF	118.14	118.71	118.11	118.23	4369400.0
2016-04-25	TLT	ETF	128.06	128.52	127.83	127.83	5539500.0
2016-04-25	AADR	ETF	39.19	39.19	38.47	38.52	3600.0
2016-04-25	AAXJ	ETF	54.87	54.89	54.63	54.72	909500.0
2016-04-25	ACTX	ETF	4.72	4.72	4.13	4.13	1058.0
2016-04-25	ACWI	ETF	57.27	57.34	57.1	57.3	817700.0
2016-04-25	ACWV	ETF	73.75	73.97	73.62	73.94	74100.0
2016-04-25	ACWX	ETF	40.73	40.761	40.6	40.72	505078.0
2016-04-25	ADRE	ETF	31.81	31.81	31.4801	31.5022	5717.0
2016-04-25	AFK	ETF	19.97	20.0499	19.86	19.8777	25415.0
2016-04-25	AFTY	ETF	12.77	12.78	12.71	12.72	18900.0
2016-04-25	AGG	ETF	110.52	110.59	110.39	110.4	3118800.0
2016-04-25	AGGY	ETF	50.68	50.7	50.614	50.67	5200.0
2016-04-25	AGQ	ETF	39.84	40.3	39.3	39.61	217900.0
2016-04-25	AGZ	ETF	114.42	114.4599	114.31	114.39	13748.0
2016-04-25	AIA	ETF	43.68	43.72	43.5975	43.6	10952.0
2016-04-25	AIQ	ETF	7.02	7.1	6.92	7.04	12801.0
2016-04-25	AIRR	ETF	17.78	17.78	17.78	17.78	700.0
2016-04-25	AIVI	ETF	39.25	39.31	39.12	39.23	14200.0
2016-04-25	ALTY	ETF	14.495	14.6	14.495	14.6	2100.0
2016-04-25	AMJ	ETF	30.0	30.14	29.465	29.58	1332726.0
2016-04-25	AMLP	ETF	60.9	61.3	59.8	60.15	1627360.0
2016-04-25	AMZA	ETF	104.2	104.25	100.1	101.4	9330.0
2016-04-25	ANGL	ETF	27.05	27.05	26.96	26.99	48300.0
2016-04-25	AOA	ETF	45.94	46.01	45.82	45.92	36300.0
2016-04-25	AOK	ETF	32.52	32.52	32.3701	32.46	30133.0
2016-04-25	AOM	ETF	35.05	35.05	34.8701	34.95	43898.0
2016-04-25	AOR	ETF	39.84	39.879	39.7101	39.79	108469.0
2016-04-25	ARGT	ETF	20.93	20.93	20.34	20.36	259500.0
2016-04-25	ARKG	ETF	18.61	18.61	18.61	18.61	100.0
2016-04-25	ARKK	ETF	19.73	19.73	19.59	19.62	700.0
2016-04-25	ARKQ	ETF	19.41	19.41	19.36	19.405	1400.0
2016-04-25	ARKW	ETF	21.181	21.181	21.181	21.181	100.0
2016-04-25	ASEA	ETF	13.68	13.68	13.51	13.52	13800.0
2016-04-25	ASHR	ETF	23.83	23.9	23.76	23.86	931500.0
2016-04-25	ASHS	ETF	33.04	33.31	33.04	33.29	38400.0
2016-04-25	ASHX	ETF	21.31	21.31	21.31	21.31	500.0
2016-04-25	ATMP	ETF	20.48	20.62	20.01	20.12	37000.0
2016-04-25	BAB	ETF	30.09	30.09	29.98	30.0	175219.0
2016-04-25	BAL	ETF	42.27	42.6212	42.1901	42.6212	4273.0
2016-04-25	BBC	ETF	21.55	21.96	21.29	21.29	46589.0
2016-04-25	BBH	ETF	112.53	113.37	112.26	112.61	41900.0
2016-04-25	BBP	ETF	27.5	27.5	27.22	27.26	24800.0
2016-04-25	BCM	ETF	25.716	25.84	25.682	25.682	4043.0
2016-04-25	BFOR	ETF	7.7225	7.725	7.665	7.675	35600.0
2016-04-25	BIB	ETF	49.51	50.0728	48.5484	48.88	452761.0

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

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