PREVIEW / etf_daily / 2015-10-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-14.parquet
  size:    48 KB
  rows:    1,191

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
2015-10-14	SPY	ETF	200.18	200.87	198.94	199.29	99106200.0
2015-10-14	QQQ	ETF	106.1	106.63	105.49	105.93	30902637.0
2015-10-14	IWM	ETF	114.04	114.75	112.71	112.87	39987400.0
2015-10-14	DIA	ETF	170.5	170.95	168.72	169.07	5424000.0
2015-10-14	GLD	ETF	112.63	113.95	112.3	113.81	10207800.0
2015-10-14	TLT	ETF	123.7	124.55	123.3	124.5	9738100.0
2015-10-14	AAXJ	ETF	56.61	56.79	56.44	56.51	1260000.0
2015-10-14	ACTX	ETF	10.6201	12.9801	10.6201	10.6201	1707.0
2015-10-14	ACWI	ETF	56.72	56.85	56.45	56.63	7485300.0
2015-10-14	ACWV	ETF	69.27	69.54	69.0	69.07	132000.0
2015-10-14	ACWX	ETF	41.32	41.47	41.215	41.36	360956.0
2015-10-14	ADRE	ETF	29.76	29.93	29.6201	29.792	8275.0
2015-10-14	AFK	ETF	21.12	21.244	21.1118	21.182	9577.0
2015-10-14	AFTY	ETF	15.45	15.58	15.45	15.54	2300.0
2015-10-14	AGG	ETF	109.83	110.05	109.73	110.03	3912000.0
2015-10-14	AGQ	ETF	37.0	37.7	36.99	37.52	337800.0
2015-10-14	AGZ	ETF	114.12	114.283	114.08	114.23	40597.0
2015-10-14	AGZD	ETF	24.01	24.01	23.92	23.935	1600.0
2015-10-14	AIA	ETF	45.04	45.24	45.0	45.1101	7788.0
2015-10-14	AIQ	ETF	10.39	10.58	10.0	10.03	15609.0
2015-10-14	AIRR	ETF	16.68	16.68	16.35	16.35	11400.0
2015-10-14	AIVI	ETF	40.7	40.82	40.58	40.82	13800.0
2015-10-14	AMJ	ETF	33.5	33.91	33.04	33.66	1561708.0
2015-10-14	AMLP	ETF	68.5	69.05	67.5	68.8	1445520.0
2015-10-14	AMZA	ETF	146.4	147.6	143.2	147.6	6370.0
2015-10-14	ANGL	ETF	26.1	26.1	26.05	26.05	4300.0
2015-10-14	AOA	ETF	45.17	45.35	45.11	45.11	34800.0
2015-10-14	AOK	ETF	32.01	32.1	31.9801	32.01	46670.0
2015-10-14	AOM	ETF	34.41	34.55	34.41	34.47	173342.0
2015-10-14	AOR	ETF	39.23	39.29	39.14	39.1532	54803.0
2015-10-14	ARGT	ETF	17.61	17.61	17.61	17.61	200.0
2015-10-14	ARKG	ETF	18.55	18.55	18.55	18.55	200.0
2015-10-14	ARKK	ETF	19.5	19.5	19.5	19.5	100.0
2015-10-14	ARKQ	ETF	18.3	18.3	18.219	18.219	200.0
2015-10-14	ARKW	ETF	21.9	21.9	21.84	21.84	300.0
2015-10-14	ASEA	ETF	13.35	13.35	13.31	13.35	1000.0
2015-10-14	ASHR	ETF	34.49	34.49	34.16	34.17	1776200.0
2015-10-14	ASHS	ETF	41.07	41.07	40.36	40.5	35500.0
2015-10-14	ATMP	ETF	22.75	23.14	22.69	23.06	77200.0
2015-10-14	AWAY	ETF	28.05	28.8911	27.76	28.3	1664124.0
2015-10-14	BAB	ETF	29.37	29.5789	29.32	29.42	42130.0
2015-10-14	BAL	ETF	42.73	42.73	42.53	42.53	1237.0
2015-10-14	BBC	ETF	25.846	26.5824	25.75	25.9071	4865.0
2015-10-14	BBH	ETF	114.46	116.09	113.03	114.02	227000.0
2015-10-14	BBP	ETF	27.87	28.85	27.87	28.48	8100.0
2015-10-14	BCM	ETF	27.558	27.5599	27.5329	27.55	1024.0
2015-10-14	BFOR	ETF	7.6825	7.7175	7.645	7.6675	36800.0
2015-10-14	BIB	ETF	58.17	59.98	56.22	57.71	1608568.0
2015-10-14	BIL	ETF	91.38	91.38	91.36	91.38	370550.0
2015-10-14	BIS	ETF	304.0	314.224	293.6	306.48	226014.5

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

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