PREVIEW / etf_daily / 2015-10-27

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-27.parquet
  size:    49 KB
  rows:    1,221

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-27	SPY	ETF	206.2	207.0	205.79	206.6	77905800.0
2015-10-27	QQQ	ETF	112.55	113.24	112.52	113.08	31390511.0
2015-10-27	IWM	ETF	114.59	114.87	113.1	113.8	38189200.0
2015-10-27	DIA	ETF	175.33	176.19	175.24	175.67	4696100.0
2015-10-27	GLD	ETF	111.31	111.81	111.29	111.68	2646100.0
2015-10-27	TLT	ETF	124.51	124.9	124.16	124.33	7156800.0
2015-10-27	AADR	ETF	38.56	38.56	38.24	38.43	1600.0
2015-10-27	AAXJ	ETF	57.64	57.79	57.48	57.61	743700.0
2015-10-27	ACTX	ETF	10.0301	11.2101	9.4401	10.0301	518.0
2015-10-27	ACWF	ETF	23.76	23.77	23.67	23.7199	1425.0
2015-10-27	ACWI	ETF	57.91	58.1	57.8	57.97	1110900.0
2015-10-27	ACWV	ETF	70.67	70.87	70.61	70.78	127600.0
2015-10-27	ACWX	ETF	41.92	41.95	41.75	41.81	614864.0
2015-10-27	ADRE	ETF	31.04	31.04	30.823	30.9	7883.0
2015-10-27	AFK	ETF	20.6	20.64	20.27	20.47	9232.0
2015-10-27	AFTY	ETF	16.02	16.09	16.01	16.03	6300.0
2015-10-27	AGG	ETF	110.03	110.03	109.88	109.96	2021900.0
2015-10-27	AGGY	ETF	50.17	50.17	50.17	50.17	600.0
2015-10-27	AGQ	ETF	35.9	36.37	35.8	36.09	64700.0
2015-10-27	AGZ	ETF	114.03	114.22	113.8901	114.04	12460.0
2015-10-27	AGZD	ETF	23.945	23.945	23.945	23.945	600.0
2015-10-27	AIA	ETF	46.17	46.225	46.05	46.19	9912.0
2015-10-27	AIQ	ETF	8.86	8.93	8.125	8.28	97387.0
2015-10-27	AIRR	ETF	16.38	16.38	16.07	16.117	7000.0
2015-10-27	AIVI	ETF	40.57	40.63	40.44	40.47	17700.0
2015-10-27	ALTY	ETF	14.5	14.513	14.5	14.513	400.0
2015-10-27	AMJ	ETF	31.06	31.41	30.69	31.07	2278002.0
2015-10-27	AMLP	ETF	63.9	63.9	62.3	63.3	2241460.0
2015-10-27	AMZA	ETF	134.8	134.8	128.95	129.8	1750.0
2015-10-27	ANGL	ETF	26.1	26.16	26.1	26.13	3700.0
2015-10-27	AOA	ETF	46.08	46.12	45.91	46.04	56700.0
2015-10-27	AOK	ETF	32.32	32.32	32.25	32.3	44572.0
2015-10-27	AOM	ETF	34.77	34.85	34.73	34.83	79674.0
2015-10-27	AOR	ETF	39.78	39.8	39.6643	39.76	152849.0
2015-10-27	ARGT	ETF	18.85	18.85	18.57	18.81	17700.0
2015-10-27	ARKG	ETF	19.5	19.5	19.5	19.5	200.0
2015-10-27	ARKK	ETF	19.64	19.64	19.61	19.61	200.0
2015-10-27	ARKQ	ETF	18.438	18.438	18.438	18.438	100.0
2015-10-27	ARKW	ETF	22.519	22.519	22.463	22.463	300.0
2015-10-27	ASEA	ETF	13.48	13.48	13.37	13.38	1600.0
2015-10-27	ASHR	ETF	35.98	35.98	35.67	35.72	902400.0
2015-10-27	ASHS	ETF	43.8	44.67	43.15	43.52	126600.0
2015-10-27	ASHX	ETF	25.31	25.33	25.21	25.23	13000.0
2015-10-27	ATMP	ETF	21.06	21.21	21.0	21.21	51800.0
2015-10-27	AWAY	ETF	31.16	31.59	30.412	30.9	947625.0
2015-10-27	BAB	ETF	29.39	29.4	29.3	29.36	92107.0
2015-10-27	BAL	ETF	41.95	42.0	41.55	41.55	5872.0
2015-10-27	BBC	ETF	27.0	27.31	26.8035	27.31	5825.0
2015-10-27	BBH	ETF	121.92	125.49	121.92	125.47	96200.0
2015-10-27	BBP	ETF	30.03	30.24	29.67	30.24	5300.0

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

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