PREVIEW / etf_daily / 2015-10-09

all etf daily files

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

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-09	SPY	ETF	201.38	201.9	200.58	201.33	107069200.0
2015-10-09	QQQ	ETF	106.1	106.73	105.81	106.53	23916227.0
2015-10-09	IWM	ETF	115.72	116.14	115.4	115.74	26497200.0
2015-10-09	DIA	ETF	170.62	170.97	170.1	170.76	5006100.0
2015-10-09	GLD	ETF	110.54	111.05	110.23	110.87	7907300.0
2015-10-09	TLT	ETF	121.97	122.64	121.9	122.28	9038100.0
2015-10-09	AADR	ETF	37.57	37.93	37.57	37.85	4500.0
2015-10-09	AAXJ	ETF	57.37	57.66	56.92	57.13	506700.0
2015-10-09	ACTX	ETF	10.6201	11.8001	7.5521	8.8501	4995.0
2015-10-09	ACWI	ETF	57.22	57.37	57.02	57.21	962900.0
2015-10-09	ACWV	ETF	69.44	69.62	69.2	69.45	97100.0
2015-10-09	ACWX	ETF	41.86	42.0	41.7201	41.83	493004.0
2015-10-09	ADRE	ETF	30.48	30.578	30.3342	30.37	3504.0
2015-10-09	AFK	ETF	21.21	21.4605	21.1635	21.34	24953.0
2015-10-09	AFTY	ETF	15.45	15.52	15.36	15.37	13500.0
2015-10-09	AGG	ETF	109.32	109.47	109.24	109.33	3235500.0
2015-10-09	AGGY	ETF	49.87	49.91	49.87	49.87	1500.0
2015-10-09	AGQ	ETF	36.21	36.32	35.5	36.07	160000.0
2015-10-09	AGZ	ETF	113.75	113.9499	113.7101	113.82	12908.0
2015-10-09	AGZD	ETF	24.035	24.035	23.96	23.96	1400.0
2015-10-09	AIA	ETF	45.73	45.73	45.251	45.35	24640.0
2015-10-09	AIQ	ETF	10.36	10.57	10.14	10.26	23987.0
2015-10-09	AIRR	ETF	16.96	17.0	16.941	16.96	12500.0
2015-10-09	AIVI	ETF	41.06	41.16	40.94	41.05	14400.0
2015-10-09	ALTY	ETF	14.538	14.538	14.538	14.538	1000.0
2015-10-09	AMJ	ETF	34.85	34.85	34.22	34.68	2116254.0
2015-10-09	AMLP	ETF	70.95	71.25	70.15	70.7	1043780.0
2015-10-09	AMUB	ETF	22.01	22.01	22.01	22.01	200.0
2015-10-09	AMZA	ETF	155.0	155.0	152.8	152.85	700.0
2015-10-09	ANGL	ETF	25.96	26.13	25.96	26.12	11000.0
2015-10-09	AOA	ETF	45.61	45.64	45.4	45.47	27400.0
2015-10-09	AOK	ETF	32.05	32.1099	31.97	32.04	14633.0
2015-10-09	AOM	ETF	34.58	34.6099	34.4501	34.55	53894.0
2015-10-09	AOR	ETF	39.42	39.4599	39.26	39.4	106428.0
2015-10-09	ARGT	ETF	17.69	17.91	17.66	17.67	9900.0
2015-10-09	ARKG	ETF	18.995	19.154	18.995	19.154	400.0
2015-10-09	ARKK	ETF	19.79	19.825	19.79	19.825	300.0
2015-10-09	ARKQ	ETF	18.47	18.47	18.47	18.47	100.0
2015-10-09	ARKW	ETF	22.2	22.2	22.2	22.2	100.0
2015-10-09	ASEA	ETF	13.54	13.64	13.54	13.57	3400.0
2015-10-09	ASHR	ETF	33.9	33.98	33.62	33.62	2021300.0
2015-10-09	ASHS	ETF	38.71	38.83	38.55	38.6	23800.0
2015-10-09	ATMP	ETF	23.72	23.79	23.61	23.61	39000.0
2015-10-09	AWAY	ETF	27.68	27.75	27.31	27.66	1354657.0
2015-10-09	BAB	ETF	29.17	29.18	29.1	29.15	76423.0
2015-10-09	BAL	ETF	41.07	41.35	40.8	41.236	7847.0
2015-10-09	BBC	ETF	27.715	27.8063	27.3701	27.46	13982.0
2015-10-09	BBH	ETF	116.0	117.22	115.01	116.42	163800.0
2015-10-09	BBP	ETF	28.2	29.15	28.2	29.01	15200.0
2015-10-09	BCHP	ETF	18.511	18.511	18.511	18.511	298.0

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

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