PREVIEW / etf_daily / 2015-10-13

all etf daily files

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

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-13	SPY	ETF	200.65	202.16	200.05	200.25	88038700.0
2015-10-13	QQQ	ETF	106.18	107.26	106.0	106.1	26999613.0
2015-10-13	IWM	ETF	115.11	116.3	113.93	113.99	37445300.0
2015-10-13	DIA	ETF	170.25	171.58	170.14	170.64	5909300.0
2015-10-13	GLD	ETF	111.36	111.87	111.28	111.86	5149600.0
2015-10-13	TLT	ETF	123.53	123.6	122.8	123.42	6147200.0
2015-10-13	AAXJ	ETF	56.45	56.79	56.18	56.22	479100.0
2015-10-13	ACTX	ETF	8.8501	11.8001	8.8501	10.6201	1766.0
2015-10-13	ACWI	ETF	56.77	57.1	56.54	56.57	2100600.0
2015-10-13	ACWV	ETF	69.28	69.64	69.16	69.17	37200.0
2015-10-13	ACWX	ETF	41.21	41.53	41.16	41.21	182386.0
2015-10-13	ADRE	ETF	30.0	30.05	29.682	29.69	10475.0
2015-10-13	AFK	ETF	21.04	21.11	20.86	21.01	22456.0
2015-10-13	AFTY	ETF	15.69	15.74	15.56	15.71	13900.0
2015-10-13	AGG	ETF	109.75	109.75	109.49	109.62	1500200.0
2015-10-13	AGQ	ETF	36.25	36.77	36.22	36.3	72700.0
2015-10-13	AGZ	ETF	114.05	114.06	113.82	114.0302	10510.0
2015-10-13	AGZD	ETF	24.025	24.025	23.965	23.965	800.0
2015-10-13	AIA	ETF	44.82	45.16	44.76	44.78	8034.0
2015-10-13	AIQ	ETF	10.02	10.79	10.02	10.41	50052.0
2015-10-13	AIRR	ETF	16.7	16.832	16.58	16.58	8800.0
2015-10-13	AIVI	ETF	40.34	40.76	40.34	40.45	27400.0
2015-10-13	ALTY	ETF	14.458	14.458	14.458	14.458	100.0
2015-10-13	AMJ	ETF	33.9	34.1	33.48	33.51	2036465.0
2015-10-13	AMLP	ETF	69.05	69.85	68.6	68.65	1674320.0
2015-10-13	AMZA	ETF	150.9	150.9	146.5	146.6	7840.0
2015-10-13	ANGL	ETF	26.09	26.11	26.06	26.09	21000.0
2015-10-13	AOA	ETF	45.31	45.45	45.13	45.22	19100.0
2015-10-13	AOK	ETF	32.05	32.088	31.9559	31.968	31124.0
2015-10-13	AOM	ETF	34.55	34.55	34.37	34.46	76719.0
2015-10-13	AOR	ETF	39.28	39.3499	39.16	39.2	101882.0
2015-10-13	ARGT	ETF	17.6	17.73	17.56	17.56	4100.0
2015-10-13	ARKG	ETF	18.96	18.96	18.8	18.8	800.0
2015-10-13	ARKK	ETF	19.6	19.6	19.6	19.6	100.0
2015-10-13	ARKQ	ETF	18.32	18.32	18.32	18.32	200.0
2015-10-13	ARKW	ETF	22.222	22.222	21.94	21.94	300.0
2015-10-13	ASEA	ETF	13.31	13.32	13.22	13.22	1600.0
2015-10-13	ASHR	ETF	34.67	34.98	34.49	34.69	1775200.0
2015-10-13	ASHS	ETF	41.0	41.38	40.16	41.02	53000.0
2015-10-13	ATMP	ETF	23.1	23.27	23.04	23.05	52100.0
2015-10-13	AWAY	ETF	27.92	28.35	27.74	27.94	847165.0
2015-10-13	BAB	ETF	29.33	29.4037	29.2704	29.37	67010.0
2015-10-13	BAL	ETF	41.3	42.75	41.28	42.609	10276.0
2015-10-13	BBC	ETF	26.716	27.5	25.78	25.78	14215.0
2015-10-13	BBH	ETF	115.76	117.71	113.42	113.57	163400.0
2015-10-13	BBP	ETF	28.862	29.16	27.75	27.75	28400.0
2015-10-13	BFOR	ETF	7.7825	7.83	7.735	7.735	21600.0
2015-10-13	BIB	ETF	59.41	62.03	56.57	56.72	1444350.0
2015-10-13	BICK	ETF	19.93	20.1775	19.88	19.89	3182.0
2015-10-13	BIL	ETF	91.38	91.38	91.36	91.38	736400.0

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

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